Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Postgres Deadlock Debugg

There is a better way to view Postgres locks and blocking chains.
select
pg_stat_activity.datname,
pg_class.relname,
pg_locks.transactionid,
pg_locks.mode,
pg_locks.granted,
pg_stat_activity.usename,
substr(pg_stat_activity.current_query,1,40) as current_query,
pg_stat_activity.query_start,
age(now(),pg_stat_activity.query_start) as "age",
pg_stat_activity.procpid
from pg_stat_activity,pg_locks
left outer join pg_class on (pg_locks.relation = pg_class.oid)
where pg_locks.pid=pg_stat_activity.procpid order by query_start;

Comments

Popular posts from this blog

VMWARE WORKSTATION 3,4,5,6,7,8,9,10,11,12,14,15...etc LICENSE KEYS COLLECTION

PostgreSQL DOMAIN Data Type -2

10. Global Sequences

Oracle to Postgresql migration

How to Configure Oracle Dataguard and How to Perform Switchover and Failover