explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xoFl

Settings
# exclusive inclusive rows x rows loops node
1. 0.149 2,278.591 ↑ 1.0 2,000 1

Limit (cost=0.57..4,493.99 rows=2,000 width=78) (actual time=2,278.077..2,278.591 rows=2,000 loops=1)

  • Buffers: shared hit=4786 read=1903
2. 5.526 2,278.442 ↑ 18.3 2,000 1

WindowAgg (cost=0.57..82,219.00 rows=36,595 width=78) (actual time=2,278.076..2,278.442 rows=2,000 loops=1)

  • Buffers: shared hit=4786 read=1903
3. 1.701 2,272.916 ↑ 3.4 10,904 1

Nested Loop (cost=0.57..81,761.57 rows=36,595 width=70) (actual time=30.698..2,272.916 rows=10,904 loops=1)

  • Buffers: shared hit=4786 read=1903
4. 0.069 0.069 ↓ 1.2 118 1

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

5. 4.956 2,271.146 ↑ 10.7 92 118

Append (cost=0.57..807.79 rows=982 width=70) (actual time=5.954..19.247 rows=92 loops=118)

  • Buffers: shared hit=4786 read=1903
6. 646.404 646.404 ↓ 0.0 0 118

Index Scan using idx_currentstatusmessage_by_trigger_equipment_timesave on currentstatusmessage_by_trigger cs (cost=0.57..766.73 rows=768 width=70) (actual time=5.478..5.478 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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=1176 read=622
7. 319.190 319.190 ↓ 9.2 92 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx121 on currentstatusmessage_by_trigger_p2019_07_25 cs_1 (cost=0.29..2.32 rows=10 width=70) (actual time=0.285..2.705 rows=92 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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=395 read=240
8. 146.084 146.084 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx122 on currentstatusmessage_by_trigger_p2019_07_26 cs_2 (cost=0.41..4.84 rows=32 width=70) (actual time=1.238..1.238 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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=235 read=120
9. 139.830 139.830 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx123 on currentstatusmessage_by_trigger_p2019_07_27 cs_3 (cost=0.41..4.84 rows=32 width=70) (actual time=1.185..1.185 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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=235 read=120
10. 139.122 139.122 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx124 on currentstatusmessage_by_trigger_p2019_07_28 cs_4 (cost=0.41..4.84 rows=32 width=70) (actual time=1.179..1.179 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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=235 read=120
11. 206.972 206.972 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx125 on currentstatusmessage_by_trigger_p2019_07_29 cs_5 (cost=0.41..4.84 rows=32 width=70) (actual time=1.754..1.754 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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=235 read=120
12. 140.538 140.538 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx126 on currentstatusmessage_by_trigger_p2019_07_30 cs_6 (cost=0.41..4.84 rows=32 width=70) (actual time=1.191..1.191 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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=235 read=120
13. 143.724 143.724 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx127 on currentstatusmessage_by_trigger_p2019_07_31 cs_7 (cost=0.41..4.84 rows=32 width=70) (actual time=1.218..1.218 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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=235 read=120
14. 170.156 170.156 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx128 on currentstatusmessage_by_trigger_p2019_08_01 cs_8 (cost=0.42..2.44 rows=1 width=70) (actual time=1.442..1.442 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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=215 read=140
15. 171.926 171.926 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx129 on currentstatusmessage_by_trigger_p2019_08_02 cs_9 (cost=0.42..2.44 rows=1 width=70) (actual time=1.457..1.457 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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=208 read=147
16. 0.236 0.236 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx130 on currentstatusmessage_by_trigger_p2019_08_03 cs_10 (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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=118
17. 0.118 0.118 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx131 on currentstatusmessage_by_trigger_p2019_08_04 cs_11 (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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=118
18. 0.118 0.118 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx132 on currentstatusmessage_by_trigger_p2019_08_05 cs_12 (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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=118
19. 0.118 0.118 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx133 on currentstatusmessage_by_trigger_p2019_08_06 cs_13 (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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=118
20. 0.118 0.118 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx134 on currentstatusmessage_by_trigger_p2019_08_07 cs_14 (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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=118
21. 40.946 40.946 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx187 on currentstatusmessage_by_trigger_p2019_08_08 cs_15 (cost=0.41..2.27 rows=1 width=70) (actual time=0.347..0.347 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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=320 read=34
22. 0.236 0.236 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx188 on currentstatusmessage_by_trigger_p2019_08_09 cs_16 (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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=118
23. 0.118 0.118 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx189 on currentstatusmessage_by_trigger_p2019_08_10 cs_17 (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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=118
24. 0.118 0.118 ↓ 0.0 0 118

Index Scan using currentstatusmessage_by_trig_external_equipment_referenc_idx190 on currentstatusmessage_by_trigger_p2019_08_11 cs_18 (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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=118
25. 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_19 (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-07-25 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=118
Planning time : 1,053.140 ms