Re: Long running queries

[Ron <ronljohnsonjr@xxxxxxxxx>]

    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.