On Wed, Jan 23, 2013 at 11:50 PM, Dan Ng <surf...@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. http://www.postgresql.org/docs/9.2/static/auto-explain.html --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/
