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

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема get a log of queries that take up a lot of CPU or take a very long time.
Дата
Msg-id 855e4dcf0911231441t39ac2785w74d949ee42002393@mail.gmail.com
обсуждение исходный текст
Ответы Re: get a log of queries that take up a lot of CPU or take a very long time.
Re: get a log of queries that take up a lot of CPU or take a very long time.
Список pgsql-general
Дерево обсуждения 
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.

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

Предыдущее
От: Martin Gainty
Дата:
Сообщение: Re: C++ and Postgis
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: get a log of queries that take up a lot of CPU or take a very long time.