diff options
author | Bryan Newbold <bnewbold@archive.org> | 2019-11-12 13:22:18 -0800 |
---|---|---|
committer | Bryan Newbold <bnewbold@archive.org> | 2019-11-12 13:22:18 -0800 |
commit | e0ad2e3be5286b2703df8f0a98b450658e28d28b (patch) | |
tree | 4f2781af5cffe42531b8585b1d5e79607c613d28 /sql/table_sizes.md | |
parent | 2e3611f0e66615ae007d4e46bb5905e2220fb690 (diff) | |
download | sandcrawler-e0ad2e3be5286b2703df8f0a98b450658e28d28b.tar.gz sandcrawler-e0ad2e3be5286b2703df8f0a98b450658e28d28b.zip |
SQL stats and commands (mostly from sept 2019)
Diffstat (limited to 'sql/table_sizes.md')
-rw-r--r-- | sql/table_sizes.md | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/table_sizes.md b/sql/table_sizes.md new file mode 100644 index 0000000..3596b2b --- /dev/null +++ b/sql/table_sizes.md @@ -0,0 +1,11 @@ + +## September 2019 + + table_name | table_size | indexes_size | total_size + --------------------------------------------------------------+------------+--------------+------------ + "public"."cdx" | 31 GB | 27 GB | 58 GB + "public"."file_meta" | 13 GB | 6500 MB | 19 GB + "public"."shadow" | 8303 MB | 9216 MB | 17 GB + "public"."grobid" | 4994 MB | 6678 MB | 11 GB + "public"."fatcat_file" | 5206 MB | 2094 MB | 7300 MB + "public"."petabox" | 403 MB | 594 MB | 997 MB |