📋Steps in this guide1/1

Find locks present in postgres

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;

postgresql configurationintermediate

by PostgreSQL

13 views

Find locks present in postgres

Code/Command (click line numbers to comment):

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;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!