How to view long-running queries in postgresql

Question

312 views17/04/2023PostgreSQL

0

Amen1.09K 14/04/2023 0 Comments

How to view long-running and active queries in postgresql? DBA scripts to view long-running and active queries in postgresql?

Ezana Answered question 17/04/2023

Write your answer.

score 0 · Answer 1 · 2023-04-17T15:23:36+00:00

To view long-running queries:

select current_timestamp - query_start as runtime, datname, usename, query
   from pg_stat_activity
   where state != 'idle'
   order by 1 desc;

To view active queries:

SELECT datname,usename,query
      FROM pg_stat_activity
      WHERE state != 'idle' ;