explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5j8T

Settings
# exclusive inclusive rows x rows loops node
1. 17.356 22,085.186 ↑ 46.9 15 1

Subquery Scan on alstom_powerband8 (cost=118,305.15..118,579.58 rows=704 width=317) (actual time=21,948.240..22,085.186 rows=15 loops=1)

  • Filter: (alstom_powerband8.mytest_1 >= (current_setting('alstom.run_length'::text))::numeric(18,7))
  • Rows Removed by Filter: 11454
2. 119.317 22,067.830 ↓ 5.4 11,469 1

WindowAgg (cost=118,305.15..118,532.09 rows=2,111 width=317) (actual time=21,947.276..22,067.830 rows=11,469 loops=1)

3. 21.189 21,948.513 ↓ 5.4 11,469 1

Sort (cost=118,305.15..118,310.43 rows=2,111 width=157) (actual time=21,947.244..21,948.513 rows=11,469 loops=1)

  • Sort Key: alstom_powerband7.value_1_partition
  • Sort Method: quicksort Memory: 1997kB
4. 8.276 21,927.324 ↓ 5.4 11,469 1

Subquery Scan on alstom_powerband7 (cost=117,713.61..118,188.59 rows=2,111 width=157) (actual time=2,738.392..21,927.324 rows=11,469 loops=1)

5. 58.907 21,919.048 ↓ 5.4 11,469 1

WindowAgg (cost=117,713.61..118,167.48 rows=2,111 width=157) (actual time=2,738.391..21,919.048 rows=11,469 loops=1)

6. 19,141.471 21,860.141 ↓ 5.4 11,469 1

WindowAgg (cost=117,713.61..118,114.70 rows=2,111 width=149) (actual time=2,732.552..21,860.141 rows=11,469 loops=1)

7. 66.802 2,718.670 ↓ 5.4 11,469 1

WindowAgg (cost=117,713.61..118,046.09 rows=2,111 width=117) (actual time=2,574.452..2,718.670 rows=11,469 loops=1)

8. 33.666 2,651.868 ↓ 5.4 11,469 1

Subquery Scan on alstom_powerband (cost=117,713.61..117,982.76 rows=2,111 width=85) (actual time=2,574.421..2,651.868 rows=11,469 loops=1)

  • Filter: (alstom_powerband.delta_cumulative_time_min < (current_setting('alstom.delta_cumulative_time_min'::text))::numeric(18,7))
  • Rows Removed by Filter: 487
9. 41.937 2,618.202 ↓ 1.9 11,956 1

WindowAgg (cost=117,713.61..117,840.27 rows=6,333 width=909) (actual time=2,574.228..2,618.202 rows=11,956 loops=1)

10. 13.947 2,576.265 ↓ 1.9 11,956 1

Sort (cost=117,713.61..117,729.44 rows=6,333 width=53) (actual time=2,574.204..2,576.265 rows=11,956 loops=1)

  • Sort Key: alstom.cumulative_time_min
  • Sort Method: quicksort Memory: 2066kB
11. 350.079 2,562.318 ↓ 1.9 11,956 1

Gather (cost=1,000.00..117,313.73 rows=6,333 width=53) (actual time=278.417..2,562.318 rows=11,956 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
12. 2,212.239 2,212.239 ↓ 1.5 3,985 3

Parallel Seq Scan on alstom (cost=0.00..115,680.43 rows=2,639 width=53) (actual time=94.389..2,212.239 rows=3,985 loops=3)

  • Filter: ((stcoolanttemperature_degc >= (coolant_temp_setpoint_degc - (current_setting('alstom.tolerance_temp'::text))::numeric(18,7))) AND (stcoolanttemperature_degc <= (coolant_temp_setpoint_degc + (current_setting('alstom.tolerance_temp'::text))::numeric(18,7))) AND (b1_stack_current_a >= ((current_setting('alstom.current'::text))::numeric(18,7) - (current_setting('alstom.tolerance_current'::text))::numeric(18,7))) AND (b1_stack_current_a <= ((current_setting('alstom.current'::text))::numeric(18,7) + (current_setting('alstom.tolerance_current'::text))::numeric(18,7))))
  • Rows Removed by Filter: 414243
Planning time : 1.359 ms
Execution time : 22,086.389 ms