explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TM09 : Query Plan

Settings
# exclusive inclusive rows x rows loops node
1. 1,307.813 9,356,999.848 ↓ 7.4 2,193,127 1

Unique (cost=73,543,354.340..73,568,526.320 rows=296,141 width=307) (actual time=9,352,895.176..9,356,999.848 rows=2,193,127 loops=1)

  • Output: (golf_two(xray_november((quebec_three.two_papa)::text))), (golf_two(xray_november((quebec_three.xray_lima)::text))), quebec_three.romeo_six, quebec_three.victor_mike, quebec_three.sierra_sierra, quebec_three.zulu_yankee, quebec_three.seven_golf, quebec_three.papa_sierra, (CASE WHEN ((quebec_three.victor_hotel + quebec_three.delta_mike) <= 'november_golf'::double precision) THEN NULL::double precision WHEN ((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) < 'november_golf'::double precision) THEN 'november_golf'::double precision WHEN (((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) / (quebec_three.victor_hotel + quebec_three.delta_mike)) > 'four'::double precision) THEN 'four'::double precision ELSE ((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) / (quebec_three.victor_hotel + quebec_three.delta_mike)) END), quebec_three.delta_uniform, quebec_three.victor_hotel, quebec_three.delta_mike, (((quebec_three.echo_juliet + quebec_three.sierra_xray) + quebec_three.alpha_whiskey)), quebec_three.xray_romeo, (CASE WHEN (quebec_three.zulu_yankee > 'november_golf'::double precision) THEN ((((quebec_three.echo_juliet + quebec_three.sierra_xray) + quebec_three.delta_mike) + quebec_three.alpha_whiskey) / quebec_three.zulu_yankee) ELSE NULL::double precision END), quebec_three.whiskey_four, quebec_three.kilo_sierra, (((quebec_three.zulu_echo + quebec_three.lima_five) + quebec_three.papa_india)), quebec_three.victor_six, (CASE WHEN (quebec_three.seven_golf > 'november_golf'::double precision) THEN ((((quebec_three.zulu_echo + quebec_three.lima_five) + quebec_three.papa_india) + quebec_three.whiskey_four) / quebec_three.seven_golf) ELSE NULL::double precision END), quebec_three.quebec_papa, quebec_three.seven_oscar, quebec_three.delta_oscar, quebec_three.golf_oscar, quebec_three.foxtrot_two, ((quebec_three.foxtrot_two - quebec_three.quebec_papa)), (CASE WHEN (quebec_three.seven_oscar > 'november_golf'::double precision) THEN ((quebec_three.golf_oscar - quebec_three.seven_oscar) / quebec_three.seven_oscar) ELSE NULL::double precision END), ((quebec_three.delta_oscar - quebec_three.quebec_papa)), ((quebec_three.delta_oscar - quebec_three.foxtrot_two)), (CASE WHEN (quebec_three.whiskey_india > 'november_golf'::double precision) THEN ((quebec_three.papa_sierra - quebec_three.whiskey_india) / quebec_three.whiskey_india) ELSE NULL::double precision END), ((quebec_three.papa_sierra - quebec_three.seven_oscar)), quebec_three.whiskey_india, quebec_three.foxtrot_india
  • Buffers: shared hit=3056 read=68399841, temp read=347492 written=347656
  • I/O Timings: read=44947793.296
2. 18,710.401 9,355,692.035 ↓ 7.4 2,193,127 1

Sort (cost=73,543,354.340..73,544,094.690 rows=296,141 width=307) (actual time=9,352,895.173..9,355,692.035 rows=2,193,127 loops=1)

  • Output: (golf_two(xray_november((quebec_three.two_papa)::text))), (golf_two(xray_november((quebec_three.xray_lima)::text))), quebec_three.romeo_six, quebec_three.victor_mike, quebec_three.sierra_sierra, quebec_three.zulu_yankee, quebec_three.seven_golf, quebec_three.papa_sierra, (CASE WHEN ((quebec_three.victor_hotel + quebec_three.delta_mike) <= 'november_golf'::double precision) THEN NULL::double precision WHEN ((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) < 'november_golf'::double precision) THEN 'november_golf'::double precision WHEN (((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) / (quebec_three.victor_hotel + quebec_three.delta_mike)) > 'four'::double precision) THEN 'four'::double precision ELSE ((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) / (quebec_three.victor_hotel + quebec_three.delta_mike)) END), quebec_three.delta_uniform, quebec_three.victor_hotel, quebec_three.delta_mike, (((quebec_three.echo_juliet + quebec_three.sierra_xray) + quebec_three.alpha_whiskey)), quebec_three.xray_romeo, (CASE WHEN (quebec_three.zulu_yankee > 'november_golf'::double precision) THEN ((((quebec_three.echo_juliet + quebec_three.sierra_xray) + quebec_three.delta_mike) + quebec_three.alpha_whiskey) / quebec_three.zulu_yankee) ELSE NULL::double precision END), quebec_three.whiskey_four, quebec_three.kilo_sierra, (((quebec_three.zulu_echo + quebec_three.lima_five) + quebec_three.papa_india)), quebec_three.victor_six, (CASE WHEN (quebec_three.seven_golf > 'november_golf'::double precision) THEN ((((quebec_three.zulu_echo + quebec_three.lima_five) + quebec_three.papa_india) + quebec_three.whiskey_four) / quebec_three.seven_golf) ELSE NULL::double precision END), quebec_three.quebec_papa, quebec_three.seven_oscar, quebec_three.delta_oscar, quebec_three.golf_oscar, quebec_three.foxtrot_two, ((quebec_three.foxtrot_two - quebec_three.quebec_papa)), (CASE WHEN (quebec_three.seven_oscar > 'november_golf'::double precision) THEN ((quebec_three.golf_oscar - quebec_three.seven_oscar) / quebec_three.seven_oscar) ELSE NULL::double precision END), ((quebec_three.delta_oscar - quebec_three.quebec_papa)), ((quebec_three.delta_oscar - quebec_three.foxtrot_two)), (CASE WHEN (quebec_three.whiskey_india > 'november_golf'::double precision) THEN ((quebec_three.papa_sierra - quebec_three.whiskey_india) / quebec_three.whiskey_india) ELSE NULL::double precision END), ((quebec_three.papa_sierra - quebec_three.seven_oscar)), quebec_three.whiskey_india, quebec_three.foxtrot_india
  • Sort Key: (golf_two(xray_november((quebec_three.two_papa)::text))), (golf_two(xray_november((quebec_three.xray_lima)::text))), quebec_three.romeo_six, quebec_three.victor_mike, quebec_three.sierra_sierra, quebec_three.zulu_yankee, quebec_three.seven_golf, quebec_three.papa_sierra, (CASE WHEN ((quebec_three.victor_hotel + quebec_three.delta_mike) <= 'november_golf'::double precision) THEN NULL::double precision WHEN ((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) < 'november_golf'::double precision) THEN 'november_golf'::double precision WHEN (((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) / (quebec_three.victor_hotel + quebec_three.delta_mike)) > 'four'::double precision) THEN 'four'::double precision ELSE ((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) / (quebec_three.victor_hotel + quebec_three.delta_mike)) END), quebec_three.delta_uniform, quebec_three.victor_hotel, quebec_three.delta_mike, (((quebec_three.echo_juliet + quebec_three.sierra_xray) + quebec_three.alpha_whiskey)), quebec_three.xray_romeo, (CASE WHEN (quebec_three.zulu_yankee > 'november_golf'::double precision) THEN ((((quebec_three.echo_juliet + quebec_three.sierra_xray) + quebec_three.delta_mike) + quebec_three.alpha_whiskey) / quebec_three.zulu_yankee) ELSE NULL::double precision END), quebec_three.whiskey_four, quebec_three.kilo_sierra, (((quebec_three.zulu_echo + quebec_three.lima_five) + quebec_three.papa_india)), quebec_three.victor_six, (CASE WHEN (quebec_three.seven_golf > 'november_golf'::double precision) THEN ((((quebec_three.zulu_echo + quebec_three.lima_five) + quebec_three.papa_india) + quebec_three.whiskey_four) / quebec_three.seven_golf) ELSE NULL::double precision END), quebec_three.quebec_papa, quebec_three.seven_oscar, quebec_three.delta_oscar, quebec_three.golf_oscar, quebec_three.foxtrot_two, ((quebec_three.foxtrot_two - quebec_three.quebec_papa)), (CASE WHEN (quebec_three.seven_oscar > 'november_golf'::double precision) THEN ((quebec_three.golf_oscar - quebec_three.seven_oscar) / quebec_three.seven_oscar) ELSE NULL::double precision END), ((quebec_three.delta_oscar - quebec_three.quebec_papa)), ((quebec_three.delta_oscar - quebec_three.foxtrot_two)), (CASE WHEN (quebec_three.whiskey_india > 'november_golf'::double precision) THEN ((quebec_three.papa_sierra - quebec_three.whiskey_india) / quebec_three.whiskey_india) ELSE NULL::double precision END), ((quebec_three.papa_sierra - quebec_three.seven_oscar)), quebec_three.whiskey_india, quebec_three.foxtrot_india
  • Sort Method: external merge Disk: 565880kB
  • Buffers: shared hit=3056 read=68399841, temp read=347492 written=347656
  • I/O Timings: read=44947793.296
3. 1,419.225 9,336,981.634 ↓ 7.4 2,193,127 1

Gather (cost=73,400,167.030..73,491,539.800 rows=296,141 width=307) (actual time=9,327,738.294..9,336,981.634 rows=2,193,127 loops=1)

  • Output: (golf_two(xray_november((quebec_three.two_papa)::text))), (golf_two(xray_november((quebec_three.xray_lima)::text))), quebec_three.romeo_six, quebec_three.victor_mike, quebec_three.sierra_sierra, quebec_three.zulu_yankee, quebec_three.seven_golf, quebec_three.papa_sierra, (CASE WHEN ((quebec_three.victor_hotel + quebec_three.delta_mike) <= 'november_golf'::double precision) THEN NULL::double precision WHEN ((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) < 'november_golf'::double precision) THEN 'november_golf'::double precision WHEN (((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) / (quebec_three.victor_hotel + quebec_three.delta_mike)) > 'four'::double precision) THEN 'four'::double precision ELSE ((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) / (quebec_three.victor_hotel + quebec_three.delta_mike)) END), quebec_three.delta_uniform, quebec_three.victor_hotel, quebec_three.delta_mike, (((quebec_three.echo_juliet + quebec_three.sierra_xray) + quebec_three.alpha_whiskey)), quebec_three.xray_romeo, (CASE WHEN (quebec_three.zulu_yankee > 'november_golf'::double precision) THEN ((((quebec_three.echo_juliet + quebec_three.sierra_xray) + quebec_three.delta_mike) + quebec_three.alpha_whiskey) / quebec_three.zulu_yankee) ELSE NULL::double precision END), quebec_three.whiskey_four, quebec_three.kilo_sierra, (((quebec_three.zulu_echo + quebec_three.lima_five) + quebec_three.papa_india)), quebec_three.victor_six, (CASE WHEN (quebec_three.seven_golf > 'november_golf'::double precision) THEN ((((quebec_three.zulu_echo + quebec_three.lima_five) + quebec_three.papa_india) + quebec_three.whiskey_four) / quebec_three.seven_golf) ELSE NULL::double precision END), quebec_three.quebec_papa, quebec_three.seven_oscar, quebec_three.delta_oscar, quebec_three.golf_oscar, quebec_three.foxtrot_two, ((quebec_three.foxtrot_two - quebec_three.quebec_papa)), (CASE WHEN (quebec_three.seven_oscar > 'november_golf'::double precision) THEN ((quebec_three.golf_oscar - quebec_three.seven_oscar) / quebec_three.seven_oscar) ELSE NULL::double precision END), ((quebec_three.delta_oscar - quebec_three.quebec_papa)), ((quebec_three.delta_oscar - quebec_three.foxtrot_two)), (CASE WHEN (quebec_three.whiskey_india > 'november_golf'::double precision) THEN ((quebec_three.papa_sierra - quebec_three.whiskey_india) / quebec_three.whiskey_india) ELSE NULL::double precision END), ((quebec_three.papa_sierra - quebec_three.seven_oscar)), quebec_three.whiskey_india, quebec_three.foxtrot_india
  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=3056 read=68399841, temp read=276757 written=276900
  • I/O Timings: read=44947793.296
4. 1,555.368 9,335,562.409 ↓ 5.9 438,625 5

Merge Join (cost=73,399,167.030..73,432,607.190 rows=74,035 width=307) (actual time=9,327,553.331..9,335,562.409 rows=438,625 loops=5)

  • Output: (golf_two(xray_november((quebec_three.two_papa)::text))), (golf_two(xray_november((quebec_three.xray_lima)::text))), quebec_three.romeo_six, quebec_three.victor_mike, quebec_three.sierra_sierra, quebec_three.zulu_yankee, quebec_three.seven_golf, quebec_three.papa_sierra, CASE WHEN ((quebec_three.victor_hotel + quebec_three.delta_mike) <= 'november_golf'::double precision) THEN NULL::double precision WHEN ((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) < 'november_golf'::double precision) THEN 'november_golf'::double precision WHEN (((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) / (quebec_three.victor_hotel + quebec_three.delta_mike)) > 'four'::double precision) THEN 'four'::double precision ELSE ((((((quebec_three.papa_sierra + quebec_three.zulu_yankee) - quebec_three.echo_juliet) - quebec_three.sierra_xray) - quebec_three.alpha_whiskey) - quebec_three.lima_quebec) / (quebec_three.victor_hotel + quebec_three.delta_mike)) END, quebec_three.delta_uniform, quebec_three.victor_hotel, quebec_three.delta_mike, ((quebec_three.echo_juliet + quebec_three.sierra_xray) + quebec_three.alpha_whiskey), quebec_three.xray_romeo, CASE WHEN (quebec_three.zulu_yankee > 'november_golf'::double precision) THEN ((((quebec_three.echo_juliet + quebec_three.sierra_xray) + quebec_three.delta_mike) + quebec_three.alpha_whiskey) / quebec_three.zulu_yankee) ELSE NULL::double precision END, quebec_three.whiskey_four, quebec_three.kilo_sierra, ((quebec_three.zulu_echo + quebec_three.lima_five) + quebec_three.papa_india), quebec_three.victor_six, CASE WHEN (quebec_three.seven_golf > 'november_golf'::double precision) THEN ((((quebec_three.zulu_echo + quebec_three.lima_five) + quebec_three.papa_india) + quebec_three.whiskey_four) / quebec_three.seven_golf) ELSE NULL::double precision END, quebec_three.quebec_papa, quebec_three.seven_oscar, quebec_three.delta_oscar, quebec_three.golf_oscar, quebec_three.foxtrot_two, (quebec_three.foxtrot_two - quebec_three.quebec_papa), CASE WHEN (quebec_three.seven_oscar > 'november_golf'::double precision) THEN ((quebec_three.golf_oscar - quebec_three.seven_oscar) / quebec_three.seven_oscar) ELSE NULL::double precision END, (quebec_three.delta_oscar - quebec_three.quebec_papa), (quebec_three.delta_oscar - quebec_three.foxtrot_two), CASE WHEN (quebec_three.whiskey_india > 'november_golf'::double precision) THEN ((quebec_three.papa_sierra - quebec_three.whiskey_india) / quebec_three.whiskey_india) ELSE NULL::double precision END, (quebec_three.papa_sierra - quebec_three.seven_oscar), quebec_three.whiskey_india, quebec_three.foxtrot_india
  • Merge Cond: (((golf_two(xray_november((quebec_three.two_papa)::text))) = five_hotel.two_papa) AND ((golf_two(xray_november((quebec_three.xray_lima)::text))) = five_hotel.romeo_echo))
  • Buffers: shared hit=3056 read=68399841, temp read=276757 written=276900
  • I/O Timings: read=44947793.296
  • Worker 0: actual time=9327513.347..9335441.807 rows=430989 loops=1
  • Buffers: shared hit=670 read=13411006, temp read=54376 written=54404
  • I/O Timings: read=8992332.960
  • Worker 1: actual time=9327502.252..9335514.409 rows=438448 loops=1
  • Buffers: shared hit=327 read=13670732, temp read=55307 written=55336
  • I/O Timings: read=8988804.070
  • Worker 2: actual time=9327509.052..9335639.652 rows=434516 loops=1
  • Buffers: shared hit=753 read=13555860, temp read=54820 written=54848
  • I/O Timings: read=8990381.416
  • Worker 3: actual time=9327510.559..9335795.678 rows=444612 loops=1
  • Buffers: shared hit=582 read=13858385, temp read=56068 written=56097
  • I/O Timings: read=8989853.163
5. 24,559.135 9,333,777.444 ↓ 1.5 1,754,682 5

Sort (cost=73,385,853.910..73,388,845.610 rows=1,196,679 width=234) (actual time=9,327,344.276..9,333,777.444 rows=1,754,682 loops=5)

  • Output: quebec_three.two_papa, quebec_three.xray_lima, quebec_three.romeo_six, quebec_three.victor_mike, quebec_three.sierra_sierra, quebec_three.zulu_yankee, quebec_three.seven_golf, quebec_three.papa_sierra, quebec_three.victor_hotel, quebec_three.delta_mike, quebec_three.echo_juliet, quebec_three.sierra_xray, quebec_three.alpha_whiskey, quebec_three.lima_quebec, quebec_three.delta_uniform, quebec_three.xray_romeo, quebec_three.whiskey_four, quebec_three.kilo_sierra, quebec_three.zulu_echo, quebec_three.lima_five, quebec_three.papa_india, quebec_three.victor_six, quebec_three.quebec_papa, quebec_three.seven_oscar, quebec_three.delta_oscar, quebec_three.golf_oscar, quebec_three.foxtrot_two, quebec_three.whiskey_india, quebec_three.foxtrot_india, (golf_two(xray_november((quebec_three.two_papa)::text))), (golf_two(xray_november((quebec_three.xray_lima)::text)))
  • Sort Key: (golf_two(xray_november((quebec_three.two_papa)::text))), (golf_two(xray_november((quebec_three.xray_lima)::text)))
  • Sort Method: external merge Disk: 449488kB
  • Buffers: shared hit=188 read=68399124, temp read=276757 written=276900
  • I/O Timings: read=44947515.349
  • Worker 0: actual time=9327330.596..9333660.188 rows=1723745 loops=1
  • Buffers: shared hit=40 read=13410919, temp read=54376 written=54404
  • I/O Timings: read=8992300.542
  • Worker 1: actual time=9327130.893..9333594.185 rows=1753252 loops=1
  • Buffers: shared hit=30 read=13670312, temp read=55307 written=55336
  • I/O Timings: read=8988624.950
  • Worker 2: actual time=9327431.112..9333936.871 rows=1737889 loops=1
  • Buffers: shared hit=36 read=13555860, temp read=54820 written=54848
  • I/O Timings: read=8990381.416
  • Worker 3: actual time=9327290.880..9333938.157 rows=1777395 loops=1
  • Buffers: shared hit=35 read=13858215, temp read=56068 written=56097
  • I/O Timings: read=8989796.085
6. 4,871.234 9,309,218.309 ↓ 1.5 1,755,052 5

Result (cost=0.000..73,185,987.300 rows=1,196,679 width=234) (actual time=2.605..9,309,218.309 rows=1,755,052 loops=5)

  • Output: quebec_three.two_papa, quebec_three.xray_lima, quebec_three.romeo_six, quebec_three.victor_mike, quebec_three.sierra_sierra, quebec_three.zulu_yankee, quebec_three.seven_golf, quebec_three.papa_sierra, quebec_three.victor_hotel, quebec_three.delta_mike, quebec_three.echo_juliet, quebec_three.sierra_xray, quebec_three.alpha_whiskey, quebec_three.lima_quebec, quebec_three.delta_uniform, quebec_three.xray_romeo, quebec_three.whiskey_four, quebec_three.kilo_sierra, quebec_three.zulu_echo, quebec_three.lima_five, quebec_three.papa_india, quebec_three.victor_six, quebec_three.quebec_papa, quebec_three.seven_oscar, quebec_three.delta_oscar, quebec_three.golf_oscar, quebec_three.foxtrot_two, quebec_three.whiskey_india, quebec_three.foxtrot_india, golf_two(xray_november((quebec_three.two_papa)::text)), golf_two(xray_november((quebec_three.xray_lima)::text))
  • Buffers: shared hit=168 read=68399124
  • I/O Timings: read=44947515.349
  • Worker 0: actual time=4.238..9309228.122 rows=1724101 loops=1
  • Buffers: shared hit=35 read=13410919
  • I/O Timings: read=8992300.542
  • Worker 1: actual time=4.079..9308881.845 rows=1753634 loops=1
  • Buffers: shared hit=25 read=13670312
  • I/O Timings: read=8988624.950
  • Worker 2: actual time=1.124..9309482.136 rows=1738228 loops=1
  • Buffers: shared hit=31 read=13555860
  • I/O Timings: read=8990381.416
  • Worker 3: actual time=3.535..9309099.101 rows=1777779 loops=1
  • Buffers: shared hit=30 read=13858215
  • I/O Timings: read=8989796.085
7. 554.646 9,304,347.075 ↓ 1.5 1,755,052 5

Append (cost=0.000..73,185,987.300 rows=1,196,679 width=234) (actual time=2.590..9,304,347.075 rows=1,755,052 loops=5)

  • Buffers: shared hit=168 read=68399124
  • I/O Timings: read=44947515.349
  • Worker 0: actual time=4.222..9304215.633 rows=1724101 loops=1
  • Buffers: shared hit=35 read=13410919
  • I/O Timings: read=8992300.542
  • Worker 1: actual time=4.063..9304052.704 rows=1753634 loops=1
  • Buffers: shared hit=25 read=13670312
  • I/O Timings: read=8988624.950
  • Worker 2: actual time=1.103..9304636.692 rows=1738228 loops=1
  • Buffers: shared hit=31 read=13555860
  • I/O Timings: read=8990381.416
  • Worker 3: actual time=3.519..9304240.635 rows=1777779 loops=1
  • Buffers: shared hit=30 read=13858215
  • I/O Timings: read=8989796.085
8. 9,303,792.335 9,303,792.335 ↓ 1.5 1,755,052 5

Parallel Seq Scan on two_golf quebec_three (cost=0.000..73,185,968.480 rows=1,196,671 width=234) (actual time=2.589..9,303,792.335 rows=1,755,052 loops=5)

  • Output: quebec_three.two_papa, quebec_three.xray_lima, quebec_three.romeo_six, quebec_three.victor_mike, quebec_three.sierra_sierra, quebec_three.zulu_yankee, quebec_three.seven_golf, quebec_three.papa_sierra, quebec_three.victor_hotel, quebec_three.delta_mike, quebec_three.echo_juliet, quebec_three.sierra_xray, quebec_three.alpha_whiskey, quebec_three.lima_quebec, quebec_three.delta_uniform, quebec_three.xray_romeo, quebec_three.whiskey_four, quebec_three.kilo_sierra, quebec_three.zulu_echo, quebec_three.lima_five, quebec_three.papa_india, quebec_three.victor_six, quebec_three.quebec_papa, quebec_three.seven_oscar, quebec_three.delta_oscar, quebec_three.golf_oscar, quebec_three.foxtrot_two, quebec_three.whiskey_india, quebec_three.foxtrot_india
  • Filter: ((quebec_three.romeo_six > 'golf_six'::date) AND (echo_tango('six'::text, (quebec_three.victor_mike - quebec_three.romeo_six)) = 'november_golf'::double precision))
  • Rows Removed by Filter: 189710133
  • Buffers: shared hit=160 read=68399124
  • I/O Timings: read=44947515.349
  • Worker 0: actual time=4.222..9303632.068 rows=1724101 loops=1
  • Buffers: shared hit=35 read=13410919
  • I/O Timings: read=8992300.542
  • Worker 1: actual time=4.062..9303505.323 rows=1753634 loops=1
  • Buffers: shared hit=25 read=13670312
  • I/O Timings: read=8988624.950
  • Worker 2: actual time=1.102..9304086.557 rows=1738228 loops=1
  • Buffers: shared hit=31 read=13555860
  • I/O Timings: read=8990381.416
  • Worker 3: actual time=3.518..9303694.704 rows=1777779 loops=1
  • Buffers: shared hit=29 read=13858215
  • I/O Timings: read=8989796.085
9. 0.073 0.073 ↓ 0.0 0 5

Parallel Index Scan using xray_whiskey on quebec_foxtrot juliet_xray_xray (cost=0.140..2.350 rows=1 width=922) (actual time=0.072..0.073 rows=0 loops=5)

  • Output: mike1.two_papa, mike1.xray_lima, mike1.romeo_six, mike1.victor_mike, mike1.sierra_sierra, mike1.zulu_yankee, mike1.seven_golf, mike1.papa_sierra, mike1.victor_hotel, mike1.delta_mike, mike1.echo_juliet, mike1.sierra_xray, mike1.alpha_whiskey, mike1.lima_quebec, mike1.delta_uniform, mike1.xray_romeo, mike1.whiskey_four, mike1.kilo_sierra, mike1.zulu_echo, mike1.lima_five, mike1.papa_india, mike1.victor_six, mike1.quebec_papa, mike1.seven_oscar, mike1.delta_oscar, mike1.golf_oscar, mike1.foxtrot_two, mike1.whiskey_india, mike1.foxtrot_india
  • Index Cond: (echo_tango('six'::text, (mike1.victor_mike - mike1.romeo_six)) = 'november_golf'::double precision)
  • Filter: (mike1.romeo_six > 'golf_six'::date)
  • Buffers: shared hit=1
  • Worker 0: actual time=0.080..0.080 rows=0 loops=1
  • Worker 1: actual time=0.059..0.060 rows=0 loops=1
  • Worker 2: actual time=0.089..0.089 rows=0 loops=1
  • Worker 3: actual time=0.079..0.080 rows=0 loops=1
10. 0.002 0.002 ↓ 0.0 0 5

Parallel Index Scan using charlie_tango on foxtrot_tango oscar (cost=0.140..2.350 rows=1 width=922) (actual time=0.002..0.002 rows=0 loops=5)

  • Output: mike2.two_papa, mike2.xray_lima, mike2.romeo_six, mike2.victor_mike, mike2.sierra_sierra, mike2.zulu_yankee, mike2.seven_golf, mike2.papa_sierra, mike2.victor_hotel, mike2.delta_mike, mike2.echo_juliet, mike2.sierra_xray, mike2.alpha_whiskey, mike2.lima_quebec, mike2.delta_uniform, mike2.xray_romeo, mike2.whiskey_four, mike2.kilo_sierra, mike2.zulu_echo, mike2.lima_five, mike2.papa_india, mike2.victor_six, mike2.quebec_papa, mike2.seven_oscar, mike2.delta_oscar, mike2.golf_oscar, mike2.foxtrot_two, mike2.whiskey_india, mike2.foxtrot_india
  • Index Cond: (echo_tango('six'::text, (mike2.victor_mike - mike2.romeo_six)) = 'november_golf'::double precision)
  • Filter: (mike2.romeo_six > 'golf_six'::date)
  • Buffers: shared hit=1
  • Worker 0: actual time=0.001..0.002 rows=0 loops=1
  • Worker 1: actual time=0.002..0.003 rows=0 loops=1
  • Worker 2: actual time=0.001..0.002 rows=0 loops=1
  • Worker 3: actual time=0.002..0.002 rows=0 loops=1
11. 0.005 0.005 ↓ 0.0 0 5

Parallel Index Scan using five_tango on echo_hotel india (cost=0.140..2.350 rows=1 width=922) (actual time=0.004..0.005 rows=0 loops=5)

  • Output: mike3.two_papa, mike3.xray_lima, mike3.romeo_six, mike3.victor_mike, mike3.sierra_sierra, mike3.zulu_yankee, mike3.seven_golf, mike3.papa_sierra, mike3.victor_hotel, mike3.delta_mike, mike3.echo_juliet, mike3.sierra_xray, mike3.alpha_whiskey, mike3.lima_quebec, mike3.delta_uniform, mike3.xray_romeo, mike3.whiskey_four, mike3.kilo_sierra, mike3.zulu_echo, mike3.lima_five, mike3.papa_india, mike3.victor_six, mike3.quebec_papa, mike3.seven_oscar, mike3.delta_oscar, mike3.golf_oscar, mike3.foxtrot_two, mike3.whiskey_india, mike3.foxtrot_india
  • Index Cond: (echo_tango('six'::text, (mike3.victor_mike - mike3.romeo_six)) = 'november_golf'::double precision)
  • Filter: (mike3.romeo_six > 'golf_six'::date)
  • Buffers: shared hit=1
  • Worker 0: actual time=0.001..0.001 rows=0 loops=1
  • Worker 1: actual time=0.001..0.002 rows=0 loops=1
  • Worker 2: actual time=0.001..0.001 rows=0 loops=1
  • Worker 3: actual time=0.001..0.001 rows=0 loops=1
12. 0.002 0.002 ↓ 0.0 0 5

Parallel Index Scan using sierra_kilo on zulu_november alpha_foxtrot (cost=0.140..2.350 rows=1 width=922) (actual time=0.001..0.002 rows=0 loops=5)

  • Output: mike4.two_papa, mike4.xray_lima, mike4.romeo_six, mike4.victor_mike, mike4.sierra_sierra, mike4.zulu_yankee, mike4.seven_golf, mike4.papa_sierra, mike4.victor_hotel, mike4.delta_mike, mike4.echo_juliet, mike4.sierra_xray, mike4.alpha_whiskey, mike4.lima_quebec, mike4.delta_uniform, mike4.xray_romeo, mike4.whiskey_four, mike4.kilo_sierra, mike4.zulu_echo, mike4.lima_five, mike4.papa_india, mike4.victor_six, mike4.quebec_papa, mike4.seven_oscar, mike4.delta_oscar, mike4.golf_oscar, mike4.foxtrot_two, mike4.whiskey_india, mike4.foxtrot_india
  • Index Cond: (echo_tango('six'::text, (mike4.victor_mike - mike4.romeo_six)) = 'november_golf'::double precision)
  • Filter: (mike4.romeo_six > 'golf_six'::date)
  • Buffers: shared hit=1
  • Worker 0: actual time=0.001..0.001 rows=0 loops=1
  • Worker 1: actual time=0.001..0.001 rows=0 loops=1
  • Worker 2: actual time=0.001..0.001 rows=0 loops=1
  • Worker 3: actual time=0.001..0.001 rows=0 loops=1
13. 0.002 0.002 ↓ 0.0 0 5

Parallel Index Scan using lima_mike on sierra_november victor_bravo (cost=0.140..2.350 rows=1 width=922) (actual time=0.001..0.002 rows=0 loops=5)

  • Output: mike5.two_papa, mike5.xray_lima, mike5.romeo_six, mike5.victor_mike, mike5.sierra_sierra, mike5.zulu_yankee, mike5.seven_golf, mike5.papa_sierra, mike5.victor_hotel, mike5.delta_mike, mike5.echo_juliet, mike5.sierra_xray, mike5.alpha_whiskey, mike5.lima_quebec, mike5.delta_uniform, mike5.xray_romeo, mike5.whiskey_four, mike5.kilo_sierra, mike5.zulu_echo, mike5.lima_five, mike5.papa_india, mike5.victor_six, mike5.quebec_papa, mike5.seven_oscar, mike5.delta_oscar, mike5.golf_oscar, mike5.foxtrot_two, mike5.whiskey_india, mike5.foxtrot_india
  • Index Cond: (echo_tango('six'::text, (mike5.victor_mike - mike5.romeo_six)) = 'november_golf'::double precision)
  • Filter: (mike5.romeo_six > 'golf_six'::date)
  • Buffers: shared hit=1
  • Worker 0: actual time=0.001..0.001 rows=0 loops=1
  • Worker 1: actual time=0.001..0.002 rows=0 loops=1
  • Worker 2: actual time=0.001..0.001 rows=0 loops=1
  • Worker 3: actual time=0.001..0.001 rows=0 loops=1
14. 0.001 0.001 ↓ 0.0 0 5

Parallel Index Scan using five_november on lima_echo kilo_bravo (cost=0.140..2.350 rows=1 width=922) (actual time=0.001..0.001 rows=0 loops=5)

  • Output: mike6.two_papa, mike6.xray_lima, mike6.romeo_six, mike6.victor_mike, mike6.sierra_sierra, mike6.zulu_yankee, mike6.seven_golf, mike6.papa_sierra, mike6.victor_hotel, mike6.delta_mike, mike6.echo_juliet, mike6.sierra_xray, mike6.alpha_whiskey, mike6.lima_quebec, mike6.delta_uniform, mike6.xray_romeo, mike6.whiskey_four, mike6.kilo_sierra, mike6.zulu_echo, mike6.lima_five, mike6.papa_india, mike6.victor_six, mike6.quebec_papa, mike6.seven_oscar, mike6.delta_oscar, mike6.golf_oscar, mike6.foxtrot_two, mike6.whiskey_india, mike6.foxtrot_india
  • Index Cond: (echo_tango('six'::text, (mike6.victor_mike - mike6.romeo_six)) = 'november_golf'::double precision)
  • Filter: (mike6.romeo_six > 'golf_six'::date)
  • Buffers: shared hit=1
  • Worker 0: actual time=0.001..0.001 rows=0 loops=1
  • Worker 1: actual time=0.001..0.001 rows=0 loops=1
  • Worker 2: actual time=0.001..0.001 rows=0 loops=1
  • Worker 3: actual time=0.000..0.000 rows=0 loops=1
15. 0.006 0.006 ↓ 0.0 0 5

Parallel Index Scan using five_kilo on juliet_xray_five november_papa (cost=0.140..2.350 rows=1 width=922) (actual time=0.005..0.006 rows=0 loops=5)

  • Output: mike7.two_papa, mike7.xray_lima, mike7.romeo_six, mike7.victor_mike, mike7.sierra_sierra, mike7.zulu_yankee, mike7.seven_golf, mike7.papa_sierra, mike7.victor_hotel, mike7.delta_mike, mike7.echo_juliet, mike7.sierra_xray, mike7.alpha_whiskey, mike7.lima_quebec, mike7.delta_uniform, mike7.xray_romeo, mike7.whiskey_four, mike7.kilo_sierra, mike7.zulu_echo, mike7.lima_five, mike7.papa_india, mike7.victor_six, mike7.quebec_papa, mike7.seven_oscar, mike7.delta_oscar, mike7.golf_oscar, mike7.foxtrot_two, mike7.whiskey_india, mike7.foxtrot_india
  • Index Cond: (echo_tango('six'::text, (mike7.victor_mike - mike7.romeo_six)) = 'november_golf'::double precision)
  • Filter: (mike7.romeo_six > 'golf_six'::date)
  • Buffers: shared hit=1
  • Worker 0: actual time=0.012..0.012 rows=0 loops=1
  • Worker 1: actual time=0.001..0.002 rows=0 loops=1
  • Worker 2: actual time=0.001..0.001 rows=0 loops=1
  • Worker 3: actual time=0.001..0.002 rows=0 loops=1
16. 0.003 0.003 ↓ 0.0 0 5

Parallel Index Scan using charlie_alpha on seven_delta bravo (cost=0.140..2.350 rows=1 width=922) (actual time=0.002..0.003 rows=0 loops=5)

  • Output: mike8.two_papa, mike8.xray_lima, mike8.romeo_six, mike8.victor_mike, mike8.sierra_sierra, mike8.zulu_yankee, mike8.seven_golf, mike8.papa_sierra, mike8.victor_hotel, mike8.delta_mike, mike8.echo_juliet, mike8.sierra_xray, mike8.alpha_whiskey, mike8.lima_quebec, mike8.delta_uniform, mike8.xray_romeo, mike8.whiskey_four, mike8.kilo_sierra, mike8.zulu_echo, mike8.lima_five, mike8.papa_india, mike8.victor_six, mike8.quebec_papa, mike8.seven_oscar, mike8.delta_oscar, mike8.golf_oscar, mike8.foxtrot_two, mike8.whiskey_india, mike8.foxtrot_india
  • Index Cond: (echo_tango('six'::text, (mike8.victor_mike - mike8.romeo_six)) = 'november_golf'::double precision)
  • Filter: (mike8.romeo_six > 'golf_six'::date)
  • Buffers: shared hit=1
  • Worker 0: actual time=0.001..0.001 rows=0 loops=1
  • Worker 1: actual time=0.002..0.003 rows=0 loops=1
  • Worker 2: actual time=0.001..0.002 rows=0 loops=1
  • Worker 3: actual time=0.006..0.007 rows=0 loops=1
  • Buffers: shared hit=1
17. 90.877 229.597 ↓ 3.5 459,724 5

Sort (cost=13,313.120..13,644.330 rows=132,483 width=16) (actual time=207.458..229.597 rows=459,724 loops=5)

  • Output: five_hotel.two_papa, five_hotel.romeo_echo
  • Sort Key: five_hotel.two_papa, five_hotel.romeo_echo
  • Sort Method: quicksort Memory: 12355kB
  • Buffers: shared hit=2868 read=717
  • I/O Timings: read=277.947
  • Worker 0: actual time=181.105..203.490 rows=452242 loops=1
  • Buffers: shared hit=630 read=87
  • I/O Timings: read=32.418
  • Worker 1: actual time=369.848..390.747 rows=459579 loops=1
  • Buffers: shared hit=297 read=420
  • I/O Timings: read=179.120
  • Worker 2: actual time=76.379..99.512 rows=455677 loops=1
  • Buffers: shared hit=717
  • Worker 3: actual time=218.064..240.398 rows=465669 loops=1
  • Buffers: shared hit=547 read=170
  • I/O Timings: read=57.078
18. 138.720 138.720 ↑ 1.0 132,483 5

Seq Scan on kilo_november five_hotel (cost=0.000..2,041.830 rows=132,483 width=16) (actual time=7.467..138.720 rows=132,483 loops=5)

  • Output: five_hotel.two_papa, five_hotel.romeo_echo
  • Buffers: shared hit=2868 read=717
  • I/O Timings: read=277.947
  • Worker 0: actual time=0.291..111.327 rows=132483 loops=1
  • Buffers: shared hit=630 read=87
  • I/O Timings: read=32.418
  • Worker 1: actual time=36.333..299.404 rows=132483 loops=1
  • Buffers: shared hit=297 read=420
  • I/O Timings: read=179.120
  • Worker 2: actual time=0.394..10.450 rows=132483 loops=1
  • Buffers: shared hit=717
  • Worker 3: actual time=0.298..149.177 rows=132483 loops=1
  • Buffers: shared hit=547 read=170
  • I/O Timings: read=57.078
Planning time : 1.912 ms
Execution time : 9,357,225.096 ms