summaryrefslogtreecommitdiffstats
path: root/extra/sql_dumps
diff options
context:
space:
mode:
Diffstat (limited to 'extra/sql_dumps')
-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;