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

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: get a log of queries that take up a lot of CPU or take a very long time.
Date: 2009-11-23 22:41:00
Message-ID: 855e4dcf0911231441t39ac2785w74d949ee42002393@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2009-11-23 22:42:39 Re: get a log of queries that take up a lot of CPU or take a very long time.
Previous Message Martin Gainty 2009-11-23 22:16:58 Re: C++ and Postgis