Re: Long running queries

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Long running queries
Date: 2023-01-25 18:02:29
Message-ID: 05d32b82-e944-15d4-b769-464e7c21175f@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 1/25/23 11:55, Clive Swan wrote:
> Greetings
> 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_activity lists all of the *currently running* queries (among the
columns in the table are query string, database name, user name, transaction
start time and query start time).

--
Born in Arizona, moved to Babylonia.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2023-01-25 21:36:03 Re: Does raising maintenance_work_mem get seen by an already running aucovac?
Previous Message Scott Ribe 2023-01-25 17:57:58 Re: Long running queries