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

Поиск

Список

Период

Сортировка

От	Sam Jas
Тема	Re: get a log of queries that take up a lot of CPU or take a very long time.
Дата	24 ноября 2009 г. 05:54:43
Msg-id	173790.26088.qm@web95008.mail.in2.yahoo.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

Дерево обсуждения

select procpid, current_query, now() - query_start as duration, backend_start
from pg_stat_activity where current_query not like '%IDLE%' order by duration desc
limit 10;

Hope it may help you!!!.

--
Thanks
Sam Jas

--- On Mon, 23/11/09, Tim Uckun <timuckun@gmail.com> wrote:

From: Tim Uckun <timuckun@gmail.com>
Subject: [GENERAL] get a log of queries that take up a lot of CPU or take a very long time.
To: "pgsql-general" <pgsql-general@postgresql.org>
Date: Monday, 23 November, 2009, 10:41 PM

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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