explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8BP1 : Funcionario Info S/I

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 36.659 ↑ 1.0 1 1

Nested Loop (cost=0.00..2,080.22 rows=1 width=267) (actual time=16.517..36.659 rows=1 loops=1)

2. 0.006 36.651 ↑ 1.0 1 1

Nested Loop (cost=0.00..2,079.93 rows=1 width=53) (actual time=16.510..36.651 rows=1 loops=1)

3. 0.008 36.615 ↓ 3.0 3 1

Nested Loop (cost=0.00..2,079.60 rows=1 width=46) (actual time=16.274..36.615 rows=3 loops=1)

4. 0.704 36.571 ↓ 3.0 3 1

Nested Loop (cost=0.00..2,077.50 rows=1 width=46) (actual time=16.250..36.571 rows=3 loops=1)

  • Join Filter: (jur.id = f.fk_pessoa_juridica_id)
5. 0.345 35.421 ↑ 1.0 1 1

Nested Loop (cost=0.00..2,015.50 rows=1 width=26) (actual time=15.880..35.421 rows=1 loops=1)

  • Join Filter: (jur.fk_pessoa_id = pes.id)
6. 34.873 34.873 ↑ 1.0 1 1

Seq Scan on pessoa pes (cost=0.00..1,986.00 rows=1 width=15) (actual time=15.340..34.873 rows=1 loops=1)

  • Filter: ((nome)::text = 'nkipp-nome'::text)
7. 0.203 0.203 ↑ 1.0 1,000 1

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

8. 0.446 0.446 ↑ 1.0 2,000 1

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

9. 0.036 0.036 ↑ 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.012..0.012 rows=1 loops=3)

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

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

  • Index Cond: (pes.id = fis.fk_pessoa_id)