simondobner

Biggest Tables

SELECT nspname || '.' || relname                     AS "relation",
       pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size"
FROM pg_class C
         LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE nspname NOT IN ('pg_catalog', 'information_schema')
  AND C.relkind <> 'i'
  AND nspname !~ '^pg_toast'
ORDER BY pg_total_relation_size(C.oid) DESC

simondobner

Locks, Blocks and Killing sessions

Find blocked and blocking sessions

select pid,
       usename,
       pg_blocking_pids(pid) as blocked_by,
       query                 as blocked_query
from pg_stat_activity