explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fp6Q

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.107 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.54..12.99 rows=1 width=310) (actual time=0.091..0.107 rows=1 loops=1)

  • Buffers: shared hit=12
2. 0.007 0.091 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.26..7.93 rows=1 width=187) (actual time=0.078..0.091 rows=1 loops=1)

  • Buffers: shared hit=12
3. 0.013 0.068 ↑ 1.0 1 1

Nested Loop (cost=0.84..5.29 rows=1 width=175) (actual time=0.057..0.068 rows=1 loops=1)

  • Buffers: shared hit=8
4. 0.037 0.037 ↑ 1.0 1 1

Index Scan using usuario_username_key on usuario usuariosei (cost=0.42..2.64 rows=1 width=83) (actual time=0.033..0.037 rows=1 loops=1)

  • Index Cond: ((username)::text = '02214140026'::text)
  • Filter: ((senha)::text = '49e69335039fd43825a4bd2f4f6d385d5263352eb24531d0e4cd82320d7f1bea'::text)
  • Buffers: shared hit=4
5. 0.018 0.018 ↑ 1.0 1 1

Index Scan using idx_bd_tb_usuario_usuario_sei_codigo on tb_usuario usuarioipog (cost=0.42..2.64 rows=1 width=100) (actual time=0.014..0.018 rows=1 loops=1)

  • Index Cond: (usuario_sei_codigo = usuariosei.codigo)
  • Buffers: shared hit=4
6. 0.016 0.016 ↑ 1.0 1 1

Index Scan using pessoa_pkey on pessoa (cost=0.42..2.64 rows=1 width=20) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: (codigo = usuariosei.pessoa)
  • Buffers: shared hit=4
7. 0.005 0.005 ↓ 0.0 0 1

Index Scan using parceiro_pkey on parceiro (cost=0.28..0.30 rows=1 width=16) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: (codigo = usuarioipog.parceiro_codigo)
8.          

SubPlan (for Nested Loop Left Join)

9. 0.000 0.000 ↓ 0.0 0

Limit (cost=2.38..2.38 rows=1 width=18) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Sort (cost=2.38..2.38 rows=1 width=18) (never executed)

  • Sort Key: contatoparceiro.codigo DESC
11. 0.000 0.000 ↓ 0.0 0

Index Scan using ch_contatoparceiro_parceiro on contatoparceiro (cost=0.15..2.37 rows=1 width=18) (never executed)

  • Index Cond: (parceiro = parceiro.codigo)
12. 0.000 0.000 ↓ 0.0 0

Limit (cost=2.38..2.38 rows=1 width=31) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Sort (cost=2.38..2.38 rows=1 width=31) (never executed)

  • Sort Key: contatoparceiro_1.codigo DESC
14. 0.000 0.000 ↓ 0.0 0

Index Scan using ch_contatoparceiro_parceiro on contatoparceiro contatoparceiro_1 (cost=0.15..2.37 rows=1 width=31) (never executed)

  • Index Cond: (parceiro = parceiro.codigo)
Planning time : 1.245 ms
Execution time : 0.260 ms