explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2UDD

Settings
# exclusive inclusive rows x rows loops node
1. 5.325 3,089.906 ↑ 1.0 30 1

Limit (cost=18,281,118.170..18,281,118.240 rows=30 width=120) (actual time=3,084.581..3,089.906 rows=30 loops=1)

2. 0.029 3,084.581 ↑ 3.6 30 1

Sort (cost=18,281,118.170..18,281,118.440 rows=109 width=120) (actual time=3,084.580..3,084.581 rows=30 loops=1)

  • Sort Key: "india_alpha".papa_foxtrot1 DESC, "india_alpha".papa_foxtrot2 DESC oscar_quebec papa_zulu
  • Sort Method: top-N heapsort Memory: 31kB
3. 0.077 3,084.552 ↓ 1.0 112 1

HashAggregate (cost=18,281,112.770..18,281,113.860 rows=109 width=120) (actual time=3,084.528..3,084.552 rows=112 loops=1)

  • Group Key: "india_alpha".quebec_seven, ('yankee_seven'::character varying), "india_alpha".india_five, "india_alpha".three_delta, "india_alpha".papa_foxtrot1, "india_alpha".papa_foxtrot2
4. 0.013 3,084.475 ↓ 1.0 112 1

Append (cost=17,353,105.080..18,281,111.130 rows=109 width=120) (actual time=1,342.953..3,084.475 rows=112 loops=1)

5. 0.009 1,342.994 ↓ 1.0 88 1

Subquery Scan on victor_victor (cost=17,353,105.080..17,353,109.160 rows=86 width=121) (actual time=1,342.952..1,342.994 rows=88 loops=1)

6. 0.046 1,342.985 ↓ 1.0 88 1

GroupAggregate (cost=17,353,105.080..17,353,108.300 rows=86 width=126) (actual time=1,342.951..1,342.985 rows=88 loops=1)

  • Group Key: quebec_sierra.juliet_delta_romeo, (CASE WHEN ((uniform_delta.tango_zulu <> 0) AND (quebec_sierra.india_hotel five_romeo NULL)) THEN ((((lima_sierra(quebec_sierra.lima_mike, 0) + lima_sierra(quebec_sierra.oscar_oscar, 'november_golf'::bigint)) + lima_sierra(quebec_sierra.tango_six, 'november_golf'::bigint)))::double precision / (uniform_delta.tango_zulu)::double precision) ELSE 'november_golf'::double precision END)
7. 0.109 1,342.939 ↓ 1.0 90 1

Sort (cost=17,353,105.080..17,353,105.290 rows=86 width=62) (actual time=1,342.935..1,342.939 rows=90 loops=1)

  • Sort Key: quebec_sierra.juliet_delta_romeo, (CASE WHEN ((uniform_delta.tango_zulu <> 0) AND (quebec_sierra.india_hotel five_romeo NULL)) THEN ((((lima_sierra(quebec_sierra.lima_mike, 0) + lima_sierra(quebec_sierra.oscar_oscar, 'november_golf'::bigint)) + lima_sierra(quebec_sierra.tango_six, 'november_golf'::bigint)))::double precision / (uniform_delta.tango_zulu)::double precision) ELSE 'november_golf'::double precision END)
  • Sort Method: quicksort Memory: 37kB
8. 0.080 1,342.830 ↓ 1.0 90 1

Hash Left Join (cost=333,845.540..17,353,102.320 rows=86 width=62) (actual time=300.729..1,342.830 rows=90 loops=1)

  • Hash Cond: ((quebec_sierra.juliet_delta_romeo)::text = (tango_tango.oscar_foxtrot)::text)
9. 1,016.518 1,082.468 ↓ 1.0 88 1

Nested Loop (cost=0.990..17,019,238.720 rows=86 width=313) (actual time=40.433..1,082.468 rows=88 loops=1)

10. 0.638 0.638 ↓ 1.2 628 1

Index Scan using delta_quebec on quebec_kilo uniform_delta (cost=0.420..1,774.110 rows=537 width=30) (actual time=0.012..0.638 rows=628 loops=1)

  • Index Cond: (papa_sierra_yankee = 6352)
11. 65.172 65.312 ↓ 0.0 0 628

Index Scan using echo_foxtrot on two_two quebec_sierra (cost=0.570..31,689.810 rows=7 width=330) (actual time=0.103..0.104 rows=0 loops=628)

  • Index Cond: (((hotel_quebec)::text = (uniform_delta.quebec_seven)::text) AND ((hotel_quebec)::text = ANY ('bravo_yankee'::text[])))
  • Filter: (((three_romeo five_romeo NOT FALSE) OR (four five_romeo NULL)) AND (romeo_mike five_romeo NOT TRUE) AND (NOT juliet_delta_yankee) AND (kilo_sierra <> november_november ('india_juliet'::integer[])) AND (india_sierra >= 'sierra_xray'::timestamp without time zone) AND (india_sierra <= 'papa_juliet'::timestamp without time zone) AND ((two_charlie)::text = ANY ('bravo_romeo'::text[])) AND ((echo_oscar five_romeo NULL) OR (NOT (delta_four_zulu 1))))
  • Rows Removed by Filter: 27
12.          

SubPlan (forIndex Scan)

13. 0.140 0.140 ↓ 0.0 0 10

Index Only Scan using victor_kilo on five_november foxtrot_bravo (cost=0.550..8.570 rows=1 width=0) (actual time=0.014..0.014 rows=0 loops=10)

  • Index Cond: (mike_whiskey = (quebec_sierra.echo_oscar)::text)
  • Heap Fetches: 4
14. 0.419 260.282 ↓ 1.1 1,810 1

Hash (cost=333,824.190..333,824.190 rows=1,629 width=41) (actual time=260.282..260.282 rows=1,810 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 146kB
15. 0.252 259.863 ↓ 1.7 2,838 1

Subquery Scan on tango_tango (cost=333,606.010..333,824.190 rows=1,629 width=41) (actual time=256.615..259.863 rows=2,838 loops=1)

16. 0.000 259.611 ↓ 1.7 2,838 1

Finalize GroupAggregate (cost=333,606.010..333,807.900 rows=1,629 width=111) (actual time=256.614..259.611 rows=2,838 loops=1)

  • Group Key: hotel_six.six_golf, hotel_six.oscar_foxtrot, kilo_foxtrot.quebec_seven
17. 0.000 259.967 ↓ 2.1 2,838 1

Gather Merge (cost=333,606.010..333,778.030 rows=1,358 width=111) (actual time=256.608..259.967 rows=2,838 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
18. 1.245 757.452 ↓ 1.4 946 3

Partial GroupAggregate (cost=332,605.990..332,621.260 rows=679 width=111) (actual time=251.981..252.484 rows=946 loops=3)

  • Group Key: hotel_six.six_golf, hotel_six.oscar_foxtrot, kilo_foxtrot.quebec_seven
19. 6.867 756.207 ↓ 2.7 1,815 3

Sort (cost=332,605.990..332,607.680 rows=679 width=136) (actual time=251.974..252.069 rows=1,815 loops=3)

  • Sort Key: hotel_six.six_golf, hotel_six.oscar_foxtrot, kilo_foxtrot.quebec_seven
  • Sort Method: quicksort Memory: 271kB
  • Worker 0: Sort Method: quicksort Memory: 266kB
  • Worker 1: Sort Method: quicksort Memory: 422kB
20. 2.220 749.340 ↓ 2.7 1,815 3

Nested Loop (cost=125,945.280..332,574.050 rows=679 width=136) (actual time=34.616..249.780 rows=1,815 loops=3)

21. 383.910 683.892 ↑ 4.1 958 3

Parallel Hash Join (cost=125,944.720..169,951.520 rows=3,950 width=136) (actual time=34.571..227.964 rows=958 loops=3)

  • Hash Cond: ((hotel_six.mike_whiskey)::text = (kilo_foxtrot.quebec_seven)::text)
22. 196.815 196.815 ↑ 1.3 661,003 3

Parallel Seq Scan on five_november hotel_six (cost=0.000..41,816.400 rows=834,440 width=99) (actual time=0.005..65.605 rows=661,003 loops=3)

23. 10.518 103.167 ↑ 1.3 11,781 3

Parallel Hash (cost=125,746.050..125,746.050 rows=15,893 width=37) (actual time=34.388..34.389 rows=11,781 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 3040kB
24. 84.956 92.649 ↑ 1.3 11,781 3

Parallel Bitmap Heap Scan on foxtrot_seven kilo_foxtrot (cost=724.040..125,746.050 rows=15,893 width=37) (actual time=10.898..30.883 rows=11,781 loops=3)

  • Recheck Cond: (delta_mike = 6352)
  • Heap Blocks: exact=9895
25. 7.693 7.693 ↑ 1.1 35,399 1

Bitmap Index Scan on sierra_lima (cost=0.000..714.500 rows=38,143 width=0) (actual time=7.693..7.693 rows=35,399 loops=1)

  • Index Cond: (delta_mike = 6352)
26. 63.228 63.228 ↑ 1.0 2 2,874

Index Scan using tango_india on victor_golf three_hotel (cost=0.560..41.150 rows=2 width=33) (actual time=0.016..0.022 rows=2 loops=2,874)

  • Index Cond: ((echo_oscar)::text = (hotel_six.mike_whiskey)::text)
  • Filter: ((hotel_quebec)::text = ANY ('bravo_yankee'::text[]))
  • Rows Removed by Filter: 0
27. 0.004 257.415 ↑ 1.0 22 1

Subquery Scan on echo_uniform (cost=438,256.410..438,257.400 rows=22 width=121) (actual time=257.404..257.415 rows=22 loops=1)

28. 0.014 257.411 ↑ 1.0 22 1

GroupAggregate (cost=438,256.410..438,257.180 rows=22 width=127) (actual time=257.402..257.411 rows=22 loops=1)

  • Group Key: golf1.juliet_delta_romeo, (CASE WHEN (whiskey_uniform1.bravo_echo <> 0) THEN (((lima_sierra(golf1.lima_mike, 0) + lima_sierra(golf1.victor_three, 0)))::double precision / (whiskey_uniform1.bravo_echo)::double precision) ELSE 'november_golf'::double precision END)
29. 0.035 257.397 ↑ 1.0 22 1

Sort (cost=438,256.410..438,256.470 rows=22 width=63) (actual time=257.396..257.397 rows=22 loops=1)

  • Sort Key: golf1.juliet_delta_romeo, (CASE WHEN (whiskey_uniform1.bravo_echo <> 0) THEN (((lima_sierra(golf1.lima_mike, 0) + lima_sierra(golf1.victor_three, 0)))::double precision / (whiskey_uniform1.bravo_echo)::double precision) ELSE 'november_golf'::double precision END)
  • Sort Method: quicksort Memory: 28kB
30. 0.016 257.362 ↑ 1.0 22 1

Hash Left Join (cost=345,003.940..438,255.920 rows=22 width=63) (actual time=256.796..257.362 rows=22 loops=1)

  • Hash Cond: ((golf1.juliet_delta_romeo)::text = (tango_foxtrot1.oscar_foxtrot)::text)
31. 0.026 28.851 ↑ 1.0 22 1

Hash Join (cost=11,159.380..104,406.540 rows=22 width=59) (actual time=28.292..28.851 rows=22 loops=1)

  • Hash Cond: ((golf1.hotel_quebec)::text = (whiskey_uniform1.quebec_seven)::text)
32. 0.982 28.026 ↑ 253.1 22 1

Bitmap Heap Scan on november_xray zulu_zulu (cost=9,378.550..102,611.100 rows=5,568 width=85) (actual time=27.475..28.026 rows=22 loops=1)

  • Recheck Cond: ((india_sierra >= 'sierra_xray'::timestamp without time zone) AND (india_sierra <= 'papa_juliet'::timestamp without time zone) AND ((hotel_quebec)::text = ANY ('bravo_yankee'::text[])))
  • Rows Removed by Index Recheck: 216
  • Filter: ((NOT juliet_delta_yankee) AND (kilo_sierra <> november_november ('india_juliet'::integer[])) AND ((two_charlie)::text = ANY ('november_tango'::text[])) AND ((echo_oscar five_romeo NULL) OR (NOT (delta_four_zulu 2))))
  • Rows Removed by Filter: 4
  • Heap Blocks: exact=12 lossy=33
33. 3.570 26.934 ↓ 0.0 0 1

BitmapAnd (cost=9,378.550..9,378.550 rows=7,192 width=0) (actual time=26.934..26.934 rows=0 loops=1)

34. 21.014 21.014 ↓ 1.1 138,153 1

Bitmap Index Scan on three_india (cost=0.000..2,960.060 rows=126,763 width=0) (actual time=21.013..21.014 rows=138,153 loops=1)

  • Index Cond: ((india_sierra >= 'sierra_xray'::timestamp without time zone) AND (india_sierra <= 'papa_juliet'::timestamp without time zone))
35. 2.350 2.350 ↑ 221.9 713 1

Bitmap Index Scan on sierra_oscar (cost=0.000..6,415.460 rows=158,218 width=0) (actual time=2.350..2.350 rows=713 loops=1)

  • Index Cond: ((hotel_quebec)::text = ANY ('bravo_yankee'::text[]))
36.          

SubPlan (forBitmap Heap Scan)

37. 0.110 0.110 ↓ 0.0 0 10

Index Only Scan using victor_kilo on five_november delta_four_papa (cost=0.550..8.570 rows=1 width=0) (actual time=0.011..0.011 rows=0 loops=10)

  • Index Cond: (mike_whiskey = (golf1.echo_oscar)::text)
  • Heap Fetches: 4
38. 0.113 0.799 ↓ 1.2 628 1

Hash (cost=1,774.110..1,774.110 rows=537 width=26) (actual time=0.799..0.799 rows=628 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
39. 0.686 0.686 ↓ 1.2 628 1

Index Scan using delta_quebec on quebec_kilo six_charlie (cost=0.420..1,774.110 rows=537 width=26) (actual time=0.017..0.686 rows=628 loops=1)

  • Index Cond: (papa_sierra_yankee = 6352)
40. 0.310 228.495 ↓ 1.1 1,810 1

Hash (cost=333,824.190..333,824.190 rows=1,629 width=41) (actual time=228.494..228.495 rows=1,810 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 146kB
41. 0.262 228.185 ↓ 1.7 2,838 1

Subquery Scan on zulu_victor (cost=333,606.010..333,824.190 rows=1,629 width=41) (actual time=224.933..228.185 rows=2,838 loops=1)

42. 0.000 227.923 ↓ 1.7 2,838 1

Finalize GroupAggregate (cost=333,606.010..333,807.900 rows=1,629 width=111) (actual time=224.932..227.923 rows=2,838 loops=1)

  • Group Key: two_juliet1.six_golf, two_juliet1.oscar_foxtrot, oscar_mike1.quebec_seven
43. 0.000 228.261 ↓ 2.1 2,838 1

Gather Merge (cost=333,606.010..333,778.030 rows=1,358 width=111) (actual time=224.926..228.261 rows=2,838 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
44. 1.161 661.353 ↓ 1.4 946 3

Partial GroupAggregate (cost=332,605.990..332,621.260 rows=679 width=111) (actual time=219.986..220.451 rows=946 loops=3)

  • Group Key: two_juliet1.six_golf, two_juliet1.oscar_foxtrot, oscar_mike1.quebec_seven
45. 6.465 660.192 ↓ 2.7 1,815 3

Sort (cost=332,605.990..332,607.680 rows=679 width=136) (actual time=219.979..220.064 rows=1,815 loops=3)

  • Sort Key: two_juliet1.six_golf, two_juliet1.oscar_foxtrot, oscar_mike1.quebec_seven
  • Sort Method: quicksort Memory: 331kB
  • Worker 0: Sort Method: quicksort Memory: 302kB
  • Worker 1: Sort Method: quicksort Memory: 277kB
46. 0.672 653.727 ↓ 2.7 1,815 3

Nested Loop (cost=125,945.280..332,574.050 rows=679 width=136) (actual time=35.060..217.909 rows=1,815 loops=3)

47. 304.335 592.701 ↑ 4.1 958 3

Parallel Hash Join (cost=125,944.720..169,951.520 rows=3,950 width=136) (actual time=35.021..197.567 rows=958 loops=3)

  • Hash Cond: ((two_juliet1.mike_whiskey)::text = (oscar_mike1.quebec_seven)::text)
48. 183.822 183.822 ↑ 1.3 661,003 3

Parallel Seq Scan on five_november india_kilo (cost=0.000..41,816.400 rows=834,440 width=99) (actual time=0.005..61.274 rows=661,003 loops=3)

49. 11.031 104.544 ↑ 1.3 11,781 3

Parallel Hash (cost=125,746.050..125,746.050 rows=15,893 width=37) (actual time=34.847..34.848 rows=11,781 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 3040kB
50. 85.661 93.513 ↑ 1.3 11,781 3

Parallel Bitmap Heap Scan on foxtrot_seven juliet_juliet (cost=724.040..125,746.050 rows=15,893 width=37) (actual time=10.582..31.171 rows=11,781 loops=3)

  • Recheck Cond: (delta_mike = 6352)
  • Heap Blocks: exact=11216
51. 7.852 7.852 ↑ 1.1 35,399 1

Bitmap Index Scan on sierra_lima (cost=0.000..714.500 rows=38,143 width=0) (actual time=7.852..7.852 rows=35,399 loops=1)

  • Index Cond: (delta_mike = 6352)
52. 60.354 60.354 ↑ 1.0 2 2,874

Index Scan using tango_india on victor_golf november_oscar (cost=0.560..41.150 rows=2 width=33) (actual time=0.015..0.021 rows=2 loops=2,874)

  • Index Cond: ((echo_oscar)::text = (two_juliet1.mike_whiskey)::text)
  • Filter: ((hotel_quebec)::text = ANY ('bravo_yankee'::text[]))
  • Rows Removed by Filter: 0
53. 0.001 1,484.053 ↓ 2.0 2 1

Subquery Scan on bravo_seven (cost=489,743.980..489,744.020 rows=1 width=121) (actual time=1,484.052..1,484.053 rows=2 loops=1)

54. 0.011 1,484.052 ↓ 2.0 2 1

GroupAggregate (cost=489,743.980..489,744.010 rows=1 width=125) (actual time=1,484.050..1,484.052 rows=2 loops=1)

  • Group Key: oscar_mike2.quebec_seven, (CASE WHEN (oscar_mike2.juliet_charlie = 3) THEN oscar_mike2.seven_foxtrot ELSE oscar_mike2.india_sierra END), 'november_golf'::double precision
55. 0.014 1,484.041 ↓ 2.0 2 1

Sort (cost=489,743.980..489,743.990 rows=1 width=69) (actual time=1,484.041..1,484.041 rows=2 loops=1)

  • Sort Key: oscar_mike2.quebec_seven, (CASE WHEN (oscar_mike2.juliet_charlie = 3) THEN oscar_mike2.seven_foxtrot ELSE oscar_mike2.india_sierra END)
  • Sort Method: quicksort Memory: 25kB
56. 0.013 1,484.027 ↓ 2.0 2 1

Nested Loop Semi Join (cost=335,321.630..489,743.970 rows=1 width=69) (actual time=573.017..1,484.027 rows=2 loops=1)

  • Join Filter: ((oscar_mike2.quebec_seven)::text = (sierra_alpha.echo_oscar)::text)
57. 0.000 883.312 ↓ 3.0 3 1

Nested Loop Left Join (cost=335,321.080..461,962.060 rows=1 width=98) (actual time=371.977..883.312 rows=3 loops=1)

  • Join Filter: ((oscar_mike2.quebec_seven)::text = (two_juliet2.six_golf)::text)
  • Rows Removed by Join Filter: 8514
58. 3.282 35.365 ↓ 3.0 3 1

Gather (cost=1,715.070..128,117.500 rows=1 width=90) (actual time=34.422..35.365 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
59. 0.006 32.083 ↑ 1.0 1 3

Nested Loop (cost=715.070..127,117.400 rows=1 width=90) (actual time=30.149..32.083 rows=1 loops=3)

60. 24.669 32.042 ↑ 5.0 1 3

Parallel Bitmap Heap Scan on foxtrot_seven charlie (cost=714.510..125,895.450 rows=5 width=57) (actual time=30.110..32.042 rows=1 loops=3)

  • Recheck Cond: (delta_mike = 6352)
  • Filter: ((NOT whiskey_yankee) AND mike_seven AND (india_sierra >= 'sierra_xray'::timestamp without time zone) AND (india_sierra <= 'papa_juliet'::timestamp without time zone) AND (two_charlie = ANY ('yankee_quebec'::integer[])))
  • Rows Removed by Filter: 11780
  • Heap Blocks: exact=9331
61. 7.373 7.373 ↑ 1.1 35,399 1

Bitmap Index Scan on sierra_lima (cost=0.000..714.500 rows=38,143 width=0) (actual time=7.373..7.373 rows=35,399 loops=1)

  • Index Cond: (delta_mike = 6352)
62. 0.035 0.035 ↑ 2.0 1 3

Index Scan using tango_india on victor_golf yankee_zulu (cost=0.560..244.370 rows=2 width=33) (actual time=0.034..0.035 rows=1 loops=3)

  • Index Cond: ((echo_oscar)::text = (oscar_mike2.quebec_seven)::text)
  • Filter: ((hotel_quebec)::text = ANY ('bravo_yankee'::text[]))
63. 0.402 848.337 ↓ 1.7 2,838 3

Finalize GroupAggregate (cost=333,606.010..333,807.900 rows=1,629 width=111) (actual time=279.998..282.779 rows=2,838 loops=3)

  • Group Key: two_juliet2.six_golf, two_juliet2.oscar_foxtrot, oscar_mike3.quebec_seven
64. 0.000 847.935 ↓ 2.1 2,838 3

Gather Merge (cost=333,606.010..333,778.030 rows=1,358 width=111) (actual time=279.991..282.645 rows=2,838 loops=3)

  • Workers Planned: 2
  • Workers Launched: 2
65. 3.528 2,160.928 ↓ 1.6 1,064 8

Partial GroupAggregate (cost=332,605.990..332,621.260 rows=679 width=111) (actual time=269.585..270.116 rows=1,064 loops=8)

  • Group Key: two_juliet2.six_golf, two_juliet2.oscar_foxtrot, oscar_mike3.quebec_seven
66. 20.536 2,157.400 ↓ 3.0 2,042 8

Sort (cost=332,605.990..332,607.680 rows=679 width=136) (actual time=269.576..269.675 rows=2,042 loops=8)

  • Sort Key: two_juliet2.six_golf, two_juliet2.oscar_foxtrot, oscar_mike3.quebec_seven
  • Sort Method: quicksort Memory: 275kB
  • Worker 0: Sort Method: quicksort Memory: 278kB
  • Worker 1: Sort Method: quicksort Memory: 406kB
67. 5.328 2,136.864 ↓ 3.0 2,042 8

Nested Loop (cost=125,945.280..332,574.050 rows=679 width=136) (actual time=35.891..267.108 rows=2,042 loops=8)

68. 1,024.736 1,924.608 ↑ 3.7 1,078 8

Parallel Hash Join (cost=125,944.720..169,951.520 rows=3,950 width=136) (actual time=35.848..240.576 rows=1,078 loops=8)

  • Hash Cond: ((two_juliet2.mike_whiskey)::text = (oscar_mike3.quebec_seven)::text)
69. 613.920 613.920 ↑ 1.1 743,629 8

Parallel Seq Scan on five_november papa_yankee (cost=0.000..41,816.400 rows=834,440 width=99) (actual time=0.005..76.740 rows=743,629 loops=8)

70. 33.432 285.952 ↑ 1.2 13,254 8

Parallel Hash (cost=125,746.050..125,746.050 rows=15,893 width=37) (actual time=35.744..35.744 rows=13,254 loops=8)

  • Buckets: 65536 Batches: 1 Memory Usage: 3040kB
71. 231.037 252.520 ↑ 1.2 13,254 8

Parallel Bitmap Heap Scan on foxtrot_seven papa_sierra_oscar (cost=724.040..125,746.050 rows=15,893 width=37) (actual time=9.684..31.565 rows=13,254 loops=8)

  • Recheck Cond: (delta_mike = 6352)
  • Heap Blocks: exact=37682
72. 21.483 21.483 ↑ 1.1 35,399 3

Bitmap Index Scan on sierra_lima (cost=0.000..714.500 rows=38,143 width=0) (actual time=7.161..7.161 rows=35,399 loops=3)

  • Index Cond: (delta_mike = 6352)
73. 206.928 206.928 ↑ 1.0 2 8,622

Index Scan using tango_india on victor_golf romeo_kilo (cost=0.560..41.150 rows=2 width=33) (actual time=0.018..0.024 rows=2 loops=8,622)

  • Index Cond: ((echo_oscar)::text = (two_juliet2.mike_whiskey)::text)
  • Filter: ((hotel_quebec)::text = ANY ('bravo_yankee'::text[]))
  • Rows Removed by Filter: 0
74. 600.702 600.702 ↑ 1.0 1 3

Index Scan using yankee_tango on seven_kilo sierra_alpha (cost=0.560..27,781.900 rows=1 width=33) (actual time=200.234..200.234 rows=1 loops=3)

  • Index Cond: ((echo_oscar)::text = (yankee_zulu.echo_oscar)::text)
  • Filter: (uniform_xray five_romeo NULL)