In response to Vlad Arkhipov :
Is there any way to inspect current running statements (optionally full
stack of these statements)? I've found there is error_context_stack
variable in each backend, but it seems there is no way to get this
variable from another backend. It will be great if Postgres have such
kind of mechanism, for instance a system table that consists statements
running longer than certain time (5-10 seconds).
select * from pg_stat_activity;
Andreas
It shows only top-level statements. You can see 'select * from f()' in
this table but you never see what is actually executing in this function.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers