Re: Long running queries

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Clive Swan <cliveswan(at)gmail(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Long running queries
Date: 2023-01-25 17:57:58
Message-ID: 8299AF9E-0269-4F02-BC0D-D86D0D817D86@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Jan 25, 2023, at 10:55 AM, Clive Swan <cliveswan(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2023-01-25 18:02:29 Re: Long running queries
Previous Message Wells Oliver 2023-01-25 17:56:50 Re: Long running queries