explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I7pF

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 221.693 ↑ 1.0 10 1

Limit (cost=10,666.000..10,666.020 rows=10 width=85) (actual time=221.692..221.693 rows=10 loops=1)

2. 3.159 221.691 ↑ 1,196.1 10 1

Sort (cost=10,666.000..10,695.900 rows=11,961 width=85) (actual time=221.690..221.691 rows=10 loops=1)

  • Sort Key: echo.quebec_juliet DESC
  • Sort Method: top-N heapsort Memory: 26kB
3. 50.871 218.532 ↓ 1.0 12,000 1

HashAggregate (cost=10,287.920..10,407.530 rows=11,961 width=85) (actual time=214.968..218.532 rows=12,000 loops=1)

  • Group Key: echo.quebec_seven
4. 76.086 167.661 ↓ 1.0 192,000 1

Hash Join (cost=1,595.750..9,808.170 rows=191,897 width=85) (actual time=27.078..167.661 rows=192,000 loops=1)

  • Hash Cond: (november.oscar = echo.quebec_seven)
5. 64.563 64.563 ↓ 1.0 192,000 1

Seq Scan on november (cost=0.000..5,576.000 rows=191,321 width=4) (actual time=0.026..64.563 rows=192,000 loops=1)

  • Filter: ((foxtrot five_romeo TRUE) AND (five_sierra = 0))
  • Rows Removed by Filter: 72000
6. 3.684 27.012 ↓ 1.0 12,000 1

Hash (cost=1,445.790..1,445.790 rows=11,997 width=89) (actual time=27.012..27.012 rows=12,000 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1675kB
7. 5.944 23.328 ↓ 1.0 12,000 1

Hash Join (cost=530.030..1,445.790 rows=11,997 width=89) (actual time=10.744..23.328 rows=12,000 loops=1)

  • Hash Cond: (four.xray = echo.quebec_seven)
8. 6.693 6.693 ↓ 1.0 12,000 1

Seq Scan on four (cost=0.000..751.260 rows=11,997 width=4) (actual time=0.016..6.693 rows=12,000 loops=1)

  • Filter: (five_sierra = 0)
  • Rows Removed by Filter: 24000
9. 4.244 10.691 ↓ 1.0 12,000 1

Hash (cost=380.510..380.510 rows=11,961 width=85) (actual time=10.691..10.691 rows=12,000 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1628kB
10. 6.447 6.447 ↓ 1.0 12,000 1

Seq Scan on echo (cost=0.000..380.510 rows=11,961 width=85) (actual time=0.013..6.447 rows=12,000 loops=1)

  • Filter: ((yankee five_romeo NULL) AND (victor = 1))