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.
