Tom Lane wrote:
> Emi Lu <emilu(at)encs(dot)concordia(dot)ca> writes:
>> Somebody know about how to find prepared query plan through command line?
> PREPARE fooplan(...)
> EXPLAIN EXECUTE fooplan(...)
Thank you Tom.
Similar to \dt to show all tables, within one session, may I know the
command to list all prepared query plan please?
show all defined prepared query plan
show the definition of the named plan.
Thanks a lot!
In response to
pgsql-sql by date
|Next:||From: Milan Oparnica||Date: 2008-07-28 21:21:50|
|Subject: Re: PERSISTANT PREPARE (another point of view)|
|Previous:||From: Andrej Ricnik-Bay||Date: 2008-07-28 18:26:05|
|Subject: Re: Encrytion in postgres field in table|