Thread: Log Query and Execution time

Hi All,

Is there is a way to log every SQL query on potgresql server and also
their execution time?
I need to find which query that eat CPU resource. Applications
connected to this server are from PHP and VB client.

Thanx.

am  Mon, dem 26.03.2007, um 15:45:07 +0700 mailte Luki Rustianto folgendes:
> Hi All,
>
> Is there is a way to log every SQL query on potgresql server and also
> their execution time?

Yes.

log_statement = 'all'
log_min_duration_statement = 0

(postgresql.conf)


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