Thread: get a log of queries that take up a lot of CPU or take a very long time.
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.
Re: get a log of queries that take up a lot of CPU or take a very long time.
From
Alan Hodgson
Date:
On Monday 23 November 2009, Tim Uckun <timuckun@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. 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."
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:
|
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.