explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HAR9

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 11,098.539 ↑ 203.2 67 1

Append (cost=464.84..38,002.60 rows=13,615 width=52) (actual time=1,533.871..11,098.539 rows=67 loops=1)

  • Buffers: shared hit=86,892 read=21,038
2. 9,588.799 11,098.516 ↑ 203.2 67 1

Bitmap Heap Scan on _timescaledb_internal._hyper_68_9636_chunk (cost=464.84..37,934.53 rows=13,615 width=52) (actual time=1,533.870..11,098.516 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
  • Recheck Cond: (_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,154,270
  • Heap Blocks: exact=79,689
  • Buffers: shared hit=86,892 read=21,038
3. 1,509.717 1,509.717 ↓ 200.6 8,154,337 1

Bitmap Index Scan on _hyper_68_9636_chunk_offer_attribute_values_day_idx (cost=0.00..461.44 rows=40,641 width=0) (actual time=1,509.717..1,509.717 rows=8,154,337 loops=1)

  • Index Cond: (_hyper_68_9636_chunk.day = '2020-08-06'::date)
  • Buffers: shared hit=17,717 read=10,524
Planning time : 0.451 ms
Execution time : 11,099.110 ms