How to get locks present in PostgreSQL

In this article, we will see How to get locks present in PostgreSQL.

Query to check the locks present in PostgreSQL:

select t.relname,l.locktype,page,virtualtransaction,pid,mode,granted from pg_locks l, pg_stat_all_tables t where l.relation=t.relid order by relation asc;

How to get locks present in PostgreSQL

Related Posts:

  1. Difference between pg_cancel_backend and pg_terminate_backend in PostrgreSQL
  2. Lock and Unlock PostgreSQL User
  3. Query to check blocking in PostgreSQL Server