explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mpvi

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 62.488 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.00..7,155.99 rows=1 width=302) (actual time=54.460..62.488 rows=1 loops=1)

  • Join Filter: (c.idtipoexame = t.idtipoexame)
  • Rows Removed by Join Filter: 2
2. 0.023 62.476 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.00..7,154.92 rows=1 width=157) (actual time=54.450..62.476 rows=1 loops=1)

  • Join Filter: (a.idmovimentoaso = m.idasomovimento)
  • Rows Removed by Join Filter: 35
3. 0.021 62.444 ↑ 1.0 1 1

Nested Loop (cost=0.00..7,153.78 rows=1 width=161) (actual time=54.419..62.444 rows=1 loops=1)

  • Join Filter: (c.idcabecalho = m.idcabecalho)
  • Rows Removed by Join Filter: 21
4. 0.362 62.408 ↑ 1.0 1 1

Nested Loop (cost=0.00..7,152.02 rows=1 width=149) (actual time=54.384..62.408 rows=1 loops=1)

  • Join Filter: ((c.cpf)::bigint = f.numcpf)
  • Rows Removed by Join Filter: 324
5. 0.017 0.017 ↑ 1.0 1 1

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

  • Filter: ((idsituacao = 3) AND (numemp = 1))
  • Rows Removed by Filter: 23
6. 62.029 62.029 ↑ 1.0 325 1

Seq Scan on view_fdw_senior_r034fun f (cost=0.00..7,145.12 rows=332 width=43) (actual time=23.823..62.029 rows=325 loops=1)

  • Filter: ((sitafa <> 7) AND (numemp = 1) AND (tipcol = 1) AND (codfil = 68))
  • Rows Removed by Filter: 54281
7. 0.015 0.015 ↑ 1.0 22 1

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

  • Filter: (idexame = 0)
  • Rows Removed by Filter: 22
8. 0.009 0.009 ↓ 6.0 36 1

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

9. 0.003 0.003 ↑ 1.0 3 1

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