explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cvBo

Settings
# exclusive inclusive rows x rows loops node
1. 2.759 999.299 ↓ 371.0 371 1

Subquery Scan on powerband8 (cost=25,076.09..25,076.43 rows=1 width=764) (actual time=989.800..999.299 rows=371 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: 98
2. 6.762 996.540 ↓ 234.5 469 1

WindowAgg (cost=25,076.09..25,076.31 rows=2 width=764) (actual time=989.743..996.540 rows=469 loops=1)

3. 1.399 989.778 ↓ 234.5 469 1

Sort (cost=25,076.09..25,076.10 rows=2 width=604) (actual time=989.712..989.778 rows=469 loops=1)

  • Sort Key: powerband7.value_4_partition
  • Sort Method: quicksort Memory: 165kB
4. 1.307 988.379 ↓ 234.5 469 1

WindowAgg (cost=25,076.05..25,076.08 rows=2 width=604) (actual time=986.995..988.379 rows=469 loops=1)

5. 0.854 987.072 ↓ 234.5 469 1

Sort (cost=25,076.05..25,076.05 rows=2 width=572) (actual time=986.989..987.072 rows=469 loops=1)

  • Sort Key: powerband7.value_3_partition
  • Sort Method: quicksort Memory: 151kB
6. 1.160 986.218 ↓ 234.5 469 1

WindowAgg (cost=25,076.00..25,076.04 rows=2 width=572) (actual time=985.012..986.218 rows=469 loops=1)

7. 0.803 985.058 ↓ 234.5 469 1

Sort (cost=25,076.00..25,076.01 rows=2 width=540) (actual time=985.006..985.058 rows=469 loops=1)

  • Sort Key: powerband7.value_2_partition
  • Sort Method: quicksort Memory: 151kB
8. 1.203 984.255 ↓ 234.5 469 1

WindowAgg (cost=25,075.96..25,075.99 rows=2 width=540) (actual time=983.002..984.255 rows=469 loops=1)

9. 0.455 983.052 ↓ 234.5 469 1

Sort (cost=25,075.96..25,075.96 rows=2 width=508) (actual time=982.995..983.052 rows=469 loops=1)

  • Sort Key: powerband7.value_1_partition
  • Sort Method: quicksort Memory: 149kB
10. 0.112 982.597 ↓ 234.5 469 1

Subquery Scan on powerband7 (cost=25,075.89..25,075.95 rows=2 width=508) (actual time=981.610..982.597 rows=469 loops=1)

11. 0.857 982.485 ↓ 234.5 469 1

WindowAgg (cost=25,075.89..25,075.93 rows=2 width=508) (actual time=981.609..982.485 rows=469 loops=1)

12. 0.377 981.628 ↓ 234.5 469 1

Sort (cost=25,075.89..25,075.90 rows=2 width=500) (actual time=981.603..981.628 rows=469 loops=1)

  • Sort Key: powerband6.fcpm_4_run_tick_h
  • Sort Method: quicksort Memory: 149kB
13. 0.604 981.251 ↓ 234.5 469 1

WindowAgg (cost=25,075.85..25,075.88 rows=2 width=500) (actual time=980.631..981.251 rows=469 loops=1)

14. 0.366 980.647 ↓ 234.5 469 1

Sort (cost=25,075.85..25,075.85 rows=2 width=492) (actual time=980.626..980.647 rows=469 loops=1)

  • Sort Key: powerband6.fcpm_3_run_tick_h
  • Sort Method: quicksort Memory: 149kB
15. 0.609 980.281 ↓ 234.5 469 1

WindowAgg (cost=25,075.80..25,075.84 rows=2 width=492) (actual time=979.658..980.281 rows=469 loops=1)

16. 0.408 979.672 ↓ 234.5 469 1

Sort (cost=25,075.80..25,075.81 rows=2 width=484) (actual time=979.652..979.672 rows=469 loops=1)

  • Sort Key: powerband6.fcpm_2_run_tick_h
  • Sort Method: quicksort Memory: 149kB
17. 0.575 979.264 ↓ 234.5 469 1

WindowAgg (cost=25,075.76..25,075.79 rows=2 width=484) (actual time=978.679..979.264 rows=469 loops=1)

18. 0.981 978.689 ↓ 234.5 469 1

Sort (cost=25,075.76..25,075.76 rows=2 width=476) (actual time=978.670..978.689 rows=469 loops=1)

  • Sort Key: powerband6.fcpm_1_run_tick_h
  • Sort Method: quicksort Memory: 135kB
19. 0.236 977.708 ↓ 234.5 469 1

Subquery Scan on powerband6 (cost=25,075.63..25,075.75 rows=2 width=476) (actual time=929.363..977.708 rows=469 loops=1)

20. 48.291 977.472 ↓ 234.5 469 1

WindowAgg (cost=25,075.63..25,075.73 rows=2 width=476) (actual time=929.361..977.472 rows=469 loops=1)

21. 1.033 929.181 ↓ 234.5 469 1

Sort (cost=25,075.63..25,075.63 rows=2 width=444) (actual time=929.163..929.181 rows=469 loops=1)

  • Sort Key: powerband5.fcpm_4_run_tick_h
  • Sort Method: quicksort Memory: 149kB
22. 51.819 928.148 ↓ 234.5 469 1

WindowAgg (cost=25,075.58..25,075.62 rows=2 width=444) (actual time=876.672..928.148 rows=469 loops=1)

23. 1.208 876.329 ↓ 234.5 469 1

Sort (cost=25,075.58..25,075.58 rows=2 width=412) (actual time=876.295..876.329 rows=469 loops=1)

  • Sort Key: powerband5.fcpm_3_run_tick_h
  • Sort Method: quicksort Memory: 149kB
24. 52.799 875.121 ↓ 234.5 469 1

WindowAgg (cost=25,075.53..25,075.57 rows=2 width=412) (actual time=823.204..875.121 rows=469 loops=1)

25. 3.018 822.322 ↓ 234.5 469 1

Sort (cost=25,075.53..25,075.53 rows=2 width=380) (actual time=821.785..822.322 rows=469 loops=1)

  • Sort Key: powerband5.fcpm_2_run_tick_h
  • Sort Method: quicksort Memory: 149kB
26. 74.030 819.304 ↓ 234.5 469 1

WindowAgg (cost=25,075.48..25,075.52 rows=2 width=380) (actual time=745.897..819.304 rows=469 loops=1)

27. 0.992 745.274 ↓ 234.5 469 1

Sort (cost=25,075.48..25,075.48 rows=2 width=348) (actual time=745.225..745.274 rows=469 loops=1)

  • Sort Key: powerband5.fcpm_1_run_tick_h
  • Sort Method: quicksort Memory: 135kB
28. 0.206 744.282 ↓ 234.5 469 1

Subquery Scan on powerband5 (cost=25,075.27..25,075.47 rows=2 width=348) (actual time=734.026..744.282 rows=469 loops=1)

29. 10.033 744.076 ↓ 234.5 469 1

WindowAgg (cost=25,075.27..25,075.45 rows=2 width=348) (actual time=734.024..744.076 rows=469 loops=1)

30. 0.955 734.043 ↓ 234.5 469 1

Sort (cost=25,075.27..25,075.28 rows=2 width=316) (actual time=733.994..734.043 rows=469 loops=1)

  • Sort Key: powerband.fcpm_4_run_tick_h
  • Sort Method: quicksort Memory: 149kB
31. 1.229 733.088 ↓ 234.5 469 1

WindowAgg (cost=25,075.23..25,075.26 rows=2 width=316) (actual time=731.828..733.088 rows=469 loops=1)

32. 0.840 731.859 ↓ 234.5 469 1

Sort (cost=25,075.23..25,075.23 rows=2 width=284) (actual time=731.817..731.859 rows=469 loops=1)

  • Sort Key: powerband.fcpm_3_run_tick_h
  • Sort Method: quicksort Memory: 149kB
33. 1.171 731.019 ↓ 234.5 469 1

WindowAgg (cost=25,075.18..25,075.22 rows=2 width=284) (actual time=729.811..731.019 rows=469 loops=1)

34. 0.879 729.848 ↓ 234.5 469 1

Sort (cost=25,075.18..25,075.19 rows=2 width=252) (actual time=729.801..729.848 rows=469 loops=1)

  • Sort Key: powerband.fcpm_2_run_tick_h
  • Sort Method: quicksort Memory: 149kB
35. 1.184 728.969 ↓ 234.5 469 1

WindowAgg (cost=25,075.14..25,075.17 rows=2 width=252) (actual time=727.743..728.969 rows=469 loops=1)

36. 0.966 727.785 ↓ 234.5 469 1

Sort (cost=25,075.14..25,075.14 rows=2 width=220) (actual time=727.732..727.785 rows=469 loops=1)

  • Sort Key: powerband.fcpm_1_run_tick_h
  • Sort Method: quicksort Memory: 131kB
37. 5.061 726.819 ↓ 234.5 469 1

Subquery Scan on powerband (cost=25,061.87..25,075.13 rows=2 width=220) (actual time=717.179..726.819 rows=469 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: 216
38. 4.527 721.758 ↓ 5.0 685 1

WindowAgg (cost=25,061.87..25,066.97 rows=136 width=524) (actual time=717.134..721.758 rows=685 loops=1)

39. 1.191 717.231 ↓ 5.0 685 1

Sort (cost=25,061.87..25,062.21 rows=136 width=188) (actual time=717.105..717.231 rows=685 loops=1)

  • Sort Key: celerity.fcpm_4_run_tick_h
  • Sort Method: quicksort Memory: 206kB
40. 1.653 716.040 ↓ 5.0 685 1

WindowAgg (cost=25,054.67..25,057.05 rows=136 width=188) (actual time=714.328..716.040 rows=685 loops=1)

41. 1.627 714.387 ↓ 5.0 685 1

Sort (cost=25,054.67..25,055.01 rows=136 width=156) (actual time=714.313..714.387 rows=685 loops=1)

  • Sort Key: celerity.fcpm_3_run_tick_h
  • Sort Method: quicksort Memory: 202kB
42. 1.548 712.760 ↓ 5.0 685 1

WindowAgg (cost=25,047.47..25,049.85 rows=136 width=156) (actual time=711.157..712.760 rows=685 loops=1)

43. 0.862 711.212 ↓ 5.0 685 1

Sort (cost=25,047.47..25,047.81 rows=136 width=124) (actual time=711.147..711.212 rows=685 loops=1)

  • Sort Key: celerity.fcpm_2_run_tick_h
  • Sort Method: quicksort Memory: 121kB
44. 1.355 710.350 ↓ 5.0 685 1

WindowAgg (cost=25,040.27..25,042.65 rows=136 width=124) (actual time=708.942..710.350 rows=685 loops=1)

45. 0.702 708.995 ↓ 5.0 685 1

Sort (cost=25,040.27..25,040.61 rows=136 width=92) (actual time=708.919..708.995 rows=685 loops=1)

  • Sort Key: celerity.fcpm_1_run_tick_h
  • Sort Method: quicksort Memory: 121kB
46. 159.813 708.293 ↓ 5.0 685 1

Gather (cost=1,000.00..25,035.45 rows=136 width=92) (actual time=96.871..708.293 rows=685 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
47. 548.480 548.480 ↓ 4.0 228 3

Parallel Seq Scan on celerity (cost=0.00..24,021.85 rows=57 width=92) (actual time=184.428..548.480 rows=228 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: 118944
Planning time : 2.101 ms
Execution time : 1,001.524 ms