Re: Long running queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


I have this essentially bookmarked and query it often. I actually have a Slackbot running that yells at people if they show up in the results.

SELECT * FROM pg_stat_activity WHERE usename IS NOT NULL AND state = 'active' AND query_start <= NOW() - INTERVAL '60 minutes'; -- Long query

On Wed, Jan 25, 2023 at 9:55 AM Clive Swan <cliveswan@xxxxxxxxx> wrote:
SQL Server has a handy SQL "tool" to spot expensive and/or long running queries.

Is there a similar query/tool for Postgresql??


Wells Oliver

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux