Log Query and Execution time
Started by Luki Rustiantoabout 19 years ago2 messagesgeneral
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.
Re: Log Query and Execution time
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