How To Check If My Session Queries Are Running Or Waiting On Locks?

1.	How To Check If My Session Queries Are Running Or Waiting On Locks?
Answer» CHECK “waiting” COLUMN in pg_stat_activity and “granted” column in pg_locks for any OBJECT level locks. Check “waiting” column in pg_stat_activity and “granted” column in pg_locks for any object level locks.

Answer»

CHECK “waiting” COLUMN in pg_stat_activity and “granted” column in pg_locks for any OBJECT level locks.

Check “waiting” column in pg_stat_activity and “granted” column in pg_locks for any object level locks.

Discussion