explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fsoj : qury1

Settings
# exclusive inclusive rows x rows loops node
1. 1,368,925.979 26,843,661.555 ↓ 1,134,418,246.0 1,134,418,246 1

Gather (cost=6,116.230..151,232.860 rows=1 width=137) (actual time=2,204.037..26,843,661.555 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=25364543063 read=106363
2. 10,135,931.662 25,474,735.576 ↓ 378,139,415.0 378,139,415 3

Nested Loop Semi Join (cost=5,116.230..150,232.760 rows=1 width=137) (actual time=2,559.876..25,474,735.576 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=25364543063 read=106363
  • Worker 0: actual time=3302.740..25160489.359 rows=370449832 loops=1
  • Buffers: shared hit=8394197416 read=18802
  • Worker 1: actual time=2176.245..25061234.270 rows=379203644 loops=1
  • Buffers: shared hit=8356020507 read=39971
3. 3,814,490.649 15,338,803.888 ↓ 378,139,415.0 378,139,415 3

Nested Loop (cost=5,115.390..150,193.960 rows=1 width=147) (actual time=2,559.784..15,338,803.888 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=14020021393 read=106348
  • Worker 0: actual time=3302.648..15216451.701 rows=370449832 loops=1
  • Buffers: shared hit=4689689597 read=18801
  • Worker 1: actual time=2176.159..14964578.558 rows=379203644 loops=1
  • Buffers: shared hit=4563670885 read=39967
4. 1,416,542.039 11,524,313.230 ↓ 378,139,415.0 378,139,415 3

Nested Loop (cost=5,115.390..150,190.670 rows=1 width=151) (actual time=2,559.743..11,524,313.230 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=11751184901 read=106348
  • Worker 0: actual time=3302.579..11474737.607 rows=370449832 loops=1
  • Buffers: shared hit=3948789933 read=18801
  • Worker 1: actual time=2176.132..11158376.629 rows=379203644 loops=1
  • Buffers: shared hit=3805263597 read=39967
5. 9,054,023.748 10,107,771.188 ↓ 378,326,744.0 378,326,744 3

Nested Loop (cost=5,115.110..150,186.680 rows=1 width=161) (actual time=2,183.988..10,107,771.188 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=9481224432 read=106348
  • Worker 0: actual time=2175.419..10090013.628 rows=370661428 loops=1
  • Buffers: shared hit=3207467075 read=18801
  • Worker 1: actual time=2176.078..9800727.236 rows=379354713 loops=1
  • Buffers: shared hit=3046554169 read=39967
6. 513,232.867 1,053,747.427 ↓ 685,906,353.0 685,906,353 3

Nested Loop (cost=5,114.530..150,182.210 rows=1 width=168) (actual time=2,157.996..1,053,747.427 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=1089700278 read=104436
  • Worker 0: actual time=2135.624..870523.408 rows=702208723 loops=1
  • Buffers: shared hit=354280657 read=18714
  • Worker 1: actual time=2145.992..1130590.351 rows=657206397 loops=1
  • Buffers: shared hit=363916516 read=38819
7. 9,548.208 540,514.261 ↓ 1,208,654.0 1,208,654 3

Nested Loop (cost=5,114.100..149,843.590 rows=1 width=170) (actual time=2,156.397..540,514.261 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=131732344 read=104030
  • Worker 0: actual time=2130.932..361164.582 rows=1089595 loops=1
  • Buffers: shared hit=34546897 read=18664
  • Worker 1: actual time=2145.935..636887.804 rows=1279629 loops=1
  • Buffers: shared hit=53195085 read=38610
8. 12,125.137 530,966.047 ↓ 1,208,654.0 1,208,654 3

Nested Loop (cost=5,113.810..149,835.840 rows=1 width=146) (actual time=2,156.369..530,966.047 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=120854464 read=104025
  • Worker 0: actual time=2130.901..352496.664 rows=1089595 loops=1
  • Buffers: shared hit=31278112 read=18663
  • Worker 1: actual time=2145.905..626915.683 rows=1279629 loops=1
  • Buffers: shared hit=49356200 read=38607
9. 515,173.359 518,840.902 ↓ 1,208,654.0 1,208,654 3

Nested Loop (cost=5,113.390..149,827.950 rows=1 width=138) (actual time=2,156.305..518,840.902 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=106348660 read=104011
  • Worker 0: actual time=2130.823..341538.046 rows=1089595 loops=1
  • Buffers: shared hit=26919626 read=18660
  • Worker 1: actual time=2145.849..614228.700 rows=1279629 loops=1
  • Buffers: shared hit=44235882 read=38600
10. 174.699 3,666.282 ↓ 882.5 407,725 3

Merge Join (cost=5,112.820..13,978.040 rows=462 width=61) (actual time=1,753.691..3,666.282 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=42541 read=970
  • Worker 0: actual time=1745.187..2689.396 rows=235521 loops=1
  • Buffers: shared hit=10076 read=186
  • Worker 1: actual time=1745.818..4310.783 rows=617506 loops=1
  • Buffers: shared hit=18969 read=456
11. 204.412 2,461.800 ↓ 250.4 407,725 3

Merge Join (cost=5,083.180..8,111.850 rows=1,628 width=51) (actual time=754.469..2,461.800 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=40996 read=965
  • Worker 0: actual time=745.533..1598.509 rows=235521 loops=1
  • Buffers: shared hit=9559 read=186
  • Worker 1: actual time=746.771..2965.282 rows=617506 loops=1
  • Buffers: shared hit=18453 read=455
12. 1,537.021 1,537.021 ↓ 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=104.325..1,537.021 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=40706 read=965
  • Worker 0: actual time=95.888..773.826 rows=37043 loops=1
  • Buffers: shared hit=9462 read=186
  • Worker 1: actual time=96.355..1916.771 rows=81731 loops=1
  • Buffers: shared hit=18356 read=455
13. 76.511 720.367 ↓ 169.7 409,086 3

Sort (cost=5,068.310..5,074.330 rows=2,411 width=28) (actual time=650.135..720.367 rows=409,086 loops=3)

  • Output: quebec_sierra.papa_alpha, quebec_sierra.papa_five, quebec_sierra.romeo_echo
  • Sort Key: quebec_sierra.romeo_echo
  • Sort Method: quicksort Memory: 187kB
  • Buffers: shared hit=290
  • Worker 0: actual time=649.637..696.049 rows=236957 loops=1
  • Buffers: shared hit=97
  • Worker 1: actual time=650.408..750.558 rows=618756 loops=1
  • Buffers: shared hit=97
14. 365.630 643.856 ↑ 1.4 1,772 3

Bitmap Heap Scan on quebec_alpha (cost=47.110..4,932.860 rows=2,411 width=28) (actual time=278.248..643.856 rows=1,772 loops=3)

  • Output: quebec_sierra.papa_alpha, quebec_sierra.papa_five, quebec_sierra.romeo_echo
  • Recheck Cond: (quebec_sierra.papa_alpha = 'echo_delta'::bpchar)
  • Heap Blocks: exact=84
  • Buffers: shared hit=278
  • Worker 0: actual time=278.075..643.367 rows=1772 loops=1
  • Buffers: shared hit=93
  • Worker 1: actual time=278.329..644.111 rows=1772 loops=1
  • Buffers: shared hit=93
15. 278.226 278.226 ↑ 1.4 1,772 3

Bitmap Index Scan on uniform_hotel_victor (cost=0.000..46.500 rows=2,411 width=0) (actual time=278.226..278.226 rows=1,772 loops=3)

  • Index Cond: (quebec_sierra.papa_alpha = 'echo_delta'::bpchar)
  • Buffers: shared hit=26
  • Worker 0: actual time=278.048..278.048 rows=1772 loops=1
  • Buffers: shared hit=9
  • Worker 1: actual time=278.312..278.312 rows=1772 loops=1
  • Buffers: shared hit=9
16. 1,029.783 1,029.783 ↑ 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=18.404..1,029.783 rows=133,668 loops=3)

  • Output: romeo_yankee.romeo_echo
  • Heap Fetches: 0
  • Buffers: shared hit=1545 read=5
  • Worker 0: actual time=18.786..972.182 rows=133652 loops=1
  • Buffers: shared hit=517
  • Worker 1: actual time=18.138..1098.654 rows=133653 loops=1
  • Buffers: shared hit=516 read=1
17. 1.261 1.261 ↓ 3.0 3 1,223,175

Index Scan using romeo_alpha on oscar_india (cost=0.570..294.040 rows=1 width=93) (actual time=1.166..1.261 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_victor'::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=106306119 read=103041
  • Worker 0: actual time=1.308..1.435 rows=5 loops=235521
  • Buffers: shared hit=26909550 read=18474
  • Worker 1: actual time=0.915..0.986 rows=2 loops=617506
  • Buffers: shared hit=44216913 read=38144
18. 0.008 0.008 ↑ 1.0 1 3,625,961

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

  • Output: juliet_zulu.papa_alpha, juliet_zulu.romeo_echo, juliet_zulu.bravo_xray, juliet_zulu.uniform_yankee, juliet_zulu.oscar_whiskey_three, juliet_zulu.november_november_five, juliet_zulu.papa_five, juliet_zulu.three_quebec, juliet_zulu.yankee_yankee_papa, juliet_zulu.november_juliet, juliet_zulu.november_lima, juliet_zulu.india_whiskey_lima, juliet_zulu.uniform_uniform, juliet_zulu.bravo_two, juliet_zulu.alpha_four, juliet_zulu.xray_golf, juliet_zulu.whiskey_six, juliet_zulu.three_delta, juliet_zulu.kilo_seven, juliet_zulu.mike_five_november, juliet_zulu.papa_sierra_india, juliet_zulu.tango_seven, juliet_zulu.quebec_kilo, juliet_zulu.bravo_three, juliet_zulu.whiskey_foxtrot, juliet_zulu.oscar_whiskey_mike, juliet_zulu.charlie_charlie1, juliet_zulu.charlie_charlie2, juliet_zulu.victor_lima, juliet_zulu.papa_sierra_victor, juliet_zulu.kilo_oscar, juliet_zulu.whiskey_four, juliet_zulu.romeo_golf, juliet_zulu.india_two, juliet_zulu.uniform_oscar, juliet_zulu.oscar_delta, juliet_zulu.seven_bravo, juliet_zulu.tango_romeo, juliet_zulu.foxtrot_romeo, juliet_zulu.tango_papa, juliet_zulu.tango_golf, juliet_zulu.six_charlie, juliet_zulu.romeo_india, juliet_zulu.delta_two_sierra, juliet_zulu.echo_yankee, juliet_zulu.seven_charlie, juliet_zulu.golf_bravo, juliet_zulu.xray_mike, juliet_zulu.zulu_victor, juliet_zulu.echo_six, juliet_zulu.six_tango_foxtrot, juliet_zulu.bravo_five, juliet_zulu.five_alpha, juliet_zulu.three_november_hotel, juliet_zulu.hotel_two, juliet_zulu.mike_november, juliet_zulu.mike_zulu, juliet_zulu.hotel_xray, juliet_zulu.four_golf, juliet_zulu.bravo_juliet_uniform, juliet_zulu.romeo_uniform_yankee, juliet_zulu.kilo_lima, juliet_zulu.uniform_juliet, juliet_zulu.bravo_zulu, juliet_zulu.bravo_zulu2, juliet_zulu.bravo_zulu3, juliet_zulu.oscar_lima, juliet_zulu.alpha_foxtrot, juliet_zulu.oscar_oscar, juliet_zulu.six_four, juliet_zulu.delta_yankee, juliet_zulu.two_kilo, juliet_zulu.three_seven, juliet_zulu.india_lima, juliet_zulu.juliet_delta_oscar, juliet_zulu.foxtrot_quebec, juliet_zulu.juliet_lima, juliet_zulu.delta_echo, juliet_zulu.hotel_charlie, juliet_zulu.whiskey_november, juliet_zulu.romeo_charlie, juliet_zulu.foxtrot_six, juliet_zulu.seven_sierra, juliet_zulu.bravo_four, juliet_zulu.oscar_four, juliet_zulu.echo_bravo, juliet_zulu.zulu_xray, juliet_zulu.quebec_lima, juliet_zulu.victor_romeo_kilo, juliet_zulu.uniform_delta, juliet_zulu.sierra_golf, juliet_zulu.mike_delta, juliet_zulu.delta_zulu, juliet_zulu.foxtrot_two, juliet_zulu.whiskey_zulu
  • Index Cond: (juliet_zulu.romeo_echo = charlie_lima.romeo_echo)
  • Buffers: shared hit=14505804 read=14
  • Worker 0: actual time=0.008..0.008 rows=1 loops=1089595
  • Buffers: shared hit=4358486 read=3
  • Worker 1: actual time=0.008..0.008 rows=1 loops=1279629
  • Buffers: shared hit=5120318 read=7
19. 0.006 0.006 ↑ 1.0 1 3,625,961

Index Scan using mike_five_four on quebec_uniform kilo_uniform (cost=0.290..7.750 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=3,625,961)

  • Output: kilo_uniform.papa_alpha, kilo_uniform.romeo_india, kilo_uniform.alpha_uniform, kilo_uniform.papa_mike, kilo_uniform.two_uniform, kilo_uniform.kilo_alpha, kilo_uniform.mike_uniform, kilo_uniform.zulu_oscar, kilo_uniform.two_hotel, kilo_uniform.delta_zulu, kilo_uniform.hotel_two, kilo_uniform.victor_romeo_india, kilo_uniform.india_mike, kilo_uniform.delta_oscar_hotel, kilo_uniform.victor_november
  • Index Cond: (kilo_uniform.romeo_india = juliet_zulu.romeo_india)
  • Buffers: shared hit=10877880 read=5
  • Worker 0: actual time=0.006..0.006 rows=1 loops=1089595
  • Buffers: shared hit=3268785 read=1
  • Worker 1: actual time=0.006..0.006 rows=1 loops=1279629
  • Buffers: shared hit=3838885 read=3
20. 0.299 0.299 ↓ 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.015..0.299 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_whiskey, 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_seven, 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_oscar, 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=957967934 read=406
  • Worker 0: actual time=0.015..0.331 rows=644 loops=1089595
  • Buffers: shared hit=319733760 read=50
  • Worker 1: actual time=0.015..0.274 rows=514 loops=1279629
  • Buffers: shared hit=310721431 read=209
21. 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.013..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=8391524154 read=1912
  • Worker 0: actual time=0.013..0.013 rows=1 loops=702208723
  • Buffers: shared hit=2853186418 read=87
  • Worker 1: actual time=0.013..0.013 rows=1 loops=657206397
  • Buffers: shared hit=2682637653 read=1148
22. 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=370661428
  • Buffers: shared hit=741322858
  • Worker 1: actual time=0.003..0.003 rows=1 loops=379354713
  • Buffers: shared hit=758709428
23. 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=370449832
  • Buffers: shared hit=740899664
  • Worker 1: actual time=0.009..0.009 rows=1 loops=379203644
  • Buffers: shared hit=758407288
24. 0.001 0.026 ↑ 1.0 1 1,134,418,246

Nested Loop (cost=0.840..38.780 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=11344521670 read=15
  • Worker 0: actual time=0.026..0.026 rows=1 loops=370449832
  • Buffers: shared hit=3704507819 read=1
  • Worker 1: actual time=0.026..0.026 rows=1 loops=379203644
  • Buffers: shared hit=3792349622 read=4
25. 0.000 0.016 ↑ 1.0 1 1,134,418,246

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

  • Output: india_three1.romeo_echo, uniform_four1.papa_alpha, uniform_four1.romeo_echo
  • Buffers: shared hit=9075685178 read=15
  • Worker 0: actual time=0.016..0.016 rows=1 loops=370449832
  • Buffers: shared hit=2963608155 read=1
  • Worker 1: actual time=0.016..0.016 rows=1 loops=379203644
  • Buffers: shared hit=3033942334 read=4
26. 0.008 0.008 ↑ 1.0 1 1,134,418,246

Index Scan using delta_oscar_romeo on bravo_quebec_bravo hotel_tango (cost=0.420..7.900 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_november, 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_yankee, 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_kilo, 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, india_three1.quebec_lima, india_three1.victor_romeo_kilo, 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) AND (india_three1.three_seven = 'alpha_whiskey'::bpchar))
  • Filter: ((india_three1.india_whiskey_lima = ANY ('bravo_charlie'::bpchar[])) AND (india_three1.bravo_xray = 'six_tango_zulu'::bpchar))
  • Buffers: shared hit=4537991134 read=10
  • Worker 0: actual time=0.008..0.008 rows=1 loops=370449832
  • Buffers: shared hit=1481808826 read=1
  • Worker 1: actual time=0.008..0.008 rows=1 loops=379203644
  • Buffers: shared hit=1517118116 read=2
27. 0.008 0.008 ↑ 1.0 1 1,134,418,246

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

  • Output: uniform_four1.papa_alpha, uniform_four1.papa_five, uniform_four1.victor_xray, uniform_four1.sierra_oscar, uniform_four1.romeo_uniform_bravo, uniform_four1.quebec_two, uniform_four1.foxtrot_golf, uniform_four1.victor_seven, uniform_four1.charlie_bravo, uniform_four1.oscar_xray, uniform_four1.two_sierra, uniform_four1.romeo_echo, uniform_four1.bravo_xray, uniform_four1.hotel_zulu_juliet, uniform_four1.hotel_two, uniform_four1.six_bravo, uniform_four1.tango_yankee, uniform_four1.yankee_three, uniform_four1.two_xray, uniform_four1.mike_delta, uniform_four1.sierra_six, uniform_four1.quebec_papa_xray
  • Index Cond: (uniform_four1.romeo_echo = india_three1.romeo_echo)
  • Filter: (uniform_four1.papa_alpha = 'echo_delta'::bpchar)
  • Buffers: shared hit=4537694044 read=5
  • Worker 0: actual time=0.008..0.008 rows=1 loops=370449832
  • Buffers: shared hit=1481799329
  • Worker 1: actual time=0.008..0.008 rows=1 loops=379203644
  • Buffers: shared hit=1516824218 read=2
28. 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=370449832
  • Buffers: shared hit=740899664
  • Worker 1: actual time=0.009..0.009 rows=1 loops=379203644
  • Buffers: shared hit=758407288
Planning time : 1,286.881 ms
Execution time : 26,905,304.204 ms