Am 23.05.24 um 20:07 schrieb nikhil kumar:
Hi Team,Can you please let me know anyone how to get each query execution time from last 24 hours in PostgreSQLI 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_secondsFROM pg_stat_activity sa WHERE sa.query_start >= current_timestamp interval '24 hours'; Thanks, Nikhil, PostgreSQL DBA, 8074430856.
pg_stat_activity shows current activity, not historic activity.Unless you use an extension like pg_stat_statements, or log your statements, the information won't be available.
Regards, Holger -- Holger Jakobs, Bergisch Gladbach
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature