Script to find sessions that are blocking other sessions in PostgreSQL

In this post, I am sharing one script to find sessions that are blocking other sessions in PostgreSQL.

Instead of finding blocked the sessions or process , sometimes it is better to find sessions that are the root of blocking.
PostgreSQL DBA can use this script to find the root cause of blocking.

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz