Difference between revisions of "Template:Table size"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
SELECT | SELECT | ||
[[schema_name]], | [[schema_name]], | ||
− | relname, | + | [[relname]], |
pg_size_pretty(table_size) AS size, | pg_size_pretty(table_size) AS size, | ||
table_size | table_size |
Revision as of 10:15, 3 March 2023
SELECT schema_name, relname, pg_size_pretty(table_size) AS size, table_size FROM ( SELECT pg_catalog.pg_namespace.nspname AS schema_name, relname, pg_relation_size(pg_catalog.pg_class.oid) AS table_size FROM pg_catalog.pg_class JOIN pg_catalog.pg_namespace ON relnamespace = pg_catalog.pg_namespace.oid ) t WHERE schema_name NOT LIKE 'pg_%' ORDER BY table_size DESC;
Advertising: