Postgres Pro
Downloads
Home   >   mailing lists

get a log of queries that take up a lot of CPU or take a very long time. - Mailing list pgsql-general

From Tim Uckun
Subject get a log of queries that take up a lot of CPU or take a very long time.
Date
Msg-id 855e4dcf0911231441t39ac2785w74d949ee42002393@mail.gmail.com
Whole thread Raw
Responses Re: get a log of queries that take up a lot of CPU or take a very long time.  (Alan Hodgson <ahodgson@simkin.ca>)
Re: get a log of queries that take up a lot of CPU or take a very long time.  (Sam Jas <samjas33@yahoo.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Martin Gainty
Date:
Subject: Re: C++ and Postgis
Next
From: Alan Hodgson
Date:
Subject: Re: get a log of queries that take up a lot of CPU or take a very long time.