Skip site navigation (1) Skip section navigation (2)

Re: Query prepared plan

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Query prepared plan
Date: 2008-07-28 19:02:22
Message-ID: 488E17BE.9000107@encs.concordia.ca (view raw or flat)
Thread:
Lists: pgsql-sql
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!

In response to

Responses

pgsql-sql by date

Next:From: Milan OparnicaDate: 2008-07-28 21:21:50
Subject: Re: PERSISTANT PREPARE (another point of view)
Previous:From: Andrej Ricnik-BayDate: 2008-07-28 18:26:05
Subject: Re: Encrytion in postgres field in table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group