From ba604bbd1e6e865977e6d17873bc5de6389f7cba Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Fri, 9 Apr 2021 13:06:12 -0700 Subject: sql: before/after pg13 table size stats --- sql/stats/2021-04-07_stats.txt | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'sql/stats/2021-04-07_stats.txt') diff --git a/sql/stats/2021-04-07_stats.txt b/sql/stats/2021-04-07_stats.txt index 33b8a3f..fca76b9 100644 --- a/sql/stats/2021-04-07_stats.txt +++ b/sql/stats/2021-04-07_stats.txt @@ -1,6 +1,8 @@ ## SQL Table Sizes + Size: 551.34G + SELECT table_name, pg_size_pretty(table_size) AS table_size, @@ -20,7 +22,7 @@ ORDER BY total_size DESC ) AS pretty_sizes; - table_size | indexes_size | total_size + table_name | table_size | indexes_size | total_size -------------------------------+------------+--------------+------------ "public"."cdx" | 49 GB | 50 GB | 100 GB "public"."ingest_file_result" | 33 GB | 52 GB | 85 GB -- cgit v1.2.3