Postgres Pro
Downloads
Home   >   mailing lists

Re: Long running queries - Mailing list pgsql-admin

From Ron
Subject Re: Long running queries
Date
Msg-id 05d32b82-e944-15d4-b769-464e7c21175f@gmail.com
Whole thread Raw
In response to Long running queries  (Clive Swan <cliveswan@gmail.com>)
List pgsql-admin
Tree view
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.

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Long running queries
Next
From: Tom Lane
Date:
Subject: Re: Does raising maintenance_work_mem get seen by an already running aucovac?