Re: query execution time for last 24 hours in PostgreSQL

[SOzcn <selahattinozcnma@xxxxxxxxx>]

Hello,

you can get this infos with pg_stat_statement extension.

https://www.postgresql.org/docs/current/pgstatstatements.html

nikhil kumar <nikhil.dba97@xxxxxxxxx>, 23 May 2024 Per, 21:08 tarihinde şunu yazdı:

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.