aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2021-11-01 18:10:42 -0700
committerBryan Newbold <bnewbold@archive.org>2021-11-04 17:19:52 -0700
commit7d4e3cd7229f55af8a5e443e6a22a4550b05ff7b (patch)
tree62423c5f44f2055c958701c561531b931e93f54c
parent1996cabae1be70d40cee03d1804a33797fc6d663 (diff)
downloadsandcrawler-7d4e3cd7229f55af8a5e443e6a22a4550b05ff7b.tar.gz
sandcrawler-7d4e3cd7229f55af8a5e443e6a22a4550b05ff7b.zip
record SQL table sizes at start of crossref re-ingest
-rw-r--r--sql/stats/2021-11-01_table_sizes.txt19
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/stats/2021-11-01_table_sizes.txt b/sql/stats/2021-11-01_table_sizes.txt
new file mode 100644
index 0000000..57f7e57
--- /dev/null
+++ b/sql/stats/2021-11-01_table_sizes.txt
@@ -0,0 +1,19 @@
+
+Size: 832.66G
+
+ table_name | table_size | indexes_size | total_size
+-------------------------------+------------+--------------+------------
+ "public"."crossref" | 311 GB | 9812 MB | 320 GB
+ "public"."ingest_request" | 44 GB | 40 GB | 84 GB
+ "public"."cdx" | 52 GB | 28 GB | 80 GB
+ "public"."grobid" | 72 GB | 6952 MB | 79 GB
+ "public"."ingest_file_result" | 38 GB | 40 GB | 78 GB
+ "public"."grobid_shadow" | 67 GB | 5455 MB | 73 GB
+ "public"."file_meta" | 34 GB | 21 GB | 54 GB
+ "public"."pdf_meta" | 20 GB | 5813 MB | 26 GB
+ "public"."fatcat_file" | 12 GB | 6602 MB | 18 GB
+ "public"."shadow" | 9517 MB | 8026 MB | 17 GB
+ "public"."html_meta" | 1200 MB | 8072 kB | 1208 MB
+ "public"."petabox" | 403 MB | 461 MB | 864 MB
+ "public"."pdftrio" | 550 MB | 297 MB | 847 MB
+(13 rows)