Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
relname | too_much_seq | case | rel_size | seq_scan | idx_scan
-----------------------------------+---------------+----------------+-------------+-----------+--------------
artist_gid_redirect | 131661036 | Missing Index? | 1867776 | 137300802 | 5639766
recording_gid_redirect | 19692294 | Missing Index? | 78274560 | 21078684 | 1386390
instrument | 18228192 | Missing Index? | 835584 | 19942566 | 1714374
work_gid_redirect | 2134306 | Missing Index? | 7331840 | 2380037 | 245731
label_gid_redirect | 889054 | Missing Index? | 196608 | 908523 | 19469
track_gid_redirect | 690924 | Missing Index? | 1499136 | 693237 | 2313
url_gid_redirect | 425702 | Missing Index? | 262144 | 616389 | 190687
edit_url | 87202 | Missing Index? | 254640128 | 339057 | 251855
l_event_url | 75414 | Missing Index? | 106496 | 366334 | 290920
l_event_event | 26542 | Missing Index? | 81920 | 82797 | 56255
autoeditor_election_vote | 23113 | Missing Index? | 327680 | 23122 | 9
label_deletion | -605 | OK | 114688 | 15 | 620
editor_watch_release_group_type | -1383 | OK | 74874880 | 54 | 1437
editor_watch_release_status | -1383 | OK | 72695808 | 54 | 1437
editor_watch_preferences | -1383 | OK | 178454528 | 54 | 1437
tag_relation | -2648 | OK | 6569984 | 190 | 2838
edit_area | -8506 | OK | 116006912 | 54 | 8560
event_alias | -13620 | OK | 180224 | 21088 | 34708
edit_instrument | -17531 | OK | 9568256 | 345 | 17876
place_tag_raw | -41978 | OK | 122880 | 377 | 42355
l_event_series | -77216 | OK | 638976 | 28161 | 105377
area_tag_raw | -83195 | OK | 139264 | 2536 | 85731
edit_place | -133630 | OK | 10428416 | 52268 | 185898
edit_event | -185015 | OK | 1990656 | 20492 | 205507
l_event_place | -204927 | OK | 294912 | 26453 | 231380
editor_oauth_token | -239906 | OK | 1556480 | 8685 | 248591
place_alias | -250030 | OK | 270336 | 6371 | 256401
label_tag_raw | -405787 | OK | 311296 | 428 | 406215
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.