Index cleanup and maintenance #661
Description
This is an issue to track potential optimizations on the database schema. At the bottom of this issue I'm attaching a dump of the statistics of the indexes since the last postgres restart.
The production database is sitting at 98GB at the moment with the biggest tables being shared_nixderivation_dependencies and shared_nixderivationoutput at 36GB and 35GB respectively. Here's the description of shared_nixderivationdependecies:
\d shared_nixderivation_dependencies
Table "public.shared_nixderivation_dependencies"
Column | Type | Collation | Nullable | Default
------------------------+--------+-----------+----------+----------------------------------
id | bigint | | not null | generated by default as identity
nixderivation_id | bigint | | not null |
nixderivationoutput_id | bigint | | not null |
Indexes:
"shared_nixderivation_dependencies_pkey" PRIMARY KEY, btree (id)
"shared_nixderivation_dep_nixderivation_id_nixderi_7ba267e1_uniq" UNIQUE CONSTRAINT, btree (nixderivation_id, nixderivationoutput_id)
"shared_nixderivation_depen_nixderivationoutput_id_7f3af1e5" btree (nixderivationoutput_id)
"shared_nixderivation_dependencies_nixderivation_id_1e830ca9" btree (nixderivation_id)
Foreign-key constraints:
"shared_nixderivation_nixderivation_id_1e830ca9_fk_shared_ni" FOREIGN KEY (nixderivation_id) REFERENCES shared_nixderivation(id) DEFERRABLE INITIALLY DEFERRED
"shared_nixderivation_nixderivationoutput__7f3af1e5_fk_shared_ni" FOREIGN KEY (nixderivationoutput_id) REFERENCES shared_nixderivationoutput(id) DEFERRABLE INITIALLY DEFERRED
One thing that pops up is that the shared_nixderivation_dependencies_pkey index which was automatically created as the primary key is never used. In its place instead the shared_nixderivation_dependencies_nixderivation_id_1e830ca9 index is used. Similarly, shared_nixderivation_dep_nixderivation_id_nixderi_7ba267e1_uniq is never used which is a unique constraint on nixderivation_id and nixderivationoutput_id. I think we can drop the autogenerated primary key and maybe also drop the single indexes on nixderivation_id and nixderivationoutput_idand instead depend on a composite primary key with both fields and save between 6-18GB (depending on if we can drop all three indexes).
Index statistics:
tablename,indexname,num_rows,table_size,index_size,unique,number_of_scans,tuples_read,tuples_fetched
account_emailaddress,account_emailaddress_email_03be32b2,2,8192 bytes,16 kB,N,0,0,0
account_emailaddress,account_emailaddress_email_03be32b2_like,2,8192 bytes,16 kB,N,6,0,0
account_emailaddress,account_emailaddress_pkey,2,8192 bytes,16 kB,Y,0,0,0
account_emailaddress,account_emailaddress_user_id_2c513194,2,8192 bytes,16 kB,N,0,0,0
account_emailaddress,account_emailaddress_user_id_email_987c8728_uniq,2,8192 bytes,16 kB,Y,2,0,0
account_emailaddress,unique_primary_email,2,8192 bytes,16 kB,Y,0,0,0
account_emailaddress,unique_verified_email,2,8192 bytes,8192 bytes,Y,0,0,0
account_emailconfirmation,account_emailconfirmation_email_address_id_5b7f8c58,0,0 bytes,8192 bytes,N,0,0,0
account_emailconfirmation,account_emailconfirmation_key_f43612bd_like,0,0 bytes,8192 bytes,N,0,0,0
account_emailconfirmation,account_emailconfirmation_key_key,0,0 bytes,8192 bytes,Y,0,0,0
account_emailconfirmation,account_emailconfirmation_pkey,0,0 bytes,8192 bytes,Y,0,0,0
auth_group,auth_group_name_a6ea08ec_like,2,8192 bytes,16 kB,N,227,226,226
auth_group,auth_group_name_key,2,8192 bytes,16 kB,Y,0,0,0
auth_group,auth_group_pkey,2,8192 bytes,16 kB,Y,1,1,1
auth_group_permissions,auth_group_permissions_group_id_b120cbf9,0,0 bytes,8192 bytes,N,0,0,0
auth_group_permissions,auth_group_permissions_group_id_permission_id_0cd325b0_uniq,0,0 bytes,8192 bytes,Y,0,0,0
auth_group_permissions,auth_group_permissions_permission_id_84c5c92e,0,0 bytes,8192 bytes,N,0,0,0
auth_group_permissions,auth_group_permissions_pkey,0,0 bytes,8192 bytes,Y,0,0,0
auth_permission,auth_permission_content_type_id_2f476e4b,244,24 kB,16 kB,N,240,888,852
auth_permission,auth_permission_content_type_id_codename_01ab375a_uniq,244,24 kB,32 kB,Y,0,0,0
auth_permission,auth_permission_pkey,244,24 kB,16 kB,Y,0,0,0
auth_user,auth_user_pkey,2,8192 bytes,16 kB,Y,101,101,101
auth_user,auth_user_username_6821ab7c_like,2,8192 bytes,16 kB,N,0,0,0
auth_user,auth_user_username_key,2,8192 bytes,16 kB,Y,0,0,0
auth_user_groups,auth_user_groups_group_id_97559544,1,8192 bytes,16 kB,N,0,0,0
auth_user_groups,auth_user_groups_pkey,1,8192 bytes,16 kB,Y,552,0,0
auth_user_groups,auth_user_groups_user_id_6a12ed8b,1,8192 bytes,16 kB,N,0,0,0
auth_user_groups,auth_user_groups_user_id_group_id_94350c0c_uniq,1,8192 bytes,16 kB,Y,707,546,546
auth_user_user_permissions,auth_user_user_permissions_permission_id_1fbb5f2c,0,0 bytes,8192 bytes,N,0,0,0
auth_user_user_permissions,auth_user_user_permissions_pkey,0,0 bytes,8192 bytes,Y,0,0,0
auth_user_user_permissions,auth_user_user_permissions_user_id_a95ead1b,0,0 bytes,8192 bytes,N,0,0,0
auth_user_user_permissions,auth_user_user_permissions_user_id_permission_id_14a6b632_uniq,0,0 bytes,8192 bytes,Y,0,0,0
debug_toolbar_historyentry,debug_toolbar_historyentry_pkey,-1,0 bytes,8192 bytes,Y,0,0,0
django_admin_log,django_admin_log_content_type_id_c4bce8eb,0,0 bytes,8192 bytes,N,0,0,0
django_admin_log,django_admin_log_pkey,0,0 bytes,8192 bytes,Y,0,0,0
django_admin_log,django_admin_log_user_id_c564eba6,0,0 bytes,8192 bytes,N,0,0,0
django_content_type,django_content_type_app_label_model_76bd3d3b_uniq,61,8192 bytes,16 kB,Y,174,305,305
django_content_type,django_content_type_pkey,61,8192 bytes,16 kB,Y,444,444,444
django_migrations,django_migrations_pkey,105,16 kB,16 kB,Y,2220786,11208276,11208276
django_session,django_session_expire_date_a5c62663,19,16 kB,16 kB,N,624,624,624
django_session,django_session_pkey,19,16 kB,16 kB,Y,0,0,0
django_session,django_session_session_key_c0390e0f_like,19,16 kB,16 kB,N,125,171,109
pghistory_context,pghistory_context_pkey,486,56 kB,40 kB,Y,62320,61834,61834
pgpubsub_notification,pgpubsub_notification_pkey,53757,25 MB,1248 kB,Y,1101779,1101779,1101779
shared_affectedproduct,affprod_with_pkgnames_idx,1.436174e+06,249 MB,2024 kB,N,0,0,0
shared_affectedproduct,shared_affe_search__aa6eef_gin,1.436174e+06,249 MB,23 MB,N,0,0,0
shared_affectedproduct,shared_affectedproduct_pkey,1.436174e+06,249 MB,32 MB,Y,12585149,12560077,11446239
shared_affectedproduct_cpes,shared_affectedproduct_c_affectedproduct_id_cpe_i_745a2881_uniq,739549,37 MB,23 MB,Y,931113,130096,6866
shared_affectedproduct_cpes,shared_affectedproduct_cpes_affectedproduct_id_7a75feb3,739549,37 MB,14 MB,N,1587802,216559,216559
shared_affectedproduct_cpes,shared_affectedproduct_cpes_cpe_id_5c8b7ebc,739549,37 MB,6152 kB,N,3179762,3179762,3061422
shared_affectedproduct_cpes,shared_affectedproduct_cpes_pkey,739549,37 MB,16 MB,Y,750296,0,0
shared_affectedproduct_modules,shared_affectedproduct_m_affectedproduct_id_modul_71459c43_uniq,11802,664 kB,416 kB,Y,1494876,0,0
shared_affectedproduct_modules,shared_affectedproduct_modules_affectedproduct_id_113df661,11802,664 kB,288 kB,N,15632,0,0
shared_affectedproduct_modules,shared_affectedproduct_modules_module_id_afeefb28,11802,664 kB,184 kB,N,2337532,2337532,2000357
shared_affectedproduct_modules,shared_affectedproduct_modules_pkey,11802,664 kB,304 kB,Y,12885,0,0
shared_affectedproduct_platforms,shared_affectedproduct_p_affectedproduct_id_platf_f588ef39_uniq,788178,41 MB,25 MB,Y,1155947,0,0
shared_affectedproduct_platforms,shared_affectedproduct_platforms_affectedproduct_id_c31c3193,788178,41 MB,16 MB,N,1160374,0,0
shared_affectedproduct_platforms,shared_affectedproduct_platforms_pkey,788178,41 MB,18 MB,Y,818698,0,0
shared_affectedproduct_platforms,shared_affectedproduct_platforms_platform_id_9e02d405,788178,41 MB,5608 kB,N,2299513,2299513,1974265
shared_affectedproduct_program_files,shared_affectedproduct_p_affectedproduct_id_progr_2ffd2173_uniq,96761,5256 kB,3192 kB,Y,1430638,0,0
shared_affectedproduct_program_files,shared_affectedproduct_pro_affectedproduct_id_a756dd5b,96761,5256 kB,2032 kB,N,169616,0,0
shared_affectedproduct_program_files,shared_affectedproduct_program_files_pkey,96761,5256 kB,2272 kB,Y,103061,0,0
shared_affectedproduct_program_files,shared_affectedproduct_program_files_programfile_id_23d922ce,96761,5256 kB,856 kB,N,2128584,2128584,1867543
shared_affectedproduct_program_routines,shared_affectedproduct_p_affectedproduct_id_progr_bf316550_uniq,5366,280 kB,184 kB,Y,402469,0,0
shared_affectedproduct_program_routines,shared_affectedproduct_pro_affectedproduct_id_f0fa86a7,5366,280 kB,64 kB,N,1077486,0,0
shared_affectedproduct_program_routines,shared_affectedproduct_pro_programroutine_id_c4faa590,5366,280 kB,72 kB,N,2521204,2521204,2467552
shared_affectedproduct_program_routines,shared_affectedproduct_program_routines_pkey,5366,280 kB,136 kB,Y,5415,0,0
shared_affectedproduct_versions,shared_affectedproduct_v_affectedproduct_id_versi_46b7b29d_uniq,2.53472e+06,131 MB,79 MB,Y,2700559,0,0
shared_affectedproduct_versions,shared_affectedproduct_versions_affectedproduct_id_e29900a4,2.53472e+06,131 MB,40 MB,N,1973839,295280,295280
shared_affectedproduct_versions,shared_affectedproduct_versions_pkey,2.53472e+06,131 MB,56 MB,Y,2633903,0,0
shared_affectedproduct_versions,shared_affectedproduct_versions_version_id_efdfdccc,2.53472e+06,131 MB,56 MB,N,4080442,4080442,3563648
shared_cachednixpkgsissue,shared_cachednixpkgsissue_pkey,0,24 kB,16 kB,Y,1441,2121,1422
shared_cachedsuggestions,shared_cachedsuggestions_pkey,1299,1528 kB,72 kB,Y,34725,4044264,156040
shared_container,shared_cont_search__979c85_gin,1.074495e+06,182 MB,16 MB,N,0,0,0
shared_container,shared_container_cve_id_07ae74e2,1.074495e+06,182 MB,15 MB,N,15848,198217,198217
shared_container,shared_container_pkey,1.074495e+06,182 MB,24 MB,Y,5881691,5881691,5873775
shared_container,shared_container_provider_id_0137d8b3,1.074495e+06,182 MB,7840 kB,N,0,0,0
shared_container_affected,shared_container_affecte_container_id_affectedpro_7b86fc98_uniq,1.436136e+06,75 MB,45 MB,Y,1499093,0,0
shared_container_affected,shared_container_affected_affectedproduct_id_0fb20f14,1.436136e+06,75 MB,32 MB,N,4424172,4424172,3310418
shared_container_affected,shared_container_affected_container_id_d819bbfa,1.436136e+06,75 MB,19 MB,N,2376551,2346216,2340924
shared_container_affected,shared_container_affected_pkey,1.436136e+06,75 MB,32 MB,Y,1497623,0,0
shared_container_configurations,shared_container_configu_container_id_description_255f1fc9_uniq,1899,104 kB,80 kB,Y,1034140,0,0
shared_container_configurations,shared_container_configurations_container_id_7a2d88e8,1899,104 kB,64 kB,N,63126,0,0
shared_container_configurations,shared_container_configurations_description_id_5367fb8d,1899,104 kB,64 kB,N,1969062,1969062,1969062
shared_container_configurations,shared_container_configurations_pkey,1899,104 kB,64 kB,Y,1976,0,0
shared_container_credits,shared_container_credits_container_id_1db3a457,117186,6088 kB,2528 kB,N,34378,0,0
shared_container_credits,shared_container_credits_container_id_credit_id_6f5ba182_uniq,117186,6088 kB,3696 kB,Y,1195415,0,0
shared_container_credits,shared_container_credits_credit_id_6d0fbb13,117186,6088 kB,2648 kB,N,2218666,2218666,2107453
shared_container_credits,shared_container_credits_pkey,117186,6088 kB,2648 kB,Y,119430,0,0
shared_container_descriptions,shared_container_descrip_container_id_description_df801546_uniq,540669,28 MB,17 MB,Y,1592814,7754,2348
shared_container_descriptions,shared_container_descriptions_container_id_da75c694,540669,28 MB,12 MB,N,133102,25072,23738
shared_container_descriptions,shared_container_descriptions_description_id_51822841,540669,28 MB,12 MB,N,1846849,1846849,1773805
shared_container_descriptions,shared_container_descriptions_pkey,540669,28 MB,12 MB,Y,556926,0,0
shared_container_exploits,shared_container_exploit_container_id_description_60656842_uniq,10503,544 kB,344 kB,Y,1101062,0,0
shared_container_exploits,shared_container_exploits_container_id_d32aa6c8,10503,544 kB,248 kB,N,19877,0,0
shared_container_exploits,shared_container_exploits_description_id_a9bf92b6,10503,544 kB,248 kB,N,1933386,1933386,1766216
shared_container_exploits,shared_container_exploits_pkey,10503,544 kB,248 kB,Y,10576,0,0
shared_container_metrics,shared_container_metrics_container_id_59b3f0e0,558615,28 MB,11 MB,N,485786,26625,24036
shared_container_metrics,shared_container_metrics_container_id_metric_id_52e52c95_uniq,558615,28 MB,17 MB,Y,1240208,38452,6993
shared_container_metrics,shared_container_metrics_metric_id_f609b31a,558615,28 MB,12 MB,N,2232615,2232615,2045784
shared_container_metrics,shared_container_metrics_pkey,558615,28 MB,12 MB,Y,559412,0,0
shared_container_problem_types,shared_container_problem_container_id_problemtype_9f71bbd4_uniq,0,0 bytes,8192 bytes,Y,0,0,0
shared_container_problem_types,shared_container_problem_types_container_id_4cd7a7bd,0,0 bytes,8192 bytes,N,1074495,0,0
shared_container_problem_types,shared_container_problem_types_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_container_problem_types,shared_container_problem_types_problemtype_id_4c8de662,0,0 bytes,8192 bytes,N,0,0,0
shared_container_references,shared_container_referen_container_id_reference_i_c9fa2993_uniq,2.856931e+06,146 MB,88 MB,Y,2956526,0,0
shared_container_references,shared_container_references_container_id_5be49907,2.856931e+06,146 MB,38 MB,N,1091894,0,0
shared_container_references,shared_container_references_pkey,2.856931e+06,146 MB,63 MB,Y,2938057,0,0
shared_container_references,shared_container_references_reference_id_965160f6,2.856931e+06,146 MB,63 MB,N,2220612,2220612,2202971
shared_container_solutions,shared_container_solutio_container_id_description_a9d05f4c_uniq,29854,1576 kB,968 kB,Y,1136625,0,0
shared_container_solutions,shared_container_solutions_container_id_36561e18,29854,1576 kB,696 kB,N,2635,0,0
shared_container_solutions,shared_container_solutions_description_id_3977a497,29854,1576 kB,696 kB,N,1985713,1985713,1977113
shared_container_solutions,shared_container_solutions_pkey,29854,1576 kB,696 kB,Y,30910,0,0
shared_container_tags,shared_container_tags_container_id_e486247c,5889,336 kB,160 kB,N,26965,0,0
shared_container_tags,shared_container_tags_container_id_tag_id_82d19a46_uniq,5889,336 kB,216 kB,Y,1082813,0,0
shared_container_tags,shared_container_tags_pkey,5889,336 kB,160 kB,Y,6491,0,0
shared_container_tags,shared_container_tags_tag_id_b37e96e6,5889,336 kB,72 kB,N,1788294,1788294,1742496
shared_container_timeline,shared_container_timeline_container_id_13ec721d,101602,5208 kB,1776 kB,N,944070,0,0
shared_container_timeline,shared_container_timeline_container_id_event_id_ea83246b_uniq,101602,5208 kB,3168 kB,Y,268456,0,0
shared_container_timeline,shared_container_timeline_event_id_d7152037,101602,5208 kB,2256 kB,N,2218666,2218666,2051624
shared_container_timeline,shared_container_timeline_pkey,101602,5208 kB,2256 kB,Y,102163,0,0
shared_container_workarounds,shared_container_workaro_container_id_description_d8c08233_uniq,10758,600 kB,376 kB,Y,1116602,0,0
shared_container_workarounds,shared_container_workarounds_container_id_bc1e0672,10758,600 kB,272 kB,N,3949,0,0
shared_container_workarounds,shared_container_workarounds_description_id_f44a85b3,10758,600 kB,272 kB,N,2015028,2015028,1976796
shared_container_workarounds,shared_container_workarounds_pkey,10758,600 kB,272 kB,Y,11661,0,0
shared_cpe,shared_cpe_pkey,30491,5864 kB,696 kB,Y,4168998,4168998,4168998
shared_cpe,shared_cpe_search__347dd9_gin,30491,5864 kB,2024 kB,N,0,0,0
shared_credit,shared_credit_description_id_5c8278d8,117186,6768 kB,2648 kB,N,0,0,0
shared_credit,shared_credit_pkey,117186,6768 kB,2648 kB,Y,2337863,2337863,2226642
shared_credit,shared_credit_user_id_5d31bf01,117186,6768 kB,832 kB,N,0,0,0
shared_cvederivationclusterproposal,shared_cvederivationclusterproposals_cve_id_94444f15,1346,104 kB,48 kB,N,1101709,15800,15768
shared_cvederivationclusterproposal,shared_cvederivationclusterproposals_pkey,1346,104 kB,48 kB,Y,559100,567673,561422
shared_cvederivationclusterproposalstatusevent,shared_cvederivationcluste_pgh_context_id_3c9b5e8a,1346,104 kB,40 kB,N,0,0,0
shared_cvederivationclusterproposalstatusevent,shared_cvederivationcluste_pgh_obj_id_61ad5d9c,1346,104 kB,48 kB,N,39156,41008,41008
shared_cvederivationclusterproposalstatusevent,shared_cvederivationclusterproposalstatusevent_pkey,1346,104 kB,48 kB,Y,0,0,0
shared_cveingestion,shared_cveingestion_pkey,659,40 kB,32 kB,Y,0,0,0
shared_cverecord,shared_cver_cve_id_7c6dc8_btree,301148,40 MB,9936 kB,N,541761,514318,236951
shared_cverecord,shared_cverecord_assigner_id_abe61879,301148,40 MB,2328 kB,N,0,0,0
shared_cverecord,shared_cverecord_pkey,301148,40 MB,7024 kB,Y,2454497,3819365,2454497
shared_cverecord,shared_cverecord_requester_id_7fa7dff1,301148,40 MB,2152 kB,N,0,0,0
shared_derivationclusterproposallink,shared_derivationclusterproposallink_derivation_id_cb0537c8,477402,27 MB,26 MB,N,15864,15864,10618
shared_derivationclusterproposallink,shared_derivationclusterproposallink_pkey,477402,27 MB,27 MB,Y,0,0,0
shared_derivationclusterproposallink,shared_derivationclusterproposallink_proposal_id_bacb7e9d,477402,27 MB,8280 kB,N,7946,2403924,1767713
shared_derivationclusterproposallinkevent,shared_derivationclusterpr_derivation_id_d21848d7,477402,50 MB,26 MB,N,0,0,0
shared_derivationclusterproposallinkevent,shared_derivationclusterpr_pgh_context_id_b829e6bf,477402,50 MB,8096 kB,N,0,0,0
shared_derivationclusterproposallinkevent,shared_derivationclusterproposallinkevent_pgh_obj_id_fdaeae10,477402,50 MB,27 MB,N,0,0,0
shared_derivationclusterproposallinkevent,shared_derivationclusterproposallinkevent_pkey,477402,50 MB,27 MB,Y,0,0,0
shared_derivationclusterproposallinkevent,shared_derivationclusterproposallinkevent_proposal_id_b9922d8a,477402,50 MB,8280 kB,N,0,0,0
shared_description,shared_desc_search__dd1c6d_gin,916241,470 MB,94 MB,N,0,0,0
shared_description,shared_description_pkey,916241,470 MB,20 MB,Y,9956485,9930684,9392402
shared_description_media,shared_description_media_description_id_2f7efa53,91185,4896 kB,2120 kB,N,38977,0,0
shared_description_media,shared_description_media_description_id_supportin_ebf6cc71_uniq,91185,4896 kB,2976 kB,Y,1009719,0,0
shared_description_media,shared_description_media_pkey,91185,4896 kB,2120 kB,Y,96030,0,0
shared_description_media,shared_description_media_supportingmedia_id_30072b4d,91185,4896 kB,2120 kB,N,1900491,1900491,1705049
shared_event,shared_event_description_id_e2645830,101600,5208 kB,2256 kB,N,0,0,0
shared_event,shared_event_pkey,101600,5208 kB,2256 kB,Y,2320780,2320780,2153730
shared_impact,shared_impact_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_impact_description,shared_impact_descriptio_impact_id_description_id_b66c5060_uniq,0,0 bytes,8192 bytes,Y,0,0,0
shared_impact_description,shared_impact_description_description_id_709f8d3b,0,0 bytes,8192 bytes,N,0,0,0
shared_impact_description,shared_impact_description_impact_id_60d2ebe0,0,0 bytes,8192 bytes,N,0,0,0
shared_impact_description,shared_impact_description_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_maintainersedit,shared_maintainersedit_maintainer_id_914929c4,0,8192 bytes,16 kB,N,0,0,0
shared_maintainersedit,shared_maintainersedit_pkey,0,8192 bytes,16 kB,Y,0,0,0
shared_maintainersedit,shared_maintainersedit_suggestion_id_3ec5a3af,0,8192 bytes,16 kB,N,0,0,0
shared_maintainersedit,unique_maintainer_edit_per_suggestion,0,8192 bytes,16 kB,Y,1293,0,0
shared_maintainerseditevent,shared_maintainerseditevent_maintainer_id_23295566,0,8192 bytes,16 kB,N,0,0,0
shared_maintainerseditevent,shared_maintainerseditevent_pgh_context_id_4b40c166,0,8192 bytes,16 kB,N,0,0,0
shared_maintainerseditevent,shared_maintainerseditevent_pgh_obj_id_266dce41,0,8192 bytes,16 kB,N,0,0,0
shared_maintainerseditevent,shared_maintainerseditevent_pkey,0,8192 bytes,16 kB,Y,0,0,0
shared_maintainerseditevent,shared_maintainerseditevent_suggestion_id_81525fbb,0,8192 bytes,16 kB,N,13160,0,0
shared_metric,shared_metric_pkey,558643,128 MB,12 MB,Y,2966833,2966833,2780028
shared_metric_scenarios,shared_metric_scenarios_description_id_1a3ffcee,111409,5912 kB,2568 kB,N,978743,978743,809726
shared_metric_scenarios,shared_metric_scenarios_metric_id_bdcdd94e,111409,5912 kB,2568 kB,N,44280,1023,1023
shared_metric_scenarios,shared_metric_scenarios_metric_id_description_id_cac16924_uniq,111409,5912 kB,3584 kB,Y,688337,2097,2097
shared_metric_scenarios,shared_metric_scenarios_pkey,111409,5912 kB,2568 kB,Y,115904,0,0
shared_module,shared_module_pkey,2875,192 kB,88 kB,Y,2473156,2473156,2445947
shared_nixchannel,shared_nixchannel_channel_branch_1b1d6dd0_like,9,16 kB,16 kB,N,280,399,271
shared_nixchannel,shared_nixchannel_pkey,9,16 kB,16 kB,Y,0,0,0
shared_nixderivation,shared_nixd_attribu_5fcca7_btree,1.8797328e+07,5180 MB,134 MB,N,0,0,0
shared_nixderivation,shared_nixd_name_fd9eb7_btree,1.8797328e+07,5180 MB,184 MB,N,0,0,0
shared_nixderivation,shared_nixd_search__8fd81f_gin,1.8797328e+07,5180 MB,197 MB,N,0,0,0
shared_nixderivation,shared_nixderivation_metadata_id_key,1.8797328e+07,5180 MB,593 MB,Y,7816,7816,3908
shared_nixderivation,shared_nixderivation_parent_evaluation_id_3952df85,1.8797328e+07,5180 MB,121 MB,N,7428,12647463867,2622389849
shared_nixderivation,shared_nixderivation_pkey,1.8797328e+07,5180 MB,403 MB,Y,314680785,316548981,313643682
shared_nixderivation_dependencies,shared_nixderivation_dep_nixderivation_id_nixderi_7ba267e1_uniq,2.8006867e+08,14 GB,8480 MB,Y,0,0,0
shared_nixderivation_dependencies,shared_nixderivation_depen_nixderivationoutput_id_7f3af1e5,2.8006867e+08,14 GB,6041 MB,N,7816,7816,3908
shared_nixderivation_dependencies,shared_nixderivation_dependencies_nixderivation_id_1e830ca9,2.8006867e+08,14 GB,2279 MB,N,445225,7821265,4512078
shared_nixderivation_dependencies,shared_nixderivation_dependencies_pkey,2.8006867e+08,14 GB,6041 MB,Y,0,0,0
shared_nixderivation_outputs,shared_nixderivation_out_nixderivation_id_nixstor_f57d0dc2_uniq,3.0189836e+07,1517 MB,917 MB,Y,9,9,0
shared_nixderivation_outputs,shared_nixderivation_outputs_nixderivation_id_06e515b4,3.0189836e+07,1517 MB,594 MB,N,445216,703150,703150
shared_nixderivation_outputs,shared_nixderivation_outputs_nixstorepathoutput_id_089218ec,3.0189836e+07,1517 MB,270 MB,N,7815,7815,2588
shared_nixderivation_outputs,shared_nixderivation_outputs_pkey,3.0189836e+07,1517 MB,653 MB,Y,0,0,0
shared_nixderivationmeta,shared_nixd_search__c5ba7b_gin,2.0135118e+07,6383 MB,231 MB,N,0,0,0
shared_nixderivationmeta,shared_nixderivationmeta_pkey,2.0135118e+07,6383 MB,434 MB,Y,61186627,61186627,61182719
shared_nixderivationmeta_licenses,shared_nixderivationmeta_licenses_nixderivationmeta_id_36fcc6d6,2.1135496e+07,1057 MB,431 MB,N,0,0,0
shared_nixderivationmeta_licenses,shared_nixderivationmeta_licenses_nixlicense_id_2063c167,2.1135496e+07,1057 MB,136 MB,N,0,0,0
shared_nixderivationmeta_licenses,shared_nixderivationmeta_licenses_pkey,2.1135496e+07,1057 MB,455 MB,Y,0,0,0
shared_nixderivationmeta_licenses,shared_nixderivationmeta_nixderivationmeta_id_nix_a01cfee3_uniq,2.1135496e+07,1057 MB,639 MB,Y,0,0,0
shared_nixderivationmeta_maintainers,shared_nixderivationmeta_m_nixderivationmeta_id_6b539cf7,2.0484888e+07,1029 MB,358 MB,N,445225,497618,497618
shared_nixderivationmeta_maintainers,shared_nixderivationmeta_maintainers_nixmaintainer_id_8b3ac510,2.0484888e+07,1029 MB,146 MB,N,7816,7816,3907
shared_nixderivationmeta_maintainers,shared_nixderivationmeta_maintainers_pkey,2.0484888e+07,1029 MB,443 MB,Y,0,0,0
shared_nixderivationmeta_maintainers,shared_nixderivationmeta_nixderivationmeta_id_nix_cad7ce1c_uniq,2.0484888e+07,1029 MB,622 MB,Y,0,0,0
shared_nixderivationmeta_source_provenances,shared_nixderivationmeta_nixderivationmeta_id_nix_b30aa5d2_uniq,0,0 bytes,8192 bytes,Y,0,0,0
shared_nixderivationmeta_source_provenances,shared_nixderivationmeta_s_nixderivationmeta_id_fe888654,0,0 bytes,8192 bytes,N,0,0,0
shared_nixderivationmeta_source_provenances,shared_nixderivationmeta_s_nixsourceprovenance_id_9c681f54,0,0 bytes,8192 bytes,N,0,0,0
shared_nixderivationmeta_source_provenances,shared_nixderivationmeta_source_provenances_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_nixderivationoutput,shared_nixderivationoutput_pkey,2.8041773e+08,29 GB,6043 MB,Y,289836890,289836890,289832982
shared_nixderivationoutput_outputs,shared_nixderivationoutp_nixderivationoutput_id_n_e1e34003_uniq,0,0 bytes,8192 bytes,Y,0,0,0
shared_nixderivationoutput_outputs,shared_nixderivationoutput_nixderivationoutput_id_a614bab2,0,0 bytes,8192 bytes,N,0,0,0
shared_nixderivationoutput_outputs,shared_nixderivationoutput_outputs_nixoutput_id_bef910cb,0,0 bytes,8192 bytes,N,0,0,0
shared_nixderivationoutput_outputs,shared_nixderivationoutput_outputs_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_nixevaluation,shared_nixevaluation_channel_id_772c26f1,30,16 kB,16 kB,N,0,0,0
shared_nixevaluation,shared_nixevaluation_channel_id_772c26f1_like,30,16 kB,16 kB,N,0,0,0
shared_nixevaluation,shared_nixevaluation_channel_id_commit_sha1_f976ff7f_uniq,30,16 kB,16 kB,Y,30,0,0
shared_nixevaluation,shared_nixevaluation_pkey,30,16 kB,16 kB,Y,5385038,5385052,5385038
shared_nixlicense,shared_nixlicense_pkey,206,32 kB,16 kB,Y,21234261,21234261,21234261
shared_nixlicense,shared_nixlicense_spdx_id_af0c0a67_like,206,32 kB,16 kB,N,21262489,21262292,21262292
shared_nixlicense,shared_nixlicense_spdx_id_af0c0a67_uniq,206,32 kB,16 kB,Y,0,0,0
shared_nixmaintainer,shared_nixmaintainer_github_59d0164e_like,4545,341 MB,6248 kB,N,64,70248,4462
shared_nixmaintainer,shared_nixmaintainer_github_key,4545,341 MB,6120 kB,Y,0,0,0
shared_nixmaintainer,shared_nixmaintainer_pkey,4545,341 MB,6112 kB,Y,62154080,49755285405,39625039
shared_nixoutput,shared_nixoutput_output_name_c188bc32_like,0,0 bytes,8192 bytes,N,0,0,0
shared_nixoutput,shared_nixoutput_output_name_key,0,0 bytes,8192 bytes,Y,0,0,0
shared_nixoutput,shared_nixoutput_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_nixpkgsadvisory,shared_nixadvisory_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_nixpkgsadvisory_issues,shared_nixadvisory_issue_nixadvisory_id_nixissue__36bc2cbc_uniq,0,0 bytes,8192 bytes,Y,0,0,0
shared_nixpkgsadvisory_issues,shared_nixadvisory_issues_nixadvisory_id_b8f87af3,0,0 bytes,8192 bytes,N,0,0,0
shared_nixpkgsadvisory_issues,shared_nixadvisory_issues_nixissue_id_b766ea90,0,0 bytes,8192 bytes,N,0,0,0
shared_nixpkgsadvisory_issues,shared_nixadvisory_issues_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_nixpkgsevent,shared_nixevent_issue_id_aa454381,0,0 bytes,8192 bytes,N,0,0,0
shared_nixpkgsevent,shared_nixevent_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_nixpkgsissue,shared_nixissue_description_id_52cf817a,0,8192 bytes,16 kB,N,0,0,0
shared_nixpkgsissue,shared_nixissue_pkey,0,8192 bytes,16 kB,Y,0,0,0
shared_nixpkgsissue_cve,shared_nixissue_cve_cverecord_id_fc792375,0,8192 bytes,16 kB,N,0,0,0
shared_nixpkgsissue_cve,shared_nixissue_cve_nixissue_id_c76cc870,0,8192 bytes,16 kB,N,0,0,0
shared_nixpkgsissue_cve,shared_nixissue_cve_nixissue_id_cverecord_id_da8a5c37_uniq,0,8192 bytes,16 kB,Y,58,40,40
shared_nixpkgsissue_cve,shared_nixissue_cve_pkey,0,8192 bytes,16 kB,Y,18,0,0
shared_nixpkgsissue_derivations,shared_nixpkgsissue_deri_nixpkgsissue_id_nixderiv_ae34e185_uniq,688,40 kB,56 kB,Y,1579,184,184
shared_nixpkgsissue_derivations,shared_nixpkgsissue_derivations_nixderivation_id_4e012afe,688,40 kB,40 kB,N,64,96,64
shared_nixpkgsissue_derivations,shared_nixpkgsissue_derivations_nixpkgsissue_id_1c52eb3a,688,40 kB,16 kB,N,29,1232,1232
shared_nixpkgsissue_derivations,shared_nixpkgsissue_derivations_pkey,688,40 kB,32 kB,Y,1572,0,0
shared_nixplatform,shared_nixplatform_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_nixplatform,shared_nixplatform_system_double_04755fd5_like,0,0 bytes,8192 bytes,N,0,0,0
shared_nixplatform,shared_nixplatform_system_double_key,0,0 bytes,8192 bytes,Y,0,0,0
shared_nixsourceprovenance,shared_nixsourceprovenance_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_nixstorepathoutput,shared_nixstorepathoutput_pkey,1.060081e+06,123 MB,24 MB,Y,31189593,31189593,31189592
shared_nixstorepathoutput,shared_nixstorepathoutput_store_path_0df106a1_like,1.060081e+06,123 MB,107 MB,N,8772861,8433773,8433773
shared_nixstorepathoutput,shared_nixstorepathoutput_store_path_0df106a1_uniq,1.060081e+06,123 MB,107 MB,Y,24051951,23222072,23222072
shared_organization,shared_organization_pkey,483,32 kB,32 kB,Y,3117781,3117352,3117352
shared_packageedit,shared_packageedit_pkey,366,40 kB,32 kB,Y,0,0,0
shared_packageedit,shared_packageedit_suggestion_id_a9c8b6b8,366,40 kB,16 kB,N,12516,196406,196403
shared_packageedit,unique_package_edit_per_suggestion,366,40 kB,64 kB,Y,1408,1217,1217
shared_packageeditevent,shared_packageeditevent_pgh_context_id_5d183a61,372,64 kB,40 kB,N,35838,35838,35838
shared_packageeditevent,shared_packageeditevent_pgh_obj_id_c2777259,372,64 kB,32 kB,N,0,0,0
shared_packageeditevent,shared_packageeditevent_pkey,372,64 kB,32 kB,Y,0,0,0
shared_packageeditevent,shared_packageeditevent_suggestion_id_389d0e34,372,64 kB,16 kB,N,30739,23822,23822
shared_platform,shared_platform_pkey,1042,64 kB,40 kB,Y,3479151,3479151,3479151
shared_problemtype,shared_problemtype_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_problemtype_description,shared_problemtype_descr_problemtype_id_descripti_b0af0863_uniq,0,0 bytes,8192 bytes,Y,0,0,0
shared_problemtype_description,shared_problemtype_description_description_id_1d536721,0,0 bytes,8192 bytes,N,0,0,0
shared_problemtype_description,shared_problemtype_description_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_problemtype_description,shared_problemtype_description_problemtype_id_0710fa92,0,0 bytes,8192 bytes,N,0,0,0
shared_problemtype_references,shared_problemtype_refer_problemtype_id_reference_8fc3cded_uniq,0,0 bytes,8192 bytes,Y,0,0,0
shared_problemtype_references,shared_problemtype_references_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_problemtype_references,shared_problemtype_references_problemtype_id_e9183f66,0,0 bytes,8192 bytes,N,0,0,0
shared_problemtype_references,shared_problemtype_references_reference_id_d01e75f8,0,0 bytes,8192 bytes,N,0,0,0
shared_product,shared_product_pkey,0,0 bytes,8192 bytes,Y,0,0,0
shared_programfile,shared_programfile_pkey,6234,448 kB,160 kB,Y,2642244,2642244,2348878
shared_programroutine,shared_programroutine_pkey,927,72 kB,40 kB,Y,2631122,2631122,2631122
shared_reference,shared_reference_pkey,2.85567e+06,329 MB,63 MB,Y,9797133,9797133,9779492
shared_reference_tags,shared_reference_tags_pkey,4.589329e+06,231 MB,100 MB,Y,4647064,0,0
shared_reference_tags,shared_reference_tags_reference_id_29416e7e,4.589329e+06,231 MB,85 MB,N,2830270,0,0
shared_reference_tags,shared_reference_tags_reference_id_tag_id_66b9d4a6_uniq,4.589329e+06,231 MB,140 MB,Y,4754851,0,0
shared_reference_tags,shared_reference_tags_tag_id_d74f016f,4.589329e+06,231 MB,31 MB,N,3703670,3703670,3703670
shared_supportingmedia,shared_supportingmedia_pkey,91185,30 MB,2120 kB,Y,1996674,1996674,1801232
shared_tag,shared_tag_pkey,134,8192 bytes,16 kB,Y,6487870,6487870,6487870
shared_version,shared_version_pkey,2.53472e+06,182 MB,56 MB,Y,7005347,7005347,6488641
socialaccount_socialaccount,socialaccount_socialaccount_pkey,2,24 kB,16 kB,Y,3,4,3
socialaccount_socialaccount,socialaccount_socialaccount_provider_uid_fc810c6e_uniq,2,24 kB,16 kB,Y,166,207,206
socialaccount_socialaccount,socialaccount_socialaccount_user_id_8146e70c,2,24 kB,16 kB,N,586,1052,586
socialaccount_socialapp,socialaccount_socialapp_pkey,0,0 bytes,8192 bytes,Y,0,0,0
socialaccount_socialtoken,socialaccount_socialtoken_account_id_951f210e,0,0 bytes,8192 bytes,N,0,0,0
socialaccount_socialtoken,socialaccount_socialtoken_app_id_636a42d7,0,0 bytes,8192 bytes,N,0,0,0
socialaccount_socialtoken,socialaccount_socialtoken_app_id_account_id_fca4e0ac_uniq,0,0 bytes,8192 bytes,Y,0,0,0
socialaccount_socialtoken,socialaccount_socialtoken_pkey,0,0 bytes,8192 bytes,Y,0,0,0
webview_notification,webview_notification_pkey,-1,0 bytes,8192 bytes,Y,0,0,0
webview_notification,webview_notification_user_id_275c72ef,-1,0 bytes,8192 bytes,N,14,0,0
webview_profile,webview_profile_pkey,2,8192 bytes,16 kB,Y,0,0,0
webview_profile,webview_profile_user_id_key,2,8192 bytes,16 kB,Y,1,0,0