From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Which query analiser tools are available? |
Date: | 2006-12-03 09:57:36 |
Message-ID: | 20061203095736.GA20975@KanotixBox |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> schrieb:
> Because JBoss is largely responsible for the SQL queries that are send
> to the back-end , I would like to see the queries that are actually
> received by PostgreSQL (insert, select, update and delete), together
> with the number of times they are called, the average execution time,
> total execution time etc.
You can use pgfouine for such job:
http://pgfouine.projects.postgresql.org/
And you can play with config-parameters like:
- log_statement = [none, mod, ddl, all]
- log_min_duration_statement = X (logs all statements runs longer then X
ms)
- stats_command_string = on
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
From | Date | Subject | |
---|---|---|---|
Next Message | Alexandru Coseru | 2006-12-03 11:11:29 | Re: Regex performance issue |
Previous Message | Joost Kraaijeveld | 2006-12-03 08:59:25 | Which query analiser tools are available? |