explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VJDV

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

HashAggregate (cost=66,496,147,781,868,353,669,300,224.00..66,652,643,660,421,951,521,816,576.00 rows=6,955,372,380,160,000,000,000,000 width=537) (actual rows= loops=)

  • Group Key: (xray.yankee_yankee five_romeo NOT NULL), (five_november.yankee_yankee five_romeo NOT NULL), xray.whiskey_whiskey, five_november.whiskey_whiskey, xray.lima_hotel, five_november.lima_hotel, ((xray.india_alpha)::text = (five_november.india_alpha)::text), xray.sierra, five_november.sierra, xray.five_xray, five_november.five_xray, ((xray.kilo)::text = (five_november.kilo)::text), xray.seven_oscar, five_november.seven_oscar, xray.yankee_whiskey_delta, five_november.yankee_whiskey_delta, ((xray.uniform_victor)::text = (five_november.uniform_victor)::text), xray.seven_quebec, xray.three_golf, five_november.three_golf, ((xray.whiskey_india)::text = (five_november.whiskey_india)::text), xray.delta_november, five_november.delta_november, xray.lima_echo, five_november.lima_echo, ((xray.zulu_mike)::text = (five_november.zulu_mike)::text), xray.bravo_three, five_november.bravo_three
2.          

CTE five_november

3. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=2,328,360.28..2,528,158.71 rows=8,291,446 width=191) (actual rows= loops=)

  • Hash Cond: (india_seven.romeo_romeo = four_zulu.quebec_seven)
4.          

CTE india_seven

5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=264,526.92..408,948.61 rows=1,258,316 width=165) (actual rows= loops=)

  • Hash Cond: (four_lima.bravo_six = zulu_whiskey.quebec_seven)
6. 0.000 0.000 ↓ 0.0

Seq Scan on four_lima (cost=0.00..20,598.16 rows=1,258,316 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=125,198.41..125,198.41 rows=3,985,241 width=157) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on zulu_whiskey (cost=0.00..125,198.41 rows=3,985,241 width=157) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

CTE Scan on india_seven (cost=0.00..25,166.32 rows=1,258,316 width=134) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=1,718,602.59..1,718,602.59 rows=8,291,446 width=68) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,255,990.95..1,718,602.59 rows=8,291,446 width=68) (actual rows= loops=)

  • Hash Cond: (four_zulu.five_echo = charlie_hotel.quebec_seven)
12. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=935,129.41..1,065,596.05 rows=8,291,446 width=59) (actual rows= loops=)

  • Hash Cond: (three_india.india_yankee = four_zulu.quebec_seven)
13. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_seven three_india (cost=0.00..30,103.12 rows=803,312 width=19) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash (cost=758,611.33..758,611.33 rows=8,291,446 width=48) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=636,681.83..758,611.33 rows=8,291,446 width=48) (actual rows= loops=)

  • Hash Cond: (seven_kilo.seven_two = four_zulu.quebec_seven)
16. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_seven seven_kilo (cost=0.00..30,103.12 rows=803,312 width=19) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash (cost=468,261.76..468,261.76 rows=8,291,446 width=37) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=411,120.54..468,261.76 rows=8,291,446 width=37) (actual rows= loops=)

  • Hash Cond: (papa.foxtrot_sierra = four_zulu.quebec_seven)
19. 0.000 0.000 ↓ 0.0

Seq Scan on papa (cost=0.00..205.53 rows=7,453 width=18) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash (cost=250,797.46..250,797.46 rows=8,291,446 width=27) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on four_zulu (cost=0.00..250,797.46 rows=8,291,446 width=27) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash (cost=266,353.02..266,353.02 rows=2,819,002 width=25) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Seq Scan on charlie_hotel (cost=0.00..266,353.02 rows=2,819,002 width=25) (actual rows= loops=)

24.          

CTE xray

25. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1,824,472,465,288,866.50..240,557,735,173,288,787,968.00 rows=16,029,669,531,431,471,153,152 width=421) (actual rows= loops=)

  • Merge Cond: ((delta_juliet.romeo_india)::text = (quebec_six1.quebec_three)::text)
26.          

CTE delta_juliet

27. 0.000 0.000 ↓ 0.0

Seq Scan on uniform_quebec (cost=0.00..396,541.74 rows=9,516,942 width=41) (actual rows= loops=)

  • Filter: (hotel_uniform five_romeo NOT NULL)
28.          

CTE five_two

29. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on four_victor (cost=49,434.47..190,880.47 rows=2,019,360 width=15) (actual rows= loops=)

  • Recheck Cond: ((five_foxtrot)::text = 'whiskey_romeo'::text)
30. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hotel_charlie (cost=0.00..48,929.63 rows=2,019,360 width=0) (actual rows= loops=)

  • Index Cond: ((five_foxtrot)::text = 'whiskey_romeo'::text)
31.          

CTE yankee_charlie

32. 0.000 0.000 ↓ 0.0

Seq Scan on four_victor victor_foxtrot_mike (cost=0.00..203,055.69 rows=4,015,559 width=15) (actual rows= loops=)

  • Filter: ((five_foxtrot)::text = 'yankee_golf'::text)
33.          

CTE seven_kilo

34. 0.000 0.000 ↓ 0.0

Index Scan using yankee_whiskey_six on four_victor india_zulu (cost=0.43..122,153.17 rows=506,287 width=24) (actual rows= loops=)

  • Index Cond: ((india_hotel)::text = 'foxtrot_six'::text)
35.          

CTE three_india

36. 0.000 0.000 ↓ 0.0

Index Scan using yankee_whiskey_six on four_victor six (cost=0.43..122,153.17 rows=506,287 width=24) (actual rows= loops=)

  • Index Cond: ((india_hotel)::text = 'foxtrot_six'::text)
37. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1,824,472,464,166,565.75..96,861,586,441,882,896.00 rows=6,332,246,149,488,914,432 width=336) (actual rows= loops=)

  • Merge Cond: ((delta_juliet.romeo_india)::text = (juliet1.hotel_whiskey)::text)
38. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1,824,472,464,079,049.25..1,871,640,586,243,515.00 rows=2,501,445,286,759,847 width=256) (actual rows= loops=)

  • Merge Cond: ((delta_juliet.romeo_india)::text = (india_november.uniform_romeo)::text)
39. 0.000 0.000 ↓ 0.0

Sort (cost=1,824,472,464,078,401.75..1,829,295,685,509,935.75 rows=1,929,288,572,613,611 width=240) (actual rows= loops=)

  • Sort Key: delta_juliet.romeo_india
40. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=54,444,763,599.78..28,994,013,599,531.70 rows=1,929,288,572,613,611 width=240) (actual rows= loops=)

  • Merge Cond: ((yankee_charlie.romeo_india)::text = (delta_juliet.victor_foxtrot_six)::text)
41. 0.000 0.000 ↓ 0.0

Sort (cost=699,187.67..709,226.57 rows=4,015,559 width=80) (actual rows= loops=)

  • Sort Key: yankee_charlie.romeo_india
42. 0.000 0.000 ↓ 0.0

CTE Scan on yankee_charlie (cost=0.00..80,311.18 rows=4,015,559 width=80) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Materialize (cost=54,444,064,412.11..54,924,517,712.04 rows=96,090,659,986 width=192) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Sort (cost=54,444,064,412.11..54,684,291,062.07 rows=96,090,659,986 width=192) (actual rows= loops=)

  • Sort Key: delta_juliet.victor_foxtrot_six
45. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=3,001,253.65..1,444,395,042.59 rows=96,090,659,986 width=192) (actual rows= loops=)

  • Merge Cond: ((five_two.romeo_india)::text = (delta_juliet.hotel_uniform)::text)
46. 0.000 0.000 ↓ 0.0

Sort (cost=341,598.89..346,647.29 rows=2,019,360 width=80) (actual rows= loops=)

  • Sort Key: five_two.romeo_india
47. 0.000 0.000 ↓ 0.0

CTE Scan on five_two (cost=0.00..40,387.20 rows=2,019,360 width=80) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Materialize (cost=2,659,654.76..2,707,239.47 rows=9,516,942 width=144) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Sort (cost=2,659,654.76..2,683,447.11 rows=9,516,942 width=144) (actual rows= loops=)

  • Sort Key: delta_juliet.hotel_uniform
50. 0.000 0.000 ↓ 0.0

CTE Scan on delta_juliet (cost=0.00..190,338.84 rows=9,516,942 width=144) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Sort (cost=647.48..666.34 rows=7,546 width=25) (actual rows= loops=)

  • Sort Key: india_november.uniform_romeo
52. 0.000 0.000 ↓ 0.0

Seq Scan on india_november (cost=0.00..161.46 rows=7,546 width=25) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Materialize (cost=87,516.41..90,047.85 rows=506,287 width=112) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Sort (cost=87,516.41..88,782.13 rows=506,287 width=112) (actual rows= loops=)

  • Sort Key: juliet1.hotel_whiskey
55. 0.000 0.000 ↓ 0.0

CTE Scan on seven_kilo mike (cost=0.00..10,125.74 rows=506,287 width=112) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Materialize (cost=87,516.41..90,047.85 rows=506,287 width=112) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Sort (cost=87,516.41..88,782.13 rows=506,287 width=112) (actual rows= loops=)

  • Sort Key: quebec_six1.quebec_three
58. 0.000 0.000 ↓ 0.0

CTE Scan on three_india charlie_sierra (cost=0.00..10,125.74 rows=506,287 width=112) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Merge Full Join (cost=41,297,491,104,667,642,363,904.00..18,316,344,221,463,533,049,610,240.00 rows=664,545,696,588,546,826,202,775,552 width=529) (actual rows= loops=)

  • Merge Cond: ((five_november.yankee_yankee)::text = (xray.yankee_yankee)::text)
60. 0.000 0.000 ↓ 0.0

Sort (cost=5,539,673.41..5,560,402.02 rows=8,291,446 width=597) (actual rows= loops=)

  • Sort Key: five_november.yankee_yankee
61. 0.000 0.000 ↓ 0.0

CTE Scan on five_november (cost=0.00..165,828.92 rows=8,291,446 width=597) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Materialize (cost=41,297,491,104,667,633,975,296.00..41,377,639,452,324,785,029,120.00 rows=16,029,669,531,431,471,153,152 width=485) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Sort (cost=41,297,491,104,667,633,975,296.00..41,337,565,278,496,209,502,208.00 rows=16,029,669,531,431,471,153,152 width=485) (actual rows= loops=)

  • Sort Key: xray.yankee_yankee
64. 0.000 0.000 ↓ 0.0

CTE Scan on xray (cost=0.00..320,593,390,628,629,446,656.00 rows=16,029,669,531,431,471,153,152 width=485) (actual rows= loops=)