From ec445720e768d3f0cc56c03052833b86d5068547 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Wed, 15 Jan 2020 14:02:35 -0800 Subject: sql table size script: shorter output This skips postgres-internal tables in size output --- extra/sql_dumps/stats_table_size.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'extra/sql_dumps') diff --git a/extra/sql_dumps/stats_table_size.sql b/extra/sql_dumps/stats_table_size.sql index cb8da26d..7b6b7f8d 100644 --- a/extra/sql_dumps/stats_table_size.sql +++ b/extra/sql_dumps/stats_table_size.sql @@ -12,6 +12,7 @@ SELECT FROM ( SELECT ('"' || table_schema || '"."' || table_name || '"') AS table_name FROM information_schema.tables + WHERE table_schema = 'public' ) AS all_tables ORDER BY total_size DESC ) AS pretty_sizes; -- cgit v1.2.3