explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9PB9 : MH

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.067 121,805.625 ↑ 1.0 1 1

Aggregate (cost=3,150,812.990..3,150,813.000 rows=1 width=0) (actual time=121,805.624..121,805.625 rows=1 loops=1)

2. 0.356 121,805.558 ↑ 26,913.9 71 1

Unique (cost=3,100,659.830..3,126,926.870 rows=1,910,890 width=36) (actual time=121,804.969..121,805.558 rows=71 loops=1)

3. 2.173 121,805.202 ↑ 11,445.3 306 1

Sort (cost=3,100,659.830..3,109,415.510 rows=3,502,272 width=36) (actual time=121,804.967..121,805.202 rows=306 loops=1)

  • Sort Key: alpha.oscar, alpha.bravo
  • Sort Method: quicksort Memory: 48kB
4. 37,519.678 121,803.029 ↑ 11,445.3 306 1

Hash Join (cost=901,911.620..2,624,198.320 rows=3,502,272 width=36) (actual time=84,407.306..121,803.029 rows=306 loops=1)

  • Hash Cond: ((alpha.quebec)::text = (india.charlie)::text)
5. 52,202.269 52,202.269 ↑ 1.0 19,028,946 1

Seq Scan on xray alpha (cost=0.000..959,565.930 rows=19,108,893 width=73) (actual time=7.486..52,202.269 rows=19,028,946 loops=1)

6. 12.703 32,081.082 ↑ 11,517.9 306 1

Hash (cost=830,320.670..830,320.670 rows=3,524,476 width=37) (actual time=32,081.082..32,081.082 rows=306 loops=1)

  • Buckets: 131,072 Batches: 4 Memory Usage: 7kB
7. 1,788.362 32,068.379 ↑ 11,517.9 306 1

Hash Join (cost=289,211.120..830,320.670 rows=3,524,476 width=37) (actual time=30,064.186..32,068.379 rows=306 loops=1)

  • Hash Cond: ((tango.echo)::text = (india.quebec)::text)
8. 10,857.572 10,857.572 ↑ 11,517.9 306 1

Seq Scan on six tango (cost=0.000..351,214.840 rows=3,524,476 width=37) (actual time=10,575.761..10,857.572 rows=306 loops=1)

  • Filter: (november > 0::numeric)
  • Rows Removed by Filter: 10,463,612
9. 5,698.295 19,422.445 ↑ 1.0 4,373,561 1

Hash (cost=179,017.610..179,017.610 rows=4,373,561 width=74) (actual time=19,422.445..19,422.445 rows=4,373,561 loops=1)

  • Buckets: 65,536 Batches: 8 Memory Usage: 56,610kB
10. 13,724.150 13,724.150 ↑ 1.0 4,373,561 1

Seq Scan on zulu india (cost=0.000..179,017.610 rows=4,373,561 width=74) (actual time=18.740..13,724.150 rows=4,373,561 loops=1)