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

Re: Query prepared plan

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Query prepared plan
Date: 2008-07-25 14:27:45
Message-ID: 4889E2E1.5030708@encs.concordia.ca (view raw or flat)
Thread:
Lists: pgsql-sql
> Good morning,
> 
> May I know the "commands" to
> . show current session's prepared plans
> . see the definition of a prepared plan
> 
> E.g., psql> PREPARE fooplan (int, text, bool, numeric) AS INSERT INTO 
> foo VALUES($1, $2, $3, $4);
> 
> (1) Similar to "\dt", I want to see "fooplan"
> (2) Similar to "\d tableName", how to see the plan def?


Somebody know about how to find prepared query plan through command line?

Thanks a lot!






In response to

Responses

pgsql-sql by date

Next:From: Igor NeymanDate: 2008-07-25 15:25:53
Subject: Re: A table with two names or table alias
Previous:From: Milan OparnicaDate: 2008-07-25 12:58:34
Subject: Re: PERSISTANT PREPARE (another point of view)

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