explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6wic

Settings
# exclusive inclusive rows x rows loops node
1. 101.940 163.476 ↑ 1.0 99,000 1

Hash Join (cost=3,475.00..7,006.89 rows=99,000 width=30) (actual time=38.598..163.476 rows=99,000 loops=1)

  • Hash Cond: (fis.fk_pessoa_id = pes.id)
2. 23.569 23.569 ↑ 1.0 99,000 1

Seq Scan on pessoa_fisica fis (cost=0.00..1,621.00 rows=99,000 width=23) (actual time=0.018..23.569 rows=99,000 loops=1)

3. 24.094 37.967 ↑ 1.0 100,000 1

Hash (cost=1,736.00..1,736.00 rows=100,000 width=15) (actual time=37.967..37.967 rows=100,000 loops=1)

  • Buckets: 131072 Batches: 2 Memory Usage: 3367kB
4. 13.873 13.873 ↑ 1.0 100,000 1

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