Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT a.datname,
- l.relation::regclass,
- l.transactionid,
- l.mode,
- l.GRANTED,
- a.usename,
- a.query,
- a.query_start,
- age(now(), a.query_start) AS "age",
- a.pid
- FROM pg_stat_activity a
- JOIN pg_locks l ON l.pid = a.pid
- ORDER BY a.query_start;
- SELECT t.schemaname,
- t.relname,
- l.locktype,
- l.page,
- l.virtualtransaction,
- l.pid,
- l.mode,
- l.granted
- FROM pg_locks l
- JOIN pg_stat_all_tables t ON l.relation = t.relid
- WHERE t.schemaname <> 'pg_toast'::name AND t.schemaname <> 'pg_catalog'::name
- ORDER BY t.schemaname, t.relname;
- SELECT pg_cancel_backend('1720');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement