Postgres Pro
Downloads
Home   >   mailing lists

Re: Long running queries - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Long running queries
Date
Msg-id 8299AF9E-0269-4F02-BC0D-D86D0D817D86@elevated-dev.com
Whole thread Raw
In response to Long running queries  (Clive Swan <cliveswan@gmail.com>)
Responses Re: Long running queries  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
Tree view 
> On Jan 25, 2023, at 10:55 AM, Clive Swan <cliveswan@gmail.com> wrote:
>
> SQL Server has a handy SQL "tool" to spot expensive and/or long running queries.
>
> Is there a similar query/tool for Postgresql??

- pg_stat_statements extension
- log_min_duration config parameter
- pg_stat_activity view

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: Long running queries
Next
From: Ron
Date:
Subject: Re: Long running queries