Re: Query prepared plan - Mailing list pgsql-sql

From Emi Lu
Subject Re: Query prepared plan
Date
Msg-id 488E17BE.9000107@encs.concordia.ca
Whole thread Raw
In response to Re: Query prepared plan  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Query prepared plan  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-sql
Tom Lane wrote:
> Emi Lu <emilu@encs.concordia.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?

For example,
[1]\dX   show all defined prepared query plan
[2]\dX planName   show the definition of the named plan.

Thanks a lot!


pgsql-sql by date:

Previous
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Encrytion in postgres field in table
Next
From: Milan Oparnica
Date:
Subject: Re: PERSISTANT PREPARE (another point of view)