explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5l0e

Settings
# exclusive inclusive rows x rows loops node
1. 2.316 128.019 ↓ 1.2 1,354 1

HashAggregate (cost=32,962.17..32,973.08 rows=1,091 width=16) (actual time=127.829..128.019 rows=1,354 loops=1)

  • Group Key: s.objectid
2. 14.758 125.703 ↓ 1.0 9,737 1

Hash Semi Join (cost=10,232.00..32,914.52 rows=9,530 width=16) (actual time=107.111..125.703 rows=9,737 loops=1)

  • Hash Cond: (s.objectid = o.objectid)
3. 58.990 58.990 ↑ 1.0 100,000 1

Seq Scan on source s (cost=0.00..20,945.00 rows=100,000 width=16) (actual time=9.703..58.990 rows=100,000 loops=1)

4. 20.277 51.955 ↑ 1.0 100,000 1

Hash (cost=8,591.00..8,591.00 rows=100,000 width=8) (actual time=51.955..51.955 rows=100,000 loops=1)

  • Buckets: 131072 Batches: 2 Memory Usage: 2981kB
5. 31.678 31.678 ↑ 1.0 100,000 1

Seq Scan on object o (cost=0.00..8,591.00 rows=100,000 width=8) (actual time=0.031..31.678 rows=100,000 loops=1)