explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 62j1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 552.327 ↑ 1.0 1 1

Finalize Aggregate (cost=80,477.84..80,477.85 rows=1 width=8) (actual time=552.327..552.327 rows=1 loops=1)

2. 16.829 558.754 ↓ 1.5 3 1

Gather (cost=80,477.62..80,477.83 rows=2 width=8) (actual time=551.823..558.754 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 61.088 541.925 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=79,477.62..79,477.63 rows=1 width=8) (actual time=541.925..541.925 rows=1 loops=3)

4. 68.591 480.837 ↑ 1.3 1,238,239 3 / 3

Parallel Append (cost=0.00..75,608.10 rows=1,547,810 width=0) (actual time=0.416..480.837 rows=1,238,239 loops=3)

5. 0.011 0.011 ↓ 0.0 0 1 / 3

Seq Scan on execution_62 (cost=0.00..1.00 rows=1 width=0) (actual time=0.032..0.032 rows=0 loops=1)

  • Filter: (configuration_id IS NULL)
6. 0.008 0.008 ↓ 26.0 26 1 / 3

Seq Scan on execution_63 (cost=0.00..1.00 rows=1 width=0) (actual time=0.022..0.025 rows=26 loops=1)

  • Filter: (configuration_id IS NULL)
7. 0.002 0.002 ↓ 0.0 0 1 / 3

Seq Scan on execution_0 (cost=0.00..0.00 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (configuration_id IS NULL)
8. 33.081 33.081 ↓ 2.4 462,455 1 / 3

Parallel Seq Scan on execution_13 (cost=0.00..6,884.90 rows=192,690 width=0) (actual time=0.026..99.243 rows=462,455 loops=1)

  • Filter: (configuration_id IS NULL)
9. 18.797 18.797 ↓ 1.7 152,869 1 / 3

Parallel Seq Scan on execution_35 (cost=0.00..3,005.24 rows=89,918 width=0) (actual time=1.163..56.391 rows=152,869 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 2
10. 11.614 11.614 ↓ 1.7 150,979 1 / 3

Parallel Seq Scan on execution_11 (cost=0.00..2,707.11 rows=88,811 width=0) (actual time=0.015..34.842 rows=150,979 loops=1)

  • Filter: (configuration_id IS NULL)
11. 15.875 15.875 ↓ 1.7 149,083 1 / 3

Parallel Seq Scan on execution_28 (cost=0.00..2,592.96 rows=87,696 width=0) (actual time=0.923..47.626 rows=149,083 loops=1)

  • Filter: (configuration_id IS NULL)
12. 15.963 15.963 ↓ 1.7 123,203 1 / 3

Parallel Seq Scan on execution_31 (cost=0.00..2,350.72 rows=72,472 width=0) (actual time=1.031..47.889 rows=123,203 loops=1)

  • Filter: (configuration_id IS NULL)
13. 9.447 9.447 ↓ 1.7 128,054 1 / 3

Parallel Seq Scan on execution_12 (cost=0.00..2,205.26 rows=75,326 width=0) (actual time=0.018..28.342 rows=128,054 loops=1)

  • Filter: (configuration_id IS NULL)
14. 7.803 7.803 ↓ 1.7 105,984 1 / 3

Parallel Seq Scan on execution_9 (cost=0.00..2,044.44 rows=62,344 width=0) (actual time=0.014..23.408 rows=105,984 loops=1)

  • Filter: (configuration_id IS NULL)
15. 8.434 8.434 ↓ 1.7 111,170 1 / 3

Parallel Seq Scan on execution_10 (cost=0.00..2,032.94 rows=65,394 width=0) (actual time=0.020..25.303 rows=111,170 loops=1)

  • Filter: (configuration_id IS NULL)
16. 12.853 12.853 ↓ 1.7 98,893 1 / 3

Parallel Seq Scan on execution_32 (cost=0.00..1,947.72 rows=58,172 width=0) (actual time=0.992..38.560 rows=98,893 loops=1)

  • Filter: (configuration_id IS NULL)
17. 12.332 12.332 ↓ 1.7 99,554 1 / 3

Parallel Seq Scan on execution_30 (cost=0.00..1,823.61 rows=58,561 width=0) (actual time=1.015..36.997 rows=99,554 loops=1)

  • Filter: (configuration_id IS NULL)
18. 11.124 11.124 ↓ 1.7 86,390 1 / 3

Parallel Seq Scan on execution_33 (cost=0.00..1,742.18 rows=50,818 width=0) (actual time=1.240..33.371 rows=86,390 loops=1)

  • Filter: (configuration_id IS NULL)
19. 10.438 10.438 ↓ 1.7 94,207 1 / 3

Parallel Seq Scan on execution_29 (cost=0.00..1,665.16 rows=55,416 width=0) (actual time=1.258..31.314 rows=94,207 loops=1)

  • Filter: (configuration_id IS NULL)
20. 11.530 11.530 ↓ 1.7 96,607 1 / 3

Parallel Seq Scan on execution_25 (cost=0.00..1,643.28 rows=56,828 width=0) (actual time=0.622..34.591 rows=96,607 loops=1)

  • Filter: (configuration_id IS NULL)
21. 7.288 7.288 ↓ 1.7 85,886 1 / 3

Parallel Seq Scan on execution_36 (cost=0.00..1,562.21 rows=50,521 width=0) (actual time=1.007..21.864 rows=85,886 loops=1)

  • Filter: (configuration_id IS NULL)
22. 6.321 6.321 ↓ 1.7 81,508 1 / 3

Parallel Seq Scan on execution_8 (cost=0.00..1,547.46 rows=47,946 width=0) (actual time=0.011..18.964 rows=81,508 loops=1)

  • Filter: (configuration_id IS NULL)
23. 14.145 14.145 ↓ 1.7 87,807 1 / 3

Parallel Seq Scan on execution_27 (cost=0.00..1,527.51 rows=51,651 width=0) (actual time=1.249..42.435 rows=87,807 loops=1)

  • Filter: (configuration_id IS NULL)
24. 10.536 10.536 ↓ 1.7 79,878 1 / 3

Parallel Seq Scan on execution_43 (cost=0.00..1,517.88 rows=47,013 width=0) (actual time=5.897..31.609 rows=79,878 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 4,082
25. 13.446 13.446 ↓ 1.7 82,104 1 / 3

Parallel Seq Scan on execution_17 (cost=0.00..1,358.96 rows=48,296 width=0) (actual time=1.798..40.339 rows=82,104 loops=1)

  • Filter: (configuration_id IS NULL)
26. 12.420 12.420 ↓ 1.7 54,311 1 / 3

Parallel Seq Scan on execution_16 (cost=0.00..1,315.48 rows=31,948 width=0) (actual time=2.447..37.259 rows=54,311 loops=1)

  • Filter: (configuration_id IS NULL)
27. 4.746 4.746 ↓ 1.7 67,407 1 / 3

Parallel Seq Scan on execution_14 (cost=0.00..1,268.51 rows=39,651 width=0) (actual time=0.012..14.238 rows=67,407 loops=1)

  • Filter: (configuration_id IS NULL)
28. 5.956 5.956 ↓ 1.7 66,065 1 / 3

Parallel Seq Scan on execution_41 (cost=0.00..1,240.92 rows=38,834 width=0) (actual time=0.017..17.868 rows=66,065 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 2,432
29. 6.345 6.345 ↓ 1.7 51,535 1 / 3

Parallel Seq Scan on execution_58 (cost=0.00..1,055.72 rows=30,359 width=0) (actual time=0.905..19.034 rows=51,535 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 5,707
30. 10.658 10.658 ↑ 1.8 19,076 3 / 3

Parallel Seq Scan on execution_26 (cost=0.00..1,008.63 rows=33,663 width=0) (actual time=0.432..10.658 rows=19,076 loops=3)

  • Filter: (configuration_id IS NULL)
31. 5.975 5.975 ↓ 1.7 48,677 1 / 3

Parallel Seq Scan on execution_56 (cost=0.00..926.60 rows=28,672 width=0) (actual time=1.118..17.925 rows=48,677 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 895
32. 4.207 4.207 ↓ 1.7 46,511 1 / 3

Parallel Seq Scan on execution_50 (cost=0.00..904.91 rows=27,348 width=0) (actual time=0.009..12.621 rows=46,511 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 2,774
33. 4.016 4.016 ↓ 1.7 46,569 1 / 3

Parallel Seq Scan on execution_40 (cost=0.00..850.19 rows=27,394 width=0) (actual time=0.016..12.047 rows=46,569 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 44
34. 7.054 7.054 ↓ 1.7 44,846 1 / 3

Parallel Seq Scan on execution_44 (cost=0.00..832.29 rows=26,379 width=0) (actual time=0.012..21.162 rows=44,846 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 1,103
35. 4.323 4.323 ↓ 1.7 40,056 1 / 3

Parallel Seq Scan on execution_59 (cost=0.00..786.12 rows=23,562 width=0) (actual time=0.986..12.968 rows=40,056 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 2,634
36. 4.875 4.875 ↓ 1.7 41,996 1 / 3

Parallel Seq Scan on execution_57 (cost=0.00..772.56 rows=24,687 width=0) (actual time=1.107..14.624 rows=41,996 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 1,109
37. 4.111 4.111 ↓ 1.7 32,923 1 / 3

Parallel Seq Scan on execution_47 (cost=0.00..759.38 rows=19,389 width=0) (actual time=0.012..12.332 rows=32,923 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 7,261
38. 3.528 3.528 ↓ 1.7 41,683 1 / 3

Parallel Seq Scan on execution_37 (cost=0.00..757.92 rows=24,519 width=0) (actual time=0.014..10.584 rows=41,683 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 123
39. 4.942 4.942 ↓ 1.7 33,747 1 / 3

Parallel Seq Scan on execution_52 (cost=0.00..730.32 rows=19,821 width=0) (actual time=1.572..14.827 rows=33,747 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 4,558
40. 3.401 3.401 ↓ 1.7 43,319 1 / 3

Parallel Seq Scan on execution_4 (cost=0.00..725.82 rows=25,482 width=0) (actual time=0.016..10.202 rows=43,319 loops=1)

  • Filter: (configuration_id IS NULL)
41. 6.075 6.075 ↓ 1.7 36,291 1 / 3

Parallel Seq Scan on execution_34 (cost=0.00..720.48 rows=21,348 width=0) (actual time=2.517..18.224 rows=36,291 loops=1)

  • Filter: (configuration_id IS NULL)
42. 3.416 3.416 ↓ 1.7 38,000 1 / 3

Parallel Seq Scan on execution_39 (cost=0.00..685.62 rows=22,358 width=0) (actual time=0.016..10.247 rows=38,000 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 525
43. 5.648 5.648 ↓ 1.7 35,156 1 / 3

Parallel Seq Scan on execution_42 (cost=0.00..667.11 rows=20,684 width=0) (actual time=5.575..16.944 rows=35,156 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 1,923
44. 3.933 3.933 ↓ 1.7 30,854 1 / 3

Parallel Seq Scan on execution_54 (cost=0.00..665.95 rows=18,136 width=0) (actual time=0.010..11.799 rows=30,854 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 3,648
45. 2.891 2.891 ↓ 1.7 35,687 1 / 3

Parallel Seq Scan on execution_38 (cost=0.00..646.40 rows=20,994 width=0) (actual time=0.011..8.672 rows=35,687 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 81
46. 4.765 4.765 ↓ 1.7 28,896 1 / 3

Parallel Seq Scan on execution_53 (cost=0.00..632.98 rows=16,969 width=0) (actual time=4.091..14.296 rows=28,896 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 4,930
47. 3.136 3.136 ↓ 1.7 32,456 1 / 3

Parallel Seq Scan on execution_46 (cost=0.00..630.52 rows=19,096 width=0) (actual time=0.806..9.407 rows=32,456 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 1,803
48. 3.712 3.712 ↓ 1.7 29,481 1 / 3

Parallel Seq Scan on execution_48 (cost=0.00..629.71 rows=17,326 width=0) (actual time=1.548..11.135 rows=29,481 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 3,449
49. 4.929 4.929 ↓ 1.7 26,150 1 / 3

Parallel Seq Scan on execution_15 (cost=0.00..601.82 rows=15,382 width=0) (actual time=1.190..14.787 rows=26,150 loops=1)

  • Filter: (configuration_id IS NULL)
50. 2.613 2.613 ↓ 1.7 31,905 1 / 3

Parallel Seq Scan on execution_7 (cost=0.00..577.68 rows=18,768 width=0) (actual time=0.016..7.840 rows=31,905 loops=1)

  • Filter: (configuration_id IS NULL)
51. 4.778 4.778 ↓ 1.7 32,518 1 / 3

Parallel Seq Scan on execution_24 (cost=0.00..575.28 rows=19,128 width=0) (actual time=0.735..14.333 rows=32,518 loops=1)

  • Filter: (configuration_id IS NULL)
52. 2.134 2.134 ↓ 1.7 24,804 1 / 3

Parallel Seq Scan on execution_45 (cost=0.00..570.91 rows=14,591 width=0) (actual time=0.013..6.403 rows=24,804 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 5,101
53. 2.470 2.470 ↓ 1.7 29,765 1 / 3

Parallel Seq Scan on execution_49 (cost=0.00..568.68 rows=17,509 width=0) (actual time=0.016..7.409 rows=29,765 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 1,630
54. 5.225 5.225 ↓ 1.7 32,164 1 / 3

Parallel Seq Scan on execution_23 (cost=0.00..559.20 rows=18,920 width=0) (actual time=1.077..15.674 rows=32,164 loops=1)

  • Filter: (configuration_id IS NULL)
55. 3.493 3.493 ↓ 1.7 30,919 1 / 3

Parallel Seq Scan on execution_6 (cost=0.00..555.88 rows=18,188 width=0) (actual time=0.914..10.479 rows=30,919 loops=1)

  • Filter: (configuration_id IS NULL)
56. 4.375 4.375 ↓ 1.7 31,016 1 / 3

Parallel Seq Scan on execution_5 (cost=0.00..532.45 rows=18,245 width=0) (actual time=1.581..13.126 rows=31,016 loops=1)

  • Filter: (configuration_id IS NULL)
57. 3.128 3.128 ↓ 1.7 28,735 1 / 3

Parallel Seq Scan on execution_2 (cost=0.00..499.09 rows=16,903 width=0) (actual time=0.015..9.385 rows=28,735 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 351
58. 2.242 2.242 ↓ 1.7 26,752 1 / 3

Parallel Seq Scan on execution_22 (cost=0.00..488.36 rows=15,736 width=0) (actual time=0.016..6.726 rows=26,752 loops=1)

  • Filter: (configuration_id IS NULL)
59. 2.070 2.070 ↓ 1.7 18,245 1 / 3

Parallel Seq Scan on execution_51 (cost=0.00..466.43 rows=10,732 width=0) (actual time=0.818..6.210 rows=18,245 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 5,458
60. 3.726 3.726 ↓ 1.7 27,088 1 / 3

Parallel Seq Scan on execution_3 (cost=0.00..460.34 rows=15,934 width=0) (actual time=1.032..11.178 rows=27,088 loops=1)

  • Filter: (configuration_id IS NULL)
61. 4.846 4.846 ↓ 1.7 24,243 1 / 3

Parallel Seq Scan on execution_20 (cost=0.00..429.61 rows=14,261 width=0) (actual time=4.207..14.539 rows=24,243 loops=1)

  • Filter: (configuration_id IS NULL)
62. 2.559 2.559 ↓ 1.7 21,711 1 / 3

Parallel Seq Scan on execution_21 (cost=0.00..390.71 rows=12,771 width=0) (actual time=1.116..7.676 rows=21,711 loops=1)

  • Filter: (configuration_id IS NULL)
63. 3.045 3.045 ↓ 1.7 21,625 1 / 3

Parallel Seq Scan on execution_19 (cost=0.00..368.21 rows=12,721 width=0) (actual time=0.695..9.136 rows=21,625 loops=1)

  • Filter: (configuration_id IS NULL)
64. 1.187 1.187 ↓ 1.7 14,330 1 / 3

Parallel Seq Scan on execution_55 (cost=0.00..263.56 rows=8,429 width=0) (actual time=0.015..3.561 rows=14,330 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 45
65. 4.086 4.086 ↓ 1.7 13,196 1 / 3

Parallel Seq Scan on execution_18 (cost=0.00..225.62 rows=7,762 width=0) (actual time=2.412..12.258 rows=13,196 loops=1)

  • Filter: (configuration_id IS NULL)
66. 1.944 1.944 ↓ 1.7 8,768 1 / 3

Parallel Seq Scan on execution_60 (cost=0.00..173.18 rows=5,157 width=0) (actual time=1.485..5.833 rows=8,768 loops=1)

  • Filter: (configuration_id IS NULL)
  • Rows Removed by Filter: 613
67. 2.170 2.170 ↓ 1.7 10,295 1 / 3

Parallel Seq Scan on execution_1 (cost=0.00..172.56 rows=6,056 width=0) (actual time=1.257..6.510 rows=10,295 loops=1)

  • Filter: (configuration_id IS NULL)
68. 0.004 0.004 ↓ 25.0 25 1 / 3

Parallel Seq Scan on execution_64 (cost=0.00..10.76 rows=1 width=0) (actual time=0.009..0.012 rows=25 loops=1)

  • Filter: (configuration_id IS NULL)
69. 0.031 0.031 ↑ 1.0 85 1 / 3

Parallel Seq Scan on execution_65 (cost=0.00..2.89 rows=89 width=0) (actual time=0.075..0.092 rows=85 loops=1)

  • Filter: (configuration_id IS NULL)
70. 0.010 0.010 ↓ 1.7 27 1 / 3

Parallel Seq Scan on execution_61 (cost=0.00..1.16 rows=16 width=0) (actual time=0.026..0.030 rows=27 loops=1)

  • Filter: (configuration_id IS NULL)
Planning time : 26.790 ms
Execution time : 559.676 ms