Skip to content

Instantly share code, notes, and snippets.

@indy-singh

indy-singh/proposal.note.index_stats.md Secret

Created May 3, 2020 11:28
Show Gist options
  • Save indy-singh/7a698dec98dd8ef2808345d1802e6b6a to your computer and use it in GitHub Desktop.
Save indy-singh/7a698dec98dd8ef2808345d1802e6b6a to your computer and use it in GitHub Desktop.
Download ZIP
proposal.note.index_stats.md
Raw
proposal.note.index_stats.md
schemaname tablename indexname num_rows table_size index_size unique number_of_scans tuples_read tuples_fetched
proposal note note_to_organisation_reference_entry_time_read_by_null_idx 3.32963e+06 783 MB 96 MB N 98 0 0
proposal note note_from_organisation_reference_entry_time_read_by_null_idx 3.32963e+06 783 MB 94 MB N 0 0 0
proposal note note_proposal_reference_type_id_entry_time_idx 3.32963e+06 783 MB 175 MB N 73817780867 500753155 500514563
proposal note note_type_id_entry_time_idx 3.32963e+06 783 MB 332 MB N 2664910 103218285685 22545334
proposal note note_entry_time_type_id_idx 3.32963e+06 783 MB 207 MB N 1003856 28338028178 28337731303
proposal note note_proposal_reference_idx 3.32963e+06 783 MB 165 MB N 59486397 488582856 363280067
proposal note note_reference_key 3.32963e+06 783 MB 127 MB Y 1 3009024 1064736
proposal note pk_note 3.32963e+06 783 MB 212 MB Y 609304 1383111 609304
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment