explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U9Ax

Settings
# exclusive inclusive rows x rows loops node
1. 10.564 6,978.684 ↑ 8.8 25 1

Subquery Scan on alstom_powerband8 (cost=117,167.02..117,252.95 rows=220 width=317) (actual time=6,911.025..6,978.684 rows=25 loops=1)

  • Filter: (alstom_powerband8.mytest_1 >= (current_setting('alstom.run_length'::text))::numeric(18,7))
  • Rows Removed by Filter: 4213
2. 62.756 6,968.120 ↓ 6.4 4,238 1

WindowAgg (cost=117,167.02..117,238.07 rows=661 width=317) (actual time=6,904.787..6,968.120 rows=4,238 loops=1)

3. 11.900 6,905.364 ↓ 6.4 4,238 1

Sort (cost=117,167.02..117,168.67 rows=661 width=157) (actual time=6,904.718..6,905.364 rows=4,238 loops=1)

  • Sort Key: alstom_powerband7.value_1_partition
  • Sort Method: quicksort Memory: 788kB
4. 5.950 6,893.464 ↓ 6.4 4,238 1

Subquery Scan on alstom_powerband7 (cost=116,987.33..117,136.05 rows=661 width=157) (actual time=2,787.978..6,893.464 rows=4,238 loops=1)

5. 43.092 6,887.514 ↓ 6.4 4,238 1

WindowAgg (cost=116,987.33..117,129.44 rows=661 width=157) (actual time=2,787.978..6,887.514 rows=4,238 loops=1)

6. 4,062.787 6,844.422 ↓ 6.4 4,238 1

WindowAgg (cost=116,987.33..117,112.92 rows=661 width=149) (actual time=2,787.180..6,844.422 rows=4,238 loops=1)

7. 26.410 2,781.635 ↓ 6.4 4,238 1

WindowAgg (cost=116,987.33..117,091.44 rows=661 width=117) (actual time=2,723.068..2,781.635 rows=4,238 loops=1)

8. 13.847 2,755.225 ↓ 6.4 4,238 1

Subquery Scan on alstom_powerband (cost=116,987.33..117,071.61 rows=661 width=85) (actual time=2,723.036..2,755.225 rows=4,238 loops=1)

  • Filter: (alstom_powerband.delta_cumulative_time_min < (current_setting('alstom.delta_cumulative_time_min'::text))::numeric(18,7))
  • Rows Removed by Filter: 284
9. 17.261 2,741.378 ↓ 2.3 4,522 1

WindowAgg (cost=116,987.33..117,026.99 rows=1,983 width=909) (actual time=2,723.014..2,741.378 rows=4,522 loops=1)

10. 7.119 2,724.117 ↓ 2.3 4,522 1

Sort (cost=116,987.33..116,992.29 rows=1,983 width=53) (actual time=2,722.987..2,724.117 rows=4,522 loops=1)

  • Sort Key: alstom.cumulative_time_min
  • Sort Method: quicksort Memory: 828kB
11. 170.365 2,716.998 ↓ 2.3 4,522 1

Gather (cost=1,000.00..116,878.73 rows=1,983 width=53) (actual time=1,161.328..2,716.998 rows=4,522 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
12. 2,546.633 2,546.633 ↓ 1.8 1,507 3

Parallel Seq Scan on alstom (cost=0.00..115,680.43 rows=826 width=53) (actual time=901.522..2,546.633 rows=1,507 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: 416721
Planning time : 0.922 ms
Execution time : 6,979.676 ms