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
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net