GP - Longest Running Query
Generating the report for top 10 longest running query in the database
SELECT now()-query_start AS "Running Time", datname AS "Database name", usename AS "Username", procpid AS "PID", sess_id AS "Session ID", substr(current_query from 1 for 100) AS "Query" FROM pg_stat_activity WHERE procpid not in (select pg_backend_pid()) AND current_query not like '' ORDER BY 1 DESC LIMIT 10;
In Above SQL, we can change the limit as required.
NOTE: Run this SQL from postgres database
Comments
Post a Comment