Re: Getting

[Michael Holt <MHolt@xxxxxxxxxxxx>]

Of course you can also see what the query plan will be without having to run the query through a standard explain query:

http://www.postgresql.org/docs/9.0/static/sql-explain.html

---

From: pgsql-admin-owner@xxxxxxxxxxxxxx [pgsql-admin-owner@xxxxxxxxxxxxxx] on behalf of Raghavendra [raghavendra.rao@xxxxxxxxxxxxxxxx]
Sent: Wednesday, January 23, 2013 9:52 PM
To: Dan Ng
Cc: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: Getting

On Wed, Jan 23, 2013 at 11:50 PM, Dan Ng <surfnet@xxxxxxxxx> wrote:

Hello,
I am a newb in Postgres coming from Oracle. Does anyone know if it's possible to see the plan being executed by Postgres for an active sql statement (from pg_stat_activity). This is to be able to troubleshoot poor performing ones and in Oracle we are able to retrieve such a plan.

Additionally, how do I see the actual sql statement that shows as "<unnamed portal x>".
Thanks so much for any advice you all may have.
-Dan

Welcome...!!! 

You need to use additional module to write query plan in logs i.e., AUTO_EXPLAIN.

http://www.postgresql.org/docs/9.2/static/auto-explain.html

---

Regards,

Raghavendra

EnterpriseDB Corporation

Blog: http://raghavt.blogspot.com/