Skip to content

Instantly share code, notes, and snippets.

@indy-singh

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

Created May 3, 2020 11:27
Show Gist options
  • Save indy-singh/1d41d15addb543bcdafc8641b9d7f036 to your computer and use it in GitHub Desktop.
Save indy-singh/1d41d15addb543bcdafc8641b9d7f036 to your computer and use it in GitHub Desktop.
Download ZIP
proposal.proposal.index_stats.md
Raw
proposal.proposal.index_stats.md
schemaname tablename indexname num_rows table_size index_size unique number_of_scans tuples_read tuples_fetched
proposal proposal proposal_has_been_anonymised_system_id_legacy_organisation_idx1 9.9808e+06 1081 MB 722 MB N 17598456266 114113058076 102822442924
proposal proposal proposal_has_been_anonymised_system_id_legacy_organisation__idx 9.9808e+06 1081 MB 464 MB N 128151 658447019 198550542
proposal proposal proposal_reference_key 9.9808e+06 1081 MB 463 MB Y 2565528123 2565534335 2565528110
proposal proposal proposal_system_id_legacy_id_key 9.9808e+06 1081 MB 425 MB Y 1 3242917 0
proposal proposal pk_proposal 9.9808e+06 1081 MB 422 MB Y 317568 317568 317568
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment