explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ilfN

Settings
# exclusive inclusive rows x rows loops node
1. 38.912 276.976 ↑ 1.6 145,493 1

Hash Join (cost=12.48..58,882.86 rows=233,833 width=8,097) (actual time=0.070..276.976 rows=145,493 loops=1)

  • Hash Cond: (p.psmorgid = tempt.id)
2. 238.008 238.008 ↑ 1.0 363,567 1

Seq Scan on psmgisareas p (cost=0.00..55,168.67 rows=363,567 width=8,057) (actual time=0.010..238.008 rows=363,567 loops=1)

3. 0.029 0.056 ↑ 1.0 377 1

Hash (cost=7.77..7.77 rows=377 width=40) (actual time=0.056..0.056 rows=377 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
4. 0.027 0.027 ↑ 1.0 377 1

Seq Scan on temp1 tempt (cost=0.00..7.77 rows=377 width=40) (actual time=0.008..0.027 rows=377 loops=1)

Planning time : 3.191 ms