Query to check blocking in PostgreSQL Server

In this article, we will see query to check blocking in PostgreSQL Server.

Syntax to check blocking PostgreSQL Server:

SELECT datname
, usename
, wait_event_type
, wait_event
, pg_blocking_pids(pid) AS blocked_by_pid
, query
FROM pg_stat_activity
WHERE wait_event IS NOT NULL;

Output is:

-[ RECORD 1 ]---+-----------------
datname         | postgres
usename         | james
wait_event_type | Lock
wait_event      | relation
blocked_by_pid      | {15356}
query           | select * from address;