Re: get a log of queries that take up a lot of CPU or take a very long time.

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: get a log of queries that take up a lot of CPU or take a very long time.
Дата
Msg-id 200911231442.39230@hal.medialogik.com
обсуждение исходный текст
Ответ на get a log of queries that take up a lot of CPU or take a very long time.  (Tim Uckun <timuckun@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On Monday 23 November 2009, Tim Uckun <timuckun@gmail.com> wrote:
> Is there a way I can get a list of the top 10 longest running queries
> for the day/week/month or the top 10 queries that took the most CPU?
>
> select * from pg_stat_activity only shows the current status.

You can enable query logging, store the logs, and parse them.

--
"No animals were harmed in the recording of this episode. We tried but that
damn monkey was just too fast."

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

Предыдущее
От: Tim Uckun
Дата:
Сообщение: get a log of queries that take up a lot of CPU or take a very long time.
Следующее
От: Scott Bailey
Дата:
Сообщение: Re: I need help creating a composite type with some sort of constraints.