#	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)

"Hash Join  (cost=29.50..2275.50 rows=1000 width=26) (actual time=0.366..17.487 rows=1000 loops=1)"
"  Hash Cond: (pes.id = jur.fk_pessoa_id)"
"  ->  Seq Scan on pessoa pes  (cost=0.00..1736.00 rows=100000 width=15) (actual time=0.016..7.127 rows=100000 loops=1)"
"  ->  Hash  (cost=17.00..17.00 rows=1000 width=19) (actual time=0.331..0.331 rows=1000 loops=1)"
"        Buckets: 1024  Batches: 1  Memory Usage: 59kB"
"        ->  Seq Scan on pessoa_juridica jur  (cost=0.00..17.00 rows=1000 width=19) (actual time=0.021..0.171 rows=1000 loops=1)"
"Planning Time: 0.237 ms"
"Execution Time: 17.537 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.160 ms	0.9 %
Hash Join	1	10.029 ms	57.4 %
Seq Scan	2	7.298 ms	41.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
pessoa	1	7.127 ms	40.8 %
Seq Scan	1	7.127 ms	100.0 %
pessoa_juridica	1	0.171 ms	1.0 %
Seq Scan	1	0.171 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: slj6u

Color mode:

Visible columns:

Per node type stats

Per table stats