explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KNOb : it-3358

Settings
# exclusive inclusive rows x rows loops node
1. 0.202 6,229.415 ↓ 1,002.0 1,002 1

Unique (cost=1,535.760..1,535.770 rows=1 width=128) (actual time=6,229.088..6,229.415 rows=1,002 loops=1)

2.          

CTE romeo_charlie

3. 1.690 6,223.172 ↓ 3,004.0 3,004 1

Merge Join (cost=1,508.080..1,527.510 rows=1 width=163) (actual time=5,343.936..6,223.172 rows=3,004 loops=1)

  • Merge Cond: (november_lima_two.bravo_tango = golf_juliet15.quebec_seven_victor)
4. 1.533 5,337.772 ↓ 751.0 3,004 1

Sort (cost=387.050..387.060 rows=4 width=100) (actual time=5,337.337..5,337.772 rows=3,004 loops=1)

  • Sort Key: november_lima_two.bravo_tango, november_lima_two.bravo_six, november_lima_two.golf_november DESC
  • Sort Method: quicksort Memory: 519kB
5.          

CTE yankee_foxtrot

6. 0.176 1.752 ↓ 1,002.0 1,002 1

Subquery Scan on zulu_four (cost=264.320..264.810 rows=1 width=12) (actual time=0.161..1.752 rows=1,002 loops=1)

  • Filter: (golf_juliet10.xray_two_six = 13)
  • Rows Removed by Filter: 2
7. 0.090 1.576 ↓ 91.3 1,004 1

Append (cost=264.320..264.680 rows=11 width=44) (actual time=0.160..1.576 rows=1,004 loops=1)

8.          

CTE oscar_kilo_quebec

9. 0.002 0.352 ↓ 2.0 2 1

Nested Loop (cost=189.230..218.890 rows=1 width=44) (actual time=0.157..0.352 rows=2 loops=1)

  • Join Filter: ((romeo_hotel11.quebec_seven_victor)::text = (golf_juliet8.kilo_sierra_hotel)::text)
10. 0.201 0.201 ↑ 1.0 1 1

Seq Scan on zulu_zulu_delta golf_zulu (cost=0.000..29.540 rows=1 width=7) (actual time=0.008..0.201 rows=1 loops=1)

  • Filter: ((five_echo)::text = 'zulu_hotel'::text)
  • Rows Removed by Filter: 1002
11. 0.002 0.149 ↑ 2.0 2 1

Unique (cost=189.230..189.260 rows=4 width=108) (actual time=0.147..0.149 rows=2 loops=1)

12.          

CTE quebec_seven_oscar

13. 0.011 0.020 ↑ 1.0 2 1

Bitmap Heap Scan on four_hotel seven_foxtrot (cost=4.160..9.500 rows=2 width=40) (actual time=0.019..0.020 rows=2 loops=1)

  • Recheck Cond: (mike_three @> LOCALTIMESTAMP)
  • Heap Blocks: exact=1
14. 0.009 0.009 ↓ 7.0 14 1

Bitmap Index Scan on november_alpha (cost=0.000..4.160 rows=2 width=0) (actual time=0.009..0.009 rows=14 loops=1)

  • Index Cond: (mike_three @> LOCALTIMESTAMP)
15.          

CTE delta_romeo

16. 0.001 0.088 ↑ 447.0 2 1

Append (cost=2.460..116.170 rows=894 width=108) (actual time=0.079..0.088 rows=2 loops=1)

17. 0.001 0.085 ↑ 7.0 2 1

Result (cost=2.460..45.950 rows=14 width=108) (actual time=0.078..0.085 rows=2 loops=1)

18. 0.001 0.084 ↑ 7.0 2 1

Append (cost=2.460..45.780 rows=14 width=104) (actual time=0.077..0.084 rows=2 loops=1)

19. 0.001 0.030 ↓ 0.0 0 1

Nested Loop (cost=2.460..25.060 rows=10 width=60) (actual time=0.030..0.030 rows=0 loops=1)

20. 0.003 0.029 ↓ 0.0 0 1

Nested Loop (cost=2.190..21.460 rows=10 width=36) (actual time=0.029..0.029 rows=0 loops=1)

21. 0.022 0.022 ↑ 1.0 2 1

CTE Scan on quebec_seven_oscar oscar_kilo_bravo (cost=0.000..0.040 rows=2 width=8) (actual time=0.021..0.022 rows=2 loops=1)

22. 0.002 0.004 ↓ 0.0 0 2

Bitmap Heap Scan on victor_six zulu_bravo (cost=2.190..10.660 rows=5 width=36) (actual time=0.002..0.002 rows=0 loops=2)

  • Recheck Cond: (mike_uniform = delta_juliet4.quebec_seven_victor)
23. 0.002 0.002 ↓ 0.0 0 2

Bitmap Index Scan on charlie_foxtrot (cost=0.000..2.190 rows=5 width=0) (actual time=0.001..0.001 rows=0 loops=2)

  • Index Cond: (mike_uniform = delta_juliet4.quebec_seven_victor)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using delta_lima on yankee_echo zulu_foxtrot_hotel (cost=0.280..0.360 rows=1 width=20) (never executed)

  • Index Cond: ((quebec_seven_victor)::text = (india_golf2.kilo_sierra_alpha)::text)
25. 0.006 0.053 ↑ 2.0 2 1

Nested Loop (cost=0.340..20.580 rows=4 width=60) (actual time=0.047..0.053 rows=2 loops=1)

26. 0.011 0.025 ↑ 2.0 2 1

Hash Join (cost=0.070..18.650 rows=4 width=36) (actual time=0.024..0.025 rows=2 loops=1)

  • Hash Cond: ((sierra_juliet2.echo_romeo)::text = (delta_juliet5.echo_romeo)::text)
27. 0.007 0.007 ↑ 360.0 1 1

Seq Scan on india_six whiskey_golf_juliet (cost=0.000..17.200 rows=360 width=64) (actual time=0.006..0.007 rows=1 loops=1)

  • Filter: "default
28. 0.006 0.007 ↑ 1.0 2 1

Hash (cost=0.040..0.040 rows=2 width=36) (actual time=0.007..0.007 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.001 0.001 ↑ 1.0 2 1

CTE Scan on quebec_seven_oscar two_charlie_juliet (cost=0.000..0.040 rows=2 width=36) (actual time=0.001..0.001 rows=2 loops=1)

30. 0.022 0.022 ↑ 1.0 1 2

Index Scan using delta_lima on yankee_echo xray_tango (cost=0.280..0.480 rows=1 width=20) (actual time=0.011..0.011 rows=1 loops=2)

  • Index Cond: ((quebec_seven_victor)::text = (sierra_juliet2.kilo_sierra_alpha)::text)
31. 0.001 0.002 ↓ 0.0 0 1

Hash Join (cost=31.520..61.420 rows=880 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: ((three_golf2.kilo_sierra_alpha)::text = (romeo_hotel10.quebec_seven_victor)::text)
32. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on papa_yankee_quebec five_bravo_hotel (cost=0.000..18.800 rows=880 width=40) (actual time=0.001..0.001 rows=0 loops=1)

33. 0.000 0.000 ↓ 0.0 0

Hash (cost=19.010..19.010 rows=1,001 width=20) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Seq Scan on yankee_echo romeo_yankee (cost=0.000..19.010 rows=1,001 width=20) (never executed)

35. 0.044 0.147 ↑ 2.0 2 1

Sort (cost=63.550..63.560 rows=4 width=108) (actual time=0.147..0.147 rows=2 loops=1)

  • Sort Key: romeo_hotel11.quebec_seven_victor, romeo_hotel11.xray_two_six, romeo_hotel11.sierra_three
  • Sort Method: quicksort Memory: 25kB
36. 0.011 0.103 ↑ 2.0 2 1

Hash Left Join (cost=32.000..63.510 rows=4 width=108) (actual time=0.092..0.103 rows=2 loops=1)

  • Hash Cond: (((romeo_hotel11.quebec_seven_victor)::text = (bravo_quebec2.kilo_sierra_alpha)::text) AND (romeo_hotel11.xray_two_six = bravo_quebec2.xray_two_six))
  • Filter: (bravo_quebec2.* five_romeo NULL)
37. 0.090 0.090 ↑ 447.0 2 1

CTE Scan on delta_romeo romeo_four (cost=0.000..17.880 rows=894 width=44) (actual time=0.080..0.090 rows=2 loops=1)

38. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=18.800..18.800 rows=880 width=128) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
39. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on foxtrot_mike_charlie echo_kilo (cost=0.000..18.800 rows=880 width=128) (actual time=0.002..0.002 rows=0 loops=1)

40.          

CTE three_juliet

41. 0.414 0.648 ↓ 100.2 1,002 1

Hash Join (cost=9.530..45.430 rows=10 width=40) (actual time=0.028..0.648 rows=1,002 loops=1)

  • Hash Cond: ((golf_juliet9.kilo_sierra_hotel)::text = (sierra_bravo7.xray_two_six)::text)
42. 0.219 0.219 ↑ 1.0 1,002 1

Seq Scan on zulu_zulu_delta lima_alpha (cost=0.000..29.540 rows=1,002 width=7) (actual time=0.003..0.219 rows=1,002 loops=1)

  • Filter: ((five_echo)::text = 'oscar_two'::text)
  • Rows Removed by Filter: 1
43. 0.007 0.015 ↑ 1.0 2 1

Hash (cost=9.500..9.500 rows=2 width=4) (actual time=0.015..0.015 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
44. 0.002 0.008 ↑ 1.0 2 1

Bitmap Heap Scan on four_hotel hotel_hotel_uniform (cost=4.160..9.500 rows=2 width=4) (actual time=0.008..0.008 rows=2 loops=1)

  • Recheck Cond: (mike_three @> LOCALTIMESTAMP)
  • Heap Blocks: exact=1
45. 0.006 0.006 ↓ 7.0 14 1

Bitmap Index Scan on november_alpha (cost=0.000..4.160 rows=2 width=0) (actual time=0.006..0.006 rows=14 loops=1)

  • Index Cond: (mike_three @> LOCALTIMESTAMP)
46. 0.355 0.355 ↓ 2.0 2 1

CTE Scan on oscar_kilo_quebec romeo_victor (cost=0.000..0.020 rows=1 width=44) (actual time=0.160..0.355 rows=2 loops=1)

47. 0.176 1.131 ↓ 100.2 1,002 1

Subquery Scan on juliet_hotel (cost=0.000..0.330 rows=10 width=44) (actual time=0.030..1.131 rows=1,002 loops=1)

48. 0.955 0.955 ↓ 100.2 1,002 1

CTE Scan on three_juliet seven_golf (cost=0.000..0.200 rows=10 width=40) (actual time=0.029..0.955 rows=1,002 loops=1)

49.          

CTE hotel_xray_november

50. 0.748 7.949 ↓ 1,002.0 1,002 1

Nested Loop Left Join (cost=4.430..17.850 rows=1 width=56) (actual time=0.189..7.949 rows=1,002 loops=1)

51. 1.154 6.199 ↓ 1,002.0 1,002 1

Nested Loop (cost=4.160..9.550 rows=1 width=20) (actual time=0.173..6.199 rows=1,002 loops=1)

  • Join Filter: (romeo_november1.xray_two_six = sierra_bravo8.xray_two_six)
  • Rows Removed by Join Filter: 1002
52. 2.039 2.039 ↓ 1,002.0 1,002 1

CTE Scan on yankee_foxtrot zulu_zulu_zulu (cost=0.000..0.020 rows=1 width=12) (actual time=0.162..2.039 rows=1,002 loops=1)

53. 1.002 3.006 ↑ 1.0 2 1,002

Bitmap Heap Scan on four_hotel quebec_xray_november (cost=4.160..9.500 rows=2 width=12) (actual time=0.002..0.003 rows=2 loops=1,002)

  • Recheck Cond: (mike_three @> LOCALTIMESTAMP)
  • Heap Blocks: exact=1002
54. 2.004 2.004 ↓ 7.0 14 1,002

Bitmap Index Scan on november_alpha (cost=0.000..4.160 rows=2 width=0) (actual time=0.002..0.002 rows=14 loops=1,002)

  • Index Cond: (mike_three @> LOCALTIMESTAMP)
55. 1.002 1.002 ↑ 1.0 1 1,002

Index Scan using yankee_sierra_charlie on bravo_sierra quebec_three (cost=0.280..8.290 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1,002)

  • Index Cond: (bravo_tango = romeo_november1.bravo_tango)
56. 0.309 5,336.239 ↓ 751.0 3,004 1

Subquery Scan on november_lima_two (cost=104.260..104.340 rows=4 width=100) (actual time=5,335.201..5,336.239 rows=3,004 loops=1)

57. 3.519 5,335.930 ↓ 751.0 3,004 1

HashAggregate (cost=104.260..104.300 rows=4 width=100) (actual time=5,335.199..5,335.930 rows=3,004 loops=1)

  • Group Key: golf_juliet18.xray_two_six, golf_juliet18.bravo_tango, golf_juliet18.bravo_six, golf_juliet18.xray_two_six, ('juliet_bravo'::character varying), golf_juliet18.charlie_seven, golf_juliet18.tango_juliet_alpha, (0)
58. 0.364 5,332.411 ↓ 751.0 3,004 1

Append (cost=0.000..104.180 rows=4 width=100) (actual time=0.191..5,332.411 rows=3,004 loops=1)

59. 8.440 8.440 ↓ 1,002.0 1,002 1

CTE Scan on hotel_xray_november kilo_five (cost=0.000..0.020 rows=1 width=100) (actual time=0.191..8.440 rows=1,002 loops=1)

  • Filter: (xray_two_six = 13)
60. 0.465 5,323.607 ↓ 667.3 2,002 1

Subquery Scan on zulu_foxtrot_india (cost=23.360..104.150 rows=3 width=80) (actual time=0.060..5,323.607 rows=2,002 loops=1)

61. 330.678 5,323.142 ↓ 667.3 2,002 1

Nested Loop Left Join (cost=23.360..104.120 rows=3 width=64) (actual time=0.059..5,323.142 rows=2,002 loops=1)

  • Join Filter: (five_sierra.november_echo = golf_juliet19.bravo_six)
  • Rows Removed by Join Filter: 1001000
  • Filter: (((alpha_three.* five_romeo NOT NULL) OR (five_sierra.* five_romeo NOT NULL) OR ((six_mike.november_lima_uniform)::text = 'juliet_bravo'::text)) AND (yankee_six((((five_sierra.* five_romeo NOT NULL))::integer * 3), (((alpha_three.* five_romeo NOT NULL))::integer * 2), 1) < 3))
  • Rows Removed by Filter: 2003000
62. 138.120 2,987.462 ↓ 200,500.2 2,005,002 1

Nested Loop Left Join (cost=23.090..100.520 rows=10 width=112) (actual time=0.031..2,987.462 rows=2,005,002 loops=1)

  • Join Filter: (alpha_three.bravo_tango = golf_juliet19.bravo_tango)
  • Rows Removed by Join Filter: 1001000
63. 230.675 844.340 ↓ 200,500.2 2,005,002 1

Nested Loop (cost=22.810..97.190 rows=10 width=60) (actual time=0.024..844.340 rows=2,005,002 loops=1)

64. 0.441 0.441 ↓ 1,002.0 1,002 1

CTE Scan on hotel_xray_november xray_delta (cost=0.000..0.020 rows=1 width=24) (actual time=0.001..0.441 rows=1,002 loops=1)

  • Filter: (xray_two_six = 13)
65. 396.782 613.224 ↓ 200.1 2,001 1,002

Hash Join (cost=22.810..97.070 rows=10 width=40) (actual time=0.002..0.612 rows=2,001 loops=1,002)

  • Hash Cond: (six_mike.delta_victor = victor_romeo.quebec_seven_victor)
66. 216.432 216.432 ↑ 1.0 2,001 1,002

Seq Scan on foxtrot_yankee six_mike (cost=0.000..49.010 rows=2,001 width=44) (actual time=0.002..0.216 rows=2,001 loops=1,002)

  • Filter: (xray_two_six = 13)
67. 0.004 0.010 ↑ 5.0 1 1

Hash (cost=22.750..22.750 rows=5 width=4) (actual time=0.010..0.010 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
68. 0.006 0.006 ↑ 5.0 1 1

Seq Scan on four_two victor_romeo (cost=0.000..22.750 rows=5 width=4) (actual time=0.006..0.006 rows=1 loops=1)

  • Filter: ((november_lima_uniform)::text = 'foxtrot_uniform'::text)
69. 2,005.002 2,005.002 ↓ 0.0 0 2,005,002

Index Scan using alpha_golf on tango_charlie alpha_three (cost=0.280..0.320 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=2,005,002)

  • Index Cond: (two_sierra = six_mike.quebec_seven_victor)
70. 2,005.002 2,005.002 ↓ 0.0 0 2,005,002

Index Scan using kilo_charlie on juliet_seven five_sierra (cost=0.280..0.320 rows=1 width=80) (actual time=0.001..0.001 rows=0 loops=2,005,002)

  • Index Cond: (two_sierra = six_mike.quebec_seven_victor)
71. 0.479 883.710 ↓ 3,002.0 3,002 1

Materialize (cost=1,121.030..1,140.380 rows=1 width=215) (actual time=6.593..883.710 rows=3,002 loops=1)

72. 69.994 883.231 ↓ 1,002.0 1,002 1

Nested Loop (cost=1,121.030..1,140.380 rows=1 width=215) (actual time=6.592..883.231 rows=1,002 loops=1)

  • Join Filter: (golf_juliet15.quebec_seven_victor = romeo_three.bravo_tango)
  • Rows Removed by Join Filter: 1003002
73. 59.485 675.963 ↓ 1,002.0 1,002 1

Nested Loop (cost=836.540..855.850 rows=1 width=207) (actual time=2.983..675.963 rows=1,002 loops=1)

  • Join Filter: (golf_juliet15.quebec_seven_victor = golf_juliet17.quebec_seven_victor)
  • Rows Removed by Join Filter: 1003002
74. 1.115 342.932 ↓ 1,002.0 1,002 1

Nested Loop Left Join (cost=572.220..591.030 rows=1 width=207) (actual time=2.925..342.932 rows=1,002 loops=1)

  • Join Filter: ((uniform_three.india_juliet_quebec)::text = (sierra_bravo13.xray_two_six)::text)
75. 1.054 340.815 ↓ 1,002.0 1,002 1

Nested Loop (cost=572.220..589.900 rows=1 width=131) (actual time=2.890..340.815 rows=1,002 loops=1)

  • Join Filter: ((sierra_bravo13.echo_romeo)::text = (whiskey_quebec.india_juliet_quebec)::text)
76. 1.012 338.759 ↓ 1,002.0 1,002 1

Nested Loop (cost=572.220..588.800 rows=1 width=159) (actual time=2.881..338.759 rows=1,002 loops=1)

77. 0.655 336.745 ↓ 1,002.0 1,002 1

Nested Loop (cost=572.080..580.630 rows=1 width=123) (actual time=2.862..336.745 rows=1,002 loops=1)

  • Join Filter: (golf_juliet16.quebec_seven_victor = golf_juliet15.quebec_seven_victor)
78. 57.486 335.088 ↓ 1,002.0 1,002 1

Nested Loop (cost=571.800..572.320 rows=1 width=60) (actual time=2.849..335.088 rows=1,002 loops=1)

  • Join Filter: (golf_juliet16.quebec_seven_victor = golf_juliet20.bravo_tango)
  • Rows Removed by Join Filter: 1003002
79. 0.174 3.054 ↓ 1,002.0 1,002 1

Unique (cost=307.480..307.490 rows=1 width=60) (actual time=2.774..3.054 rows=1,002 loops=1)

80.          

CTE yankee_foxtrot

81. 0.104 1.063 ↓ 1,002.0 1,002 1

Subquery Scan on four_yankee (cost=264.320..264.810 rows=1 width=12) (actual time=0.091..1.063 rows=1,002 loops=1)

  • Filter: (golf_juliet3.xray_two_six = 13)
  • Rows Removed by Filter: 2
82. 0.051 0.959 ↓ 91.3 1,004 1

Append (cost=264.320..264.680 rows=11 width=44) (actual time=0.090..0.959 rows=1,004 loops=1)

83.          

CTE oscar_kilo_quebec

84. 0.003 0.190 ↓ 2.0 2 1

Nested Loop (cost=189.230..218.890 rows=1 width=44) (actual time=0.089..0.190 rows=2 loops=1)

  • Join Filter: ((romeo_hotel3.quebec_seven_victor)::text = (golf_juliet1.kilo_sierra_hotel)::text)
85. 0.105 0.105 ↑ 1.0 1 1

Seq Scan on zulu_zulu_delta zulu_zulu_mike (cost=0.000..29.540 rows=1 width=7) (actual time=0.005..0.105 rows=1 loops=1)

  • Filter: ((five_echo)::text = 'zulu_hotel'::text)
  • Rows Removed by Filter: 1002
86. 0.000 0.082 ↑ 2.0 2 1

Unique (cost=189.230..189.260 rows=4 width=108) (actual time=0.082..0.082 rows=2 loops=1)

87.          

CTE quebec_seven_oscar

88. 0.004 0.012 ↑ 1.0 2 1

Bitmap Heap Scan on four_hotel (cost=4.160..9.500 rows=2 width=40) (actual time=0.011..0.012 rows=2 loops=1)

  • Recheck Cond: (mike_three @> LOCALTIMESTAMP)
  • Heap Blocks: exact=1
89. 0.008 0.008 ↓ 7.0 14 1

Bitmap Index Scan on november_alpha (cost=0.000..4.160 rows=2 width=0) (actual time=0.008..0.008 rows=14 loops=1)

  • Index Cond: (mike_three @> LOCALTIMESTAMP)
90.          

CTE delta_romeo

91. 0.001 0.062 ↑ 447.0 2 1

Append (cost=2.460..116.170 rows=894 width=108) (actual time=0.056..0.062 rows=2 loops=1)

92. 0.001 0.060 ↑ 7.0 2 1

Result (cost=2.460..45.950 rows=14 width=108) (actual time=0.056..0.060 rows=2 loops=1)

93. 0.001 0.059 ↑ 7.0 2 1

Append (cost=2.460..45.780 rows=14 width=104) (actual time=0.055..0.059 rows=2 loops=1)

94. 0.000 0.021 ↓ 0.0 0 1

Nested Loop (cost=2.460..25.060 rows=10 width=60) (actual time=0.021..0.021 rows=0 loops=1)

95. 0.004 0.021 ↓ 0.0 0 1

Nested Loop (cost=2.190..21.460 rows=10 width=36) (actual time=0.021..0.021 rows=0 loops=1)

96. 0.013 0.013 ↑ 1.0 2 1

CTE Scan on quebec_seven_oscar (cost=0.000..0.040 rows=2 width=8) (actual time=0.012..0.013 rows=2 loops=1)

97. 0.002 0.004 ↓ 0.0 0 2

Bitmap Heap Scan on victor_six zulu_papa (cost=2.190..10.660 rows=5 width=36) (actual time=0.002..0.002 rows=0 loops=2)

  • Recheck Cond: (mike_uniform = quebec_seven_oscar.quebec_seven_victor)
98. 0.002 0.002 ↓ 0.0 0 2

Bitmap Index Scan on charlie_foxtrot (cost=0.000..2.190 rows=5 width=0) (actual time=0.001..0.001 rows=0 loops=2)

  • Index Cond: (mike_uniform = quebec_seven_oscar.quebec_seven_victor)
99. 0.000 0.000 ↓ 0.0 0

Index Scan using delta_lima on yankee_echo delta_romeo (cost=0.280..0.360 rows=1 width=20) (never executed)

  • Index Cond: ((quebec_seven_victor)::text = (zulu_papa.kilo_sierra_alpha)::text)
100. 0.004 0.037 ↑ 2.0 2 1

Nested Loop (cost=0.340..20.580 rows=4 width=60) (actual time=0.033..0.037 rows=2 loops=1)

101. 0.006 0.023 ↑ 2.0 2 1

Hash Join (cost=0.070..18.650 rows=4 width=36) (actual time=0.022..0.023 rows=2 loops=1)

  • Hash Cond: ((six_zulu.echo_romeo)::text = (delta_juliet1.echo_romeo)::text)
102. 0.012 0.012 ↑ 360.0 1 1

Seq Scan on india_six six_zulu (cost=0.000..17.200 rows=360 width=64) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: "default
103. 0.004 0.005 ↑ 1.0 2 1

Hash (cost=0.040..0.040 rows=2 width=36) (actual time=0.005..0.005 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
104. 0.001 0.001 ↑ 1.0 2 1

CTE Scan on quebec_seven_oscar six_seven (cost=0.000..0.040 rows=2 width=36) (actual time=0.001..0.001 rows=2 loops=1)

105. 0.010 0.010 ↑ 1.0 1 2

Index Scan using delta_lima on yankee_echo delta_foxtrot (cost=0.280..0.480 rows=1 width=20) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: ((quebec_seven_victor)::text = (six_zulu.kilo_sierra_alpha)::text)
106. 0.000 0.001 ↓ 0.0 0 1

Hash Join (cost=31.520..61.420 rows=880 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Hash Cond: ((zulu_xray.kilo_sierra_alpha)::text = (romeo_hotel2.quebec_seven_victor)::text)
107. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on papa_yankee_quebec zulu_xray (cost=0.000..18.800 rows=880 width=40) (actual time=0.001..0.001 rows=0 loops=1)

108. 0.000 0.000 ↓ 0.0 0

Hash (cost=19.010..19.010 rows=1,001 width=20) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Seq Scan on yankee_echo mike_mike (cost=0.000..19.010 rows=1,001 width=20) (never executed)

110. 0.008 0.082 ↑ 2.0 2 1

Sort (cost=63.550..63.560 rows=4 width=108) (actual time=0.081..0.082 rows=2 loops=1)

  • Sort Key: romeo_hotel3.quebec_seven_victor, romeo_hotel3.xray_two_six, romeo_hotel3.sierra_three
  • Sort Method: quicksort Memory: 25kB
111. 0.008 0.074 ↑ 2.0 2 1

Hash Left Join (cost=32.000..63.510 rows=4 width=108) (actual time=0.067..0.074 rows=2 loops=1)

  • Hash Cond: (((romeo_hotel3.quebec_seven_victor)::text = (november_india.kilo_sierra_alpha)::text) AND (romeo_hotel3.xray_two_six = november_india.xray_two_six))
  • Filter: (november_india.* five_romeo NULL)
112. 0.064 0.064 ↑ 447.0 2 1

CTE Scan on delta_romeo tango_november (cost=0.000..17.880 rows=894 width=44) (actual time=0.057..0.064 rows=2 loops=1)

113. 0.001 0.002 ↓ 0.0 0 1

Hash (cost=18.800..18.800 rows=880 width=128) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
114. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on foxtrot_mike_charlie november_india (cost=0.000..18.800 rows=880 width=128) (actual time=0.001..0.001 rows=0 loops=1)

115.          

CTE three_juliet

116. 0.277 0.422 ↓ 100.2 1,002 1

Hash Join (cost=9.530..45.430 rows=10 width=40) (actual time=0.045..0.422 rows=1,002 loops=1)

  • Hash Cond: ((golf_juliet2.kilo_sierra_hotel)::text = (sierra_bravo1.xray_two_six)::text)
117. 0.131 0.131 ↑ 1.0 1,002 1

Seq Scan on zulu_zulu_delta romeo_two (cost=0.000..29.540 rows=1,002 width=7) (actual time=0.003..0.131 rows=1,002 loops=1)

  • Filter: ((five_echo)::text = 'oscar_two'::text)
  • Rows Removed by Filter: 1
118. 0.004 0.014 ↑ 1.0 2 1

Hash (cost=9.500..9.500 rows=2 width=4) (actual time=0.014..0.014 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
119. 0.003 0.010 ↑ 1.0 2 1

Bitmap Heap Scan on four_hotel yankee_sierra_seven (cost=4.160..9.500 rows=2 width=4) (actual time=0.009..0.010 rows=2 loops=1)

  • Recheck Cond: (mike_three @> LOCALTIMESTAMP)
  • Heap Blocks: exact=1
120. 0.007 0.007 ↓ 7.0 14 1

Bitmap Index Scan on november_alpha (cost=0.000..4.160 rows=2 width=0) (actual time=0.007..0.007 rows=14 loops=1)

  • Index Cond: (mike_three @> LOCALTIMESTAMP)
121. 0.192 0.192 ↓ 2.0 2 1

CTE Scan on oscar_kilo_quebec (cost=0.000..0.020 rows=1 width=44) (actual time=0.089..0.192 rows=2 loops=1)

122. 0.110 0.716 ↓ 100.2 1,002 1

Subquery Scan on echo_uniform (cost=0.000..0.330 rows=10 width=44) (actual time=0.047..0.716 rows=1,002 loops=1)

123. 0.606 0.606 ↓ 100.2 1,002 1

CTE Scan on three_juliet (cost=0.000..0.200 rows=10 width=40) (actual time=0.047..0.606 rows=1,002 loops=1)

124.          

CTE zulu_india

125. 0.001 0.054 ↑ 4.0 1 1

Unique (cost=28.060..28.090 rows=4 width=57) (actual time=0.054..0.054 rows=1 loops=1)

126.          

CTE papa_four

127. 0.019 0.019 ↑ 1.0 1 1

Index Scan using november_alpha on four_hotel delta_six (cost=0.140..8.160 rows=1 width=57) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: ((xray_two_six = 13) AND (mike_three @> LOCALTIMESTAMP))
128.          

CTE tango_six

129. 0.002 0.020 ↓ 0.0 0 1

Nested Loop (cost=4.320..19.540 rows=3 width=57) (actual time=0.020..0.020 rows=0 loops=1)

130. 0.016 0.016 ↑ 1.0 1 1

Index Scan using november_alpha on four_hotel lima_sierra (cost=0.140..8.160 rows=1 width=12) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: ((xray_two_six = 13) AND (mike_three @> LOCALTIMESTAMP))
131. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on foxtrot_xray five_hotel (cost=4.170..11.280 rows=3 width=80) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (xray_two_six = 13)
132. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on charlie_oscar (cost=0.000..4.170 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (xray_two_six = 13)
133. 0.008 0.053 ↑ 4.0 1 1

Sort (cost=0.360..0.370 rows=4 width=57) (actual time=0.053..0.053 rows=1 loops=1)

  • Sort Key: sierra_whiskey.xray_two_six, sierra_whiskey.november_lima_uniform, sierra_whiskey.golf_november DESC
  • Sort Method: quicksort Memory: 25kB
134. 0.001 0.045 ↑ 4.0 1 1

Subquery Scan on sierra_whiskey (cost=0.190..0.320 rows=4 width=57) (actual time=0.045..0.045 rows=1 loops=1)

135. 0.003 0.044 ↑ 4.0 1 1

HashAggregate (cost=0.190..0.230 rows=4 width=57) (actual time=0.044..0.044 rows=1 loops=1)

  • Group Key: papa_four.xray_two_six, papa_four.tango_lima, papa_four.seven_hotel, papa_four.november_lima_uniform, papa_four.alpha_papa, papa_four.seven_zulu, papa_four.golf_november
136. 0.001 0.041 ↑ 4.0 1 1

Append (cost=0.000..0.120 rows=4 width=57) (actual time=0.019..0.041 rows=1 loops=1)

137. 0.019 0.019 ↑ 1.0 1 1

CTE Scan on papa_four (cost=0.000..0.020 rows=1 width=57) (actual time=0.019..0.019 rows=1 loops=1)

138. 0.021 0.021 ↓ 0.0 0 1

CTE Scan on tango_six (cost=0.000..0.060 rows=3 width=57) (actual time=0.021..0.021 rows=0 loops=1)

139. 0.261 2.880 ↓ 1,002.0 1,002 1

Sort (cost=14.570..14.580 rows=1 width=60) (actual time=2.774..2.880 rows=1,002 loops=1)

  • Sort Key: golf_juliet20.bravo_tango, (((lima_mike.* five_romeo NOT NULL))::integer) DESC
  • Sort Method: quicksort Memory: 103kB
140. 0.881 2.619 ↓ 1,002.0 1,002 1

Nested Loop Left Join (cost=4.210..14.560 rows=1 width=60) (actual time=0.151..2.619 rows=1,002 loops=1)

  • Join Filter: (lima_mike.bravo_tango = golf_juliet20.bravo_tango)
  • Filter: ((lima_mike.* five_romeo NOT NULL) OR whiskey_golf_echo1.seven_zulu)
141. 0.475 1.738 ↓ 1,002.0 1,002 1

Nested Loop (cost=0.000..0.120 rows=1 width=61) (actual time=0.147..1.738 rows=1,002 loops=1)

142. 1.263 1.263 ↓ 1,002.0 1,002 1

CTE Scan on yankee_foxtrot echo_foxtrot_five (cost=0.000..0.020 rows=1 width=12) (actual time=0.091..1.263 rows=1,002 loops=1)

  • Filter: (xray_two_six = 13)
143. 0.000 0.000 ↑ 1.0 1 1,002

CTE Scan on zulu_india yankee_seven_golf (cost=0.000..0.090 rows=1 width=53) (actual time=0.000..0.000 rows=1 loops=1,002)

  • Filter: (xray_two_six = 13)
144. 0.000 0.000 ↓ 0.0 0 1,002

Bitmap Heap Scan on golf_four_mike lima_mike (cost=4.210..14.350 rows=7 width=60) (actual time=0.000..0.000 rows=0 loops=1,002)

  • Recheck Cond: (papa_six = whiskey_golf_echo1.tango_lima)
145. 0.000 0.000 ↓ 0.0 0 1,002

Bitmap Index Scan on november_three (cost=0.000..4.210 rows=7 width=0) (actual time=0.000..0.000 rows=0 loops=1,002)

  • Index Cond: (papa_six = whiskey_golf_echo1.tango_lima)
146. 70.140 274.548 ↓ 1,002.0 1,002 1,002

Subquery Scan on bravo_lima (cost=264.320..264.810 rows=1 width=12) (actual time=0.000..0.274 rows=1,002 loops=1,002)

  • Filter: (golf_juliet16.xray_two_six = 13)
  • Rows Removed by Filter: 2
147. 46.092 204.408 ↓ 91.3 1,004 1,002

Append (cost=264.320..264.680 rows=11 width=44) (actual time=0.000..0.204 rows=1,004 loops=1,002)

148.          

CTE oscar_kilo_quebec

149. 0.002 0.159 ↓ 2.0 2 1

Nested Loop (cost=189.230..218.890 rows=1 width=44) (actual time=0.073..0.159 rows=2 loops=1)

  • Join Filter: ((romeo_hotel15.quebec_seven_victor)::text = (golf_juliet11.kilo_sierra_hotel)::text)
150. 0.087 0.087 ↑ 1.0 1 1

Seq Scan on zulu_zulu_delta three_alpha (cost=0.000..29.540 rows=1 width=7) (actual time=0.002..0.087 rows=1 loops=1)

  • Filter: ((five_echo)::text = 'zulu_hotel'::text)
  • Rows Removed by Filter: 1002
151. 0.001 0.070 ↑ 2.0 2 1

Unique (cost=189.230..189.260 rows=4 width=108) (actual time=0.069..0.070 rows=2 loops=1)

152.          

CTE quebec_seven_oscar

153. 0.004 0.010 ↑ 1.0 2 1

Bitmap Heap Scan on four_hotel seven_kilo (cost=4.160..9.500 rows=2 width=40) (actual time=0.010..0.010 rows=2 loops=1)

  • Recheck Cond: (mike_three @> LOCALTIMESTAMP)
  • Heap Blocks: exact=1
154. 0.006 0.006 ↓ 7.0 14 1

Bitmap Index Scan on november_alpha (cost=0.000..4.160 rows=2 width=0) (actual time=0.006..0.006 rows=14 loops=1)

  • Index Cond: (mike_three @> LOCALTIMESTAMP)
155.          

CTE delta_romeo

156. 0.000 0.049 ↑ 447.0 2 1

Append (cost=2.460..116.170 rows=894 width=108) (actual time=0.044..0.049 rows=2 loops=1)

157. 0.001 0.048 ↑ 7.0 2 1

Result (cost=2.460..45.950 rows=14 width=108) (actual time=0.044..0.048 rows=2 loops=1)

158. 0.000 0.047 ↑ 7.0 2 1

Append (cost=2.460..45.780 rows=14 width=104) (actual time=0.043..0.047 rows=2 loops=1)

159. 0.001 0.018 ↓ 0.0 0 1

Nested Loop (cost=2.460..25.060 rows=10 width=60) (actual time=0.018..0.018 rows=0 loops=1)

160. 0.003 0.017 ↓ 0.0 0 1

Nested Loop (cost=2.190..21.460 rows=10 width=36) (actual time=0.017..0.017 rows=0 loops=1)

161. 0.012 0.012 ↑ 1.0 2 1

CTE Scan on quebec_seven_oscar echo_quebec (cost=0.000..0.040 rows=2 width=8) (actual time=0.011..0.012 rows=2 loops=1)

162. 0.000 0.002 ↓ 0.0 0 2

Bitmap Heap Scan on victor_six two_bravo (cost=2.190..10.660 rows=5 width=36) (actual time=0.001..0.001 rows=0 loops=2)

  • Recheck Cond: (mike_uniform = delta_juliet6.quebec_seven_victor)
163. 0.002 0.002 ↓ 0.0 0 2

Bitmap Index Scan on charlie_foxtrot (cost=0.000..2.190 rows=5 width=0) (actual time=0.001..0.001 rows=0 loops=2)

  • Index Cond: (mike_uniform = delta_juliet6.quebec_seven_victor)
164. 0.000 0.000 ↓ 0.0 0

Index Scan using delta_lima on yankee_echo hotel_xray_charlie (cost=0.280..0.360 rows=1 width=20) (never executed)

  • Index Cond: ((quebec_seven_victor)::text = (india_golf3.kilo_sierra_alpha)::text)
165. 0.004 0.029 ↑ 2.0 2 1

Nested Loop (cost=0.340..20.580 rows=4 width=60) (actual time=0.025..0.029 rows=2 loops=1)

166. 0.009 0.015 ↑ 2.0 2 1

Hash Join (cost=0.070..18.650 rows=4 width=36) (actual time=0.014..0.015 rows=2 loops=1)

  • Hash Cond: ((sierra_juliet3.echo_romeo)::text = (delta_juliet7.echo_romeo)::text)
167. 0.002 0.002 ↑ 360.0 1 1

Seq Scan on india_six quebec_hotel (cost=0.000..17.200 rows=360 width=64) (actual time=0.002..0.002 rows=1 loops=1)

  • Filter: "default
168. 0.002 0.004 ↑ 1.0 2 1

Hash (cost=0.040..0.040 rows=2 width=36) (actual time=0.004..0.004 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
169. 0.002 0.002 ↑ 1.0 2 1

CTE Scan on quebec_seven_oscar uniform_oscar (cost=0.000..0.040 rows=2 width=36) (actual time=0.000..0.002 rows=2 loops=1)

170. 0.010 0.010 ↑ 1.0 1 2

Index Scan using delta_lima on yankee_echo two_echo (cost=0.280..0.480 rows=1 width=20) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: ((quebec_seven_victor)::text = (sierra_juliet3.kilo_sierra_alpha)::text)
171. 0.000 0.001 ↓ 0.0 0 1

Hash Join (cost=31.520..61.420 rows=880 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Hash Cond: ((three_golf3.kilo_sierra_alpha)::text = (romeo_hotel14.quebec_seven_victor)::text)
172. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on papa_yankee_quebec mike_six (cost=0.000..18.800 rows=880 width=40) (actual time=0.001..0.001 rows=0 loops=1)

173. 0.000 0.000 ↓ 0.0 0

Hash (cost=19.010..19.010 rows=1,001 width=20) (never executed)

174. 0.000 0.000 ↓ 0.0 0

Seq Scan on yankee_echo hotel_sierra (cost=0.000..19.010 rows=1,001 width=20) (never executed)

175. 0.009 0.069 ↑ 2.0 2 1

Sort (cost=63.550..63.560 rows=4 width=108) (actual time=0.069..0.069 rows=2 loops=1)

  • Sort Key: romeo_hotel15.quebec_seven_victor, romeo_hotel15.xray_two_six, romeo_hotel15.sierra_three
  • Sort Method: quicksort Memory: 25kB
176. 0.008 0.060 ↑ 2.0 2 1

Hash Left Join (cost=32.000..63.510 rows=4 width=108) (actual time=0.054..0.060 rows=2 loops=1)

  • Hash Cond: (((romeo_hotel15.quebec_seven_victor)::text = (bravo_quebec3.kilo_sierra_alpha)::text) AND (romeo_hotel15.xray_two_six = bravo_quebec3.xray_two_six))
  • Filter: (bravo_quebec3.* five_romeo NULL)
177. 0.051 0.051 ↑ 447.0 2 1

CTE Scan on delta_romeo foxtrot_mike_yankee (cost=0.000..17.880 rows=894 width=44) (actual time=0.045..0.051 rows=2 loops=1)

178. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=18.800..18.800 rows=880 width=128) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
179. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on foxtrot_mike_charlie mike_juliet (cost=0.000..18.800 rows=880 width=128) (actual time=0.001..0.001 rows=0 loops=1)

180.          

CTE three_juliet

181. 0.219 0.345 ↓ 100.2 1,002 1

Hash Join (cost=9.530..45.430 rows=10 width=40) (actual time=0.020..0.345 rows=1,002 loops=1)

  • Hash Cond: ((golf_juliet12.kilo_sierra_hotel)::text = (sierra_bravo10.xray_two_six)::text)
182. 0.116 0.116 ↑ 1.0 1,002 1

Seq Scan on zulu_zulu_delta hotel_quebec (cost=0.000..29.540 rows=1,002 width=7) (actual time=0.002..0.116 rows=1,002 loops=1)

  • Filter: ((five_echo)::text = 'oscar_two'::text)
  • Rows Removed by Filter: 1
183. 0.003 0.010 ↑ 1.0 2 1

Hash (cost=9.500..9.500 rows=2 width=4) (actual time=0.010..0.010 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
184. 0.003 0.007 ↑ 1.0 2 1

Bitmap Heap Scan on four_hotel five_bravo_zulu (cost=4.160..9.500 rows=2 width=4) (actual time=0.006..0.007 rows=2 loops=1)

  • Recheck Cond: (mike_three @> LOCALTIMESTAMP)
  • Heap Blocks: exact=1
185. 0.004 0.004 ↓ 7.0 14 1

Bitmap Index Scan on november_alpha (cost=0.000..4.160 rows=2 width=0) (actual time=0.004..0.004 rows=14 loops=1)

  • Index Cond: (mike_three @> LOCALTIMESTAMP)
186. 0.000 0.000 ↓ 2.0 2 1,002

CTE Scan on oscar_kilo_quebec seven_romeo (cost=0.000..0.020 rows=1 width=44) (actual time=0.000..0.000 rows=2 loops=1,002)

187. 97.194 158.316 ↓ 100.2 1,002 1,002

Subquery Scan on tango_delta (cost=0.000..0.330 rows=10 width=44) (actual time=0.000..0.158 rows=1,002 loops=1,002)

188. 61.122 61.122 ↓ 100.2 1,002 1,002

CTE Scan on three_juliet victor_india (cost=0.000..0.200 rows=10 width=40) (actual time=0.000..0.061 rows=1,002 loops=1,002)

189. 1.002 1.002 ↑ 1.0 1 1,002

Index Scan using mike_foxtrot on zulu_zulu_delta kilo_juliet (cost=0.280..8.290 rows=1 width=63) (actual time=0.001..0.001 rows=1 loops=1,002)

  • Index Cond: (quebec_seven_victor = golf_juliet20.bravo_tango)
190. 1.002 1.002 ↑ 1.0 1 1,002

Index Scan using november_alpha on four_hotel whiskey_hotel (cost=0.140..8.160 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=1,002)

  • Index Cond: ((xray_two_six = 13) AND (mike_three @> LOCALTIMESTAMP))
191. 1.002 1.002 ↑ 1.0 1 1,002

Seq Scan on india_juliet_five whiskey_quebec (cost=0.000..1.090 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1,002)

  • Filter: (((delta_xray)::text = 'quebec_papa'::text) AND (five_juliet = 'hotel_xray_four'::five_juliet))
  • Rows Removed by Filter: 1
192. 1.002 1.002 ↑ 2.0 1 1,002

Seq Scan on india_juliet_five uniform_three (cost=0.000..1.090 rows=2 width=80) (actual time=0.001..0.001 rows=1 loops=1,002)

  • Filter: (((delta_xray)::text = 'oscar_two'::text) AND (five_juliet = 'hotel_xray_four'::five_juliet))
  • Rows Removed by Filter: 3
193. 69.138 273.546 ↓ 1,002.0 1,002 1,002

Subquery Scan on delta_charlie (cost=264.320..264.810 rows=1 width=12) (actual time=0.000..0.273 rows=1,002 loops=1,002)

  • Filter: (golf_juliet17.xray_two_six = 13)
  • Rows Removed by Filter: 2
194. 45.090 204.408 ↓ 91.3 1,004 1,002

Append (cost=264.320..264.680 rows=11 width=44) (actual time=0.000..0.204 rows=1,004 loops=1,002)

195.          

CTE oscar_kilo_quebec

196. 0.007 0.146 ↓ 2.0 2 1

Nested Loop (cost=189.230..218.890 rows=1 width=44) (actual time=0.055..0.146 rows=2 loops=1)

  • Join Filter: ((romeo_hotel19.quebec_seven_victor)::text = (golf_juliet13.kilo_sierra_hotel)::text)
197. 0.086 0.086 ↑ 1.0 1 1

Seq Scan on zulu_zulu_delta juliet_papa (cost=0.000..29.540 rows=1 width=7) (actual time=0.002..0.086 rows=1 loops=1)

  • Filter: ((five_echo)::text = 'zulu_hotel'::text)
  • Rows Removed by Filter: 1002
198. 0.001 0.053 ↑ 2.0 2 1

Unique (cost=189.230..189.260 rows=4 width=108) (actual time=0.052..0.053 rows=2 loops=1)

199.          

CTE quebec_seven_oscar

200. 0.002 0.006 ↑ 1.0 2 1

Bitmap Heap Scan on four_hotel golf_quebec (cost=4.160..9.500 rows=2 width=40) (actual time=0.006..0.006 rows=2 loops=1)

  • Recheck Cond: (mike_three @> LOCALTIMESTAMP)
  • Heap Blocks: exact=1
201. 0.004 0.004 ↓ 7.0 14 1

Bitmap Index Scan on november_alpha (cost=0.000..4.160 rows=2 width=0) (actual time=0.004..0.004 rows=14 loops=1)

  • Index Cond: (mike_three @> LOCALTIMESTAMP)
202.          

CTE delta_romeo

203. 0.000 0.036 ↑ 447.0 2 1

Append (cost=2.460..116.170 rows=894 width=108) (actual time=0.031..0.036 rows=2 loops=1)

204. 0.001 0.035 ↑ 7.0 2 1

Result (cost=2.460..45.950 rows=14 width=108) (actual time=0.031..0.035 rows=2 loops=1)

205. 0.001 0.034 ↑ 7.0 2 1

Append (cost=2.460..45.780 rows=14 width=104) (actual time=0.031..0.034 rows=2 loops=1)

206. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=2.460..25.060 rows=10 width=60) (actual time=0.012..0.012 rows=0 loops=1)

207. 0.003 0.012 ↓ 0.0 0 1

Nested Loop (cost=2.190..21.460 rows=10 width=36) (actual time=0.012..0.012 rows=0 loops=1)

208. 0.007 0.007 ↑ 1.0 2 1

CTE Scan on quebec_seven_oscar six_whiskey (cost=0.000..0.040 rows=2 width=8) (actual time=0.007..0.007 rows=2 loops=1)

209. 0.002 0.002 ↓ 0.0 0 2

Bitmap Heap Scan on victor_six papa_papa (cost=2.190..10.660 rows=5 width=36) (actual time=0.001..0.001 rows=0 loops=2)

  • Recheck Cond: (mike_uniform = delta_juliet8.quebec_seven_victor)
210. 0.000 0.000 ↓ 0.0 0 2

Bitmap Index Scan on charlie_foxtrot (cost=0.000..2.190 rows=5 width=0) (actual time=0.000..0.000 rows=0 loops=2)

  • Index Cond: (mike_uniform = delta_juliet8.quebec_seven_victor)
211. 0.000 0.000 ↓ 0.0 0

Index Scan using delta_lima on yankee_echo sierra_six (cost=0.280..0.360 rows=1 width=20) (never executed)

  • Index Cond: ((quebec_seven_victor)::text = (india_golf4.kilo_sierra_alpha)::text)
212. 0.002 0.021 ↑ 2.0 2 1

Nested Loop (cost=0.340..20.580 rows=4 width=60) (actual time=0.018..0.021 rows=2 loops=1)

213. 0.005 0.011 ↑ 2.0 2 1

Hash Join (cost=0.070..18.650 rows=4 width=36) (actual time=0.010..0.011 rows=2 loops=1)

  • Hash Cond: ((sierra_juliet4.echo_romeo)::text = (delta_juliet9.echo_romeo)::text)
214. 0.002 0.002 ↑ 360.0 1 1

Seq Scan on india_six romeo_tango (cost=0.000..17.200 rows=360 width=64) (actual time=0.001..0.002 rows=1 loops=1)

  • Filter: "default
215. 0.003 0.004 ↑ 1.0 2 1

Hash (cost=0.040..0.040 rows=2 width=36) (actual time=0.004..0.004 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
216. 0.001 0.001 ↑ 1.0 2 1

CTE Scan on quebec_seven_oscar whiskey_india (cost=0.000..0.040 rows=2 width=36) (actual time=0.000..0.001 rows=2 loops=1)

217. 0.008 0.008 ↑ 1.0 1 2

Index Scan using delta_lima on yankee_echo golf_xray (cost=0.280..0.480 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=2)

  • Index Cond: ((quebec_seven_victor)::text = (sierra_juliet4.kilo_sierra_alpha)::text)
218. 0.000 0.001 ↓ 0.0 0 1

Hash Join (cost=31.520..61.420 rows=880 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Hash Cond: ((three_golf4.kilo_sierra_alpha)::text = (romeo_hotel18.quebec_seven_victor)::text)
219. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on papa_yankee_quebec tango_tango_alpha (cost=0.000..18.800 rows=880 width=40) (actual time=0.001..0.001 rows=0 loops=1)

220. 0.000 0.000 ↓ 0.0 0

Hash (cost=19.010..19.010 rows=1,001 width=20) (never executed)

221. 0.000 0.000 ↓ 0.0 0

Seq Scan on yankee_echo four_golf (cost=0.000..19.010 rows=1,001 width=20) (never executed)

222. 0.006 0.052 ↑ 2.0 2 1

Sort (cost=63.550..63.560 rows=4 width=108) (actual time=0.052..0.052 rows=2 loops=1)

  • Sort Key: romeo_hotel19.quebec_seven_victor, romeo_hotel19.xray_two_six, romeo_hotel19.sierra_three
  • Sort Method: quicksort Memory: 25kB
223. 0.007 0.046 ↑ 2.0 2 1

Hash Left Join (cost=32.000..63.510 rows=4 width=108) (actual time=0.039..0.046 rows=2 loops=1)

  • Hash Cond: (((romeo_hotel19.quebec_seven_victor)::text = (bravo_quebec4.kilo_sierra_alpha)::text) AND (romeo_hotel19.xray_two_six = bravo_quebec4.xray_two_six))
  • Filter: (bravo_quebec4.* five_romeo NULL)
224. 0.038 0.038 ↑ 447.0 2 1

CTE Scan on delta_romeo papa_yankee_tango (cost=0.000..17.880 rows=894 width=44) (actual time=0.032..0.038 rows=2 loops=1)

225. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=18.800..18.800 rows=880 width=128) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
226. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on foxtrot_mike_charlie foxtrot_delta (cost=0.000..18.800 rows=880 width=128) (actual time=0.001..0.001 rows=0 loops=1)

227.          

CTE three_juliet

228. 0.223 0.352 ↓ 100.2 1,002 1

Hash Join (cost=9.530..45.430 rows=10 width=40) (actual time=0.023..0.352 rows=1,002 loops=1)

  • Hash Cond: ((golf_juliet14.kilo_sierra_hotel)::text = (sierra_bravo12.xray_two_six)::text)
229. 0.117 0.117 ↑ 1.0 1,002 1

Seq Scan on zulu_zulu_delta kilo_kilo (cost=0.000..29.540 rows=1,002 width=7) (actual time=0.003..0.117 rows=1,002 loops=1)

  • Filter: ((five_echo)::text = 'oscar_two'::text)
  • Rows Removed by Filter: 1
230. 0.005 0.012 ↑ 1.0 2 1

Hash (cost=9.500..9.500 rows=2 width=4) (actual time=0.012..0.012 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
231. 0.002 0.007 ↑ 1.0 2 1

Bitmap Heap Scan on four_hotel quebec_xray_alpha (cost=4.160..9.500 rows=2 width=4) (actual time=0.007..0.007 rows=2 loops=1)

  • Recheck Cond: (mike_three @> LOCALTIMESTAMP)
  • Heap Blocks: exact=1
232. 0.005 0.005 ↓ 7.0 14 1

Bitmap Index Scan on november_alpha (cost=0.000..4.160 rows=2 width=0) (actual time=0.005..0.005 rows=14 loops=1)

  • Index Cond: (mike_three @> LOCALTIMESTAMP)
233. 0.000 0.000 ↓ 2.0 2 1,002

CTE Scan on oscar_kilo_quebec alpha_seven (cost=0.000..0.020 rows=1 width=44) (actual time=0.000..0.000 rows=2 loops=1,002)

234. 98.196 159.318 ↓ 100.2 1,002 1,002

Subquery Scan on five_oscar (cost=0.000..0.330 rows=10 width=44) (actual time=0.000..0.159 rows=1,002 loops=1,002)

235. 61.122 61.122 ↓ 100.2 1,002 1,002

CTE Scan on three_juliet sierra_oscar (cost=0.000..0.200 rows=10 width=40) (actual time=0.000..0.061 rows=1,002 loops=1,002)

236. 100.200 137.274 ↓ 1,002.0 1,002 1,002

Unique (cost=284.490..284.500 rows=1 width=24) (actual time=0.004..0.137 rows=1,002 loops=1,002)

237.          

CTE yankee_foxtrot

238. 0.115 1.030 ↓ 1,002.0 1,002 1

Subquery Scan on whiskey_oscar (cost=264.320..264.810 rows=1 width=12) (actual time=0.053..1.030 rows=1,002 loops=1)

  • Filter: (golf_juliet6.xray_two_six = 13)
  • Rows Removed by Filter: 2
239. 0.054 0.915 ↓ 91.3 1,004 1

Append (cost=264.320..264.680 rows=11 width=44) (actual time=0.052..0.915 rows=1,004 loops=1)

240.          

CTE oscar_kilo_quebec

241. 0.002 0.137 ↓ 2.0 2 1

Nested Loop (cost=189.230..218.890 rows=1 width=44) (actual time=0.051..0.137 rows=2 loops=1)

  • Join Filter: ((romeo_hotel7.quebec_seven_victor)::text = (golf_juliet4.kilo_sierra_hotel)::text)
242. 0.086 0.086 ↑ 1.0 1 1

Seq Scan on zulu_zulu_delta lima_tango (cost=0.000..29.540 rows=1 width=7) (actual time=0.002..0.086 rows=1 loops=1)

  • Filter: ((five_echo)::text = 'zulu_hotel'::text)
  • Rows Removed by Filter: 1002
243. 0.001 0.049 ↑ 2.0 2 1

Unique (cost=189.230..189.260 rows=4 width=108) (actual time=0.048..0.049 rows=2 loops=1)

244.          

CTE quebec_seven_oscar

245. 0.003 0.007 ↑ 1.0 2 1

Bitmap Heap Scan on four_hotel yankee_seven_whiskey (cost=4.160..9.500 rows=2 width=40) (actual time=0.007..0.007 rows=2 loops=1)

  • Recheck Cond: (mike_three @> LOCALTIMESTAMP)
  • Heap Blocks: exact=1
246. 0.004 0.004 ↓ 7.0 14 1

Bitmap Index Scan on november_alpha (cost=0.000..4.160 rows=2 width=0) (actual time=0.004..0.004 rows=14 loops=1)

  • Index Cond: (mike_three @> LOCALTIMESTAMP)
247.          

CTE delta_romeo

248. 0.001 0.035 ↑ 447.0 2 1

Append (cost=2.460..116.170 rows=894 width=108) (actual time=0.030..0.035 rows=2 loops=1)

249. 0.001 0.033 ↑ 7.0 2 1

Result (cost=2.460..45.950 rows=14 width=108) (actual time=0.030..0.033 rows=2 loops=1)

250. 0.000 0.032 ↑ 7.0 2 1

Append (cost=2.460..45.780 rows=14 width=104) (actual time=0.029..0.032 rows=2 loops=1)

251. 0.000 0.011 ↓ 0.0 0 1

Nested Loop (cost=2.460..25.060 rows=10 width=60) (actual time=0.011..0.011 rows=0 loops=1)

252. 0.001 0.011 ↓ 0.0 0 1

Nested Loop (cost=2.190..21.460 rows=10 width=36) (actual time=0.011..0.011 rows=0 loops=1)

253. 0.008 0.008 ↑ 1.0 2 1

CTE Scan on quebec_seven_oscar xray_two_papa (cost=0.000..0.040 rows=2 width=8) (actual time=0.007..0.008 rows=2 loops=1)

254. 0.002 0.002 ↓ 0.0 0 2

Bitmap Heap Scan on victor_six papa_oscar (cost=2.190..10.660 rows=5 width=36) (actual time=0.001..0.001 rows=0 loops=2)

  • Recheck Cond: (mike_uniform = delta_juliet2.quebec_seven_victor)
255. 0.000 0.000 ↓ 0.0 0 2

Bitmap Index Scan on charlie_foxtrot (cost=0.000..2.190 rows=5 width=0) (actual time=0.000..0.000 rows=0 loops=2)

  • Index Cond: (mike_uniform = delta_juliet2.quebec_seven_victor)
256. 0.000 0.000 ↓ 0.0 0

Index Scan using delta_lima on yankee_echo two_five (cost=0.280..0.360 rows=1 width=20) (never executed)

  • Index Cond: ((quebec_seven_victor)::text = (india_golf1.kilo_sierra_alpha)::text)
257. 0.003 0.021 ↑ 2.0 2 1

Nested Loop (cost=0.340..20.580 rows=4 width=60) (actual time=0.017..0.021 rows=2 loops=1)

258. 0.006 0.010 ↑ 2.0 2 1

Hash Join (cost=0.070..18.650 rows=4 width=36) (actual time=0.010..0.010 rows=2 loops=1)

  • Hash Cond: ((sierra_juliet1.echo_romeo)::text = (delta_juliet3.echo_romeo)::text)
259. 0.001 0.001 ↑ 360.0 1 1

Seq Scan on india_six romeo_delta (cost=0.000..17.200 rows=360 width=64) (actual time=0.001..0.001 rows=1 loops=1)

  • Filter: "default
260. 0.002 0.003 ↑ 1.0 2 1

Hash (cost=0.040..0.040 rows=2 width=36) (actual time=0.003..0.003 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
261. 0.001 0.001 ↑ 1.0 2 1

CTE Scan on quebec_seven_oscar tango_juliet_juliet (cost=0.000..0.040 rows=2 width=36) (actual time=0.000..0.001 rows=2 loops=1)

262. 0.008 0.008 ↑ 1.0 1 2

Index Scan using delta_lima on yankee_echo november_two (cost=0.280..0.480 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=2)

  • Index Cond: ((quebec_seven_victor)::text = (sierra_juliet1.kilo_sierra_alpha)::text)
263. 0.000 0.001 ↓ 0.0 0 1

Hash Join (cost=31.520..61.420 rows=880 width=64) (actual time=0.001..0.001 rows=0 loops=1)

  • Hash Cond: ((three_golf1.kilo_sierra_alpha)::text = (romeo_hotel6.quebec_seven_victor)::text)
264. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on papa_yankee_quebec whiskey_lima (cost=0.000..18.800 rows=880 width=40) (actual time=0.001..0.001 rows=0 loops=1)

265. 0.000 0.000 ↓ 0.0 0

Hash (cost=19.010..19.010 rows=1,001 width=20) (never executed)

266. 0.000 0.000 ↓ 0.0 0

Seq Scan on yankee_echo november_quebec (cost=0.000..19.010 rows=1,001 width=20) (never executed)

267. 0.005 0.048 ↑ 2.0 2 1

Sort (cost=63.550..63.560 rows=4 width=108) (actual time=0.048..0.048 rows=2 loops=1)

  • Sort Key: romeo_hotel7.quebec_seven_victor, romeo_hotel7.xray_two_six, romeo_hotel7.sierra_three
  • Sort Method: quicksort Memory: 25kB
268. 0.006 0.043 ↑ 2.0 2 1

Hash Left Join (cost=32.000..63.510 rows=4 width=108) (actual time=0.038..0.043 rows=2 loops=1)

  • Hash Cond: (((romeo_hotel7.quebec_seven_victor)::text = (bravo_quebec1.kilo_sierra_alpha)::text) AND (romeo_hotel7.xray_two_six = bravo_quebec1.xray_two_six))
  • Filter: (bravo_quebec1.* five_romeo NULL)
269. 0.036 0.036 ↑ 447.0 2 1

CTE Scan on delta_romeo tango_tango_india (cost=0.000..17.880 rows=894 width=44) (actual time=0.031..0.036 rows=2 loops=1)

270. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=18.800..18.800 rows=880 width=128) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
271. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on foxtrot_mike_charlie four_romeo (cost=0.000..18.800 rows=880 width=128) (actual time=0.001..0.001 rows=0 loops=1)

272.          

CTE three_juliet

273. 0.278 0.412 ↓ 100.2 1,002 1

Hash Join (cost=9.530..45.430 rows=10 width=40) (actual time=0.018..0.412 rows=1,002 loops=1)

  • Hash Cond: ((golf_juliet5.kilo_sierra_hotel)::text = (sierra_bravo5.xray_two_six)::text)
274. 0.126 0.126 ↑ 1.0 1,002 1

Seq Scan on zulu_zulu_delta golf_four_bravo (cost=0.000..29.540 rows=1,002 width=7) (actual time=0.002..0.126 rows=1,002 loops=1)

  • Filter: ((five_echo)::text = 'oscar_two'::text)
  • Rows Removed by Filter: 1
275. 0.003 0.008 ↑ 1.0 2 1

Hash (cost=9.500..9.500 rows=2 width=4) (actual time=0.008..0.008 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
276. 0.002 0.005 ↑ 1.0 2 1

Bitmap Heap Scan on four_hotel uniform_romeo (cost=4.160..9.500 rows=2 width=4) (actual time=0.005..0.005 rows=2 loops=1)

  • Recheck Cond: (mike_three @> LOCALTIMESTAMP)
  • Heap Blocks: exact=1
277. 0.003 0.003 ↓ 7.0 14 1

Bitmap Index Scan on november_alpha (cost=0.000..4.160 rows=2 width=0) (actual time=0.003..0.003 rows=14 loops=1)

  • Index Cond: (mike_three @> LOCALTIMESTAMP)
278. 0.138 0.138 ↓ 2.0 2 1

CTE Scan on oscar_kilo_quebec echo_foxtrot_four (cost=0.000..0.020 rows=1 width=44) (actual time=0.052..0.138 rows=2 loops=1)

279. 0.113 0.723 ↓ 100.2 1,002 1

Subquery Scan on bravo_alpha (cost=0.000..0.330 rows=10 width=44) (actual time=0.019..0.723 rows=1,002 loops=1)

280. 0.610 0.610 ↓ 100.2 1,002 1

CTE Scan on three_juliet juliet_oscar (cost=0.000..0.200 rows=10 width=40) (actual time=0.019..0.610 rows=1,002 loops=1)

281.          

CTE romeo_charlie

282. 0.000 2.225 ↓ 1,002.0 1,002 1

Nested Loop (cost=0.280..8.330 rows=1 width=16) (actual time=0.059..2.225 rows=1,002 loops=1)

283. 1.235 1.235 ↓ 1,002.0 1,002 1

CTE Scan on yankee_foxtrot papa_echo (cost=0.000..0.020 rows=1 width=12) (actual time=0.053..1.235 rows=1,002 loops=1)

284. 1.002 1.002 ↑ 1.0 1 1,002

Index Scan using mike_foxtrot on zulu_zulu_delta hotel_hotel_romeo (cost=0.280..8.290 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1,002)

  • Index Cond: (quebec_seven_victor = papa_echo.bravo_tango)
285. 33.609 37.074 ↓ 1,002.0 1,002 1,002

Sort (cost=11.350..11.360 rows=1 width=24) (actual time=0.004..0.037 rows=1,002 loops=1,002)

  • Sort Key: romeo_three.bravo_tango, juliet_kilo.oscar_echo DESC
  • Sort Method: quicksort Memory: 71kB
286. 1.032 3.465 ↓ 1,002.0 1,002 1

Nested Loop Left Join (cost=4.170..11.340 rows=1 width=24) (actual time=0.065..3.465 rows=1,002 loops=1)

287. 2.433 2.433 ↓ 1,002.0 1,002 1

CTE Scan on romeo_charlie romeo_three (cost=0.000..0.020 rows=1 width=16) (actual time=0.061..2.433 rows=1,002 loops=1)

  • Filter: (xray_two_six = 13)
288. 0.000 0.000 ↓ 0.0 0 1,002

Bitmap Heap Scan on golf_five juliet_kilo (cost=4.170..11.300 rows=1 width=48) (actual time=0.000..0.000 rows=0 loops=1,002)

  • Recheck Cond: (seven_oscar = romeo_three.bravo_tango)
  • Filter: ((xray_two_six = 13) AND ((two_charlie_romeo)::text = 'tango_romeo'::text) AND (xray_two_six = romeo_three.xray_two_six))
289. 0.000 0.000 ↓ 0.0 0 1,002

Bitmap Index Scan on echo_juliet (cost=0.000..4.170 rows=3 width=0) (actual time=0.000..0.000 rows=0 loops=1,002)

  • Index Cond: (seven_oscar = romeo_three.bravo_tango)
290. 1.034 6,229.213 ↓ 3,004.0 3,004 1

Sort (cost=8.260..8.260 rows=1 width=128) (actual time=6,229.088..6,229.213 rows=3,004 loops=1)

  • Sort Key: quebec_sierra.bravo_tango
  • Sort Method: quicksort Memory: 894kB
291. 0.605 6,228.179 ↓ 3,004.0 3,004 1

Nested Loop (cost=0.140..8.250 rows=1 width=128) (actual time=5,343.956..6,228.179 rows=3,004 loops=1)

292. 6,224.570 6,224.570 ↓ 3,004.0 3,004 1

CTE Scan on romeo_charlie quebec_sierra (cost=0.000..0.020 rows=1 width=136) (actual time=5,343.938..6,224.570 rows=3,004 loops=1)

293. 3.004 3.004 ↑ 1.0 1 3,004

Index Scan using seven_xray on six_juliet kilo_foxtrot (cost=0.140..8.160 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=3,004)

  • Index Cond: (quebec_seven_victor = quebec_sierra.xray_two_six)