explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c58x : SPP

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

Nested Loop (cost=504,796.330..678,870.840 rows=1 width=89) (actual rows= loops=)

  • Join Filter: ((uniform_foxtrot3.lima_sierra)::text = (two_november2kilo1.lima_sierra)::text)
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=504,796.190..678,870.670 rows=1 width=89) (actual rows= loops=)

  • Hash Cond: (six_hotel_hotel.six_hotel_mike = tango_four.golf)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=454,162.910..628,237.240 rows=37 width=8) (actual rows= loops=)

  • Hash Cond: (six_hotel_hotel.foxtrot_two = victor_xray2.echo_zulu)
4. 0.000 0.000 ↓ 0.0

CTE Scan on six_hotel_hotel (cost=384,433.050..487,587.990 rows=5,157,747 width=8) (actual rows= loops=)

5.          

CTE six_hotel_hotel

6. 0.000 0.000 ↓ 0.0

Recursive Union (cost=0.000..384,433.050 rows=5,157,747 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on xray (cost=0.000..3,148.460 rows=51,067 width=4) (actual rows= loops=)

  • Filter: (zulu_romeo five_romeo NULL)
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=5,410.530..27,812.970 rows=510,668 width=8) (actual rows= loops=)

  • Hash Cond: (romeo_three.foxtrot_two = november_tango5.zulu_romeo)
9. 0.000 0.000 ↓ 0.0

WorkTable Scan on resolve_feature_member t (cost=0.000..10,213.400 rows=510,670 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=3,148.460..3,148.460 rows=137,846 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on xray victor_four (cost=0.000..3,148.460 rows=137,846 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=69,729.850..69,729.850 rows=1 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=68,329.280..69,729.850 rows=1 width=8) (actual rows= loops=)

  • Join Filter: ((two_november.lima_sierra)::text = (two_november2.lima_sierra)::text)
14. 0.000 0.000 ↓ 0.0

Merge Join (cost=68,329.150..69,729.680 rows=1 width=36) (actual rows= loops=)

  • Merge Cond: ((victor_xray.bravo_seven = victor_xray2.bravo_seven) AND (victor_xray.bravo_oscar = victor_xray2.bravo_oscar))
  • Join Filter: (victor_xray2.four_golf = victor_xray.four_golf)
15. 0.000 0.000 ↓ 0.0

Unique (cost=20,581.580..21,960.040 rows=1,470 width=38) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Sort (cost=20,581.580..20,926.200 rows=137,846 width=38) (actual rows= loops=)

  • Sort Key: victor_xray.bravo_seven, victor_xray.bravo_oscar, two_november.lima_sierra, victor_xray.four_golf DESC
17. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.230..5,045.070 rows=137,846 width=38) (actual rows= loops=)

  • Hash Cond: ((victor_xray.whiskey_mike)::text = (two_november.three_sierra)::text)
18. 0.000 0.000 ↓ 0.0

Seq Scan on xray victor_xray (cost=0.000..3,148.460 rows=137,846 width=18) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash (cost=1.100..1.100 rows=10 width=48) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_tango two_november (cost=0.000..1.100 rows=10 width=48) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Sort (cost=47,747.570..47,747.570 rows=1 width=34) (actual rows= loops=)

  • Sort Key: victor_xray2.bravo_seven, victor_xray2.bravo_oscar
22. 0.000 0.000 ↓ 0.0

Merge Join (cost=47,747.530..47,747.560 rows=1 width=34) (actual rows= loops=)

  • Merge Cond: ((victor_xray2.four_golf = (alpha(victor_xray2kilo3.four_golf))) AND (victor_xray2.bravo_six = victor_xray2kilo3.bravo_six))
23. 0.000 0.000 ↓ 0.0

Sort (cost=24,647.180..24,647.190 rows=1 width=143) (actual rows= loops=)

  • Sort Key: victor_xray2.four_golf, victor_xray2.bravo_six
24. 0.000 0.000 ↓ 0.0

Nested Loop (cost=24,554.990..24,647.170 rows=1 width=143) (actual rows= loops=)

  • Join Filter: (echo_lima1.bravo_six = victor_xray2.bravo_six)
25. 0.000 0.000 ↓ 0.0

Hash Join (cost=24,554.570..24,643.050 rows=1 width=82) (actual rows= loops=)

  • Hash Cond: (juliet_india.bravo_six = echo_lima1.bravo_six)
26. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,454.230..1,491.480 rows=3,725 width=39) (actual rows= loops=)

  • Group Key: juliet_india.bravo_six
27. 0.000 0.000 ↓ 0.0

Merge Join (cost=940.210..1,444.920 rows=3,725 width=39) (actual rows= loops=)

  • Merge Cond: (juliet_india.echo_zulu = uniform_delta.golf)
28. 0.000 0.000 ↓ 0.0

Index Scan using delta on xray juliet_india (cost=0.420..10,505.070 rows=137,846 width=43) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Sort (cost=526.110..535.450 rows=3,736 width=4) (actual rows= loops=)

  • Sort Key: uniform_delta.golf
30. 0.000 0.000 ↓ 0.0

Seq Scan on lima_bravo uniform_delta (cost=0.000..304.430 rows=3,736 width=4) (actual rows= loops=)

  • Filter: romeo_sierra
31. 0.000 0.000 ↓ 0.0

Hash (cost=23,100.330..23,100.330 rows=1 width=43) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Subquery Scan on four_bravo (cost=23,100.310..23,100.330 rows=1 width=43) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

HashAggregate (cost=23,100.310..23,100.320 rows=1 width=43) (actual rows= loops=)

  • Group Key: victor_xray2kilo2.bravo_six
34. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20,720.140..23,100.310 rows=1 width=43) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20,581.580..21,997.920 rows=7 width=38) (actual rows= loops=)

  • Join Filter: ((two_november2kilo2.lima_sierra)::text = (uniform_foxtrot1.lima_sierra)::text)
36. 0.000 0.000 ↓ 0.0

Unique (cost=20,581.580..21,960.040 rows=1,470 width=38) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Sort (cost=20,581.580..20,926.200 rows=137,846 width=38) (actual rows= loops=)

  • Sort Key: november_tango1.bravo_seven, november_tango1.bravo_oscar, uniform_foxtrot1.lima_sierra, november_tango1.four_golf DESC
38. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.230..5,045.070 rows=137,846 width=38) (actual rows= loops=)

  • Hash Cond: ((november_tango1.whiskey_mike)::text = (uniform_foxtrot1.three_sierra)::text)
39. 0.000 0.000 ↓ 0.0

Seq Scan on xray november_whiskey (cost=0.000..3,148.460 rows=137,846 width=18) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Hash (cost=1.100..1.100 rows=10 width=48) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_tango papa_three_echo (cost=0.000..1.100 rows=10 width=48) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Materialize (cost=0.000..1.130 rows=1 width=48) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_tango two_five_alpha (cost=0.000..1.120 rows=1 width=48) (actual rows= loops=)

  • Filter: ((three_sierra)::text = 'oscar'::text)
44. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on xray lima_tango (cost=138.560..157.290 rows=19 width=57) (actual rows= loops=)

  • Recheck Cond: ((bravo_oscar = november_tango1.bravo_oscar) AND (four_golf = november_tango1.four_golf))
  • Filter: (((whiskey_mike)::text = 'oscar'::text) AND (november_tango1.bravo_seven = bravo_seven))
45. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=138.560..138.560 rows=547 width=0) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on bravo_romeo (cost=0.000..50.690 rows=6,564 width=0) (actual rows= loops=)

  • Index Cond: (bravo_oscar = november_tango1.bravo_oscar)
47. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on bravo_mike (cost=0.000..87.610 rows=11,487 width=0) (actual rows= loops=)

  • Index Cond: (four_golf = november_tango1.four_golf)
48. 0.000 0.000 ↓ 0.0

Index Scan using four_xray on xray zulu_hotel (cost=0.420..4.070 rows=4 width=61) (actual rows= loops=)

  • Index Cond: (bravo_six = juliet_india.bravo_six)
  • Filter: (bravo_six <> november_november ('lima_zulu'::text[]))
49. 0.000 0.000 ↓ 0.0

Sort (cost=23,100.340..23,100.350 rows=1 width=47) (actual rows= loops=)

  • Sort Key: (alpha(victor_xray2kilo3.four_golf)), victor_xray2kilo3.bravo_six
50. 0.000 0.000 ↓ 0.0

HashAggregate (cost=23,100.310..23,100.320 rows=1 width=47) (actual rows= loops=)

  • Group Key: victor_xray2kilo3.bravo_six
51. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20,720.140..23,100.310 rows=1 width=47) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20,581.580..21,997.920 rows=7 width=38) (actual rows= loops=)

  • Join Filter: ((two_november2kilo3.lima_sierra)::text = (uniform_foxtrot2.lima_sierra)::text)
53. 0.000 0.000 ↓ 0.0

Unique (cost=20,581.580..21,960.040 rows=1,470 width=38) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Sort (cost=20,581.580..20,926.200 rows=137,846 width=38) (actual rows= loops=)

  • Sort Key: november_tango2.bravo_seven, november_tango2.bravo_oscar, uniform_foxtrot2.lima_sierra, november_tango2.four_golf DESC
55. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.230..5,045.070 rows=137,846 width=38) (actual rows= loops=)

  • Hash Cond: ((november_tango2.whiskey_mike)::text = (uniform_foxtrot2.three_sierra)::text)
56. 0.000 0.000 ↓ 0.0

Seq Scan on xray tango_delta (cost=0.000..3,148.460 rows=137,846 width=18) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Hash (cost=1.100..1.100 rows=10 width=48) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_tango charlie_november (cost=0.000..1.100 rows=10 width=48) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Materialize (cost=0.000..1.130 rows=1 width=48) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_tango yankee (cost=0.000..1.120 rows=1 width=48) (actual rows= loops=)

  • Filter: ((three_sierra)::text = 'oscar'::text)
61. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on xray foxtrot_victor (cost=138.560..157.290 rows=19 width=57) (actual rows= loops=)

  • Recheck Cond: ((bravo_oscar = november_tango2.bravo_oscar) AND (four_golf = november_tango2.four_golf))
  • Filter: (((whiskey_mike)::text = 'oscar'::text) AND (november_tango2.bravo_seven = bravo_seven))
62. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=138.560..138.560 rows=547 width=0) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on bravo_romeo (cost=0.000..50.690 rows=6,564 width=0) (actual rows= loops=)

  • Index Cond: (bravo_oscar = november_tango2.bravo_oscar)
64. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on bravo_mike (cost=0.000..87.610 rows=11,487 width=0) (actual rows= loops=)

  • Index Cond: (four_golf = november_tango2.four_golf)
65. 0.000 0.000 ↓ 0.0

Index Scan using juliet_hotel on whiskey_tango victor_mike (cost=0.140..0.150 rows=1 width=48) (actual rows= loops=)

  • Index Cond: ((three_sierra)::text = (victor_xray2.whiskey_mike)::text)
66. 0.000 0.000 ↓ 0.0

Hash (cost=50,633.270..50,633.270 rows=1 width=89) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Merge Join (cost=49,232.740..50,633.270 rows=1 width=89) (actual rows= loops=)

  • Merge Cond: ((november_tango3.bravo_seven = victor_xray2kilo1.bravo_seven) AND (november_tango3.bravo_oscar = victor_xray2kilo1.bravo_oscar))
  • Join Filter: (victor_xray2kilo1.four_golf = november_tango3.four_golf)
68. 0.000 0.000 ↓ 0.0

Unique (cost=20,581.580..21,960.040 rows=1,470 width=38) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Sort (cost=20,581.580..20,926.200 rows=137,846 width=38) (actual rows= loops=)

  • Sort Key: november_tango3.bravo_seven, november_tango3.bravo_oscar, uniform_foxtrot3.lima_sierra, november_tango3.four_golf DESC
70. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.230..5,045.070 rows=137,846 width=38) (actual rows= loops=)

  • Hash Cond: ((november_tango3.whiskey_mike)::text = (uniform_foxtrot3.three_sierra)::text)
71. 0.000 0.000 ↓ 0.0

Seq Scan on xray november_golf (cost=0.000..3,148.460 rows=137,846 width=18) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Hash (cost=1.100..1.100 rows=10 width=48) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_tango three_november (cost=0.000..1.100 rows=10 width=48) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Sort (cost=28,651.160..28,651.160 rows=1 width=73) (actual rows= loops=)

  • Sort Key: victor_xray2kilo1.bravo_seven, victor_xray2kilo1.bravo_oscar
75. 0.000 0.000 ↓ 0.0

Nested Loop (cost=28,640.990..28,651.150 rows=1 width=73) (actual rows= loops=)

  • Join Filter: ((alpha(victor_xray2kilo4.four_golf)) = victor_xray2kilo1.four_golf)
76. 0.000 0.000 ↓ 0.0

Nested Loop (cost=28,640.570..28,648.610 rows=1 width=92) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

HashAggregate (cost=28,640.280..28,640.290 rows=1 width=47) (actual rows= loops=)

  • Group Key: victor_xray2kilo4.bravo_six
78. 0.000 0.000 ↓ 0.0

Hash Join (cost=22,197.850..28,640.280 rows=1 width=47) (actual rows= loops=)

  • Hash Cond: (((victor_xray2kilo4.whiskey_mike)::text = (two_november2kilo4.three_sierra)::text) AND (victor_xray2kilo4.bravo_seven = november_tango4.bravo_seven) AND (victor_xray2kilo4.bravo_oscar = november_tango4.bravo_oscar) AND (victor_xray2kilo4.four_golf = november_tango4.four_golf))
79. 0.000 0.000 ↓ 0.0

Seq Scan on xray three_two (cost=0.000..3,493.070 rows=65,541 width=57) (actual rows= loops=)

  • Filter: ((whiskey_mike)::text = ANY ('charlie_whiskey'::text[]))
80. 0.000 0.000 ↓ 0.0

Hash (cost=22,196.370..22,196.370 rows=74 width=38) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20,581.580..22,196.370 rows=74 width=38) (actual rows= loops=)

  • Join Filter: ((two_november2kilo4.lima_sierra)::text = (uniform_foxtrot4.lima_sierra)::text)
82. 0.000 0.000 ↓ 0.0

Unique (cost=20,581.580..21,960.040 rows=1,470 width=38) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Sort (cost=20,581.580..20,926.200 rows=137,846 width=38) (actual rows= loops=)

  • Sort Key: november_tango4.bravo_seven, november_tango4.bravo_oscar, uniform_foxtrot4.lima_sierra, november_tango4.four_golf DESC
84. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.230..5,045.070 rows=137,846 width=38) (actual rows= loops=)

  • Hash Cond: ((november_tango4.whiskey_mike)::text = (uniform_foxtrot4.three_sierra)::text)
85. 0.000 0.000 ↓ 0.0

Seq Scan on xray uniform_india (cost=0.000..3,148.460 rows=137,846 width=18) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Hash (cost=1.100..1.100 rows=10 width=48) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_tango juliet_whiskey (cost=0.000..1.100 rows=10 width=48) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Materialize (cost=0.000..1.150 rows=10 width=48) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_tango four_quebec (cost=0.000..1.100 rows=10 width=48) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Index Scan using tango_kilo on lima_bravo tango_four (cost=0.280..8.300 rows=1 width=45) (actual rows= loops=)

  • Index Cond: (five_whiskey = victor_xray2kilo4.bravo_six)
91. 0.000 0.000 ↓ 0.0

Index Scan using four_xray on xray two_five_delta (cost=0.420..2.480 rows=4 width=61) (actual rows= loops=)

  • Index Cond: (bravo_six = tango_four.five_whiskey)
92. 0.000 0.000 ↓ 0.0

Index Scan using juliet_hotel on whiskey_tango papa_three_oscar (cost=0.140..0.150 rows=1 width=48) (actual rows= loops=)

  • Index Cond: ((three_sierra)::text = (victor_xray2kilo1.whiskey_mike)::text)