: [GENERAL] get a log of queries that take up a lot of CPU or take a
very long time.
To: "pgsql-general"
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
On Monday 23 November 2009, Tim Uckun 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 log
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@postgresql.org)
To make changes to your s
