Re: View running statements

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