explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hqtk : req1_upd

Settings
# exclusive inclusive rows x rows loops node
1. 1,140,182.845 26,412,061.919 ↓ 1,134,418,246.0 1,134,418,246 1

Gather (cost=1,048.470..146,221.160 rows=1 width=137) (actual time=130.501..26,412,061.919 rows=1,134,418,246 loops=1)

  • Output: charlie_lima.bravo_juliet_victor, juliet_zulu.romeo_india, kilo_uniform.papa_mike, charlie_lima.romeo_echo, charlie_lima.papa_sierra_victor, charlie_lima.bravo_xray, charlie_lima.charlie_oscar, charlie_lima.juliet_tango, charlie_lima.mike_seven, charlie_lima.papa_november, ("zulu_quebec"((charlie_lima.alpha_echo)::text, 4)), charlie_lima.papa_two, charlie_lima.five_bravo, charlie_lima.yankee_yankee_sierra
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=24226263320 read=7284
2. 10,304,706.900 25,271,879.074 ↓ 378,139,415.0 378,139,415 3

Nested Loop Semi Join (cost=48.470..145,221.060 rows=1 width=137) (actual time=376.362..25,271,879.074 rows=378,139,415 loops=3)

  • Output: charlie_lima.bravo_juliet_victor, juliet_zulu.romeo_india, kilo_uniform.papa_mike, charlie_lima.romeo_echo, charlie_lima.papa_sierra_victor, charlie_lima.bravo_xray, charlie_lima.charlie_oscar, charlie_lima.juliet_tango, charlie_lima.mike_seven, charlie_lima.papa_november, "zulu_quebec"((charlie_lima.alpha_echo)::text, 4), charlie_lima.papa_two, charlie_lima.five_bravo, charlie_lima.yankee_yankee_sierra
  • Buffers: shared hit=24226263320 read=7284
  • Worker 0: actual time=852.862..24895197.938 rows=364763098 loops=1
  • Buffers: shared hit=8012122462 read=2794
  • Worker 1: actual time=147.210..24959653.421 rows=373601653 loops=1
  • Buffers: shared hit=7984684483 read=3122
3. 3,833,528.523 14,967,172.148 ↓ 378,139,415.0 378,139,415 3

Nested Loop (cost=47.630..145,205.670 rows=1 width=147) (actual time=376.274..14,967,172.148 rows=378,139,415 loops=3)

  • Output: charlie_lima.bravo_juliet_victor, charlie_lima.romeo_echo, charlie_lima.papa_sierra_victor, charlie_lima.bravo_xray, charlie_lima.charlie_oscar, charlie_lima.juliet_tango, charlie_lima.mike_seven, charlie_lima.papa_november, charlie_lima.alpha_echo, charlie_lima.papa_two, charlie_lima.five_bravo, charlie_lima.yankee_yankee_sierra, juliet_zulu.romeo_india, kilo_uniform.papa_mike, quebec_sierra.romeo_echo, romeo_yankee.romeo_echo, xray_seven.romeo_echo
  • Buffers: shared hit=14016499105 read=7282
  • Worker 0: actual time=852.784..14976535.236 rows=364763098 loops=1
  • Buffers: shared hit=4729254581 read=2792
  • Worker 1: actual time=147.112..14846721.867 rows=373601653 loops=1
  • Buffers: shared hit=4622269605 read=3122
4. 1,422,187.156 11,133,643.616 ↓ 378,139,415.0 378,139,415 3

Nested Loop (cost=47.630..145,202.380 rows=1 width=151) (actual time=376.230..11,133,643.616 rows=378,139,415 loops=3)

  • Output: charlie_lima.bravo_juliet_victor, charlie_lima.romeo_echo, charlie_lima.papa_sierra_victor, charlie_lima.bravo_xray, charlie_lima.charlie_oscar, charlie_lima.juliet_tango, charlie_lima.mike_seven, charlie_lima.papa_november, charlie_lima.alpha_echo, charlie_lima.papa_two, charlie_lima.five_bravo, charlie_lima.yankee_yankee_sierra, juliet_zulu.romeo_india, kilo_uniform.papa_mike, quebec_sierra.papa_alpha, quebec_sierra.romeo_echo, romeo_yankee.romeo_echo, xray_seven.romeo_echo
  • Inner Unique: true
  • Buffers: shared hit=11747662613 read=7282
  • Worker 0: actual time=852.717..11295034.708 rows=364763098 loops=1
  • Buffers: shared hit=3999728385 read=2792
  • Worker 1: actual time=147.069..11068936.406 rows=373601653 loops=1
  • Buffers: shared hit=3875066299 read=3122
5. 8,977,304.878 9,711,456.457 ↓ 378,326,744.0 378,326,744 3

Nested Loop (cost=47.350..145,198.390 rows=1 width=161) (actual time=149.437..9,711,456.457 rows=378,326,744 loops=3)

  • Output: charlie_lima.bravo_juliet_victor, charlie_lima.romeo_echo, charlie_lima.papa_sierra_victor, charlie_lima.bravo_xray, charlie_lima.charlie_oscar, charlie_lima.juliet_tango, charlie_lima.mike_seven, charlie_lima.papa_november, charlie_lima.alpha_echo, charlie_lima.papa_two, charlie_lima.five_bravo, charlie_lima.yankee_yankee_sierra, juliet_zulu.romeo_india, kilo_uniform.papa_mike, bravo_quebec_alpha.charlie_oscar, quebec_sierra.papa_alpha, quebec_sierra.romeo_echo, romeo_yankee.romeo_echo, xray_seven.charlie_oscar, xray_seven.romeo_echo
  • Join Filter: ((xray_seven.charlie_oscar)::text = (bravo_quebec_alpha.charlie_oscar)::text)
  • Buffers: shared hit=9477702144 read=7282
  • Worker 0: actual time=172.455..9940160.875 rows=365090782 loops=1
  • Buffers: shared hit=3269546819 read=2792
  • Worker 1: actual time=147.009..9666679.254 rows=373684916 loops=1
  • Buffers: shared hit=3127696465 read=3122
6. 487,925.588 734,151.566 ↓ 685,906,353.0 685,906,353 3

Nested Loop (cost=46.780..145,193.920 rows=1 width=168) (actual time=139.839..734,151.566 rows=685,906,353 loops=3)

  • Output: charlie_lima.bravo_juliet_victor, charlie_lima.romeo_echo, charlie_lima.papa_sierra_victor, charlie_lima.bravo_xray, charlie_lima.charlie_oscar, charlie_lima.juliet_tango, charlie_lima.mike_seven, charlie_lima.papa_november, charlie_lima.alpha_echo, charlie_lima.papa_two, charlie_lima.five_bravo, charlie_lima.yankee_yankee_sierra, juliet_zulu.romeo_india, kilo_uniform.papa_mike, quebec_sierra.papa_alpha, quebec_sierra.romeo_echo, six_oscar.alpha_echo, romeo_yankee.romeo_echo, xray_seven.charlie_oscar, xray_seven.romeo_echo
  • Buffers: shared hit=1086175537 read=7281
  • Worker 0: actual time=161.754..695287.745 rows=715967089 loops=1
  • Buffers: shared hit=362342463 read=2792
  • Worker 1: actual time=135.982..779073.729 rows=674830753 loops=1
  • Buffers: shared hit=373397384 read=3121
7. 9,722.600 246,225.698 ↓ 1,208,654.0 1,208,654 3

Nested Loop (cost=46.340..144,855.300 rows=1 width=170) (actual time=139.772..246,225.698 rows=1,208,654 loops=3)

  • Output: charlie_lima.bravo_juliet_victor, charlie_lima.romeo_echo, charlie_lima.papa_sierra_victor, charlie_lima.bravo_xray, charlie_lima.charlie_oscar, charlie_lima.juliet_tango, charlie_lima.mike_seven, charlie_lima.papa_november, charlie_lima.alpha_echo, charlie_lima.papa_two, charlie_lima.five_bravo, charlie_lima.yankee_yankee_sierra, juliet_zulu.romeo_india, kilo_uniform.papa_mike, quebec_sierra.papa_alpha, quebec_sierra.papa_five, quebec_sierra.romeo_echo, romeo_yankee.romeo_echo, xray_seven.charlie_oscar, xray_seven.romeo_echo
  • Inner Unique: true
  • Buffers: shared hit=128207197 read=7281
  • Worker 0: actual time=161.687..202922.967 rows=1132712 loops=1
  • Buffers: shared hit=34975671 read=2792
  • Worker 1: actual time=135.915..298579.208 rows=1328016 loops=1
  • Buffers: shared hit=52314179 read=3121
8. 10,918.126 236,503.091 ↓ 1,208,654.0 1,208,654 3

Nested Loop (cost=45.930..144,851.150 rows=1 width=146) (actual time=139.687..236,503.091 rows=1,208,654 loops=3)

  • Output: charlie_lima.bravo_juliet_victor, charlie_lima.romeo_echo, charlie_lima.papa_sierra_victor, charlie_lima.bravo_xray, charlie_lima.charlie_oscar, charlie_lima.juliet_tango, charlie_lima.mike_seven, charlie_lima.papa_november, charlie_lima.alpha_echo, charlie_lima.papa_two, charlie_lima.five_bravo, charlie_lima.yankee_yankee_sierra, juliet_zulu.romeo_india, quebec_sierra.papa_alpha, quebec_sierra.papa_five, quebec_sierra.romeo_echo, romeo_yankee.romeo_echo, xray_seven.charlie_oscar, xray_seven.romeo_echo
  • Inner Unique: true
  • Buffers: shared hit=117329312 read=7278
  • Worker 0: actual time=161.609..193773.368 rows=1132712 loops=1
  • Buffers: shared hit=31577534 read=2791
  • Worker 1: actual time=135.841..288033.079 rows=1328016 loops=1
  • Buffers: shared hit=48330129 read=3121
9. 224,998.067 225,584.957 ↓ 1,208,654.0 1,208,654 3

Nested Loop (cost=45.510..144,846.990 rows=1 width=138) (actual time=139.629..225,584.957 rows=1,208,654 loops=3)

  • Output: charlie_lima.bravo_juliet_victor, charlie_lima.romeo_echo, charlie_lima.papa_sierra_victor, charlie_lima.bravo_xray, charlie_lima.charlie_oscar, charlie_lima.juliet_tango, charlie_lima.mike_seven, charlie_lima.papa_november, charlie_lima.alpha_echo, charlie_lima.papa_two, charlie_lima.five_bravo, charlie_lima.yankee_yankee_sierra, quebec_sierra.papa_alpha, quebec_sierra.papa_five, quebec_sierra.romeo_echo, romeo_yankee.romeo_echo, xray_seven.charlie_oscar, xray_seven.romeo_echo
  • Buffers: shared hit=106451429 read=7273
  • Worker 0: actual time=161.554..183479.723 rows=1132712 loops=1
  • Buffers: shared hit=28179396 read=2791
  • Worker 1: actual time=135.786..276144.319 rows=1328016 loops=1
  • Buffers: shared hit=44346079 read=3121
10. 188.677 586.340 ↓ 882.5 407,725 3

Merge Join (cost=44.940..9,006.320 rows=462 width=61) (actual time=94.568..586.340 rows=407,725 loops=3)

  • Output: quebec_sierra.papa_alpha, quebec_sierra.papa_five, quebec_sierra.romeo_echo, romeo_yankee.romeo_echo, xray_seven.romeo_papa, xray_seven.charlie_oscar, xray_seven.romeo_echo
  • Inner Unique: true
  • Merge Cond: (xray_seven.romeo_echo = romeo_yankee.romeo_echo)
  • Buffers: shared hit=49482 read=60
  • Worker 0: actual time=106.870..409.329 rows=228270 loops=1
  • Buffers: shared hit=11824 read=5
  • Worker 1: actual time=104.342..777.520 rows=611223 loops=1
  • Buffers: shared hit=21727 read=15
11. 169.562 346.044 ↓ 250.4 407,725 3

Merge Join (cost=15.290..3,140.130 rows=1,628 width=51) (actual time=2.204..346.044 rows=407,725 loops=3)

  • Output: quebec_sierra.papa_alpha, quebec_sierra.papa_five, quebec_sierra.romeo_echo, xray_seven.romeo_papa, xray_seven.charlie_oscar, xray_seven.romeo_echo
  • Merge Cond: (xray_seven.romeo_echo = quebec_sierra.romeo_echo)
  • Buffers: shared hit=47976 read=16
  • Worker 0: actual time=0.124..215.904 rows=228270 loops=1
  • Buffers: shared hit=11309 read=3
  • Worker 1: actual time=0.527..481.882 rows=611223 loops=1
  • Buffers: shared hit=21223 read=2
12. 41.598 41.598 ↓ 1.8 59,380 3

Parallel Index Only Scan using echo_four on three_november_quebec (cost=0.560..2,930.400 rows=33,923 width=23) (actual time=2.115..41.598 rows=59,380 loops=3)

  • Output: xray_seven.papa_alpha, xray_seven.romeo_echo, xray_seven.charlie_oscar, xray_seven.romeo_papa
  • Index Cond: (xray_seven.papa_alpha = 'echo_delta'::bpchar)
  • Heap Fetches: 0
  • Buffers: shared hit=41667 read=3
  • Worker 0: actual time=0.039..24.462 rows=35160 loops=1
  • Buffers: shared hit=9804
  • Worker 1: actual time=0.454..57.148 rows=83888 loops=1
  • Buffers: shared hit=17919 read=1
13. 134.884 134.884 ↓ 169.7 409,072 3

Index Only Scan using tango_bravo on quebec_alpha (cost=0.420..102.610 rows=2,411 width=28) (actual time=0.083..134.884 rows=409,072 loops=3)

  • Output: quebec_sierra.papa_alpha, quebec_sierra.romeo_echo, quebec_sierra.papa_five
  • Index Cond: (quebec_sierra.papa_alpha = 'echo_delta'::bpchar)
  • Heap Fetches: 0
  • Buffers: shared hit=6309 read=13
  • Worker 0: actual time=0.078..83.977 rows=229737 loops=1
  • Buffers: shared hit=1505 read=3
  • Worker 1: actual time=0.067..180.582 rows=612444 loops=1
  • Buffers: shared hit=3304 read=1
14. 51.619 51.619 ↑ 1.3 133,668 3

Index Only Scan using foxtrot_juliet on bravo_quebec_bravo (cost=0.420..5,402.780 rows=177,224 width=10) (actual time=2.797..51.619 rows=133,668 loops=3)

  • Output: romeo_yankee.romeo_echo
  • Heap Fetches: 0
  • Buffers: shared hit=1506 read=44
  • Worker 0: actual time=2.759..51.219 rows=133699 loops=1
  • Buffers: shared hit=515 read=2
  • Worker 1: actual time=2.852..49.612 rows=133653 loops=1
  • Buffers: shared hit=504 read=13
15. 0.550 0.550 ↓ 3.0 3 1,223,175

Index Scan using romeo_alpha on oscar_india (cost=0.570..294.020 rows=1 width=93) (actual time=0.497..0.550 rows=3 loops=1,223,175)

  • Output: charlie_lima.papa_alpha, charlie_lima.romeo_papa, charlie_lima.yankee_yankee_sierra, charlie_lima.quebec_quebec, charlie_lima.delta_charlie, charlie_lima.romeo_echo, charlie_lima.kilo_india, charlie_lima.alpha_echo, charlie_lima.five_bravo, charlie_lima.charlie_oscar, charlie_lima.papa_two, charlie_lima.bravo_xray, charlie_lima.papa_sierra_victor, charlie_lima.juliet_tango, charlie_lima.mike_seven, charlie_lima.victor_xray, charlie_lima.bravo_juliet_victor, charlie_lima.papa_november, charlie_lima.five_seven, charlie_lima.yankee_yankee_six
  • Index Cond: ((charlie_lima.romeo_papa = xray_seven.romeo_papa) AND ((charlie_lima.charlie_oscar)::text = (xray_seven.charlie_oscar)::text))
  • Filter: ((charlie_lima.yankee_yankee_sierra = 'zulu_india'::numeric) AND ((charlie_lima.kilo_india)::text = 'hotel_zulu'::text) AND (charlie_lima.five_bravo = 'uniform_xray'::bpchar) AND (charlie_lima.papa_alpha = 'echo_delta'::bpchar) AND (xray_seven.romeo_echo = charlie_lima.bravo_juliet_victor))
  • Rows Removed by Filter: 36
  • Buffers: shared hit=106401947 read=7213
  • Worker 0: actual time=0.709..0.798 rows=5 loops=228270
  • Buffers: shared hit=28167572 read=2786
  • Worker 1: actual time=0.412..0.449 rows=2 loops=611223
  • Buffers: shared hit=44324352 read=3106
16. 0.008 0.008 ↑ 1.0 1 3,625,961

Index Only Scan using kilo_charlie on bravo_quebec_bravo juliet_zulu (cost=0.420..4.160 rows=1 width=18) (actual time=0.008..0.008 rows=1 loops=3,625,961)

  • Output: juliet_zulu.romeo_echo, juliet_zulu.romeo_india
  • Index Cond: (juliet_zulu.romeo_echo = charlie_lima.romeo_echo)
  • Heap Fetches: 0
  • Buffers: shared hit=10877883 read=5
  • Worker 0: actual time=0.008..0.008 rows=1 loops=1132712
  • Buffers: shared hit=3398138
  • Worker 1: actual time=0.008..0.008 rows=1 loops=1328016
  • Buffers: shared hit=3984050
17. 0.007 0.007 ↑ 1.0 1 3,625,961

Index Only Scan using zulu_xray_golf on quebec_uniform kilo_uniform (cost=0.410..4.150 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=3,625,961)

  • Output: kilo_uniform.romeo_india, kilo_uniform.papa_mike
  • Index Cond: (kilo_uniform.romeo_india = juliet_zulu.romeo_india)
  • Heap Fetches: 0
  • Buffers: shared hit=10877885 read=3
  • Worker 0: actual time=0.007..0.007 rows=1 loops=1132712
  • Buffers: shared hit=3398137 read=1
  • Worker 1: actual time=0.007..0.007 rows=1 loops=1328016
  • Buffers: shared hit=3984050
18. 0.280 0.280 ↓ 4.6 567 3,625,961

Index Scan using lima_three on juliet_three (cost=0.430..337.370 rows=124 width=26) (actual time=0.014..0.280 rows=567 loops=3,625,961)

  • Output: six_oscar.papa_alpha, six_oscar.alpha_echo, six_oscar.romeo_four, six_oscar.tango_whiskey, six_oscar.uniform_bravo, six_oscar.victor_xray, six_oscar.tango_five, six_oscar.papa_two, six_oscar.sierra_yankee, six_oscar.delta_oscar, six_oscar.delta_yankee, six_oscar.bravo_golf, six_oscar.sierra_six, six_oscar.tango_kilo, six_oscar.seven_quebec, six_oscar.yankee_tango, six_oscar.juliet_seven, six_oscar.sierra_kilo, six_oscar.delta_two_xray, six_oscar.uniform_hotel, six_oscar.zulu_whiskey, six_oscar.india_whiskey_tango, six_oscar.papa_five, six_oscar.hotel_two, six_oscar.sierra_five, six_oscar.golf_mike, six_oscar.india_xray, six_oscar.juliet_delta_november, six_oscar.six_romeo, six_oscar.mike_six, six_oscar.india_oscar, six_oscar.quebec_papa, six_oscar.quebec_two, six_oscar.foxtrot_golf, six_oscar.victor_seven, six_oscar.yankee_yankee_sierra
  • Index Cond: (six_oscar.papa_five = quebec_sierra.papa_five)
  • Buffers: shared hit=957968340
  • Worker 0: actual time=0.015..0.302 rows=632 loops=1132712
  • Buffers: shared hit=327366792
  • Worker 1: actual time=0.014..0.253 rows=508 loops=1328016
  • Buffers: shared hit=321083205
19. 0.013 0.013 ↑ 3.0 1 2,057,719,059

Index Only Scan using charlie_four on four_sierra (cost=0.570..4.440 rows=3 width=17) (actual time=0.012..0.013 rows=1 loops=2,057,719,059)

  • Output: bravo_quebec_alpha.alpha_echo, bravo_quebec_alpha.charlie_oscar
  • Index Cond: ((bravo_quebec_alpha.alpha_echo = six_oscar.alpha_echo) AND (bravo_quebec_alpha.charlie_oscar = (charlie_lima.charlie_oscar)::text))
  • Heap Fetches: 0
  • Buffers: shared hit=8391526607 read=1
  • Worker 0: actual time=0.012..0.012 rows=1 loops=715967089
  • Buffers: shared hit=2907204356
  • Worker 1: actual time=0.013..0.013 rows=1 loops=674830753
  • Buffers: shared hit=2754299081 read=1
20. 0.003 0.003 ↑ 1.0 1 1,134,980,232

Index Only Scan using five_oscar on golf_two (cost=0.280..3.980 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=1,134,980,232)

  • Output: four_six.charlie_oscar, four_six.zulu_alpha
  • Index Cond: (four_six.charlie_oscar = (bravo_quebec_alpha.charlie_oscar)::text)
  • Filter: (four_six.zulu_alpha <> november_november_bravo ('whiskey_whiskey'::bpchar[]))
  • Rows Removed by Filter: 0
  • Heap Fetches: 0
  • Buffers: shared hit=2269960469
  • Worker 0: actual time=0.003..0.003 rows=1 loops=365090782
  • Buffers: shared hit=730181566
  • Worker 1: actual time=0.003..0.003 rows=1 loops=373684916
  • Buffers: shared hit=747369834
21. 0.009 0.009 ↑ 1.0 1 1,134,418,246

Seq Scan on hotel_bravo seven_whiskey (cost=0.000..3.290 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=1,134,418,246)

  • Output: seven_whiskey.papa_alpha, seven_whiskey.oscar_xray, seven_whiskey.kilo_zulu, seven_whiskey.alpha_charlie, seven_whiskey.hotel_two, seven_whiskey.victor_five, seven_whiskey.charlie_tango, seven_whiskey.lima_kilo, seven_whiskey.uniform_golf
  • Filter: (seven_whiskey.oscar_xray = 'echo_delta'::bpchar)
  • Rows Removed by Filter: 102
  • Buffers: shared hit=2268836492
  • Worker 0: actual time=0.009..0.009 rows=1 loops=364763098
  • Buffers: shared hit=729526196
  • Worker 1: actual time=0.009..0.009 rows=1 loops=373601653
  • Buffers: shared hit=747203306
22. 0.000 0.026 ↑ 1.0 1 1,134,418,246

Nested Loop (cost=0.840..15.370 rows=1 width=20) (actual time=0.026..0.026 rows=1 loops=1,134,418,246)

  • Output: india_three1.romeo_echo, uniform_four1.romeo_echo
  • Buffers: shared hit=10209764215 read=2
  • Worker 0: actual time=0.026..0.026 rows=1 loops=364763098
  • Buffers: shared hit=3282867881 read=2
  • Worker 1: actual time=0.026..0.026 rows=1 loops=373601653
  • Buffers: shared hit=3362414878
23. 0.001 0.017 ↑ 1.0 1 1,134,418,246

Nested Loop (cost=0.840..12.070 rows=1 width=24) (actual time=0.017..0.017 rows=1 loops=1,134,418,246)

  • Output: india_three1.romeo_echo, uniform_four1.papa_alpha, uniform_four1.romeo_echo
  • Buffers: shared hit=7940927723 read=2
  • Worker 0: actual time=0.017..0.017 rows=1 loops=364763098
  • Buffers: shared hit=2553341685 read=2
  • Worker 1: actual time=0.017..0.017 rows=1 loops=373601653
  • Buffers: shared hit=2615211572
24. 0.008 0.008 ↑ 1.0 1 1,134,418,246

Index Scan using kilo_charlie on bravo_quebec_bravo hotel_tango (cost=0.420..7.890 rows=1 width=10) (actual time=0.008..0.008 rows=1 loops=1,134,418,246)

  • Output: india_three1.papa_alpha, india_three1.romeo_echo, india_three1.bravo_xray, india_three1.uniform_yankee, india_three1.oscar_whiskey_three, india_three1.november_november_five, india_three1.papa_five, india_three1.three_quebec, india_three1.yankee_yankee_papa, india_three1.november_juliet, india_three1.november_lima, india_three1.india_whiskey_lima, india_three1.uniform_uniform, india_three1.bravo_two, india_three1.alpha_four, india_three1.xray_golf, india_three1.whiskey_six, india_three1.three_delta, india_three1.kilo_seven, india_three1.mike_five, india_three1.papa_sierra_india, india_three1.tango_seven, india_three1.quebec_kilo, india_three1.bravo_three, india_three1.whiskey_foxtrot, india_three1.oscar_whiskey_mike, india_three1.charlie_charlie1, india_three1.charlie_charlie2, india_three1.victor_lima, india_three1.papa_sierra_victor, india_three1.kilo_oscar, india_three1.whiskey_four, india_three1.romeo_golf, india_three1.india_two, india_three1.uniform_oscar, india_three1.oscar_delta, india_three1.seven_bravo, india_three1.tango_romeo, india_three1.foxtrot_romeo, india_three1.tango_papa, india_three1.tango_golf, india_three1.six_charlie, india_three1.romeo_india, india_three1.delta_two_sierra, india_three1.echo_yankee, india_three1.seven_charlie, india_three1.golf_bravo, india_three1.xray_mike, india_three1.zulu_victor, india_three1.echo_six, india_three1.six_tango_foxtrot, india_three1.bravo_five, india_three1.five_alpha, india_three1.three_november_hotel, india_three1.hotel_two, india_three1.mike_november, india_three1.mike_zulu, india_three1.hotel_xray, india_three1.four_golf, india_three1.bravo_juliet_uniform, india_three1.romeo_uniform, india_three1.kilo_lima, india_three1.uniform_juliet, india_three1.bravo_zulu, india_three1.bravo_zulu2, india_three1.bravo_zulu3, india_three1.oscar_lima, india_three1.alpha_foxtrot, india_three1.oscar_oscar, india_three1.six_four, india_three1.delta_yankee, india_three1.two, india_three1.three_seven, india_three1.india_lima, india_three1.juliet_delta_oscar, india_three1.foxtrot_quebec, india_three1.juliet_lima, india_three1.delta_echo, india_three1.hotel_charlie, india_three1.whiskey_november, india_three1.romeo_charlie, india_three1.foxtrot_six, india_three1.seven_sierra, india_three1.bravo_four, india_three1.oscar_four, india_three1.echo_bravo, india_three1.zulu_xray_victor, india_three1.quebec_lima, india_three1.victor_romeo, india_three1.uniform_delta, india_three1.sierra_golf, india_three1.mike_delta, india_three1.delta_zulu, india_three1.foxtrot_two, india_three1.whiskey_zulu
  • Index Cond: (india_three1.romeo_echo = xray_seven.romeo_echo)
  • Filter: ((india_three1.india_whiskey_lima = ANY ('bravo_charlie'::bpchar[])) AND (india_three1.bravo_xray = 'six_tango_zulu'::bpchar) AND (india_three1.three_seven = 'alpha_whiskey'::bpchar))
  • Buffers: shared hit=4537672982 read=2
  • Worker 0: actual time=0.008..0.008 rows=1 loops=364763098
  • Buffers: shared hit=1459052390 read=2
  • Worker 1: actual time=0.008..0.008 rows=1 loops=373601653
  • Buffers: shared hit=1494406612
25. 0.008 0.008 ↑ 1.0 1 1,134,418,246

Index Only Scan using tango_bravo on quebec_alpha papa_victor (cost=0.420..4.170 rows=1 width=14) (actual time=0.008..0.008 rows=1 loops=1,134,418,246)

  • Output: uniform_four1.papa_alpha, uniform_four1.romeo_echo, uniform_four1.papa_five
  • Index Cond: ((uniform_four1.papa_alpha = 'echo_delta'::bpchar) AND (uniform_four1.romeo_echo = india_three1.romeo_echo))
  • Heap Fetches: 0
  • Buffers: shared hit=3403254741
  • Worker 0: actual time=0.008..0.008 rows=1 loops=364763098
  • Buffers: shared hit=1094289295
  • Worker 1: actual time=0.008..0.008 rows=1 loops=373601653
  • Buffers: shared hit=1120804960
26. 0.009 0.009 ↑ 1.0 1 1,134,418,246

Seq Scan on hotel_bravo juliet_five (cost=0.000..3.290 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=1,134,418,246)

  • Output: five_whiskey1.papa_alpha, five_whiskey1.oscar_xray, five_whiskey1.kilo_zulu, five_whiskey1.alpha_charlie, five_whiskey1.hotel_two, five_whiskey1.victor_five, five_whiskey1.charlie_tango, five_whiskey1.lima_kilo, five_whiskey1.uniform_golf
  • Filter: (five_whiskey1.oscar_xray = 'echo_delta'::bpchar)
  • Rows Removed by Filter: 100
  • Buffers: shared hit=2268836492
  • Worker 0: actual time=0.009..0.009 rows=1 loops=364763098
  • Buffers: shared hit=729526196
  • Worker 1: actual time=0.009..0.009 rows=1 loops=373601653
  • Buffers: shared hit=747203306
Planning time : 365.971 ms
Execution time : 26,472,504.630 ms