explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dLVy : Funcionario Info S/I

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.502 ↑ 1.0 1 1

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

2. 0.000 0.499 ↑ 1.0 1 1

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

3. 0.003 0.488 ↓ 3.0 3 1

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

4. 0.191 0.476 ↓ 3.0 3 1

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

  • Hash Cond: (f.fk_pessoa_juridica_id = jur.id)
5. 0.126 0.126 ↑ 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.126 rows=2,000 loops=1)

6. 0.001 0.159 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
7. 0.075 0.158 ↑ 1.0 1 1

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

  • Hash Cond: (jur.fk_pessoa_id = pes.id)
8. 0.064 0.064 ↑ 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.064 rows=1,000 loops=1)

9. 0.002 0.019 ↑ 1.0 1 1

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

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

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

  • Index Cond: ((nome)::text = 'nkipp-nome'::text)
11. 0.009 0.009 ↑ 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.003..0.003 rows=1 loops=3)

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

Index Scan using pessoa_pkey on pessoa pes (cost=0.00..0.32 rows=1 width=15) (actual time=0.004..0.004 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)