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

[Tim Uckun <timuckun@xxxxxxxxx>]

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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general