explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9bAz

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 10,862.549 ↑ 1.0 67 1

Append (cost=0.43..244.32 rows=67 width=52) (actual time=910.607..10,862.549 rows=67 loops=1)

  • Buffers: shared hit=592,467
2. 10,862.522 10,862.522 ↑ 1.0 67 1

Index Scan using _hyper_68_9636_chunk_offer_attribute_values_day_idx on _timescaledb_internal._hyper_68_9636_chunk (cost=0.43..243.99 rows=67 width=52) (actual time=910.606..10,862.522 rows=67 loops=1)

  • Output: _hyper_68_9636_chunk.id, _hyper_68_9636_chunk.day, _hyper_68_9636_chunk.value, _hyper_68_9636_chunk.farm_hash_64
  • Index Cond: ((_hyper_68_9636_chunk.day >= '2020-08-06'::date) AND (_hyper_68_9636_chunk.day <= '2020-08-06'::date) AND (_hyper_68_9636_chunk.day = '2020-08-06'::date))
  • Filter: (_hyper_68_9636_chunk.id = ANY ('{15417238110,15415799291,15389314751,15415156652,15417698640,15415588239,15389305593,15417249805,15415599165,15409223809,15390236962,15417740434,15415600516,15415589429,15389303614,15389320016,15417315689,15417293659,15389309596,15415586405,15415589687,15389303597,15415798741,15415747143,15417570772,15389317850,15417566188,15417752949,15415594269,15415587557,15415587428,15417346727,15415818629,15417525568,15414818292,15415587477,15410391775,15410397865,15389309141,15389311366,15417651306,15415588312,15389304405,15415793573,15415611234,15415581391,15415972032,15417212757,15417406847,15417601000,15417689624,15417748818,15415588265,15415604358,15415602453,15389305504,15389306309,15417662110,15417284899,15417331995,15415587024,15389749886,15416150720,15389418430,15389343577,15415386629,15417325286}'::bigint[]))
  • Rows Removed by Filter: 8,074,941
  • Buffers: shared hit=592,467
Planning time : 5.848 ms
Execution time : 10,862.598 ms