explain.depesz.com

PostgreSQL's explain analyze made readable

Result: slj6u

Settings
# exclusive inclusive rows x rows loops node
1. 10.029 17.487 ↑ 1.0 1,000 1

Hash Join (cost=29.50..2,275.50 rows=1,000 width=26) (actual time=0.366..17.487 rows=1,000 loops=1)

  • Hash Cond: (pes.id = jur.fk_pessoa_id)
2. 7.127 7.127 ↑ 1.0 100,000 1

Seq Scan on pessoa pes (cost=0.00..1,736.00 rows=100,000 width=15) (actual time=0.016..7.127 rows=100,000 loops=1)

3. 0.160 0.331 ↑ 1.0 1,000 1

Hash (cost=17.00..17.00 rows=1,000 width=19) (actual time=0.331..0.331 rows=1,000 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 59kB
4. 0.171 0.171 ↑ 1.0 1,000 1

Seq Scan on pessoa_juridica jur (cost=0.00..17.00 rows=1,000 width=19) (actual time=0.021..0.171 rows=1,000 loops=1)