explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bu2t : quer1

Settings
# exclusive inclusive rows x rows loops node
1. 0.815 1,447,279.752 ↑ 223.7 1,516 1

Append (cost=33,314,979.630..33,434,150.930 rows=339,115 width=620) (actual time=1,193,062.708..1,447,279.752 rows=1,516 loops=1)

2.          

CTE sierra_november

3. 23,826.109 98,848.334 ↓ 6.7 8,251,704 1

Hash Join (cost=646,467.480..3,370,594.610 rows=1,226,860 width=19) (actual time=60,097.750..98,848.334 rows=8,251,704 loops=1)

  • Hash Cond: ((delta_two.charlie_three)::text = (quebec_three.quebec_seven)::text)
4. 42,933.162 42,933.162 ↓ 1.4 22,561,806 1

Seq Scan on kilo delta_two (cost=0.000..2,313,740.800 rows=15,949,178 width=19) (actual time=13,748.415..42,933.162 rows=22,561,806 loops=1)

  • Filter: (delta_kilo >= 'yankee_november'::timestamp without time zone)
5. 1,155.385 32,089.063 ↓ 1.7 3,345,214 1

Hash (cost=609,347.610..609,347.610 rows=2,021,830 width=19) (actual time=32,089.063..32,089.063 rows=3,345,214 loops=1)

  • Buckets: 32,768 Batches: 16 (originally 8) Memory Usage: 16,385kB
6. 628.168 30,933.678 ↓ 1.7 3,345,214 1

Nested Loop (cost=62,027.160..609,347.610 rows=2,021,830 width=19) (actual time=6,510.301..30,933.678 rows=3,345,214 loops=1)

7. 0.050 0.050 ↑ 1.0 1 1

Seq Scan on charlie_hotel hotel_whiskey (cost=0.000..1.160 rows=1 width=8) (actual time=0.010..0.050 rows=1 loops=1)

  • Filter: ((mike_tango)::text = 'lima'::text)
8. 23,828.560 30,305.460 ↓ 1.4 3,345,214 1

Bitmap Heap Scan on golf_tango quebec_three (cost=62,027.160..579,478.510 rows=2,389,435 width=27) (actual time=6,510.283..30,305.460 rows=3,345,214 loops=1)

  • Recheck Cond: (foxtrot_bravo = hotel_whiskey.quebec_seven)
9. 6,476.900 6,476.900 ↓ 1.8 4,348,174 1

Bitmap Index Scan on echo_india (cost=0.000..61,429.800 rows=2,389,435 width=0) (actual time=6,476.900..6,476.900 rows=4,348,174 loops=1)

  • Index Cond: (foxtrot_bravo = hotel_whiskey.quebec_seven)
10.          

CTE delta_seven

11. 1,323.664 231,119.532 ↑ 353.0 1,479 1

HashAggregate (cost=2,212,689.240..2,217,910.220 rows=522,098 width=8) (actual time=231,118.549..231,119.532 rows=1,479 loops=1)

12. 5,134.959 229,795.868 ↓ 2.5 8,251,704 1

Hash Join (cost=2,093,003.770..2,204,498.250 rows=3,276,396 width=8) (actual time=222,102.876..229,795.868 rows=8,251,704 loops=1)

  • Hash Cond: (uniform_five.india_foxtrot = echo_lima.quebec_seven)
13. 3,391.859 3,391.859 ↓ 1.0 1,565,379 1

Seq Scan on romeo_papa uniform_five (cost=0.000..53,857.690 rows=1,509,169 width=8) (actual time=0.003..3,391.859 rows=1,565,379 loops=1)

14. 2,072.103 221,269.050 ↓ 7.3 8,251,704 1

Hash (cost=2,073,300.380..2,073,300.380 rows=1,133,471 width=16) (actual time=221,269.050..221,269.050 rows=8,251,704 loops=1)

  • Buckets: 65,536 Batches: 128 (originally 4) Memory Usage: 16,385kB
15. 3,711.609 219,196.947 ↓ 7.3 8,251,704 1

Hash Join (cost=1,562,587.850..2,073,300.380 rows=1,133,471 width=16) (actual time=100,439.585..219,196.947 rows=8,251,704 loops=1)

  • Hash Cond: (juliet_xray.india_foxtrot = echo_lima.quebec_seven)
16. 25,907.451 215,006.414 ↓ 7.3 8,251,704 1

Hash Join (cost=1,543,406.650..2,023,387.430 rows=1,133,471 width=8) (actual time=99,960.406..215,006.414 rows=8,251,704 loops=1)

  • Hash Cond: ((quebec_three.foxtrot_hotel)::text = (juliet_xray.quebec_seven)::text)
17. 50,652.702 179,075.400 ↓ 6.7 8,251,704 1

Hash Join (cost=1,264,617.250..1,686,982.150 rows=1,226,860 width=11) (actual time=86,902.083..179,075.400 rows=8,251,704 loops=1)

  • Hash Cond: ((three_charlie.quebec_seven)::text = (quebec_three.quebec_seven)::text)
18. 101,618.557 101,618.557 ↓ 6.7 8,251,704 1

CTE Scan on sierra_november three_charlie (cost=0.000..24,537.200 rows=1,226,860 width=516) (actual time=60,097.754..101,618.557 rows=8,251,704 loops=1)

19. 9,429.225 26,804.141 ↓ 1.2 30,502,708 1

Hash (cost=756,394.890..756,394.890 rows=26,283,789 width=30) (actual time=26,804.141..26,804.141 rows=30,502,708 loops=1)

  • Buckets: 32,768 Batches: 128 Memory Usage: 14,722kB
20. 17,374.916 17,374.916 ↓ 1.2 30,502,708 1

Seq Scan on golf_tango quebec_three (cost=0.000..756,394.890 rows=26,283,789 width=30) (actual time=0.010..17,374.916 rows=30,502,708 loops=1)

21. 2,847.693 10,023.563 ↓ 2.8 9,967,957 1

Hash (cost=214,566.620..214,566.620 rows=3,498,062 width=19) (actual time=10,023.563..10,023.563 rows=9,967,957 loops=1)

  • Buckets: 32,768 Batches: 32 (originally 16) Memory Usage: 16,385kB
22. 7,175.870 7,175.870 ↓ 2.8 9,967,957 1

Seq Scan on three_quebec juliet_xray (cost=0.000..214,566.620 rows=3,498,062 width=19) (actual time=2.272..7,175.870 rows=9,967,957 loops=1)

23. 141.529 478.924 ↑ 1.0 521,941 1

Hash (cost=10,614.980..10,614.980 rows=522,098 width=8) (actual time=478.924..478.924 rows=521,941 loops=1)

  • Buckets: 65,536 Batches: 2 Memory Usage: 10,200kB
24. 337.395 337.395 ↑ 1.0 521,941 1

Seq Scan on mike_hotel echo_lima (cost=0.000..10,614.980 rows=522,098 width=8) (actual time=0.007..337.395 rows=521,941 loops=1)

25.          

CTE echo_three

26. 5,892.998 59,878.147 ↓ 7.4 1,479 1

GroupAggregate (cost=60,025.510..2,982,072.040 rows=200 width=19) (actual time=39,016.644..59,878.147 rows=1,479 loops=1)

27. 1,241.072 53,985.149 ↑ 91.0 1,380,698 1

Merge Join (cost=60,025.510..2,353,644.200 rows=125,685,168 width=19) (actual time=36,060.174..53,985.149 rows=1,380,698 loops=1)

  • Merge Cond: (juliet_xray.india_foxtrot = sierra_seven.quebec_seven)
28. 52,650.147 52,650.147 ↓ 2.8 9,967,491 1

Index Scan using quebec_charlie on three_quebec juliet_xray (cost=0.000..399,596.020 rows=3,498,062 width=19) (actual time=0.014..52,650.147 rows=9,967,491 loops=1)

29. 93.737 93.930 ↓ 2.6 1,380,684 1

Sort (cost=60,025.510..61,330.750 rows=522,098 width=8) (actual time=0.673..93.930 rows=1,380,684 loops=1)

  • Sort Key: sierra_seven.quebec_seven
  • Sort Method: quicksort Memory: 118kB
30. 0.193 0.193 ↑ 353.0 1,479 1

CTE Scan on delta_seven sierra_seven (cost=0.000..10,441.960 rows=522,098 width=8) (actual time=0.001..0.193 rows=1,479 loops=1)

31.          

CTE victor_hotel

32. 1,299.744 284,606.091 ↑ 91.0 1,380,698 1

Merge Join (cost=60,025.510..2,353,644.200 rows=125,685,168 width=19) (actual time=277,248.720..284,606.091 rows=1,380,698 loops=1)

  • Merge Cond: (juliet_xray.india_foxtrot = echo_lima.quebec_seven)
33. 52,072.641 52,072.641 ↓ 2.8 9,967,491 1

Index Scan using quebec_charlie on three_quebec juliet_xray (cost=0.000..399,596.020 rows=3,498,062 width=19) (actual time=0.011..52,072.641 rows=9,967,491 loops=1)

34. 113.846 231,233.706 ↓ 2.6 1,380,684 1

Sort (cost=60,025.510..61,330.750 rows=522,098 width=8) (actual time=231,120.404..231,233.706 rows=1,380,684 loops=1)

  • Sort Key: echo_lima.quebec_seven
  • Sort Method: quicksort Memory: 118kB
35. 231,119.860 231,119.860 ↑ 353.0 1,479 1

CTE Scan on delta_seven echo_lima (cost=0.000..10,441.960 rows=522,098 width=8) (actual time=231,118.552..231,119.860 rows=1,479 loops=1)

36.          

CTE romeo_quebec

37. 883.522 472,590.460 ↓ 299.2 1,381,888 1

Nested Loop Left Join (cost=1,023,963.790..22,022,731.270 rows=4,618 width=64) (actual time=349,730.351..472,590.460 rows=1,381,888 loops=1)

38. 11,674.833 369,447.226 ↓ 299.2 1,381,888 1

Hash Join (cost=1,023,963.790..21,750,849.020 rows=4,618 width=38) (actual time=349,725.560..369,447.226 rows=1,381,888 loops=1)

  • Hash Cond: (((juliet_lima.foxtrot_hotel)::text = (juliet_xray.quebec_seven)::text) AND (juliet_lima.india_foxtrot = juliet_xray.india_foxtrot))
39. 285,306.496 285,306.496 ↑ 91.0 1,380,698 1

CTE Scan on victor_hotel juliet_lima (cost=0.000..2,513,703.360 rows=125,685,168 width=524) (actual time=277,248.727..285,306.496 rows=1,380,698 loops=1)

40. 1,372.539 72,465.897 ↓ 1.8 3,345,214 1

Hash (cost=977,702.870..977,702.870 rows=1,867,928 width=49) (actual time=72,465.897..72,465.897 rows=3,345,214 loops=1)

  • Buckets: 32,768 Batches: 32 (originally 16) Memory Usage: 16,385kB
41. 22,535.356 71,093.358 ↓ 1.8 3,345,214 1

Hash Join (cost=340,816.550..977,702.870 rows=1,867,928 width=49) (actual time=19,606.827..71,093.358 rows=3,345,214 loops=1)

  • Hash Cond: ((quebec_three.foxtrot_hotel)::text = (juliet_xray.quebec_seven)::text)
  • Hash Cond: ((quebec_three.foxtrot_hotel)::text = (juliet_xray.quebec_seven)::text)
42. 795.286 39,560.853 ↓ 1.7 3,345,214 1

Nested Loop (cost=62,027.160..609,347.610 rows=2,021,830 width=30) (actual time=10,585.421..39,560.853 rows=3,345,214 loops=1)

43. 0.014 0.014 ↑ 1.0 1 1

Seq Scan on charlie_hotel hotel_whiskey (cost=0.000..1.160 rows=1 width=8) (actual time=0.010..0.014 rows=1 loops=1)

  • Filter: ((mike_tango)::text = 'lima'::text)
44. 28,208.145 38,765.553 ↓ 1.4 3,345,214 1

Bitmap Heap Scan on golf_tango quebec_three (cost=62,027.160..579,478.510 rows=2,389,435 width=38) (actual time=10,585.404..38,765.553 rows=3,345,214 loops=1)

  • Recheck Cond: (foxtrot_bravo = hotel_whiskey.quebec_seven)
45. 10,557.408 10,557.408 ↓ 1.8 4,348,174 1

Bitmap Index Scan on echo_india (cost=0.000..61,429.800 rows=2,389,435 width=0) (actual time=10,557.408..10,557.408 rows=4,348,174 loops=1)

  • Index Cond: (foxtrot_bravo = hotel_whiskey.quebec_seven)
46. 2,895.843 8,997.149 ↓ 2.8 9,967,957 1

Hash (cost=214,566.620..214,566.620 rows=3,498,062 width=19) (actual time=8,997.149..8,997.149 rows=9,967,957 loops=1)

  • Buckets: 32,768 Batches: 64 (originally 16) Memory Usage: 16,385kB
47. 6,101.306 6,101.306 ↓ 2.8 9,967,957 1

Seq Scan on three_quebec juliet_xray (cost=0.000..214,566.620 rows=3,498,062 width=19) (actual time=0.011..6,101.306 rows=9,967,957 loops=1)

48. 102,259.712 102,259.712 ↓ 0.0 0 1,381,888

Index Scan using victor_yankee on seven_yankee tango_five (cost=0.000..58.860 rows=1 width=49) (actual time=0.074..0.074 rows=0 loops=1,381,888)

  • Index Cond: ((foxtrot_hotel)::text = (juliet_xray.quebec_seven)::text)
  • Filter: ((mike_tango)::text = 'two_golf'::text)
49.          

CTE juliet_victor

50. 3,351.685 638,085.672 ↓ 85.9 8,330,211 1

Hash Join (cost=3.050..151,907.290 rows=97,020 width=529) (actual time=349,733.911..638,085.672 rows=8,330,211 loops=1)

  • Hash Cond: (delta_two.sierra_victor = yankee_juliet.quebec_seven)
51. 3,432.550 634,733.948 ↓ 85.9 8,330,211 1

Nested Loop (cost=0.000..150,570.220 rows=97,020 width=532) (actual time=349,733.841..634,733.948 rows=8,330,211 loops=1)

52. 473,766.166 473,766.166 ↓ 299.2 1,381,888 1

CTE Scan on romeo_quebec hotel_three (cost=0.000..92.360 rows=4,618 width=1,040) (actual time=349,730.353..473,766.166 rows=1,381,888 loops=1)

53. 157,535.232 157,535.232 ↑ 3.5 6 1,381,888

Index Scan using sierra_whiskey on kilo delta_two (cost=0.000..32.320 rows=21 width=27) (actual time=0.077..0.114 rows=6 loops=1,381,888)

  • Index Cond: ((charlie_three)::text = (hotel_three.charlie_three)::text)
54. 0.017 0.039 ↑ 1.0 91 1

Hash (cost=1.910..1.910 rows=91 width=13) (actual time=0.039..0.039 rows=91 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 5kB
55. 0.022 0.022 ↑ 1.0 91 1

Seq Scan on oscar yankee_juliet (cost=0.000..1.910 rows=91 width=13) (actual time=0.008..0.022 rows=91 loops=1)

56.          

CTE alpha

57. 4.880 2,849.580 ↓ 80.0 320 1

HashAggregate (cost=85,226.530..85,226.570 rows=4 width=8) (actual time=2,849.532..2,849.580 rows=320 loops=1)

58. 7.446 2,844.700 ↓ 4,014.8 16,059 1

Nested Loop (cost=0.000..85,226.520 rows=4 width=8) (actual time=295.142..2,844.700 rows=16,059 loops=1)

  • Join Filter: (quebec_three.foxtrot_bravo = hotel_whiskey.quebec_seven)
59. 0.012 0.012 ↑ 1.0 1 1

Seq Scan on charlie_hotel hotel_whiskey (cost=0.000..1.160 rows=1 width=8) (actual time=0.009..0.012 rows=1 loops=1)

  • Filter: ((mike_tango)::text = 'lima'::text)
60. 16.521 2,837.242 ↓ 945.8 46,343 1

Nested Loop (cost=0.000..85,224.750 rows=49 width=16) (actual time=295.124..2,837.242 rows=46,343 loops=1)

61. 3.112 1,276.237 ↓ 2,163.1 15,142 1

Nested Loop (cost=0.000..85,137.030 rows=7 width=19) (actual time=292.686..1,276.237 rows=15,142 loops=1)

62. 1.373 923.001 ↓ 358.0 358 1

Nested Loop (cost=0.000..85,062.790 rows=1 width=16) (actual time=291.978..923.001 rows=358 loops=1)

63. 807.951 807.951 ↓ 589.0 589 1

Seq Scan on romeo_uniform whiskey_hotel (cost=0.000..85,054.400 rows=1 width=8) (actual time=15.129..807.951 rows=589 loops=1)

  • Filter: (((november)::text = 'seven_delta'::text) AND ((six_mike)::text = 'four'::text))
64. 113.677 113.677 ↑ 1.0 1 589

Index Scan using echo_whiskey on mike_hotel echo_lima (cost=0.000..8.380 rows=1 width=8) (actual time=0.190..0.193 rows=1 loops=589)

  • Index Cond: (quebec_seven = whiskey_hotel.india_foxtrot)
  • Filter: (delta_kilo >= 'yankee_november'::timestamp without time zone)
65. 350.124 350.124 ↑ 5.7 42 358

Index Scan using quebec_charlie on three_quebec juliet_xray (cost=0.000..71.220 rows=241 width=19) (actual time=0.580..0.978 rows=42 loops=358)

  • Index Cond: (india_foxtrot = echo_lima.quebec_seven)
66. 1,544.484 1,544.484 ↑ 2.3 3 15,142

Index Scan using five on golf_tango quebec_three (cost=0.000..12.440 rows=7 width=19) (actual time=0.076..0.102 rows=3 loops=15,142)

  • Index Cond: ((foxtrot_hotel)::text = (juliet_xray.quebec_seven)::text)
67. 1.621 1,443,078.417 ↑ 229.3 1,479 1

Subquery Scan on victor_victor (cost=130,893.430..164,802.930 rows=339,095 width=620) (actual time=1,193,062.707..1,443,078.417 rows=1,479 loops=1)

68. 13,884.707 1,443,076.796 ↑ 229.3 1,479 1

GroupAggregate (cost=130,893.430..161,411.980 rows=339,095 width=620) (actual time=1,193,062.706..1,443,076.796 rows=1,479 loops=1)

69. 721,219.752 1,429,192.089 ↓ 24.6 8,330,211 1

Sort (cost=130,893.430..131,741.170 rows=339,095 width=620) (actual time=1,193,059.663..1,429,192.089 rows=8,330,211 loops=1)

  • Sort Key: papa.mike_tango, quebec_sierra.mike_tango, uniform_five.three_four, quebec_three.india_foxtrot, india_three.six_papa, echo_lima.delta_charlie, quebec_three.tango_echo
  • Sort Method: external merge Disk: 832,336kB
70. 4,061.010 707,972.337 ↓ 24.6 8,330,211 1

Hash Join (cost=3,559.510..5,864.800 rows=339,095 width=620) (actual time=410,643.728..707,972.337 rows=8,330,211 loops=1)

  • Hash Cond: (quebec_three.india_foxtrot = echo_lima.quebec_seven)
71. 643,001.521 643,001.521 ↓ 85.9 8,330,211 1

CTE Scan on juliet_victor quebec_three (cost=0.000..1,940.400 rows=97,020 width=528) (actual time=349,733.913..643,001.521 rows=8,330,211 loops=1)

72. 2.177 60,909.806 ↓ 2.6 1,479 1

Hash (cost=3,552.280..3,552.280 rows=578 width=116) (actual time=60,909.806..60,909.806 rows=1,479 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 197kB
73. 2.843 60,907.629 ↓ 2.6 1,479 1

Hash Join (cost=3.440..3,552.280 rows=578 width=116) (actual time=39,024.032..60,907.629 rows=1,479 loops=1)

  • Hash Cond: (echo_lima.sierra_five = papa.quebec_seven)
74. 2.555 60,904.735 ↓ 2.6 1,479 1

Nested Loop (cost=0.000..3,540.890 rows=578 width=110) (actual time=39,023.964..60,904.735 rows=1,479 loops=1)

75. 3.073 60,099.083 ↓ 7.4 1,479 1

Nested Loop (cost=0.000..1,641.320 rows=200 width=40) (actual time=39,020.070..60,099.083 rows=1,479 loops=1)

76. 59,880.076 59,880.076 ↓ 7.4 1,479 1

CTE Scan on echo_three india_three (cost=0.000..4.000 rows=200 width=16) (actual time=39,016.647..59,880.076 rows=1,479 loops=1)

77. 215.934 215.934 ↑ 1.0 1 1,479

Index Scan using echo_whiskey on mike_hotel echo_lima (cost=0.000..8.170 rows=1 width=24) (actual time=0.146..0.146 rows=1 loops=1,479)

  • Index Cond: (quebec_seven = india_three.quebec_seven)
78. 803.097 803.097 ↑ 3.0 1 1,479

Index Scan using delta_sierra on romeo_papa uniform_five (cost=0.000..9.460 rows=3 width=70) (actual time=0.540..0.543 rows=1 loops=1,479)

  • Index Cond: (india_foxtrot = echo_lima.quebec_seven)
79. 0.007 0.051 ↑ 1.0 33 1

Hash (cost=3.030..3.030 rows=33 width=22) (actual time=0.051..0.051 rows=33 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 2kB
80. 0.024 0.044 ↑ 1.0 33 1

Hash Join (cost=1.250..3.030 rows=33 width=22) (actual time=0.028..0.044 rows=33 loops=1)

  • Hash Cond: (papa.uniform_zulu = quebec_sierra.quebec_seven)
81. 0.007 0.007 ↑ 1.0 33 1

Seq Scan on two_india papa (cost=0.000..1.330 rows=33 width=23) (actual time=0.005..0.007 rows=33 loops=1)

82. 0.007 0.013 ↑ 1.0 11 1

Hash (cost=1.110..1.110 rows=11 width=15) (actual time=0.013..0.013 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
83. 0.006 0.006 ↑ 1.0 11 1

Seq Scan on whiskey_oscar quebec_sierra (cost=0.000..1.110 rows=11 width=15) (actual time=0.003..0.006 rows=11 loops=1)

84. 0.044 4,200.520 ↓ 1.9 37 1

Subquery Scan on echo_uniform (cost=85,260.900..85,261.800 rows=20 width=140) (actual time=4,200.349..4,200.520 rows=37 loops=1)

85. 0.198 4,200.476 ↓ 1.9 37 1

GroupAggregate (cost=85,260.900..85,261.600 rows=20 width=140) (actual time=4,200.328..4,200.476 rows=37 loops=1)

86. 1.813 4,200.278 ↓ 6.0 119 1

Sort (cost=85,260.900..85,260.950 rows=20 width=140) (actual time=4,200.270..4,200.278 rows=119 loops=1)

  • Sort Key: papa.mike_tango, quebec_sierra.mike_tango, uniform_five.three_four, echo_lima.quebec_seven, echo_lima.delta_charlie, tango_five.six_mike
  • Sort Method: quicksort Memory: 41kB
87. 0.120 4,198.465 ↓ 6.0 119 1

Nested Loop (cost=0.090..85,260.470 rows=20 width=140) (actual time=4,017.330..4,198.465 rows=119 loops=1)

88. 0.113 4,156.100 ↓ 17.0 119 1

Nested Loop Left Join (cost=0.090..85,193.640 rows=7 width=94) (actual time=4,015.776..4,156.100 rows=119 loops=1)

89. 0.064 4,138.613 ↓ 17.0 119 1

Nested Loop (cost=0.090..85,138.050 rows=7 width=57) (actual time=4,015.741..4,138.613 rows=119 loops=1)

90. 0.072 4,138.216 ↓ 37.0 37 1

Nested Loop (cost=0.090..85,063.810 rows=1 width=38) (actual time=4,015.728..4,138.216 rows=37 loops=1)

91. 0.088 4,137.589 ↓ 37.0 37 1

Nested Loop (cost=0.090..85,063.170 rows=1 width=39) (actual time=4,015.253..4,137.589 rows=37 loops=1)

92. 0.824 4,136.761 ↓ 37.0 37 1

Nested Loop (cost=0.090..85,062.890 rows=1 width=32) (actual time=4,014.589..4,136.761 rows=37 loops=1)

93. 1,125.558 1,125.558 ↓ 589.0 589 1

Seq Scan on romeo_uniform whiskey_hotel (cost=0.000..85,054.400 rows=1 width=8) (actual time=158.031..1,125.558 rows=589 loops=1)

  • Filter: (((november)::text = 'seven_delta'::text) AND ((six_mike)::text = 'four'::text))
94. 160.711 3,010.379 ↓ 0.0 0 589

Index Scan using echo_whiskey on mike_hotel echo_lima (cost=0.090..8.470 rows=1 width=24) (actual time=5.111..5.111 rows=0 loops=589)

  • Index Cond: (quebec_seven = whiskey_hotel.india_foxtrot)
  • Filter: ((delta_kilo >= 'yankee_november'::timestamp without time zone) AND (NOT (mike_mike delta_four 8)))
95.          

SubPlan (for Index Scan)

96. 2,849.668 2,849.668 ↓ 80.0 320 1

CTE Scan on alpha (cost=0.000..0.080 rows=4 width=8) (actual time=2,849.540..2,849.668 rows=320 loops=1)

97. 0.740 0.740 ↑ 1.0 1 37

Index Scan using whiskey_four on two_india papa (cost=0.000..0.270 rows=1 width=23) (actual time=0.019..0.020 rows=1 loops=37)

  • Index Cond: (quebec_seven = echo_lima.sierra_five)
98. 0.555 0.555 ↑ 1.0 1 37

Index Scan using golf_kilo on whiskey_oscar quebec_sierra (cost=0.000..0.630 rows=1 width=15) (actual time=0.015..0.015 rows=1 loops=37)

  • Index Cond: (quebec_seven = papa.uniform_zulu)
99. 0.333 0.333 ↑ 80.3 3 37

Index Scan using quebec_charlie on three_quebec juliet_xray (cost=0.000..71.220 rows=241 width=19) (actual time=0.007..0.009 rows=3 loops=37)

  • Index Cond: (india_foxtrot = echo_lima.quebec_seven)
100. 17.374 17.374 ↑ 1.0 1 119

Index Scan using victor_yankee on seven_yankee tango_five (cost=0.000..7.930 rows=1 width=49) (actual time=0.119..0.146 rows=1 loops=119)

  • Index Cond: ((foxtrot_hotel)::text = (juliet_xray.quebec_seven)::text)
  • Filter: ((mike_tango)::text = 'two_golf'::text)
101. 42.245 42.245 ↑ 3.0 1 119

Index Scan using delta_sierra on romeo_papa uniform_five (cost=0.000..9.510 rows=3 width=70) (actual time=0.355..0.355 rows=1 loops=119)

  • Index Cond: (india_foxtrot = echo_lima.quebec_seven)
Total runtime : 1,447,328.407 ms