explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3WRi

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather Motion 25:1 (slice24; segments: 25) (cost=2,208,299.550..2,208,300.680 rows=30 width=336) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,208,299.550..2,208,300.680 rows=2 width=336) (actual rows= loops=)

  • Group By: paragone.org_id
3. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice23; segments: 25) (cost=2,208,297.750..2,208,298.350 rows=2 width=336) (actual rows= loops=)

  • Hash Key: paragone.org_id
4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,208,297.750..2,208,297.750 rows=2 width=336) (actual rows= loops=)

  • Group By: "?column1?
5. 0.000 0.000 ↓ 0.0

Append (cost=31,962.270..2,208,296.550 rows=2 width=60) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 1" (cost=31,962.270..31,962.300 rows=1 width=56) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

HashAggregate (cost=31,962.270..31,962.290 rows=1 width=56) (actual rows= loops=)

  • Group By: rsccallplan.org_id
8. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice3; segments: 25) (cost=31,962.240..31,962.260 rows=1 width=16) (actual rows= loops=)

  • Hash Key: rsccallplan.org_id
9. 0.000 0.000 ↓ 0.0

HashAggregate (cost=31,962.240..31,962.240 rows=1 width=16) (actual rows= loops=)

  • Group By: rsccallplan.org_id
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9,412.090..31,962.200 rows=1 width=16) (actual rows= loops=)

  • Join Filter: zulu_lima.whiskey_seven = "india_mike".quebec_seven
11. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice2; segments: 25) (cost=9,165.440..25,597.990 rows=59 width=20) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash Join (cost=9,165.440..25,582.880 rows=3 width=20) (actual rows= loops=)

  • Hash Cond: sierra_quebec.india_papa = zulu_lima.quebec_seven
13. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice1; segments: 25) (cost=0.000..16,416.570 rows=3 width=24) (actual rows= loops=)

  • Hash Key: rsccallplan.creator_id
14. 0.000 0.000 ↓ 0.0

Seq Scan on kilo_yankee sierra_quebec (cost=0.000..16,415.410 rows=3 width=24) (actual rows= loops=)

  • Filter: bravo_romeo = 0 AND oscar(yankee::text, 1, 8) = 'uniform_lima'::text AND juliet_charlie = 0
15. 0.000 0.000 ↓ 0.0

Hash (cost=8,843.530..8,843.530 rows=1,031 width=12) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on six zulu_lima (cost=0.000..8,843.530 rows=1,031 width=12) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Materialize (cost=246.650..248.520 rows=8 width=8) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on five_echo india_mike (cost=0.000..246.460 rows=8 width=8) (actual rows= loops=)

  • Filter: four_alpha::text = 'seven'::text
19. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 2" (cost=399,215.850..399,215.870 rows=1 width=60) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

HashAggregate (cost=399,215.850..399,215.860 rows=1 width=60) (actual rows= loops=)

  • Group By: rscintention.org_id
21. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice6; segments: 25) (cost=399,215.810..399,215.830 rows=1 width=24) (actual rows= loops=)

  • Hash Key: rscintention.org_id
22. 0.000 0.000 ↓ 0.0

HashAggregate (cost=399,215.810..399,215.810 rows=1 width=24) (actual rows= loops=)

  • Group By: rscintention.org_id
23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9,465.270..399,215.350 rows=3 width=20) (actual rows= loops=)

  • Join Filter: zulu_lima.whiskey_seven = "india_mike".quebec_seven
24. 0.000 0.000 ↓ 0.0

Hash Join (cost=9,165.440..68,020.560 rows=126 width=24) (actual rows= loops=)

  • Hash Cond: lima_romeo.india_papa = zulu_lima.quebec_seven
25. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice4; segments: 25) (cost=0.000..58,807.990 rows=126 width=28) (actual rows= loops=)

  • Hash Key: rscintention.creator_id
26. 0.000 0.000 ↓ 0.0

Seq Scan on alpha_charlie lima_romeo (cost=0.000..58,745.150 rows=126 width=28) (actual rows= loops=)

  • Filter: bravo_romeo = 0 AND three_tango = 0
27. 0.000 0.000 ↓ 0.0

Hash (cost=8,843.530..8,843.530 rows=1,031 width=12) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on six zulu_lima (cost=0.000..8,843.530 rows=1,031 width=12) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Materialize (cost=299.820..346.630 rows=188 width=8) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice5; segments: 25) (cost=0.000..295.140 rows=188 width=8) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Seq Scan on five_echo india_mike (cost=0.000..246.460 rows=8 width=8) (actual rows= loops=)

  • Filter: four_alpha::text = 'seven'::text
32. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 3" (cost=219,470.330..219,470.350 rows=1 width=52) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

HashAggregate (cost=219,470.330..219,470.340 rows=1 width=52) (actual rows= loops=)

  • Group By: rscsatisfy.org_id
34. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice9; segments: 25) (cost=219,470.290..219,470.310 rows=1 width=12) (actual rows= loops=)

  • Hash Key: rscsatisfy.org_id
35. 0.000 0.000 ↓ 0.0

HashAggregate (cost=219,470.290..219,470.290 rows=1 width=12) (actual rows= loops=)

  • Group By: rscsatisfy.org_id
36. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.000..219,470.250 rows=1 width=8) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice8; segments: 25) (cost=0.000..218,499.870 rows=39 width=12) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.000..218,489.980 rows=2 width=12) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice7; segments: 25) (cost=0.000..30,122.170 rows=39 width=12) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_romeo two_yankee (cost=0.000..30,112.280 rows=2 width=12) (actual rows= loops=)

  • Filter: bravo_romeo = 0 AND zulu_papa::text >= 'uniform_quebec'::text AND zulu_papa::text <= 'lima_alpha'::text AND xray = 1
41. 0.000 0.000 ↓ 0.0

Index Scan using tango on six zulu_lima (cost=0.000..197.950 rows=1 width=12) (actual rows= loops=)

  • Index Cond: two_yankee.india_papa = zulu_lima.quebec_seven
42. 0.000 0.000 ↓ 0.0

Index Scan using papa on five_echo india_mike (cost=0.000..1.010 rows=1 width=8) (actual rows= loops=)

  • Index Cond: zulu_lima.whiskey_seven = "india_mike".quebec_seven
  • Filter: four_alpha::text = 'seven'::text
43. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 4" (cost=309,963.250..309,963.520 rows=1 width=68) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

HashAggregate (cost=309,963.250..309,963.430 rows=1 width=68) (actual rows= loops=)

  • Group By: rsccustomer.org_id
45. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice13; segments: 25) (cost=309,962.780..309,963.050 rows=1 width=40) (actual rows= loops=)

  • Hash Key: rsccustomer.org_id
46. 0.000 0.000 ↓ 0.0

HashAggregate (cost=309,962.780..309,962.870 rows=1 width=40) (actual rows= loops=)

  • Group By: rsccustomer.org_id
47. 0.000 0.000 ↓ 0.0

Nested Loop (cost=13,282.140..309,962.660 rows=1 width=20) (actual rows= loops=)

  • Join Filter: zulu_lima.whiskey_seven = "india_mike".quebec_seven
48. 0.000 0.000 ↓ 0.0

Hash Join (cost=12,982.310..259,008.960 rows=20 width=24) (actual rows= loops=)

  • Hash Cond: sierra_lima.india_papa = zulu_lima.quebec_seven
49. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice11; segments: 25) (cost=3,816.870..249,836.300 rows=20 width=28) (actual rows= loops=)

  • Hash Key: rsccustomer.creator_id
50. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,816.870..249,826.680 rows=20 width=28) (actual rows= loops=)

  • Hash Cond: bravo_seven.uniform_six = sierra_lima.uniform_six
51. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice10; segments: 25) (cost=0.000..245,893.830 rows=1,298 width=20) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_hotel bravo_seven (cost=0.000..245,556.400 rows=52 width=20) (actual rows= loops=)

  • Filter: bravo_romeo = 0 AND juliet_charlie = 0
53. 0.000 0.000 ↓ 0.0

Hash (cost=3,263.800..3,263.800 rows=1,770 width=24) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_yankee sierra_lima (cost=0.000..3,263.800 rows=1,770 width=24) (actual rows= loops=)

  • Filter: romeo = 1 AND four_foxtrot = 1
55. 0.000 0.000 ↓ 0.0

Hash (cost=8,843.530..8,843.530 rows=1,031 width=12) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Seq Scan on six zulu_lima (cost=0.000..8,843.530 rows=1,031 width=12) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Materialize (cost=299.820..346.630 rows=188 width=8) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice12; segments: 25) (cost=0.000..295.140 rows=188 width=8) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Seq Scan on five_echo india_mike (cost=0.000..246.460 rows=8 width=8) (actual rows= loops=)

  • Filter: four_alpha::text = 'seven'::text
60. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 5" (cost=398,327.070..398,327.460 rows=1 width=56) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

HashAggregate (cost=398,327.070..398,327.290 rows=1 width=56) (actual rows= loops=)

  • Group By: rsccustomer.org_id
62. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice18; segments: 25) (cost=398,326.480..398,326.820 rows=1 width=16) (actual rows= loops=)

  • Hash Key: rsccustomer.org_id
63. 0.000 0.000 ↓ 0.0

HashAggregate (cost=398,326.480..398,326.480 rows=1 width=16) (actual rows= loops=)

  • Group By: rsccustomer.org_id
64. 0.000 0.000 ↓ 0.0

Hash Left Anti Semi Join (Not-In) (cost=101,645.670..398,326.390 rows=1 width=16) (actual rows= loops=)

  • Hash Cond: bravo_seven.quebec_seven = "juliet_golf".alpha_bravo
65. 0.000 0.000 ↓ 0.0

Nested Loop (cost=13,282.140..309,962.660 rows=1 width=16) (actual rows= loops=)

  • Join Filter: zulu_lima.whiskey_seven = "india_mike".quebec_seven
66. 0.000 0.000 ↓ 0.0

Hash Join (cost=12,982.310..259,008.960 rows=20 width=20) (actual rows= loops=)

  • Hash Cond: sierra_lima.india_papa = zulu_lima.quebec_seven
67. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice15; segments: 25) (cost=3,816.870..249,836.300 rows=20 width=24) (actual rows= loops=)

  • Hash Key: rsccustomer.creator_id
68. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,816.870..249,826.680 rows=20 width=24) (actual rows= loops=)

  • Hash Cond: bravo_seven.uniform_six = sierra_lima.uniform_six
69. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice14; segments: 25) (cost=0.000..245,893.830 rows=1,298 width=16) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_hotel bravo_seven (cost=0.000..245,556.400 rows=52 width=16) (actual rows= loops=)

  • Filter: bravo_romeo = 0 AND quebec_seven five_romeo NOT NULL AND juliet_charlie = 0
71. 0.000 0.000 ↓ 0.0

Hash (cost=3,263.800..3,263.800 rows=1,770 width=24) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_yankee sierra_lima (cost=0.000..3,263.800 rows=1,770 width=24) (actual rows= loops=)

  • Filter: romeo = 1 AND four_foxtrot = 1
73. 0.000 0.000 ↓ 0.0

Hash (cost=8,843.530..8,843.530 rows=1,031 width=12) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Seq Scan on six zulu_lima (cost=0.000..8,843.530 rows=1,031 width=12) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Materialize (cost=299.820..346.630 rows=188 width=8) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice16; segments: 25) (cost=0.000..295.140 rows=188 width=8) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Seq Scan on five_echo india_mike (cost=0.000..246.460 rows=8 width=8) (actual rows= loops=)

  • Filter: four_alpha::text = 'seven'::text
78. 0.000 0.000 ↓ 0.0

Hash (cost=42,285.720..42,285.720 rows=147,449 width=8) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice17; segments: 25) (cost=0.000..42,285.720 rows=147,449 width=8) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Subquery Scan "NotIn_SUBQUERY" (cost=0.000..3,948.980 rows=5,898 width=8) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Seq Scan on sierra_oscar echo (cost=0.000..2,474.490 rows=5,898 width=8) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 6" (cost=849,357.040..849,357.060 rows=1 width=56) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

HashAggregate (cost=849,357.040..849,357.050 rows=1 width=56) (actual rows= loops=)

  • Group By: ejobcandidate.org_id
84. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice22; segments: 25) (cost=849,357.000..849,357.020 rows=1 width=16) (actual rows= loops=)

  • Hash Key: ejobcandidate.org_id
85. 0.000 0.000 ↓ 0.0

HashAggregate (cost=849,357.000..849,357.000 rows=1 width=16) (actual rows= loops=)

  • Group By: ejobcandidate.org_id
86. 0.000 0.000 ↓ 0.0

Nested Loop (cost=109,664.240..849,356.530 rows=4 width=16) (actual rows= loops=)

  • Join Filter: zulu_lima.whiskey_seven = "india_mike".quebec_seven
87. 0.000 0.000 ↓ 0.0

Hash Join (cost=109,364.410..344,723.670 rows=192 width=20) (actual rows= loops=)

  • Hash Cond: three_xray.india_papa = zulu_lima.quebec_seven
88. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice20; segments: 25) (cost=100,198.970..335,486.400 rows=192 width=24) (actual rows= loops=)

  • Hash Key: ejobcandidate.creator_id
89. 0.000 0.000 ↓ 0.0

Hash Join (cost=100,198.970..335,390.620 rows=192 width=24) (actual rows= loops=)

  • Hash Cond: bravo_seven.quebec_seven = three_xray.alpha_bravo
90. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_hotel bravo_seven (cost=0.000..231,272.370 rows=61,751 width=8) (actual rows= loops=)

  • Filter: bravo_three = ANY ('two_charlie'::integer[])
91. 0.000 0.000 ↓ 0.0

Hash (cost=99,755.890..99,755.890 rows=1,418 width=32) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice19; segments: 25) (cost=0.000..99,755.890 rows=1,418 width=32) (actual rows= loops=)

  • Hash Key: ejobcandidate.rsc_ejob_id
93. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_four three_xray (cost=0.000..99,046.950 rows=1,418 width=32) (actual rows= loops=)

  • Filter: bravo_romeo = 0 AND hotel::text >= 'kilo_tango'::text AND hotel::text <= 'lima_alpha'::text
94. 0.000 0.000 ↓ 0.0

Hash (cost=8,843.530..8,843.530 rows=1,031 width=12) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Seq Scan on six zulu_lima (cost=0.000..8,843.530 rows=1,031 width=12) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Materialize (cost=299.820..346.630 rows=188 width=8) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice21; segments: 25) (cost=0.000..295.140 rows=188 width=8) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Seq Scan on five_echo india_mike (cost=0.000..246.460 rows=8 width=8) (actual rows= loops=)

  • Filter: four_alpha::text = 'seven'::text