blob: a8a9cd54b518657ff0b8990f7342375154917e61 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
## SQL Table Sizes
Size: 467.23G
SELECT
table_name,
pg_size_pretty(table_size) AS table_size,
pg_size_pretty(indexes_size) AS indexes_size,
pg_size_pretty(total_size) AS total_size
FROM (
SELECT
table_name,
pg_table_size(table_name) AS table_size,
pg_indexes_size(table_name) AS indexes_size,
pg_total_relation_size(table_name) AS total_size
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;
table_name | table_size | indexes_size | total_size
-------------------------------+------------+--------------+------------
"public"."cdx" | 49 GB | 26 GB | 76 GB
"public"."grobid" | 69 GB | 6834 MB | 75 GB
"public"."grobid_shadow" | 67 GB | 5455 MB | 73 GB
"public"."ingest_request" | 39 GB | 32 GB | 70 GB
"public"."ingest_file_result" | 32 GB | 29 GB | 60 GB
"public"."file_meta" | 32 GB | 21 GB | 53 GB
"public"."pdf_meta" | 18 GB | 3733 MB | 22 GB
"public"."fatcat_file" | 12 GB | 6602 MB | 18 GB
"public"."shadow" | 9517 MB | 8026 MB | 17 GB
"public"."html_meta" | 1196 MB | 8072 kB | 1204 MB
"public"."petabox" | 403 MB | 461 MB | 864 MB
"public"."pdftrio" | 550 MB | 297 MB | 847 MB
(12 rows)
|
