GP - Database Lock Information

Generating a report of database lock if any
SELECT
 (select datname from pg_database where oid=a.database) AS "Database Name",
 a.locktype AS "Lock Type",
 a.relation::regclass AS "Relation Name",
 (select rsqname from pg_resqueue where oid=a.objid) AS "Resource Queue",
 count(*) AS "Total Waiters"
FROM 
 pg_locks a 
WHERE 
 a.granted='f'
GROUP BY 1,2,3,4;
NOTE: This SQL can be executed 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