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?
For example,
[1]\dX
show all defined prepared query plan
[2]\dX planName
show the definition of the named plan.
Thanks a lot!