SELECT pg_size_pretty(pg_database_size(current_database())) AS db_size;
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')
ORDER BY pg_total_relation_size(C.oid) DESC
LIMIT 10;
SELECT pid, now() - pg_stat_activity.query_start AS duration, query, state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes'
AND state != 'idle'
ORDER BY duration DESC;
SELECT pg_cancel_backend(pid);
SET work_mem = '256MB';
postgresql.conf and restart the database:SHOW config_file;
postgresql.conf, increase work_mem and/or shared_buffers, then restart PostgreSQL.Let Dr. Droid create custom investigation plans for your infrastructure.
Book Demo
