summaryrefslogtreecommitdiffstats
path: root/extra/sql_dumps/stats_table_size.sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2020-01-15 14:02:35 -0800
committerBryan Newbold <bnewbold@robocracy.org>2020-01-15 14:02:38 -0800
commitec445720e768d3f0cc56c03052833b86d5068547 (patch)
tree3c87c248b44f4c77da07374822506d15fe16ff92 /extra/sql_dumps/stats_table_size.sql
parent5235b034058f9c0cf8a418a4854ba1491fa347c7 (diff)
downloadfatcat-ec445720e768d3f0cc56c03052833b86d5068547.tar.gz
fatcat-ec445720e768d3f0cc56c03052833b86d5068547.zip
sql table size script: shorter output
This skips postgres-internal tables in size output
Diffstat (limited to 'extra/sql_dumps/stats_table_size.sql')
-rw-r--r--extra/sql_dumps/stats_table_size.sql1
1 files changed, 1 insertions, 0 deletions
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;