explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cTJx

Settings
# exclusive inclusive rows x rows loops node
1. 38.352 272.884 ↑ 1.6 145,493 1

Hash Join (cost=12.48..58,873.51 rows=233,535 width=8,097) (actual time=0.075..272.884 rows=145,493 loops=1)

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

Seq Scan on psmgisareas p (cost=0.00..55,164.04 rows=363,104 width=8,057) (actual time=0.011..234.473 rows=363,567 loops=1)

3. 0.033 0.059 ↑ 1.0 377 1

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

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

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

Planning time : 0.150 ms