explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SBtI

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 713.299 ↓ 0.0 0 1

Unique (cost=27,555,565.660..28,820,124.650 rows=8,028,946 width=3,546) (actual time=713.299..713.299 rows=0 loops=1)

  • Buffers: shared hit=78036 dirtied=3
2. 0.093 713.298 ↓ 0.0 0 1

Sort (cost=27,555,565.660..27,575,638.020 rows=8,028,946 width=3,546) (actual time=713.298..713.298 rows=0 loops=1)

  • Sort Key: four_charlie.india_november_seven, papa_four.xray_sierra, yankee_uniform9.bravo_oscar, yankee_uniform0kilo_oscar2.whiskey_foxtrot, yankee_uniform2.zulu_quebec, yankee_uniform2.three_quebec, yankee_uniform2.oscar_charlie, yankee_uniform2.india_yankee, yankee_uniform2.echo_delta, yankee_uniform2.kilo_charlie, yankee_uniform2.xray_five, yankee_uniform2.victor_delta_romeo, yankee_uniform2.papa_alpha_five, yankee_uniform2.quebec_echo, yankee_uniform2.golf_delta_foxtrot, yankee_uniform2.seven_foxtrot, yankee_uniform2.quebec_seven, yankee_uniform2.november_alpha, yankee_uniform2.alpha_two_sierra, yankee_uniform1.seven_golf, yankee_uniform1.zulu_four, yankee_uniform1.two_quebec, yankee_uniform1.victor_oscar, yankee_uniform1.six, yankee_uniform1.alpha_bravo, yankee_uniform1.delta_six, yankee_uniform1.three_zulu, yankee_uniform1.echo_quebec, yankee_uniform1.xray_romeo, yankee_uniform1.uniform_victor, yankee_uniform1.mike_kilo, yankee_uniform1.lima_golf, yankee_uniform1.bravo_xray, yankee_uniform1.mike_oscar, yankee_uniform1.november_uniform, yankee_uniform1.foxtrot_quebec, yankee_uniform1.romeo_quebec, yankee_uniform1.uniform_two, yankee_uniform1.four_foxtrot, yankee_uniform1.foxtrot_two, yankee_uniform10.bravo_oscar, yankee_uniform11.bravo_oscar, yankee_uniform6.bravo_oscar, yankee_uniform13.bravo_oscar, yankee_uniform21.bravo_oscar, yankee_uniform14.bravo_oscar, yankee_uniform15.bravo_oscar, yankee_uniform16.bravo_oscar, yankee_uniform17.bravo_oscar, yankee_uniform7.bravo_oscar, yankee_uniform18.bravo_oscar, yankee_uniform19.bravo_oscar, yankee_uniform20.bravo_oscar, yankee_uniform22.bravo_oscar, yankee_uniform12.bravo_oscar, yankee_uniform23.bravo_oscar, yankee_uniform24.bravo_oscar, yankee_uniform3.bravo_oscar, yankee_uniform4.bravo_oscar, yankee_uniform5.bravo_oscar, yankee_uniform8.bravo_oscar, yankee_uniform0kilo_oscar4.charlie_papa
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=78036 dirtied=3
3. 0.000 713.205 ↓ 0.0 0 1

Nested Loop (cost=2,089,170.600..5,080,107.250 rows=8,028,946 width=3,546) (actual time=713.205..713.205 rows=0 loops=1)

  • Buffers: shared hit=78036 dirtied=3
4. 94.750 773.856 ↓ 0.0 0 1

Gather (cost=2,089,170.460..4,913,657.930 rows=51,563 width=3,493) (actual time=713.204..773.856 rows=0 loops=1)

  • Buffers: shared hit=78036 dirtied=3
5. 0.000 679.106 ↓ 0.0 0 2

Nested Loop (cost=2,088,170.460..4,907,501.630 rows=8,594 width=3,493) (actual time=679.106..679.106 rows=0 loops=2)

  • Buffers: shared hit=78036 dirtied=3
6. 0.001 679.106 ↓ 0.0 0 2

Nested Loop (cost=2,088,169.900..4,904,796.610 rows=3,281 width=3,435) (actual time=679.106..679.106 rows=0 loops=2)

  • Buffers: shared hit=78036 dirtied=3
7. 0.001 679.105 ↓ 0.0 0 2

Nested Loop (cost=2,088,169.340..4,902,977.240 rows=1,927 width=3,427) (actual time=679.105..679.105 rows=0 loops=2)

  • Buffers: shared hit=78036 dirtied=3
8. 0.000 679.104 ↓ 0.0 0 2

Nested Loop (cost=2,088,168.780..4,901,015.560 rows=1,927 width=3,369) (actual time=679.104..679.104 rows=0 loops=2)

  • Buffers: shared hit=78036 dirtied=3
9. 0.578 679.104 ↓ 0.0 0 2

Hash Join (cost=2,088,168.220..4,899,053.880 rows=1,927 width=3,311) (actual time=679.103..679.104 rows=0 loops=2)

  • Buffers: shared hit=78036 dirtied=3
10. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,906,347.310..4,623,115.170 rows=25,095,060 width=3,295) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,787,737.100..4,438,629.940 rows=25,095,060 width=3,237) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,419,833.110..3,788,088.990 rows=9,673,273 width=3,179) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,419,832.550..3,666,933.050 rows=9,673,273 width=3,121) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,419,831.990..3,527,843.510 rows=9,673,273 width=3,063) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,419,831.440..3,406,687.570 rows=9,673,273 width=3,005) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,419,830.880..3,285,531.640 rows=9,673,273 width=2,947) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,419,830.320..3,164,375.700 rows=9,673,273 width=2,889) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,419,829.760..3,043,219.760 rows=9,673,273 width=2,831) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,419,829.210..2,922,063.830 rows=9,673,273 width=2,773) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,419,828.650..2,800,907.890 rows=9,673,273 width=2,715) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,419,828.090..2,679,751.950 rows=9,673,273 width=2,657) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,419,827.530..2,536,284.470 rows=9,673,273 width=2,599) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,419,826.980..2,404,428.400 rows=9,673,273 width=2,541) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,419,826.420..2,261,624.970 rows=9,673,273 width=2,483) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=1,082,733.520..1,810,432.430 rows=4,407,994 width=2,425) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=748,454.420..1,420,725.530 rows=2,042,824 width=2,367) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=748,453.870..1,299,603.210 rows=2,042,824 width=2,309) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=748,453.440..1,244,271.110 rows=2,042,824 width=2,071) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=748,453.010..866,698.030 rows=2,042,824 width=76) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Sort (cost=748,452.460..753,559.520 rows=2,042,824 width=18) (never executed)

  • Sort Key: yankee_uniform0kilo_oscar2.whiskey_foxtrot
31. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=34,464.340..509,804.210 rows=2,042,824 width=18) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Append (cost=0.000..442,244.520 rows=2,042,824 width=8) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Index Only Scan using four_kilo on three_bravo lima_two (cost=0.430..107,527.260 rows=316,035 width=8) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Seq Scan on victor_alpha whiskey_four (cost=0.000..324,482.790 rows=1,726,779 width=8) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Seq Scan on lima_hotel kilo_uniform (cost=0.000..10.180 rows=18 width=8) (never executed)

36. 0.000 0.000 ↓ 0.0 0

Seq Scan on victor_xray bravo_five (cost=0.000..10.180 rows=18 width=8) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Hash (cost=25,426.170..25,426.170 rows=492,254 width=18) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Seq Scan on whiskey_alpha alpha_two_four (cost=0.000..25,426.170 rows=492,254 width=18) (never executed)

  • Filter: (yankee_uniform7.xray_three = 'xray_zulu'::uuid)
39. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa whiskey_delta (cost=0.560..107,463.610 rows=15,016 width=66) (never executed)

  • Index Cond: (yankee_uniform5.xray_three = 'hotel_whiskey'::uuid)
40. 0.000 0.000 ↓ 0.0 0

Index Scan using bravo_alpha on quebec_november xray_oscar (cost=0.430..346,796.750 rows=2,096,414 width=2,003) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Index Scan using papa_alpha_romeo on charlie_mike hotel_hotel (cost=0.420..28,380.940 rows=566,343 width=246) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa five_india (cost=0.560..115,031.000 rows=26,028 width=66) (never executed)

  • Index Cond: (yankee_uniform6.xray_three = 'golf_yankee'::uuid)
43. 0.000 0.000 ↓ 0.0 0

Sort (cost=334,279.090..337,399.490 rows=1,248,161 width=66) (never executed)

  • Sort Key: yankee_uniform3.whiskey_foxtrot
44. 0.000 0.000 ↓ 0.0 0

Seq Scan on november_papa juliet (cost=0.000..177,908.880 rows=1,248,161 width=66) (never executed)

  • Filter: (yankee_uniform3.xray_three = 'xray_yankee'::uuid)
45. 0.000 0.000 ↓ 0.0 0

Sort (cost=337,092.900..340,266.360 rows=1,269,384 width=66) (never executed)

  • Sort Key: yankee_uniform4.whiskey_foxtrot
46. 0.000 0.000 ↓ 0.0 0

Seq Scan on november_papa foxtrot_kilo_oscar (cost=0.000..177,908.880 rows=1,269,384 width=66) (never executed)

  • Filter: (yankee_uniform4.xray_three = 'india_november_xray'::uuid)
47. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa yankee_india (cost=0.560..114,372.430 rows=25,027 width=66) (never executed)

  • Index Cond: (yankee_uniform8.xray_three = 'alpha_four'::uuid)
48. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa charlie_uniform (cost=0.560..105,565.870 rows=12,414 width=66) (never executed)

  • Index Cond: (yankee_uniform9.xray_three = 'uniform_lima'::uuid)
49. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa tango_uniform (cost=0.560..114,900.530 rows=25,828 width=66) (never executed)

  • Index Cond: (yankee_uniform10.xray_three = 'quebec_yankee'::uuid)
50. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa foxtrot_sierra (cost=0.560..96,783.330 rows=1,116 width=66) (never executed)

  • Index Cond: (yankee_uniform11.xray_three = 'yankee_quebec'::uuid)
51. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa golf_delta_november (cost=0.560..96,783.330 rows=1,116 width=66) (never executed)

  • Index Cond: (yankee_uniform12.xray_three = 'seven_whiskey'::uuid)
52. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa romeo_sierra (cost=0.560..96,783.330 rows=1,116 width=66) (never executed)

  • Index Cond: (yankee_uniform13.xray_three = 'tango_tango'::uuid)
53. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa sierra_romeo (cost=0.560..96,783.330 rows=1,116 width=66) (never executed)

  • Index Cond: (yankee_uniform14.xray_three = 'uniform_whiskey'::uuid)
54. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa five_mike (cost=0.560..96,783.330 rows=1,116 width=66) (never executed)

  • Index Cond: (yankee_uniform16.xray_three = 'november_oscar'::uuid)
55. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa five_golf (cost=0.560..96,783.330 rows=1,116 width=66) (never executed)

  • Index Cond: (yankee_uniform18.xray_three = 'november_tango'::uuid)
56. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa kilo_bravo (cost=0.560..96,783.330 rows=1,116 width=66) (never executed)

  • Index Cond: (yankee_uniform19.xray_three = 'india_november_mike'::uuid)
57. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa oscar_mike_bravo (cost=0.560..111,406.200 rows=20,622 width=66) (never executed)

  • Index Cond: (yankee_uniform20.xray_three = 'zulu_oscar'::uuid)
58. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa sierra_yankee (cost=0.560..96,783.330 rows=1,116 width=66) (never executed)

  • Index Cond: (yankee_uniform21.xray_three = 'three_tango'::uuid)
59. 0.000 0.000 ↓ 0.0 0

Sort (cost=367,903.990..371,655.580 rows=1,500,636 width=66) (never executed)

  • Sort Key: yankee_uniform15.whiskey_foxtrot
60. 0.000 0.000 ↓ 0.0 0

Seq Scan on november_papa yankee_victor (cost=0.000..177,908.880 rows=1,500,636 width=66) (never executed)

  • Filter: (yankee_uniform15.xray_three = 'lima_november'::uuid)
61. 0.000 0.000 ↓ 0.0 0

Hash (cost=117,843.380..117,843.380 rows=61,347 width=66) (never executed)

62. 0.000 0.000 ↓ 0.0 0

Seq Scan on november_papa xray_quebec (cost=0.000..117,843.380 rows=61,347 width=66) (never executed)

  • Filter: (yankee_uniform17.xray_three = 'victor_delta_lima'::uuid)
63. 1.005 678.526 ↓ 0.0 0 2

Hash (cost=181,816.160..181,816.160 rows=380 width=24) (actual time=678.526..678.526 rows=0 loops=2)

  • Buffers: shared hit=77989 dirtied=3
64. 4.020 677.521 ↓ 0.0 0 2

Nested Loop (cost=1.000..181,816.160 rows=380 width=24) (actual time=677.521..677.521 rows=0 loops=2)

  • Buffers: shared hit=77989 dirtied=3
65. 673.493 673.493 ↑ 1.0 500 2

Index Scan using zulu_victor on xray_juliet papa_four (cost=0.560..180,461.280 rows=513 width=16) (actual time=208.406..673.493 rows=500 loops=2)

  • Index Cond: (papa_four.delta_oscar = 276298)
  • Filter: (papa_four.delta_four = 204)
  • Buffers: shared hit=71977 dirtied=3
66. 0.008 0.008 ↓ 0.0 0 1,000

Index Scan using bravo_charlie on november_five four_charlie (cost=0.430..2.640 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=1,000)

  • Index Cond: (four_charlie.india_november_seven = papa_four.echo_sierra)
  • Filter: ((four_charlie.whiskey_whiskey = ANY ('oscar_uniform'::bigint[])) AND (four_charlie.victor_papa = 'quebec_golf'::uuid))
  • Buffers: shared hit=6012
67. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa papa_charlie (cost=0.560..1.020 rows=1 width=66) (never executed)

  • Index Cond: ((yankee_uniform0kilo_oscar2.whiskey_foxtrot = yankee_uniform22.whiskey_foxtrot) AND (yankee_uniform22.xray_three = 'alpha_two_kilo'::uuid))
68. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa papa_seven (cost=0.560..1.020 rows=1 width=66) (never executed)

  • Index Cond: ((yankee_uniform0kilo_oscar2.whiskey_foxtrot = yankee_uniform23.whiskey_foxtrot) AND (yankee_uniform23.xray_three = 'delta_hotel'::uuid))
69. 0.000 0.000 ↓ 0.0 0

Index Scan using yankee_xray on charlie_yankee two_mike (cost=0.560..1.330 rows=2 width=16) (never executed)

  • Index Cond: (yankee_uniform0kilo_oscar2.whiskey_foxtrot = yankee_uniform25.whiskey_foxtrot)
  • Filter: (yankee_uniform25.xray_three = 'tango_november'::uuid)
70. 0.000 0.000 ↓ 0.0 0

Index Scan using two_golf on november_papa zulu_five (cost=0.560..1.360 rows=3 width=66) (never executed)

  • Index Cond: ((yankee_uniform0kilo_oscar2.whiskey_foxtrot = yankee_uniform24.whiskey_foxtrot) AND (yankee_uniform24.xray_three = 'foxtrot_kilo_november'::uuid))
71. 0.000 0.000 ↓ 0.0 0

Append (cost=0.140..3.180 rows=5 width=69) (never executed)

72. 0.000 0.000 ↓ 0.0 0

Index Scan using whiskey_xray on alpha_five_yankee oscar_mike_foxtrot (cost=0.140..0.270 rows=1 width=524) (never executed)

  • Index Cond: (yankee_uniform25.bravo_oscar = yankee_uniform0kilo_oscar4.sierra_zulu)
73. 0.000 0.000 ↓ 0.0 0

Index Scan using whiskey_uniform on golf_oscar quebec_zulu (cost=0.140..0.270 rows=1 width=524) (never executed)

  • Index Cond: (yankee_uniform25.bravo_oscar = yankee_uniform0kilo_oscar5.sierra_zulu)
74. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_five_lima on uniform_india oscar_lima (cost=0.430..0.880 rows=1 width=68) (never executed)

  • Index Cond: (yankee_uniform25.bravo_oscar = yankee_uniform0kilo_oscar6.sierra_zulu)
75. 0.000 0.000 ↓ 0.0 0

Index Scan using november_six on india_zulu romeo_victor (cost=0.430..0.860 rows=1 width=79) (never executed)

  • Index Cond: (yankee_uniform25.bravo_oscar = yankee_uniform0kilo_oscar7.sierra_zulu)
76. 0.000 0.000 ↓ 0.0 0

Index Scan using three_kilo on victor_charlie five_five (cost=0.430..0.870 rows=1 width=61) (never executed)

  • Index Cond: (yankee_uniform25.bravo_oscar = yankee_uniform0kilo_oscar8.sierra_zulu)