From: | Hassan Syed <h(dot)a(dot)syed(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | [Feature Request] explaining sql statements executed in UDF's |
Date: | 2012-09-11 13:37:17 |
Message-ID: | CAO5trKxVHW-Ba-vD61iTJ3-hdpFWu0_p7nP+TnWX=J90VA6z7A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello Folks,
I hope this is the right place to ask for this feature.
I have just started working with Postgres seriously, and I come from a SQL
Server background. In SQL Server when one develops complex stored
procedures, it is possible to see the query plans of the stored procedure,
even when the invocations are nested.
I wanted to have the same functionality in Postgres so I asked this
question on the dba.stackexchange.com website:
So, in order to achieve this use-case I have to first enable the feature in
a session and then "tail -f" the server log. It would be great if we could
have the server look into the UDF's and show the entirety of the query
plans.
This feature is quite beneficial when developing complex nested UDF
implementations. Eventually I hope I can get these query plans displayed
graphically in Pgadmin3.
Hassan
From | Date | Subject | |
---|---|---|---|
Next Message | Amit kapila | 2012-09-11 13:37:36 | Re: Proof of concept: standalone backend with full FE/BE protocol |
Previous Message | Shigeru HANADA | 2012-09-11 09:30:02 | Move postgresql_fdw_validator into dblink |