Thread: Profiling postgresql queries

Hi all,<br />I was wondering if there is any GUI or command line based tool running on windows that could help me to
profilePostgreSQL queries performance. It should be able to do live profiling since I want to profile the accesses that
myapplication is doing on the Postgres database.<br /><br />Thanks to all<br />Nacef<br /> 

am  Wed, dem 09.07.2008, um 10:22:09 +0200 mailte Nacef LABIDI folgendes:
> Hi all,
> I was wondering if there is any GUI or command line based tool running on
> windows that could help me to profile PostgreSQL queries performance. It should

You can use EXPLAIN ANALYSE to analyse your queries (if they use
indexes, execution plan, estimated versus real rows etc.)


> be able to do live profiling since I want to profile the accesses that my
> application is doing on the Postgres database.

You can log slow queries with a setting in your postgresql.conf:

log_min_duration_statement = N

with N means the duration time in ms, it loggs all queries with an
execution time more than that.


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