Live Queries

1 query

Pid Duration State

4476

0.0 s

active

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/`

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.