actual SQL statement

Started by MGabout 20 years ago2 messagesgeneral
Jump to latest
#1MG
pgsql-general@carladata.de

Hello,

can I find out, what SQL statement the PostgreSQL-server is executing?

Thanks
Michaela

#2A. Kretschmer
andreas.kretschmer@schollglas.com
In reply to: MG (#1)
Re: actual SQL statement

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 ===