Thread: actual SQL statement

actual SQL statement

From
"MG"
Date:
Hello,
 
can I find out, what SQL statement the PostgreSQL-server is executing?
 
Thanks

Michaela

 

 

Re: actual SQL statement

From
"A. Kretschmer"
Date:
am  23.02.2006, um 10:58:12 +0100 mailte MG folgendes:
> Hello,
>
> can I find out, what SQL statement the PostgreSQL-server is executing?

select * from pg_stat_activity;

You should enable 'stats_command_string' in postgresql.conf.


Btw.: please, no HTML


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===