query execution time for last 24 hours in PostgreSQL

From: nikhil kumar <nikhil(dot)dba97(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: query execution time for last 24 hours in PostgreSQL
Date: 2024-05-23 18:07:42
Message-ID: CACJRp483AWu5Jar4xt9y2wbdDq9Fsxqou6kaPLCs_ifC==902A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team,

Can you please let me know anyone how to get each query execution time from
last 24 hours in PostgreSQL

I tried the below query but giving the wrong information.

SELECT sa.client_addr,
sa.usename,
sa.datname,
sa.state,
sa.query,
sa.query_start,
EXTRACT (EPOCH FROM (current_timestamp sa.query_start)) AS
execution_time_seconds
FROM pg_stat_activity sa
WHERE sa.query_start >= current_timestamp interval '24 hours';

Thanks,
Nikhil,
PostgreSQL DBA,
8074430856.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message SOzcn 2024-05-23 18:25:21 Re: query execution time for last 24 hours in PostgreSQL
Previous Message Kashif Zeeshan 2024-05-23 15:41:32 Re: Upgrade from PostgreSQL version 10 to 16