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

Popular posts from this blog

GP - Kerberos errors and resolutions

How to set Optimizer at database level in greenplum

GP - SQL Joins