explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r6FK

Settings
# exclusive inclusive rows x rows loops node
1. 16.463 22,161.740 ↓ 751.0 751 1

Subquery Scan on powerband8 (cost=25,733.36..25,736.54 rows=1 width=764) (actual time=22,049.861..22,161.740 rows=751 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: 3857
2. 91.319 22,145.277 ↓ 242.5 4,608 1

WindowAgg (cost=25,733.36..25,735.40 rows=19 width=764) (actual time=22,049.798..22,145.277 rows=4,608 loops=1)

3. 11.032 22,053.958 ↓ 242.5 4,608 1

Sort (cost=25,733.36..25,733.40 rows=19 width=604) (actual time=22,049.763..22,053.958 rows=4,608 loops=1)

  • Sort Key: powerband7.value_4_partition
  • Sort Method: quicksort Memory: 1808kB
4. 9.958 22,042.926 ↓ 242.5 4,608 1

WindowAgg (cost=25,732.62..25,732.95 rows=19 width=604) (actual time=22,032.499..22,042.926 rows=4,608 loops=1)

5. 4.084 22,032.968 ↓ 242.5 4,608 1

Sort (cost=25,732.62..25,732.67 rows=19 width=572) (actual time=22,032.494..22,032.968 rows=4,608 loops=1)

  • Sort Key: powerband7.value_3_partition
  • Sort Method: quicksort Memory: 1522kB
6. 5.483 22,028.884 ↓ 242.5 4,608 1

WindowAgg (cost=25,731.88..25,732.22 rows=19 width=572) (actual time=22,023.185..22,028.884 rows=4,608 loops=1)

7. 4.782 22,023.401 ↓ 242.5 4,608 1

Sort (cost=25,731.88..25,731.93 rows=19 width=540) (actual time=22,023.168..22,023.401 rows=4,608 loops=1)

  • Sort Key: powerband7.value_2_partition
  • Sort Method: quicksort Memory: 1490kB
8. 6.815 22,018.619 ↓ 242.5 4,608 1

WindowAgg (cost=25,731.15..25,731.48 rows=19 width=540) (actual time=22,011.501..22,018.619 rows=4,608 loops=1)

9. 3.945 22,011.804 ↓ 242.5 4,608 1

Sort (cost=25,731.15..25,731.20 rows=19 width=508) (actual time=22,011.492..22,011.804 rows=4,608 loops=1)

  • Sort Key: powerband7.value_1_partition
  • Sort Method: quicksort Memory: 1417kB
10. 1.029 22,007.859 ↓ 242.5 4,608 1

Subquery Scan on powerband7 (cost=25,730.22..25,730.74 rows=19 width=508) (actual time=21,999.662..22,007.859 rows=4,608 loops=1)

11. 6.942 22,006.830 ↓ 242.5 4,608 1

WindowAgg (cost=25,730.22..25,730.55 rows=19 width=508) (actual time=21,999.660..22,006.830 rows=4,608 loops=1)

12. 5.628 21,999.888 ↓ 242.5 4,608 1

Sort (cost=25,730.22..25,730.27 rows=19 width=500) (actual time=21,999.650..21,999.888 rows=4,608 loops=1)

  • Sort Key: powerband6.fcpm_4_run_tick_h
  • Sort Method: quicksort Memory: 1417kB
13. 9.344 21,994.260 ↓ 242.5 4,608 1

WindowAgg (cost=25,729.49..25,729.82 rows=19 width=500) (actual time=21,984.598..21,994.260 rows=4,608 loops=1)

14. 5.008 21,984.916 ↓ 242.5 4,608 1

Sort (cost=25,729.49..25,729.53 rows=19 width=492) (actual time=21,984.589..21,984.916 rows=4,608 loops=1)

  • Sort Key: powerband6.fcpm_3_run_tick_h
  • Sort Method: quicksort Memory: 1417kB
15. 8.427 21,979.908 ↓ 242.5 4,608 1

WindowAgg (cost=25,728.75..25,729.08 rows=19 width=492) (actual time=21,971.203..21,979.908 rows=4,608 loops=1)

16. 5.729 21,971.481 ↓ 242.5 4,608 1

Sort (cost=25,728.75..25,728.80 rows=19 width=484) (actual time=21,971.180..21,971.481 rows=4,608 loops=1)

  • Sort Key: powerband6.fcpm_2_run_tick_h
  • Sort Method: quicksort Memory: 1417kB
17. 8.896 21,965.752 ↓ 242.5 4,608 1

WindowAgg (cost=25,728.01..25,728.35 rows=19 width=484) (actual time=21,956.550..21,965.752 rows=4,608 loops=1)

18. 22.637 21,956.856 ↓ 242.5 4,608 1

Sort (cost=25,728.01..25,728.06 rows=19 width=476) (actual time=21,956.535..21,956.856 rows=4,608 loops=1)

  • Sort Key: powerband6.fcpm_1_run_tick_h
  • Sort Method: quicksort Memory: 1325kB
19. 6.537 21,934.219 ↓ 242.5 4,608 1

Subquery Scan on powerband6 (cost=25,726.47..25,727.61 rows=19 width=476) (actual time=15,732.323..21,934.219 rows=4,608 loops=1)

20. 6,197.751 21,927.682 ↓ 242.5 4,608 1

WindowAgg (cost=25,726.47..25,727.42 rows=19 width=476) (actual time=15,732.322..21,927.682 rows=4,608 loops=1)

21. 14.660 15,729.931 ↓ 242.5 4,608 1

Sort (cost=25,726.47..25,726.52 rows=19 width=444) (actual time=15,729.716..15,729.931 rows=4,608 loops=1)

  • Sort Key: powerband5.fcpm_4_run_tick_h
  • Sort Method: quicksort Memory: 1417kB
22. 4,735.678 15,715.271 ↓ 242.5 4,608 1

WindowAgg (cost=25,725.69..25,726.07 rows=19 width=444) (actual time=10,982.752..15,715.271 rows=4,608 loops=1)

23. 17.651 10,979.593 ↓ 242.5 4,608 1

Sort (cost=25,725.69..25,725.73 rows=19 width=412) (actual time=10,979.245..10,979.593 rows=4,608 loops=1)

  • Sort Key: powerband5.fcpm_3_run_tick_h
  • Sort Method: quicksort Memory: 1417kB
24. 5,140.707 10,961.942 ↓ 242.5 4,608 1

WindowAgg (cost=25,724.90..25,725.28 rows=19 width=412) (actual time=5,824.669..10,961.942 rows=4,608 loops=1)

25. 15.970 5,821.235 ↓ 242.5 4,608 1

Sort (cost=25,724.90..25,724.95 rows=19 width=380) (actual time=5,820.937..5,821.235 rows=4,608 loops=1)

  • Sort Key: powerband5.fcpm_2_run_tick_h
  • Sort Method: quicksort Memory: 1417kB
26. 4,874.224 5,805.265 ↓ 242.5 4,608 1

WindowAgg (cost=25,724.12..25,724.50 rows=19 width=380) (actual time=934.622..5,805.265 rows=4,608 loops=1)

27. 6.198 931.041 ↓ 242.5 4,608 1

Sort (cost=25,724.12..25,724.17 rows=19 width=348) (actual time=930.734..931.041 rows=4,608 loops=1)

  • Sort Key: powerband5.fcpm_1_run_tick_h
  • Sort Method: quicksort Memory: 1325kB
28. 1.334 924.843 ↓ 242.5 4,608 1

Subquery Scan on powerband5 (cost=25,721.86..25,723.72 rows=19 width=348) (actual time=886.142..924.843 rows=4,608 loops=1)

29. 36.985 923.509 ↓ 242.5 4,608 1

WindowAgg (cost=25,721.86..25,723.53 rows=19 width=348) (actual time=886.140..923.509 rows=4,608 loops=1)

30. 5.160 886.524 ↓ 242.5 4,608 1

Sort (cost=25,721.86..25,721.91 rows=19 width=316) (actual time=886.109..886.524 rows=4,608 loops=1)

  • Sort Key: powerband.fcpm_4_run_tick_h
  • Sort Method: quicksort Memory: 1417kB
31. 5.262 881.364 ↓ 242.5 4,608 1

WindowAgg (cost=25,721.13..25,721.46 rows=19 width=316) (actual time=875.856..881.364 rows=4,608 loops=1)

32. 7.178 876.102 ↓ 242.5 4,608 1

Sort (cost=25,721.13..25,721.18 rows=19 width=284) (actual time=875.849..876.102 rows=4,608 loops=1)

  • Sort Key: powerband.fcpm_3_run_tick_h
  • Sort Method: quicksort Memory: 1417kB
33. 8.748 868.924 ↓ 242.5 4,608 1

WindowAgg (cost=25,720.39..25,720.72 rows=19 width=284) (actual time=859.792..868.924 rows=4,608 loops=1)

34. 5.352 860.176 ↓ 242.5 4,608 1

Sort (cost=25,720.39..25,720.44 rows=19 width=252) (actual time=859.774..860.176 rows=4,608 loops=1)

  • Sort Key: powerband.fcpm_2_run_tick_h
  • Sort Method: quicksort Memory: 1417kB
35. 6.015 854.824 ↓ 242.5 4,608 1

WindowAgg (cost=25,719.66..25,719.99 rows=19 width=252) (actual time=848.520..854.824 rows=4,608 loops=1)

36. 6.115 848.809 ↓ 242.5 4,608 1

Sort (cost=25,719.66..25,719.70 rows=19 width=220) (actual time=848.511..848.809 rows=4,608 loops=1)

  • Sort Key: powerband.fcpm_1_run_tick_h
  • Sort Method: quicksort Memory: 1252kB
37. 27.546 842.694 ↓ 242.5 4,608 1

Subquery Scan on powerband (cost=25,571.83..25,719.25 rows=19 width=220) (actual time=791.073..842.694 rows=4,608 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: 2666
38. 23.404 815.148 ↓ 4.8 7,274 1

WindowAgg (cost=25,571.83..25,628.53 rows=1,512 width=524) (actual time=791.028..815.148 rows=7,274 loops=1)

39. 9.251 791.744 ↓ 4.8 7,274 1

Sort (cost=25,571.83..25,575.61 rows=1,512 width=188) (actual time=791.010..791.744 rows=7,274 loops=1)

  • Sort Key: celerity.fcpm_4_run_tick_h
  • Sort Method: quicksort Memory: 2125kB
40. 7.861 782.493 ↓ 4.8 7,274 1

WindowAgg (cost=25,465.52..25,491.98 rows=1,512 width=188) (actual time=774.258..782.493 rows=7,274 loops=1)

41. 12.062 774.632 ↓ 4.8 7,274 1

Sort (cost=25,465.52..25,469.30 rows=1,512 width=156) (actual time=774.238..774.632 rows=7,274 loops=1)

  • Sort Key: celerity.fcpm_3_run_tick_h
  • Sort Method: quicksort Memory: 2081kB
42. 17.212 762.570 ↓ 4.8 7,274 1

WindowAgg (cost=25,359.21..25,385.67 rows=1,512 width=156) (actual time=744.436..762.570 rows=7,274 loops=1)

43. 12.158 745.358 ↓ 4.8 7,274 1

Sort (cost=25,359.21..25,362.99 rows=1,512 width=124) (actual time=744.417..745.358 rows=7,274 loops=1)

  • Sort Key: celerity.fcpm_2_run_tick_h
  • Sort Method: quicksort Memory: 1215kB
44. 14.594 733.200 ↓ 4.8 7,274 1

WindowAgg (cost=25,252.90..25,279.36 rows=1,512 width=124) (actual time=717.745..733.200 rows=7,274 loops=1)

45. 8.000 718.606 ↓ 4.8 7,274 1

Sort (cost=25,252.90..25,256.68 rows=1,512 width=92) (actual time=717.724..718.606 rows=7,274 loops=1)

  • Sort Key: celerity.fcpm_1_run_tick_h
  • Sort Method: quicksort Memory: 1215kB
46. 148.224 710.606 ↓ 4.8 7,274 1

Gather (cost=1,000.00..25,173.05 rows=1,512 width=92) (actual time=94.593..710.606 rows=7,274 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
47. 562.382 562.382 ↓ 3.8 2,425 3

Parallel Seq Scan on celerity (cost=0.00..24,021.85 rows=630 width=92) (actual time=187.818..562.382 rows=2,425 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: 116747
Planning time : 2.125 ms
Execution time : 22,168.886 ms