Tom Lane wrote:
Emi Lu <[EMAIL PROTECTED]> 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!
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
