Skip to content

Instantly share code, notes, and snippets.

@mayhem

mayhem/gist:1428fb2ecba0d0f1716856ff17385afb

Created May 8, 2020 11:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mayhem/1428fb2ecba0d0f1716856ff17385afb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mayhem/1428fb2ecba0d0f1716856ff17385afb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=0.42..1289.31 rows=50 width=523)
-> Custom Scan (ChunkAppend) on listen (cost=0.42..1701.76 rows=66 width=523)
Order: listen.listened_at DESC
-> Index Scan using _hyper_35_5591_chunk_listened_at_user_name_ndx_listen on _hyper_35_5591_chunk (cost=0.42..1701.76 rows=66 width=698)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5588_chunk_listened_at_user_name_ndx_listen on _hyper_35_5588_chunk (cost=0.42..3196.45 rows=217 width=703)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5586_chunk_listened_at_user_name_ndx_listen on _hyper_35_5586_chunk (cost=0.42..3161.08 rows=43 width=700)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5584_chunk_listened_at_user_name_ndx_listen on _hyper_35_5584_chunk (cost=0.42..2928.60 rows=39 width=723)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5582_chunk_listened_at_user_name_ndx_listen on _hyper_35_5582_chunk (cost=0.42..3396.46 rows=438 width=668)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5580_chunk_listened_at_user_name_ndx_listen on _hyper_35_5580_chunk (cost=0.42..3335.43 rows=168 width=681)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5579_chunk_listened_at_user_name_ndx_listen on _hyper_35_5579_chunk (cost=0.42..2888.47 rows=336 width=720)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5577_chunk_listened_at_user_name_ndx_listen on _hyper_35_5577_chunk (cost=0.42..3038.19 rows=185 width=712)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5575_chunk_listened_at_user_name_ndx_listen on _hyper_35_5575_chunk (cost=0.42..3435.32 rows=202 width=692)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5573_chunk_listened_at_user_name_ndx_listen on _hyper_35_5573_chunk (cost=0.42..3667.13 rows=188 width=676)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5571_chunk_listened_at_user_name_ndx_listen on _hyper_35_5571_chunk (cost=0.42..4774.46 rows=404 width=627)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5569_chunk_listened_at_user_name_ndx_listen on _hyper_35_5569_chunk (cost=0.42..4500.79 rows=295 width=627)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5567_chunk_listened_at_user_name_ndx_listen on _hyper_35_5567_chunk (cost=0.42..3746.23 rows=334 width=660)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5566_chunk_listened_at_user_name_ndx_listen on _hyper_35_5566_chunk (cost=0.42..3699.34 rows=441 width=668)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5564_chunk_listened_at_user_name_ndx_listen on _hyper_35_5564_chunk (cost=0.42..3652.70 rows=383 width=668)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5562_chunk_listened_at_user_name_ndx_listen on _hyper_35_5562_chunk (cost=0.42..3792.11 rows=255 width=666)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5561_chunk_listened_at_user_name_ndx_listen on _hyper_35_5561_chunk (cost=0.42..3964.74 rows=490 width=665)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5559_chunk_listened_at_user_name_ndx_listen on _hyper_35_5559_chunk (cost=0.42..3559.94 rows=190 width=671)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5557_chunk_listened_at_user_name_ndx_listen on _hyper_35_5557_chunk (cost=0.42..3620.64 rows=207 width=663)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5556_chunk_listened_at_user_name_ndx_listen on _hyper_35_5556_chunk (cost=0.42..3982.59 rows=269 width=660)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5554_chunk_listened_at_user_name_ndx_listen on _hyper_35_5554_chunk (cost=0.42..3495.23 rows=52 width=654)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5552_chunk_listened_at_user_name_ndx_listen on _hyper_35_5552_chunk (cost=0.42..3755.82 rows=407 width=666)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5550_chunk_listened_at_user_name_ndx_listen on _hyper_35_5550_chunk (cost=0.42..3953.05 rows=475 width=654)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5549_chunk_listened_at_user_name_ndx_listen on _hyper_35_5549_chunk (cost=0.42..4094.14 rows=491 width=649)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_5547_chunk_listened_at_user_name_ndx_listen on _hyper_35_5547_chunk (cost=0.42..3981.46 rows=264 width=650)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
. . .
-> Index Scan using _hyper_35_4398_chunk_listened_at_user_name_ndx_listen on _hyper_35_4398_chunk (cost=0.29..577.44 rows=1 width=427)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4397_chunk_listened_at_user_name_ndx_listen on _hyper_35_4397_chunk (cost=0.29..585.74 rows=1 width=426)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4396_chunk_listened_at_user_name_ndx_listen on _hyper_35_4396_chunk (cost=0.29..545.93 rows=1 width=427)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4395_chunk_listened_at_user_name_ndx_listen on _hyper_35_4395_chunk (cost=0.29..546.14 rows=1 width=427)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4394_chunk_listened_at_user_name_ndx_listen on _hyper_35_4394_chunk (cost=0.29..449.80 rows=1 width=428)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4393_chunk_listened_at_user_name_ndx_listen on _hyper_35_4393_chunk (cost=0.29..449.85 rows=1 width=426)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4392_chunk_listened_at_user_name_ndx_listen on _hyper_35_4392_chunk (cost=0.29..444.31 rows=1 width=425)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4391_chunk_listened_at_user_name_ndx_listen on _hyper_35_4391_chunk (cost=0.29..494.29 rows=1 width=425)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4390_chunk_listened_at_user_name_ndx_listen on _hyper_35_4390_chunk (cost=0.29..477.58 rows=1 width=425)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4389_chunk_listened_at_user_name_ndx_listen on _hyper_35_4389_chunk (cost=0.29..486.00 rows=1 width=426)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4388_chunk_listened_at_user_name_ndx_listen on _hyper_35_4388_chunk (cost=0.29..470.97 rows=1 width=425)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4387_chunk_listened_at_user_name_ndx_listen on _hyper_35_4387_chunk (cost=0.42..12055.05 rows=31 width=455)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4386_chunk_listened_at_recording_msid_user_name_ndx_l on _hyper_35_4386_chunk (cost=0.12..2.34 rows=1 width=56)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4385_chunk_listened_at_recording_msid_user_name_ndx_l on _hyper_35_4385_chunk (cost=0.12..2.34 rows=1 width=56)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4384_chunk_listened_at_recording_msid_user_name_ndx_l on _hyper_35_4384_chunk (cost=0.12..2.34 rows=1 width=56)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
-> Index Scan using _hyper_35_4383_chunk_listened_at_recording_msid_user_name_ndx_l on _hyper_35_4383_chunk (cost=0.13..2.35 rows=1 width=56)
Index Cond: ((listened_at < 1580085314) AND (user_name = 'rob'::text))
(2197 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment