diff options
author | Bryan Newbold <bnewbold@archive.org> | 2021-04-09 13:06:12 -0700 |
---|---|---|
committer | Bryan Newbold <bnewbold@archive.org> | 2021-04-09 13:06:12 -0700 |
commit | ba604bbd1e6e865977e6d17873bc5de6389f7cba (patch) | |
tree | c79ba416bd107e237e25c91cb8c48b58e0127764 /sql/stats/2021-04-07_stats.txt | |
parent | dd4e8bcd6dbe0aaa141b94c851a47963bb49563a (diff) | |
download | sandcrawler-ba604bbd1e6e865977e6d17873bc5de6389f7cba.tar.gz sandcrawler-ba604bbd1e6e865977e6d17873bc5de6389f7cba.zip |
sql: before/after pg13 table size stats
Diffstat (limited to 'sql/stats/2021-04-07_stats.txt')
-rw-r--r-- | sql/stats/2021-04-07_stats.txt | 4 |
1 files changed, 3 insertions, 1 deletions
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 |