Re: Getting
| От | Raghavendra |
|---|---|
| Тема | Re: Getting |
| Дата | |
| Msg-id | CA+h6Ahg6eDD=eVb5CrfeGCAevkRUSqcqWoC+7H_z8FO_RO=dCg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Getting (Dan Ng <surfnet@yahoo.com>) |
| Ответы |
Re: Getting
|
| Список | pgsql-admin |
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 по дате отправления: