Difference between revisions of "Template:Table size"
Jump to navigation
Jump to search
(Created page with " SELECT schema_name, relname, pg_size_pretty(table_size) AS size, table_size FROM ( SELECT pg_catalog.pg_namespace.nspname AS schema_name,...") |
|||
(6 intermediate revisions by the same user not shown) | |||
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]] |
FROM ( | FROM ( | ||
SELECT | SELECT | ||
− | pg_catalog.pg_namespace.nspname AS schema_name, | + | [[pg_catalog]].pg_namespace.nspname AS schema_name, |
relname, | relname, | ||
− | pg_relation_size(pg_catalog.pg_class.oid) AS table_size | + | [[pg_relation_size]](pg_catalog.pg_class.oid) AS table_size |
− | + | ||
FROM pg_catalog.pg_class | FROM pg_catalog.pg_class | ||
JOIN pg_catalog.pg_namespace ON relnamespace = pg_catalog.pg_namespace.oid | JOIN pg_catalog.pg_namespace ON relnamespace = pg_catalog.pg_namespace.oid | ||
) t | ) t | ||
− | WHERE schema_name NOT LIKE 'pg_%' | + | WHERE [[schema_name]] NOT LIKE 'pg_%' |
ORDER BY table_size DESC; | ORDER BY table_size DESC; |
Latest revision as of 10:18, 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: