aboutsummaryrefslogtreecommitdiffstats
path: root/extra/stats/2019-06-04-prod-table-sizes.txt
blob: 1965d684f41905d7e52b21b6d3a0a9cf2497b4b7 (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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
                          table_name                          | table_size | indexes_size | total_size 
--------------------------------------------------------------+------------+--------------+------------
 "public"."refs_blob"                                         | 77 GB      | 2638 MB      | 80 GB
 "public"."release_rev"                                       | 44 GB      | 28 GB        | 72 GB
 "public"."release_contrib"                                   | 32 GB      | 30 GB        | 62 GB
 "public"."release_edit"                                      | 11 GB      | 18 GB        | 30 GB
 "public"."work_edit"                                         | 11 GB      | 18 GB        | 29 GB
 "public"."release_ident"                                     | 7768 MB    | 14 GB        | 22 GB
 "public"."work_ident"                                        | 7572 MB    | 14 GB        | 21 GB
 "public"."abstracts"                                         | 10 GB      | 904 MB       | 11 GB
 "public"."file_rev_url"                                      | 7967 MB    | 3267 MB      | 11 GB
 "public"."work_rev"                                          | 4908 MB    | 5821 MB      | 10 GB
 "public"."release_ref"                                       | 3950 MB    | 5626 MB      | 9577 MB
 "public"."file_rev"                                          | 2481 MB    | 4128 MB      | 6609 MB
 "public"."file_edit"                                         | 2003 MB    | 2790 MB      | 4793 MB
 "public"."file_rev_release"                                  | 1245 MB    | 2385 MB      | 3629 MB
 "public"."file_ident"                                        | 1343 MB    | 2208 MB      | 3551 MB
 "public"."release_rev_abstract"                              | 1204 MB    | 1628 MB      | 2832 MB
 "public"."editgroup"                                         | 591 MB     | 345 MB       | 936 MB
 "public"."creator_edit"                                      | 377 MB     | 420 MB       | 797 MB
 "public"."creator_rev"                                       | 370 MB     | 353 MB       | 723 MB
 "public"."creator_ident"                                     | 254 MB     | 319 MB       | 573 MB
 "public"."release_rev_extid"                                 | 190 MB     | 296 MB       | 486 MB
 "public"."changelog"                                         | 167 MB     | 199 MB       | 366 MB
 "public"."container_rev"                                     | 39 MB      | 14 MB        | 53 MB
 "public"."container_edit"                                    | 13 MB      | 20 MB        | 33 MB
 "public"."container_ident"                                   | 8440 kB    | 16 MB        | 24 MB
 "pg_catalog"."pg_depend"                                     | 568 kB     | 848 kB       | 1416 kB
 "pg_catalog"."pg_statistic"                                  | 1336 kB    | 40 kB        | 1376 kB
 "pg_catalog"."pg_proc"                                       | 648 kB     | 352 kB       | 1000 kB
 "pg_catalog"."pg_attribute"                                  | 664 kB     | 288 kB       | 952 kB
 "pg_catalog"."pg_rewrite"                                    | 584 kB     | 32 kB        | 616 kB
 "pg_catalog"."pg_description"                                | 360 kB     | 184 kB       | 544 kB
 "pg_catalog"."pg_collation"                                  | 216 kB     | 80 kB        | 296 kB
 "pg_catalog"."pg_class"                                      | 160 kB     | 136 kB       | 296 kB
 "pg_catalog"."pg_constraint"                                 | 152 kB     | 128 kB       | 280 kB
 "pg_catalog"."pg_operator"                                   | 152 kB     | 88 kB        | 240 kB
 "pg_catalog"."pg_type"                                       | 144 kB     | 80 kB        | 224 kB
 "pg_catalog"."pg_amop"                                       | 88 kB      | 112 kB       | 200 kB
 "pg_catalog"."pg_trigger"                                    | 80 kB      | 64 kB        | 144 kB
 "pg_catalog"."pg_amproc"                                     | 64 kB      | 64 kB        | 128 kB
 "pg_catalog"."pg_index"                                      | 80 kB      | 32 kB        | 112 kB
 "pg_catalog"."pg_conversion"                                 | 56 kB      | 48 kB        | 104 kB
 "information_schema"."sql_features"                          | 96 kB      | 0 bytes      | 96 kB
 "public"."webcapture_rev_cdx"                                | 56 kB      | 32 kB        | 88 kB
 "pg_catalog"."pg_attrdef"                                    | 56 kB      | 32 kB        | 88 kB
 "pg_catalog"."pg_opclass"                                    | 56 kB      | 32 kB        | 88 kB
 "public"."fileset_rev_file"                                  | 48 kB      | 32 kB        | 80 kB
 "pg_catalog"."pg_cast"                                       | 48 kB      | 32 kB        | 80 kB
 "pg_catalog"."pg_ts_config_map"                              | 48 kB      | 32 kB        | 80 kB
 "pg_catalog"."pg_opfamily"                                   | 48 kB      | 32 kB        | 80 kB
 "pg_catalog"."pg_extension"                                  | 40 kB      | 32 kB        | 72 kB
 "pg_catalog"."pg_namespace"                                  | 40 kB      | 32 kB        | 72 kB
 "pg_catalog"."pg_language"                                   | 40 kB      | 32 kB        | 72 kB
 "pg_catalog"."pg_am"                                         | 40 kB      | 32 kB        | 72 kB
 "pg_catalog"."pg_database"                                   | 40 kB      | 32 kB        | 72 kB
 "pg_catalog"."pg_tablespace"                                 | 40 kB      | 32 kB        | 72 kB
 "pg_catalog"."pg_auth_members"                               | 40 kB      | 32 kB        | 72 kB
 "pg_catalog"."pg_shdepend"                                   | 40 kB      | 32 kB        | 72 kB
 "pg_catalog"."pg_ts_config"                                  | 40 kB      | 32 kB        | 72 kB
 "pg_catalog"."pg_authid"                                     | 40 kB      | 32 kB        | 72 kB
 "pg_catalog"."pg_ts_dict"                                    | 40 kB      | 32 kB        | 72 kB
 "pg_catalog"."pg_ts_parser"                                  | 40 kB      | 32 kB        | 72 kB
 "pg_catalog"."pg_ts_template"                                | 40 kB      | 32 kB        | 72 kB
 "public"."auth_oidc"                                         | 16 kB      | 48 kB        | 64 kB
 "pg_catalog"."pg_init_privs"                                 | 48 kB      | 16 kB        | 64 kB
 "pg_catalog"."pg_aggregate"                                  | 48 kB      | 16 kB        | 64 kB
 "public"."editgroup_annotation"                              | 16 kB      | 48 kB        | 64 kB
 "public"."editor"                                            | 16 kB      | 48 kB        | 64 kB
 "pg_catalog"."pg_shdescription"                              | 48 kB      | 16 kB        | 64 kB
 "public"."fileset_edit"                                      | 16 kB      | 48 kB        | 64 kB
 "public"."webcapture_edit"                                   | 16 kB      | 48 kB        | 64 kB
 "pg_catalog"."pg_pltemplate"                                 | 40 kB      | 16 kB        | 56 kB
 "pg_catalog"."pg_range"                                      | 40 kB      | 16 kB        | 56 kB
 "information_schema"."sql_sizing"                            | 48 kB      | 0 bytes      | 48 kB
 "information_schema"."sql_packages"                          | 48 kB      | 0 bytes      | 48 kB
 "information_schema"."sql_languages"                         | 48 kB      | 0 bytes      | 48 kB
 "information_schema"."sql_implementation_info"               | 48 kB      | 0 bytes      | 48 kB
 "public"."webcapture_rev_url"                                | 16 kB      | 32 kB        | 48 kB
 "public"."fileset_rev_url"                                   | 16 kB      | 32 kB        | 48 kB
 "information_schema"."sql_parts"                             | 48 kB      | 0 bytes      | 48 kB
 "public"."fileset_rev_release"                               | 8192 bytes | 32 kB        | 40 kB
 "public"."fileset_ident"                                     | 8192 bytes | 32 kB        | 40 kB
 "public"."webcapture_rev_release"                            | 8192 bytes | 32 kB        | 40 kB
 "public"."webcapture_ident"                                  | 8192 bytes | 32 kB        | 40 kB
 "pg_catalog"."pg_statistic_ext"                              | 8192 bytes | 24 kB        | 32 kB
 "public"."webcapture_rev"                                    | 16 kB      | 16 kB        | 32 kB
 "public"."fileset_rev"                                       | 16 kB      | 16 kB        | 32 kB
 "public"."__diesel_schema_migrations"                        | 8192 bytes | 16 kB        | 24 kB
 "pg_catalog"."pg_sequence"                                   | 8192 bytes | 16 kB        | 24 kB
 "pg_catalog"."pg_enum"                                       | 0 bytes    | 24 kB        | 24 kB
 "pg_catalog"."pg_subscription"                               | 0 bytes    | 16 kB        | 16 kB
 "pg_catalog"."pg_db_role_setting"                            | 8192 bytes | 8192 bytes   | 16 kB
 "pg_catalog"."pg_inherits"                                   | 0 bytes    | 16 kB        | 16 kB
 "pg_catalog"."pg_event_trigger"                              | 0 bytes    | 16 kB        | 16 kB
 "pg_catalog"."pg_transform"                                  | 0 bytes    | 16 kB        | 16 kB
 "pg_catalog"."pg_shseclabel"                                 | 8192 bytes | 8192 bytes   | 16 kB
 "pg_catalog"."pg_publication"                                | 0 bytes    | 16 kB        | 16 kB
 "pg_catalog"."pg_publication_rel"                            | 0 bytes    | 16 kB        | 16 kB
 "pg_catalog"."pg_seclabel"                                   | 8192 bytes | 8192 bytes   | 16 kB
 "pg_catalog"."pg_default_acl"                                | 0 bytes    | 16 kB        | 16 kB
 "pg_catalog"."pg_replication_origin"                         | 0 bytes    | 16 kB        | 16 kB
 "pg_catalog"."pg_policy"                                     | 0 bytes    | 16 kB        | 16 kB
 "pg_catalog"."pg_foreign_server"                             | 0 bytes    | 16 kB        | 16 kB
 "pg_catalog"."pg_foreign_data_wrapper"                       | 0 bytes    | 16 kB        | 16 kB
 "pg_catalog"."pg_user_mapping"                               | 0 bytes    | 16 kB        | 16 kB
 "pg_catalog"."pg_foreign_table"                              | 0 bytes    | 8192 bytes   | 8192 bytes
 "pg_catalog"."pg_largeobject_metadata"                       | 0 bytes    | 8192 bytes   | 8192 bytes
 "pg_catalog"."pg_partitioned_table"                          | 0 bytes    | 8192 bytes   | 8192 bytes
 "pg_catalog"."pg_subscription_rel"                           | 0 bytes    | 8192 bytes   | 8192 bytes
 "pg_catalog"."pg_largeobject"                                | 0 bytes    | 8192 bytes   | 8192 bytes
 "information_schema"."sql_sizing_profiles"                   | 8192 bytes | 0 bytes      | 8192 bytes
 "pg_catalog"."pg_stat_xact_user_tables"                      | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_statio_all_tables"                          | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_statio_sys_tables"                          | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_statio_user_tables"                         | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_all_indexes"                           | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_sys_indexes"                           | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_user_indexes"                          | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_statio_user_indexes"                        | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_statio_all_sequences"                       | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_statio_sys_sequences"                       | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_statio_user_sequences"                      | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_activity"                              | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_replication"                           | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_wal_receiver"                          | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_subscription"                          | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_ssl"                                   | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_replication_slots"                          | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_database"                              | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_database_conflicts"                    | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_user_functions"                        | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_xact_user_functions"                   | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_archiver"                              | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_bgwriter"                              | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_progress_vacuum"                       | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_user_mappings"                              | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."key_column_usage"                      | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."information_schema_catalog_name"       | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."column_privileges"                     | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."applicable_roles"                      | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."administrable_role_authorizations"     | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."domain_udt_usage"                      | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."attributes"                            | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."column_udt_usage"                      | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."character_sets"                        | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."check_constraint_routine_usage"        | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."check_constraints"                     | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."columns"                               | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."collations"                            | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."collation_character_set_applicability" | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."column_domain_usage"                   | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."constraint_column_usage"               | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."domains"                               | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."constraint_table_usage"                | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."domain_constraints"                    | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."referential_constraints"               | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."enabled_roles"                         | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."parameters"                            | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."routine_privileges"                    | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."role_column_grants"                    | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."role_routine_grants"                   | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."routines"                              | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."schemata"                              | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."table_constraints"                     | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."sequences"                             | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_group"                                      | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_sys_tables"                            | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."table_privileges"                      | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_xact_all_tables"                       | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_all_tables"                            | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_timezone_names"                             | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."triggers"                              | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_timezone_abbrevs"                           | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."role_table_grants"                     | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_matviews"                                   | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."usage_privileges"                      | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."tables"                                | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."transforms"                            | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."udt_privileges"                        | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."triggered_update_columns"              | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."role_udt_grants"                       | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."user_defined_types"                    | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."role_usage_grants"                     | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."view_column_usage"                     | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."view_routine_usage"                    | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."view_table_usage"                      | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."views"                                 | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."data_type_privileges"                  | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."user_mapping_options"                  | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."element_types"                         | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."_pg_foreign_table_columns"             | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."column_options"                        | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."_pg_foreign_data_wrappers"             | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."foreign_data_wrapper_options"          | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."user_mappings"                         | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."foreign_data_wrappers"                 | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."_pg_foreign_servers"                   | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."foreign_server_options"                | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."foreign_servers"                       | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."_pg_foreign_tables"                    | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."foreign_table_options"                 | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_statio_sys_indexes"                         | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."foreign_tables"                        | 0 bytes    | 0 bytes      | 0 bytes
 "information_schema"."_pg_user_mappings"                     | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_seclabels"                                  | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_prepared_statements"                        | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_prepared_xacts"                             | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_statio_all_indexes"                         | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_available_extension_versions"               | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_available_extensions"                       | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_replication_origin_status"                  | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_cursors"                                    | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_locks"                                      | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_publication_tables"                         | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stats"                                      | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_sequences"                                  | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_indexes"                                    | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_tables"                                     | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_config"                                     | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_hba_file_rules"                             | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_file_settings"                              | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_views"                                      | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_rules"                                      | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_policies"                                   | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_user"                                       | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_settings"                                   | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_roles"                                      | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_shadow"                                     | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_xact_sys_tables"                       | 0 bytes    | 0 bytes      | 0 bytes
 "pg_catalog"."pg_stat_user_tables"                           | 0 bytes    | 0 bytes      | 0 bytes
(229 rows)