PgHero

Live Queries

1 query

Pid Duration State
4476 0.0 s active
puma: cluster worker 1: 1 [app] main
SELECT n.nspname AS schema, c.relname AS relation, CASE WHEN c.relkind = 'r' THEN 'table' ELSE 'index' END AS type, pg_table_size(c.oid) AS size_bytes FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname NOT IN ('pg_catalog', 'information_schema') AND n.nspname !~ '^pg_toast' AND c.relkind IN ('r', 'i') ORDER BY pg_table_size(c.oid) DESC, 2 ASC /*pghero*/

You may need to restart your app servers afterwards.