Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
[GENERAL] get a log of queries that take up a lot of CPU or take a very long time.
1 view
Skip to first unread message
Tim Uckun
Nov 23, 2009, 5:41:00 PM11/23/09
to
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?
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-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Alan Hodgson
Nov 23, 2009, 5:42:39 PM11/23/09
to
On Monday 23 November 2009, Tim Uckun <timu...@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.
> 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."
0 new messages