explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GbGR

Settings
# exclusive inclusive rows x rows loops node
1. 26,674.119 26,674.119 ↓ 3.5 67,842 1

CTE Scan on juliet_tango (cost=312,105,266.340..312,105,649.120 rows=19,139 width=84) (actual time=26,325.635..26,674.119 rows=67,842 loops=1)

2.          

CTE alpha_five

3. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on whiskey_echo (cost=0.000..12.660 rows=1,000 width=29) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: ((uniform_yankee)::text = 'echo_victor'::text)
  • Rows Removed by Filter: 53
4.          

CTE kilo_golf

5. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on whiskey_echo hotel_hotel (cost=0.000..12.660 rows=1,000 width=29) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: ((uniform_yankee)::text = 'quebec_india'::text)
  • Rows Removed by Filter: 53
6.          

CTE charlie_zulu

7. 0.049 0.049 ↑ 1,000.0 1 1

Seq Scan on whiskey_echo xray_victor (cost=0.000..12.660 rows=1,000 width=29) (actual time=0.028..0.049 rows=1 loops=1)

  • Filter: ((uniform_yankee)::text = 'romeo_india'::text)
  • Rows Removed by Filter: 52
8.          

CTE india_xray

9. 0.128 6.075 ↑ 37.5 171 1

HashSetOp Except (cost=484.980..597.580 rows=6,408 width=4) (actual time=6.024..6.075 rows=171 loops=1)

10. 0.051 5.947 ↑ 43.3 171 1

Append (cost=484.980..579.060 rows=7,408 width=4) (actual time=5.756..5.947 rows=171 loops=1)

11. 0.082 5.885 ↑ 37.5 171 1

Result (cost=484.980..549.060 rows=6,408 width=4) (actual time=5.756..5.885 rows=171 loops=1)

12. 0.149 5.803 ↑ 37.5 171 1

HashAggregate (cost=484.980..549.060 rows=6,408 width=4) (actual time=5.754..5.803 rows=171 loops=1)

  • Group Key: romeo_three.five_uniform
13. 0.062 5.654 ↑ 37.5 171 1

Append (cost=27.000..468.960 rows=6,408 width=4) (actual time=0.294..5.654 rows=171 loops=1)

14. 2.689 5.578 ↑ 31.6 171 1

Hash Join (cost=27.000..384.880 rows=5,408 width=4) (actual time=0.294..5.578 rows=171 loops=1)

  • Hash Cond: (romeo_three.november_three1uniform_zulu = charlie_zulu.alpha_three)
15. 2.827 2.827 ↓ 1.0 10,834 1

Seq Scan on delta_xray romeo_three (cost=0.000..209.160 rows=10,816 width=8) (actual time=0.007..2.827 rows=10,834 loops=1)

16. 0.003 0.062 ↑ 200.0 1 1

Hash (cost=24.500..24.500 rows=200 width=4) (actual time=0.062..0.062 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
17. 0.008 0.059 ↑ 200.0 1 1

HashAggregate (cost=22.500..24.500 rows=200 width=4) (actual time=0.058..0.059 rows=1 loops=1)

  • Group Key: charlie_zulu.alpha_three
18. 0.051 0.051 ↑ 1,000.0 1 1

CTE Scan on charlie_zulu (cost=0.000..20.000 rows=1,000 width=4) (actual time=0.030..0.051 rows=1 loops=1)

19. 0.014 0.014 ↓ 0.0 0 1

CTE Scan on alpha_five (cost=0.000..20.000 rows=1,000 width=4) (actual time=0.014..0.014 rows=0 loops=1)

20. 0.001 0.011 ↓ 0.0 0 1

Subquery Scan on bravo_seven (cost=0.000..30.000 rows=1,000 width=4) (actual time=0.011..0.011 rows=0 loops=1)

21. 0.010 0.010 ↓ 0.0 0 1

CTE Scan on kilo_golf (cost=0.000..20.000 rows=1,000 width=4) (actual time=0.010..0.010 rows=0 loops=1)

22.          

CTE sierra_juliet

23. 0.191 0.191 ↓ 2.3 7 1

CTE Scan on delta_kilo (cost=5.020..5.250 rows=3 width=4) (actual time=0.165..0.191 rows=7 loops=1)

  • Filter: (tango_romeo > 0)
  • Rows Removed by Filter: 1
24.          

CTE three_sierra_four

25. 0.007 0.021 ↑ 1.0 10 1

Append (cost=0.000..0.200 rows=10 width=4) (actual time=0.002..0.021 rows=10 loops=1)

26. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.000..0.010 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

27. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.000..0.010 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

28. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.000..0.010 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

29. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.000..0.010 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

30. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.000..0.010 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

31. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.000..0.010 rows=1 width=0) (actual time=0.000..0.001 rows=1 loops=1)

32. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.000..0.010 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

33. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.000..0.010 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

34. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.000..0.010 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

35. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.000..0.010 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

36.          

CTE delta_kilo

37. 0.005 0.153 ↑ 1.0 8 1

Limit (cost=4.800..4.820 rows=8 width=8) (actual time=0.146..0.153 rows=8 loops=1)

38. 0.032 0.148 ↑ 12.5 8 1

Sort (cost=4.800..5.050 rows=100 width=8) (actual time=0.145..0.148 rows=8 loops=1)

  • Sort Key: ((quebec_three.hotel_quebec + (10 * five_hotel.hotel_quebec)))
  • Sort Method: top-N heapsort Memory: 25kB
39. 0.058 0.116 ↑ 1.0 100 1

Nested Loop (cost=0.000..2.800 rows=100 width=8) (actual time=0.010..0.116 rows=100 loops=1)

40. 0.008 0.008 ↑ 1.0 10 1

CTE Scan on three_sierra_four quebec_three (cost=0.000..0.200 rows=10 width=4) (actual time=0.004..0.008 rows=10 loops=1)

41. 0.050 0.050 ↑ 1.0 10 10

CTE Scan on three_sierra_four five_hotel (cost=0.000..0.200 rows=10 width=4) (actual time=0.000..0.005 rows=10 loops=10)

42.          

CTE lima_zulu

43. 76.525 564.718 ↓ 67.3 159,195 1

Subquery Scan on kilo_quebec (cost=396,590.730..411,956.990 rows=2,364 width=8) (actual time=274.155..564.718 rows=159,195 loops=1)

  • Filter: (kilo_quebec.two_bravo = 1)
  • Rows Removed by Filter: 22,449
44. 142.103 488.193 ↑ 2.6 181,644 1

WindowAgg (cost=396,590.730..406,046.890 rows=472,808 width=12) (actual time=274.135..488.193 rows=181,644 loops=1)

45. 203.917 346.090 ↑ 2.6 181,644 1

Sort (cost=396,590.730..397,772.750 rows=472,808 width=12) (actual time=274.126..346.090 rows=181,644 loops=1)

  • Sort Key: zulu_mike_alpha.uniform_six, six_four.tango_four
  • Sort Method: external merge Disk: 3,896kB
46. 80.366 142.173 ↑ 2.6 181,644 1

Nested Loop (cost=0.560..343,944.960 rows=472,808 width=12) (actual time=0.042..142.173 rows=181,644 loops=1)

47. 0.019 0.019 ↑ 1.2 4 1

Seq Scan on three_uniform six_four (cost=0.000..1.360 rows=5 width=8) (actual time=0.013..0.019 rows=4 loops=1)

  • Filter: foxtrot_oscar
  • Rows Removed by Filter: 36
48. 61.788 61.788 ↑ 2.1 45,411 4

Index Scan using romeo_whiskey on seven zulu_mike_alpha (cost=0.560..67,843.100 rows=94,562 width=8) (actual time=0.016..15.447 rows=45,411 loops=4)

  • Index Cond: (two_zulu = six_four.two_zulu)
49.          

CTE five_mike

50. 1,102.520 19,125.736 ↑ 5.0 115,714 1

Merge Join (cost=1,200,589.390..311,025,311.370 rows=574,163 width=58) (actual time=12,840.452..19,125.736 rows=115,714 loops=1)

  • Merge Cond: ((three_sierra_india.five_uniform = four.five_uniform) AND (yankee_zulu.hotel_zulu = four.hotel_zulu))
51. 2,830.496 10,877.905 ↓ 1.7 746,044 1

Sort (cost=416,339.700..417,434.760 rows=438,025 width=50) (actual time=10,547.437..10,877.905 rows=746,044 loops=1)

  • Sort Key: three_sierra_india.five_uniform, yankee_zulu.hotel_zulu
  • Sort Method: external merge Disk: 42,408kB
52. 558.138 8,047.409 ↓ 1.7 746,044 1

Merge Left Join (cost=352,445.430..360,322.320 rows=438,025 width=50) (actual time=6,160.594..8,047.409 rows=746,044 loops=1)

  • Merge Cond: ((three_sierra_india.five_uniform = quebec_tango.five_uniform) AND (lima_zulu.two_zulu = quebec_tango.two_zulu))
53. 1,546.691 6,718.037 ↓ 1.7 732,658 1

Sort (cost=306,737.350..307,832.410 rows=438,025 width=40) (actual time=6,160.589..6,718.037 rows=732,658 loops=1)

  • Sort Key: three_sierra_india.five_uniform, lima_zulu.two_zulu
  • Sort Method: external merge Disk: 40,512kB
54. 468.724 5,171.346 ↓ 1.7 732,658 1

Hash Right Join (cost=249,466.260..253,712.470 rows=438,025 width=40) (actual time=4,316.915..5,171.346 rows=732,658 loops=1)

  • Hash Cond: (lima_zulu.uniform_six = three_sierra_india.uniform_six)
55. 660.247 660.247 ↓ 67.3 159,195 1

CTE Scan on lima_zulu (cost=0.000..47.280 rows=2,364 width=8) (actual time=274.159..660.247 rows=159,195 loops=1)

56. 361.961 4,042.375 ↓ 1.7 732,658 1

Hash (cost=240,567.950..240,567.950 rows=438,025 width=36) (actual time=4,042.375..4,042.375 rows=732,658 loops=1)

  • Buckets: 65,536 Batches: 16 Memory Usage: 3,756kB
57. 942.789 3,680.414 ↓ 1.7 732,658 1

Hash Join (cost=169,562.830..240,567.950 rows=438,025 width=36) (actual time=2,039.661..3,680.414 rows=732,658 loops=1)

  • Hash Cond: (three_sierra_india.three_echo = yankee_zulu.quebec_seven)
58. 703.528 782.234 ↓ 1.0 732,669 1

Bitmap Heap Scan on juliet_golf_foxtrot three_sierra_india (cost=23,293.350..68,600.970 rows=730,650 width=32) (actual time=83.850..782.234 rows=732,669 loops=1)

  • Recheck Cond: (foxtrot_two five_romeo NULL)
  • Filter: (foxtrot_three <= (('juliet_five'::cstring)::date + 'romeo_victor'::interval))
  • Rows Removed by Filter: 72
  • Heap Blocks: exact=28,102
59. 78.706 78.706 ↑ 1.0 734,436 1

Bitmap Index Scan on echo_november (cost=0.000..23,110.690 rows=734,881 width=0) (actual time=78.706..78.706 rows=734,436 loops=1)

  • Index Cond: (foxtrot_two five_romeo NULL)
60. 668.125 1,955.391 ↑ 1.0 1,961,043 1

Hash (cost=114,040.400..114,040.400 rows=1,964,406 width=8) (actual time=1,955.391..1,955.391 rows=1,961,043 loops=1)

  • Buckets: 131,072 Batches: 32 Memory Usage: 3,418kB
61. 1,287.266 1,287.266 ↑ 1.0 1,961,043 1

Seq Scan on sierra_four yankee_zulu (cost=0.000..114,040.400 rows=1,964,406 width=8) (actual time=0.006..1,287.266 rows=1,961,043 loops=1)

  • Filter: foxtrot_oscar
  • Rows Removed by Filter: 1,313,458
62. 139.526 771.234 ↓ 1.0 335,413 1

Materialize (cost=45,708.080..47,331.470 rows=324,677 width=22) (actual time=455.474..771.234 rows=335,413 loops=1)

63. 502.334 631.708 ↓ 1.0 324,798 1

Sort (cost=45,708.080..46,519.770 rows=324,677 width=22) (actual time=455.471..631.708 rows=324,798 loops=1)

  • Sort Key: quebec_tango.five_uniform, quebec_tango.two_zulu
  • Sort Method: external merge Disk: 10,168kB
64. 129.374 129.374 ↓ 1.0 324,798 1

Seq Scan on tango_charlie quebec_tango (cost=0.000..9,325.600 rows=324,677 width=22) (actual time=0.008..129.374 rows=324,798 loops=1)

  • Filter: (NOT whiskey_yankee)
  • Rows Removed by Filter: 167,240
65. 383.618 3,211.035 ↓ 1.1 940,959 1

Materialize (cost=783,751.710..788,083.850 rows=866,428 width=20) (actual time=2,292.870..3,211.035 rows=940,959 loops=1)

66. 1,379.523 2,827.417 ↑ 1.0 834,757 1

Sort (cost=783,751.710..785,917.780 rows=866,428 width=20) (actual time=2,292.865..2,827.417 rows=834,757 loops=1)

  • Sort Key: four.five_uniform, four.hotel_zulu
  • Sort Method: external merge Disk: 21,088kB
67. 585.542 1,447.894 ↑ 1.0 853,821 1

Hash Join (cost=660.110..680,531.960 rows=866,428 width=20) (actual time=13.739..1,447.894 rows=853,821 loops=1)

  • Hash Cond: (four.five_uniform = yankee_romeo.quebec_seven)
68. 848.647 848.647 ↑ 2.0 867,186 1

Seq Scan on charlie_sierra four (cost=0.000..664,709.960 rows=1,732,696 width=16) (actual time=0.010..848.647 rows=867,186 loops=1)

69. 3.160 13.705 ↓ 2.0 10,663 1

Hash (cost=592.440..592.440 rows=5,414 width=4) (actual time=13.705..13.705 rows=10,663 loops=1)

  • Buckets: 16,384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 503kB
70. 4.269 10.545 ↓ 2.0 10,663 1

Index Only Scan using yankee_oscar on yankee_romeo (cost=146.970..592.440 rows=5,414 width=4) (actual time=6.359..10.545 rows=10,663 loops=1)

  • Filter: (NOT (mike_mike delta_four 11))
  • Rows Removed by Filter: 171
  • Heap Fetches: 58
71.          

SubPlan (for Index Only Scan)

72. 0.117 6.276 ↑ 1.2 171 1

HashAggregate (cost=144.180..146.180 rows=200 width=4) (actual time=6.220..6.276 rows=171 loops=1)

  • Group Key: india_xray.five_uniform
73. 6.159 6.159 ↑ 37.5 171 1

CTE Scan on india_xray (cost=0.000..128.160 rows=6,408 width=4) (actual time=6.027..6.159 rows=171 loops=1)

74.          

SubPlan (for Merge Join)

75. 578.570 2,545.708 ↑ 1.0 1 115,714

Aggregate (cost=269.760..269.770 rows=1 width=4) (actual time=0.022..0.022 rows=1 loops=115,714)

76. 1,967.138 1,967.138 ↑ 6.9 11 115,714

Index Scan using quebec_victor on delta_charlie alpha_victor (cost=0.440..269.570 rows=76 width=4) (actual time=0.005..0.017 rows=11 loops=115,714)

  • Index Cond: (romeo_quebec = three_sierra_india.quebec_seven)
77. 578.570 1,388.568 ↑ 1.0 1 115,714

Aggregate (cost=269.760..269.770 rows=1 width=3) (actual time=0.012..0.012 rows=1 loops=115,714)

78. 809.998 809.998 ↑ 6.9 11 115,714

Index Scan using quebec_victor on delta_charlie echo_alpha (cost=0.440..269.570 rows=76 width=3) (actual time=0.002..0.007 rows=11 loops=115,714)

  • Index Cond: (romeo_quebec = three_sierra_india.quebec_seven)
79.          

CTE kilo_yankee_papa

80. 462.943 25,051.617 ↓ 4.0 691,068 1

Unique (cost=292,047.160..308,315.110 rows=172,249 width=170) (actual time=24,204.392..25,051.617 rows=691,068 loops=1)

81. 2,795.823 24,588.674 ↓ 1.4 783,773 1

Sort (cost=292,047.160..293,402.820 rows=542,265 width=170) (actual time=24,204.391..24,588.674 rows=783,773 loops=1)

  • Sort Key: mike_bravo.romeo_quebec, mike_bravo.november_juliet, mike_bravo.three_echo, mike_bravo.uniform_six, mike_bravo.foxtrot_three, mike_bravo.five_uniform, mike_bravo.uniform_quebec, (golf((mike_bravo.papa_india1xray_oscar + CASE WHEN (mike_bravo.tango_xray = 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE (mike_bravo.papa_india2six_oscar / mike_bravo.tango_xray) END))), mike_bravo.hotel_zulu, mike_bravo.tango_xray, alpha_xray.lima_hotel
  • Sort Method: external merge Disk: 54,312kB
82. 1,309.432 21,792.851 ↓ 1.4 783,773 1

Hash Anti Join (cost=84,293.880..194,063.610 rows=542,265 width=170) (actual time=13,331.329..21,792.851 rows=783,773 loops=1)

  • Hash Cond: (mike_bravo.uniform_six = delta_delta.uniform_six)
  • Join Filter: ((alpha_xray.lima_hotel >= delta_delta.foxtrot_three) AND (alpha_xray.lima_hotel <= lima_sierra((delta_delta.lima_romeo)::timestamp without time zone, (('juliet_five'::cstring)::date + 'oscar'::interval))))
  • Rows Removed by Join Filter: 526,963
83. 495.588 19,993.849 ↓ 1.4 809,751 1

Nested Loop (cost=0.000..50,239.290 rows=574,163 width=170) (actual time=12,840.628..19,993.849 rows=809,751 loops=1)

  • Join Filter: (mike_bravo.foxtrot_three <= alpha_xray.lima_hotel)
  • Rows Removed by Join Filter: 247
84. 19,266.833 19,266.833 ↑ 5.0 115,714 1

CTE Scan on five_mike mike_bravo (cost=0.000..11,483.260 rows=574,163 width=166) (actual time=12,840.455..19,266.833 rows=115,714 loops=1)

85. 231.428 231.428 ↓ 2.3 7 115,714

CTE Scan on sierra_juliet alpha_xray (cost=0.000..0.060 rows=3 width=4) (actual time=0.000..0.002 rows=7 loops=115,714)

86. 192.724 489.570 ↓ 1.0 538,536 1

Hash (cost=75,184.690..75,184.690 rows=524,015 width=12) (actual time=489.570..489.570 rows=538,536 loops=1)

  • Buckets: 131,072 Batches: 8 Memory Usage: 3,922kB
87. 237.122 296.846 ↓ 1.0 538,536 1

Bitmap Heap Scan on mike_charlie delta_delta (cost=24,261.540..75,184.690 rows=524,015 width=12) (actual time=65.999..296.846 rows=538,536 loops=1)

  • Recheck Cond: (five_yankee five_romeo NULL)
  • Heap Blocks: exact=33,398
88. 59.724 59.724 ↓ 1.0 541,831 1

Bitmap Index Scan on two_alpha (cost=0.000..24,130.540 rows=524,015 width=0) (actual time=59.724..59.724 rows=541,831 loops=1)

  • Index Cond: (five_yankee five_romeo NULL)
89.          

CTE juliet_tango

90. 72.759 26,622.405 ↓ 3.5 67,842 1

Subquery Scan on romeo_juliet (cost=355,405.710..359,042.060 rows=19,139 width=130) (actual time=26,325.632..26,622.405 rows=67,842 loops=1)

  • Filter: (bravo_hotel(victor4.november_juliet, (victor4.yankee_mike - lima_sierra(victor4.india_foxtrot, 'november_golf'::numeric))) > 'november_golf'::numeric)
  • Rows Removed by Filter: 9,582
91. 77.989 26,549.646 ↓ 1.3 77,424 1

WindowAgg (cost=355,405.710..358,132.970 rows=57,416 width=130) (actual time=26,325.619..26,549.646 rows=77,424 loops=1)

92. 34.191 26,471.657 ↓ 1.3 77,424 1

Subquery Scan on delta_uniform (cost=355,405.710..357,128.190 rows=57,416 width=130) (actual time=26,325.584..26,471.657 rows=77,424 loops=1)

93. 87.575 26,437.466 ↓ 1.3 77,424 1

WindowAgg (cost=355,405.710..356,554.030 rows=57,416 width=98) (actual time=26,325.583..26,437.466 rows=77,424 loops=1)

94. 84.811 26,349.891 ↓ 1.3 77,424 1

Sort (cost=355,405.710..355,549.250 rows=57,416 width=98) (actual time=26,325.569..26,349.891 rows=77,424 loops=1)

  • Sort Key: victor1.romeo_quebec, victor1.lima_hotel
  • Sort Method: external sort Disk: 3,176kB
95. 32.903 26,265.080 ↓ 1.3 77,424 1

Subquery Scan on kilo_yankee_seven (cost=345,858.200..347,724.220 rows=57,416 width=98) (actual time=26,157.878..26,265.080 rows=77,424 loops=1)

96. 51.175 26,232.177 ↓ 1.3 77,424 1

Group (cost=345,858.200..347,150.060 rows=57,416 width=69) (actual time=26,157.878..26,232.177 rows=77,424 loops=1)

  • Group Key: kilo_yankee_papa.romeo_quebec, kilo_yankee_papa.three_echo, kilo_yankee_papa.uniform_six, kilo_yankee_papa.five_uniform, ('delta_sierra'::text), kilo_yankee_papa.romeo_mike, kilo_yankee_papa.lima_hotel, (CASE WHEN (uniform_whiskey.november_juliet five_romeo NOT NULL) THEN uniform_whiskey.november_juliet ELSE kilo_yankee_papa.november_juliet END)
97. 126.374 26,181.002 ↓ 1.3 77,425 1

Sort (cost=345,858.200..346,001.740 rows=57,416 width=69) (actual time=26,157.876..26,181.002 rows=77,425 loops=1)

  • Sort Key: kilo_yankee_papa.romeo_quebec, kilo_yankee_papa.three_echo, kilo_yankee_papa.uniform_six, kilo_yankee_papa.five_uniform, ('delta_sierra'::text), kilo_yankee_papa.romeo_mike, kilo_yankee_papa.lima_hotel, (CASE WHEN (uniform_whiskey.november_juliet five_romeo NOT NULL) THEN uniform_whiskey.november_juliet ELSE kilo_yankee_papa.november_juliet END)
  • Sort Method: external sort Disk: 3,248kB
98. 286.408 26,054.628 ↓ 1.3 77,425 1

Nested Loop Left Join (cost=0.430..338,964.200 rows=57,416 width=69) (actual time=24,204.503..26,054.628 rows=77,425 loops=1)

  • Filter: ((kilo_yankee_papa.uniform_quebec ~~ juliet_golf_five('xray_alpha', echo_tango('delta_golf'::text, (kilo_yankee_papa.lima_hotel)::timestamp without time zone), 'xray_alpha')) OR (uniform_whiskey.november_juliet five_romeo NOT NULL))
  • Rows Removed by Filter: 71,186
99. 25,470.998 25,470.998 ↓ 2.6 148,611 1

CTE Scan on kilo_yankee_papa (cost=0.000..3,875.600 rows=57,416 width=98) (actual time=24,204.465..25,470.998 rows=148,611 loops=1)

  • Filter: (romeo_mike > 'november_golf'::numeric)
  • Rows Removed by Filter: 542,457
100. 297.222 297.222 ↓ 0.0 0 148,611

Index Scan using papa_yankee on kilo_four uniform_whiskey (cost=0.430..5.820 rows=1 width=11) (actual time=0.002..0.002 rows=0 loops=148,611)

  • Index Cond: ((romeo_quebec = kilo_yankee_papa.romeo_quebec) AND (zulu_mike_victor = kilo_yankee_papa.lima_hotel))
Planning time : 3.160 ms
Execution time : 26,733.987 ms