explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OKw4

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 0.221 ↑ 1.0 1 1

Nested Loop (cost=1.52..13.34 rows=1 width=302) (actual time=0.216..0.221 rows=1 loops=1)

2. 0.002 0.132 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.10..4.88 rows=1 width=267) (actual time=0.129..0.132 rows=1 loops=1)

  • Join Filter: (c.idtipoexame = t.idtipoexame)
  • Rows Removed by Join Filter: 2
3. 0.010 0.124 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.10..3.82 rows=1 width=122) (actual time=0.123..0.124 rows=1 loops=1)

  • Join Filter: (a.idmovimentoaso = m.idasomovimento)
  • Rows Removed by Join Filter: 35
4. 0.059 0.103 ↑ 1.0 1 1

Hash Join (cost=1.10..2.68 rows=1 width=126) (actual time=0.102..0.103 rows=1 loops=1)

  • Hash Cond: (m.idcabecalho = c.idcabecalho)
5. 0.025 0.025 ↑ 1.0 22 1

Seq Scan on aso_movimento m (cost=0.00..1.49 rows=22 width=16) (actual time=0.022..0.025 rows=22 loops=1)

  • Filter: (idexame = 0)
  • Rows Removed by Filter: 22
6. 0.005 0.019 ↑ 1.0 1 1

Hash (cost=1.09..1.09 rows=1 width=114) (actual time=0.019..0.019 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.014 0.014 ↑ 1.0 1 1

Seq Scan on aso_cabecalho c (cost=0.00..1.09 rows=1 width=114) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: ((idsituacao = 3) AND (numemp = 1))
  • Rows Removed by Filter: 23
8. 0.011 0.011 ↓ 6.0 36 1

Seq Scan on aso_anexo a (cost=0.00..1.06 rows=6 width=4) (actual time=0.007..0.011 rows=36 loops=1)

9. 0.006 0.006 ↑ 1.0 3 1

Seq Scan on aso_tipo_exame t (cost=0.00..1.03 rows=3 width=149) (actual time=0.004..0.006 rows=3 loops=1)

10. 0.070 0.070 ↑ 1.0 1 1

Index Scan using view_fdw_senior_r034fun_idx on view_fdw_senior_r034fun f (cost=0.42..8.45 rows=1 width=43) (actual time=0.069..0.070 rows=1 loops=1)

  • Index Cond: ((numemp = 1) AND (numcpf = (c.cpf)::bigint) AND (tipcol = 1))
  • Filter: ((sitafa <> 7) AND (codfil = 68))