Discussion:
What query currently running within function
Rebecca Clarke
2014-07-22 09:36:34 UTC
Permalink
Hi all,

Presently I'm executing a function that runs many queries within it.

select * from _myfunction();

Is there a way to see what query it is up to within the function?
When I do a select of pg_stat_activity it just shows me the _myfunction()
query.

I'm running postgresql 9.1

Thanks in advance.
Guillaume Lelarge
2014-07-22 09:45:19 UTC
Permalink
Hi,
Post by Rebecca Clarke
Hi all,
Presently I'm executing a function that runs many queries within it.
select * from _myfunction();
Is there a way to see what query it is up to within the function?
Unfortunately, no. Even with the latest release. pg_stat_activity shows you
what the client fires, not what the server does.
Post by Rebecca Clarke
When I do a select of pg_stat_activity it just shows me the _myfunction()
query.
I'm running postgresql 9.1
Thanks in advance.
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
Peter Geoghegan
2014-07-24 04:42:32 UTC
Permalink
On Tue, Jul 22, 2014 at 2:45 AM, Guillaume Lelarge
Post by Guillaume Lelarge
Unfortunately, no. Even with the latest release. pg_stat_activity shows you
what the client fires, not what the server does.
pg_stat_statements has a "track" GUC which controls whether or not
nested statements, such as statements executed within functions are
tracked.
--
Regards,
Peter Geoghegan
--
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Merlin Moncure
2014-07-31 13:18:45 UTC
Permalink
Post by Rebecca Clarke
Hi all,
Presently I'm executing a function that runs many queries within it.
select * from _myfunction();
Is there a way to see what query it is up to within the function?
When I do a select of pg_stat_activity it just shows me the _myfunction()
query.
I'm running postgresql 9.1
Thanks in advance.
raise notices or warnings in the log. if the function is sql and
not pl/pgsql, you can wrap the RAISE feature.

merlin
--
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Loading...