Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting - Mailing list pgsql-admin

From Michael Holt
Subject Re: Getting
Date
Msg-id E7907DC29186A94988A077445AFD1DC02514D9AA@EXCHANGEVIC.ad.terapeak.com
Whole thread Raw
In response to Re: Getting  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Responses Re: Getting  (Greg Williamson <gwilliamson39@yahoo.com>)
List pgsql-admin
Tree view
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@postgresql.org [pgsql-admin-owner@postgresql.org] on behalf of Raghavendra [raghavendra.rao@enterprisedb.com]
Sent: Wednesday, January 23, 2013 9:52 PM
To: Dan Ng
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Getting

On Wed, Jan 23, 2013 at 11:50 PM, Dan Ng <surfnet@yahoo.com> 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.

---
Regards,
Raghavendra
EnterpriseDB Corporation

pgsql-admin by date:

Previous
From: Raghavendra
Date:
Subject: Re: Getting
Next
From: Bert
Date:
Subject: Re: vacuum / analyze parent tables on partitioned tables.