Обсуждение: pg query exec time, reports

Поиск
Список
Период
Сортировка

pg query exec time, reports

От
"Johnny Edge"
Дата:

Hello folks,
 
I wish to log query execution time on all queries.
 
Could you please advise re the same?
 
Could you also suggest report generation tools? I.e. what queries take longest time to exec, duration of session, etc.
 
Thanks,
 
-JE

Re: pg query exec time, reports

От
Bill Moran
Дата:
In response to "Johnny Edge" <jedge@visafirst.com>:
>
> I wish to log query execution time on all queries.

http://www.postgresql.org/docs/8.3/static/runtime-config-logging.html
Specifically the log_*_statement directives.

> Could you also suggest report generation tools? I.e. what queries take longest time to exec, duration of session,
etc.

pgFouine

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/