explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bcSO

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 764.402 ↓ 0.0 0 1

Limit (cost=0.57..15,990.85 rows=2,000 width=78) (actual time=764.402..764.402 rows=0 loops=1)

  • Buffers: shared hit=1540 read=366
2. 0.002 764.401 ↓ 0.0 0 1

WindowAgg (cost=0.57..77,057.73 rows=9,638 width=78) (actual time=764.401..764.401 rows=0 loops=1)

  • Buffers: shared hit=1540 read=366
3. 0.169 764.399 ↓ 0.0 0 1

Nested Loop (cost=0.57..76,937.25 rows=9,638 width=70) (actual time=764.399..764.399 rows=0 loops=1)

  • Buffers: shared hit=1540 read=366
4. 0.062 0.062 ↓ 1.2 118 1

Function Scan on unnest v (cost=0.00..1.00 rows=100 width=32) (actual time=0.016..0.062 rows=118 loops=1)

5. 0.590 764.168 ↓ 0.0 0 118

Append (cost=0.57..767.29 rows=207 width=70) (actual time=6.476..6.476 rows=0 loops=118)

  • Buffers: shared hit=1540 read=366
6. 763.224 763.224 ↓ 0.0 0 118

Index Scan using idx_currentstatusmessage_by_trigger_equipment_timesave on currentstatusmessage_by_trigger cs (cost=0.57..766.73 rows=205 width=70) (actual time=6.468..6.468 rows=0 loops=118)

  • Index Cond: ((external_equipment_reference = v.external_equipment_reference) AND (time_save >= v.start_time) AND (time_save < v.end_time))
  • Filter: (message_timestamp >= '2019-08-11 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=1304 read=366
7. 0.236 0.236 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx190 on currentstatusmessage_by_trigger_p2019_08_11 cs_1 (cost=0.15..0.28 rows=1 width=124) (actual time=0.002..0.002 rows=0 loops=118)

  • Index Cond: ((external_equipment_reference = v.external_equipment_reference) AND (time_save >= v.start_time) AND (time_save < v.end_time))
  • Filter: (message_timestamp >= '2019-08-11 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=118
8. 0.118 0.118 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx191 on currentstatusmessage_by_trigger_p2019_08_12 cs_2 (cost=0.15..0.28 rows=1 width=124) (actual time=0.001..0.001 rows=0 loops=118)

  • Index Cond: ((external_equipment_reference = v.external_equipment_reference) AND (time_save >= v.start_time) AND (time_save < v.end_time))
  • Filter: (message_timestamp >= '2019-08-11 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=118
Planning time : 61.641 ms