Re: investigating slow queries through

Поиск
Список
Период
Сортировка
От Jacques Caron
Тема Re: investigating slow queries through
Дата
Msg-id 6.2.0.14.0.20050620204307.039e9e78@pop.interactivemediafactory.net
обсуждение исходный текст
Ответ на investigating slow queries through pg_stat_activity  (Dan Harris <fbsd@drivefaster.net>)
Список pgsql-performance
Hi,

At 19:55 20/06/2005, Dan Harris wrote:
>Also, I'm sure some people will respond with "turn on query
>logging".. I've explored that option and the formatting of the log
>file and the fact that EVERY query is logged is not what I'm after
>for this project.

You can log just those queries that take "a little bit too much time". See
log_min_duration_statement in postgresql.conf. Set it really high, and
you'll only get those queries you're after.

Jacques.



В списке pgsql-performance по дате отправления:

Предыдущее
От: Dan Harris
Дата:
Сообщение: investigating slow queries through pg_stat_activity
Следующее
От: Tom Lane
Дата:
Сообщение: Re: investigating slow queries through pg_stat_activity