Re: [ADMIN] Getting

2013-01-24 Thread Dan Ng
M Subject: Re: [ADMIN] Getting Dan -- > > From: Michael Holt >To: Raghavendra ; Dan Ng >Cc: "pgsql-admin@postgresql.org" >Sent: Wednesday, January 23, 2013 9:55 PM >Subject: Re: [ADMIN] Getting > > > >Of course you can

[ADMIN] Getting

2013-01-23 Thread Dan Ng
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. Addition