diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2020-01-19 10:19:50 -0800 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2020-01-19 10:21:10 -0800 |
| commit | c336d805bbe580d4d905398bfa86f52617eb8144 (patch) | |
| tree | 277bf166b9c3609b978b5aaf325d9c8f5d3374b3 /extra/stats/2019-06-04-prod-table-sizes.txt | |
| parent | 404b2b36e2a58f0a5c98963e0f1d3d4c9970c78a (diff) | |
| download | fatcat-c336d805bbe580d4d905398bfa86f52617eb8144.tar.gz fatcat-c336d805bbe580d4d905398bfa86f52617eb8144.zip | |
stats: remove internal PG table sizes from old dumps
For ease of reading and comparison
Diffstat (limited to 'extra/stats/2019-06-04-prod-table-sizes.txt')
| -rw-r--r-- | extra/stats/2019-06-04-prod-table-sizes.txt | 189 |
1 files changed, 0 insertions, 189 deletions
diff --git a/extra/stats/2019-06-04-prod-table-sizes.txt b/extra/stats/2019-06-04-prod-table-sizes.txt index 1965d684..c0e59dc2 100644 --- a/extra/stats/2019-06-04-prod-table-sizes.txt +++ b/extra/stats/2019-06-04-prod-table-sizes.txt @@ -25,209 +25,20 @@ "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) |