explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ajoW

Settings
# exclusive inclusive rows x rows loops node
1. 8.019 4,650.611 ↓ 618.0 618 1

Subquery Scan on powerband8 (cost=25,207.83..25,209.34 rows=1 width=764) (actual time=4,608.803..4,650.611 rows=618 loops=1)

  • Filter: ((powerband8.mytest_1 >= (current_setting('celerity.run_length'::text))::numeric(10,5)) AND (powerband8.mytest_2 >= (current_setting('celerity.run_length'::text))::numeric(10,5)) AND (powerband8.mytest_3 >= (current_setting('celerity.run_length'::text))::numeric(10,5)) AND (powerband8.mytest_4 >= (current_setting('celerity.run_length'::text))::numeric(10,5)))
  • Rows Removed by Filter: 1829
2. 33.542 4,642.592 ↓ 271.9 2,447 1

WindowAgg (cost=25,207.83..25,208.80 rows=9 width=764) (actual time=4,608.771..4,642.592 rows=2,447 loops=1)

3. 2.137 4,609.050 ↓ 271.9 2,447 1

Sort (cost=25,207.83..25,207.85 rows=9 width=604) (actual time=4,608.750..4,609.050 rows=2,447 loops=1)

  • Sort Key: powerband7.value_4_partition
  • Sort Method: quicksort Memory: 891kB
4. 2.348 4,606.913 ↓ 271.9 2,447 1

WindowAgg (cost=25,207.53..25,207.69 rows=9 width=604) (actual time=4,604.457..4,606.913 rows=2,447 loops=1)

5. 2.661 4,604.565 ↓ 271.9 2,447 1

Sort (cost=25,207.53..25,207.55 rows=9 width=572) (actual time=4,604.453..4,604.565 rows=2,447 loops=1)

  • Sort Key: powerband7.value_3_partition
  • Sort Method: quicksort Memory: 848kB
6. 3.240 4,601.904 ↓ 271.9 2,447 1

WindowAgg (cost=25,207.23..25,207.39 rows=9 width=572) (actual time=4,598.502..4,601.904 rows=2,447 loops=1)

7. 2.199 4,598.664 ↓ 271.9 2,447 1

Sort (cost=25,207.23..25,207.25 rows=9 width=540) (actual time=4,598.497..4,598.664 rows=2,447 loops=1)

  • Sort Key: powerband7.value_2_partition
  • Sort Method: quicksort Memory: 819kB
8. 2.933 4,596.465 ↓ 271.9 2,447 1

WindowAgg (cost=25,206.93..25,207.09 rows=9 width=540) (actual time=4,593.414..4,596.465 rows=2,447 loops=1)

9. 4.065 4,593.532 ↓ 271.9 2,447 1

Sort (cost=25,206.93..25,206.95 rows=9 width=508) (actual time=4,593.406..4,593.532 rows=2,447 loops=1)

  • Sort Key: powerband7.value_1_partition
  • Sort Method: quicksort Memory: 747kB
10. 1.066 4,589.467 ↓ 271.9 2,447 1

Subquery Scan on powerband7 (cost=25,128.79..25,206.79 rows=9 width=508) (actual time=1,119.445..4,589.467 rows=2,447 loops=1)

11. 19.728 4,588.401 ↓ 271.9 2,447 1

WindowAgg (cost=25,128.79..25,206.70 rows=9 width=508) (actual time=1,119.443..4,588.401 rows=2,447 loops=1)

12. 3,461.279 4,568.673 ↓ 271.9 2,447 1

WindowAgg (cost=25,128.79..25,206.40 rows=9 width=476) (actual time=1,115.501..4,568.673 rows=2,447 loops=1)

13. 47.322 1,107.394 ↓ 271.9 2,447 1

WindowAgg (cost=25,128.79..25,205.75 rows=9 width=348) (actual time=999.768..1,107.394 rows=2,447 loops=1)

14. 24.945 1,060.072 ↓ 271.9 2,447 1

Subquery Scan on powerband (cost=25,128.79..25,204.92 rows=9 width=220) (actual time=999.702..1,060.072 rows=2,447 loops=1)

  • Filter: ((powerband.delta_fcpm_1_run_tick_s < (current_setting('celerity.delta_fcpm_run_tick_s'::text))::numeric(10,5)) AND (powerband.delta_fcpm_2_run_tick_s < (current_setting('celerity.delta_fcpm_run_tick_s'::text))::numeric(10,5)) AND (powerband.delta_fcpm_3_run_tick_s < (current_setting('celerity.delta_fcpm_run_tick_s'::text))::numeric(10,5)) AND (powerband.delta_fcpm_4_run_tick_s < (current_setting('celerity.delta_fcpm_run_tick_s'::text))::numeric(10,5)))
  • Rows Removed by Filter: 1455
15. 32.051 1,035.127 ↓ 5.4 3,902 1

WindowAgg (cost=25,128.79..25,161.42 rows=725 width=524) (actual time=999.636..1,035.127 rows=3,902 loops=1)

16. 8.024 1,003.076 ↓ 5.4 3,902 1

Sort (cost=25,128.79..25,130.61 rows=725 width=92) (actual time=999.609..1,003.076 rows=3,902 loops=1)

  • Sort Key: celerity.time_stamp
  • Sort Method: quicksort Memory: 645kB
17. 385.951 995.052 ↓ 5.4 3,902 1

Gather (cost=1,000.00..25,094.35 rows=725 width=92) (actual time=239.959..995.052 rows=3,902 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
18. 609.101 609.101 ↓ 4.3 1,301 3

Parallel Seq Scan on celerity (cost=0.00..24,021.85 rows=302 width=92) (actual time=127.333..609.101 rows=1,301 loops=3)

  • Filter: ((system_coolant_outlet_temp_degc >= (system_coolant_outlet_temp_sp_degc - (current_setting('celerity.tolerance_temp'::text))::numeric(10,5))) AND (system_coolant_outlet_temp_degc <= (system_coolant_outlet_temp_sp_degc + (current_setting('celerity.tolerance_temp'::text))::numeric(10,5))) AND (system_power_kw >= ((current_setting('celerity.powerband'::text))::numeric(10,5) - (current_setting('celerity.tolerance_powerband'::text))::numeric(10,5))) AND (system_power_kw <= ((current_setting('celerity.powerband'::text))::numeric(10,5) + (current_setting('celerity.tolerance_powerband'::text))::numeric(10,5))))
  • Rows Removed by Filter: 117871
Planning time : 4.400 ms
Execution time : 4,652.939 ms