On Monday 23 November 2009, Tim Uckun <timuc...@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." -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
