Re: Query prepared plan

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Query prepared plan
Date: 2008-07-28 23:08:24
Message-ID: 20080728230824.GF14617@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Emi Lu wrote:

> Similar to \dt to show all tables, within one session, may I know the
> command to list all prepared query plan please?

select * from pg_prepared_statements;

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Lennin Caro 2008-07-29 03:26:19 Re: Encrytion in postgres field in table
Previous Message Milan Oparnica 2008-07-28 21:21:50 Re: PERSISTANT PREPARE (another point of view)