explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R7sy

Settings
# exclusive inclusive rows x rows loops node
1. 1.926 10.252 ↓ 199.5 4,390 1

Sort (cost=137.59..137.64 rows=22 width=576) (actual time=9.922..10.252 rows=4,390 loops=1)

  • Sort Key: bet_hist.ts DESC
  • Sort Method: quicksort Memory: 2180kB
  • Buffers: shared hit=6300
2. 0.515 8.326 ↓ 199.5 4,390 1

Custom Scan (cost=0.43..137.1 rows=22 width=576) (actual time=0.104..8.326 rows=4,390 loops=1)

  • Buffers: shared hit=6300
3. 7.811 7.811 ↓ 439.0 4,390 1

Index Scan using _hyper_1_16351_chunk_ix_bet_hist_market_id_selection_id_inc on _hyper_1_16351_chunk _hyper_1_16351_chunk (cost=0.43..105.18 rows=10 width=576) (actual time=0.104..7.811 rows=4,390 loops=1)

  • Index Cond: ((_hyper_1_16351_chunk.market_id = 314999720) AND (_hyper_1_16351_chunk.selection_id = 333202565))
  • Filter: ((_hyper_1_16351_chunk.ts > '2019-09-09 19:22:04+00'::timestamp with time zone) AND (_hyper_1_16351_chunk.ts <= ('2019-09-09 19:32:04+00'::timestamp with time zone + '00:00:20'::interval)))
  • Buffers: shared hit=6300