explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yWcw : Funcionario Info S/I

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.594 ↑ 1.0 1 1

Nested Loop (cost=29.07..76.31 rows=1 width=267) (actual time=0.424..0.594 rows=1 loops=1)

2. 0.000 0.589 ↑ 1.0 1 1

Nested Loop (cost=29.07..76.02 rows=1 width=53) (actual time=0.420..0.589 rows=1 loops=1)

3. 0.002 0.575 ↓ 3.0 3 1

Nested Loop (cost=29.07..75.69 rows=1 width=46) (actual time=0.343..0.575 rows=3 loops=1)

4. 0.205 0.558 ↓ 3.0 3 1

Hash Join (cost=29.07..73.59 rows=1 width=46) (actual time=0.336..0.558 rows=3 loops=1)

  • Hash Cond: (f.fk_pessoa_juridica_id = jur.id)
5. 0.138 0.138 ↑ 1.0 2,000 1

Seq Scan on funcionario f (cost=0.00..37.00 rows=2,000 width=28) (actual time=0.006..0.138 rows=2,000 loops=1)

6. 0.001 0.215 ↑ 1.0 1 1

Hash (cost=29.06..29.06 rows=1 width=26) (actual time=0.215..0.215 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
7. 0.082 0.214 ↑ 1.0 1 1

Hash Join (cost=8.30..29.06 rows=1 width=26) (actual time=0.212..0.214 rows=1 loops=1)

  • Hash Cond: (jur.fk_pessoa_id = pes.id)
8. 0.059 0.059 ↑ 1.0 1,000 1

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

9. 0.003 0.073 ↑ 1.0 1 1

Hash (cost=8.28..8.28 rows=1 width=15) (actual time=0.073..0.073 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
10. 0.070 0.070 ↑ 1.0 1 1

Index Scan using pessoa_nome on pessoa pes (cost=0.00..8.28 rows=1 width=15) (actual time=0.070..0.070 rows=1 loops=1)

  • Index Cond: ((nome)::text = 'nkipp-nome'::text)
11. 0.015 0.015 ↑ 1.0 1 3

Index Scan using pessoa_fisica_pkey on pessoa_fisica fis (cost=0.00..2.09 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=3)

  • Index Cond: (fis.id = f.fk_pessoa_fisica_id)
12. 0.015 0.015 ↓ 0.0 0 3

Index Scan using pessoa_pkey on pessoa pes (cost=0.00..0.32 rows=1 width=15) (actual time=0.005..0.005 rows=0 loops=3)

  • Index Cond: (pes.id = fis.fk_pessoa_id)
  • Filter: ((pes.nome)::text = 'xfkdx-nome'::text)
13. 0.002 0.002 ↑ 1.0 1 1

Index Scan using cargo_pkey on cargo c (cost=0.00..0.27 rows=1 width=222) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: (c.id = f.fk_cargo_id)