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
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.