explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X5dS

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.069 ↓ 0.0 0 1

Nested Loop (cost=14.94..248.12 rows=1 width=24) (actual time=0.069..0.069 rows=0 loops=1)

  • Join Filter: ((ve.id_evento = a.id_evento) AND ((SubPlan 1) = a.id_acao))
2. 0.001 0.068 ↓ 0.0 0 1

Nested Loop (cost=14.51..223.08 rows=1 width=32) (actual time=0.068..0.068 rows=0 loops=1)

3. 0.000 0.067 ↓ 0.0 0 1

Nested Loop (cost=14.23..222.45 rows=2 width=58) (actual time=0.067..0.067 rows=0 loops=1)

4. 0.004 0.067 ↓ 0.0 0 1

Nested Loop (cost=13.80..220.26 rows=1 width=50) (actual time=0.067..0.067 rows=0 loops=1)

5. 0.005 0.049 ↑ 5.5 2 1

Nested Loop (cost=13.37..208.87 rows=11 width=4) (actual time=0.046..0.049 rows=2 loops=1)

6. 0.004 0.027 ↑ 5.0 1 1

Bitmap Heap Scan on syo_veiculo veic (cost=8.88..28.72 rows=5 width=13) (actual time=0.027..0.027 rows=1 loops=1)

  • Recheck Cond: ((no_chassi = '9BHGA811BKP149640'::text) OR (ds_placa = 'OKM9640'::text))
  • Heap Blocks: exact=1
7. 0.001 0.023 ↓ 0.0 0 1

BitmapOr (cost=8.88..8.88 rows=5 width=0) (actual time=0.023..0.023 rows=0 loops=1)

8. 0.014 0.014 ↑ 2.0 1 1

Bitmap Index Scan on syo_veiculo_vendido2 (cost=0.00..4.44 rows=2 width=0) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (no_chassi = '9BHGA811BKP149640'::text)
9. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on syo_veiculo_ds_placa (cost=0.00..4.45 rows=3 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (ds_placa = 'OKM9640'::text)
10. 0.007 0.017 ↑ 4.0 2 1

Bitmap Heap Scan on syo_veiculoevento ve (cost=4.49..35.95 rows=8 width=18) (actual time=0.016..0.017 rows=2 loops=1)

  • Recheck Cond: (id_veiculo = veic.id_veiculo)
  • Heap Blocks: exact=1
11. 0.010 0.010 ↑ 4.0 2 1

Bitmap Index Scan on fk_syo_veiculoevento (cost=0.00..4.48 rows=8 width=0) (actual time=0.010..0.010 rows=2 loops=1)

  • Index Cond: (id_veiculo = veic.id_veiculo)
12. 0.014 0.014 ↓ 0.0 0 2

Index Scan using pk_syo_evento on syo_evento e (cost=0.43..1.03 rows=1 width=46) (actual time=0.007..0.007 rows=0 loops=2)

  • Index Cond: (id_evento = ve.id_evento)
  • Filter: ((id_grupoevento = 'AGENDAMENTO'::text) AND (id_statusevento = 'CONCLUIDO'::text))
  • Rows Removed by Filter: 1
13. 0.000 0.000 ↓ 0.0 0

Index Scan using syo_encaminhamento_evento_agenteativo on syo_encaminhamento en (cost=0.43..1.74 rows=45 width=8) (never executed)

  • Index Cond: (id_evento = ve.id_evento)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using syo_tipoevento_select on syo_tipoevento tp (cost=0.28..0.31 rows=1 width=34) (never executed)

  • Index Cond: ((id_grupoevento = 'AGENDAMENTO'::text) AND (id_tipoevento = e.id_tipoevento) AND (id_empresa = en.id_empresa))
15. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_acao_evento2 on syo_acao a (cost=0.43..0.76 rows=1 width=8) (never executed)

  • Index Cond: (id_evento = en.id_evento)
  • Filter: (ds_resultado = 'INSUCESSO'::text)
16.          

SubPlan (forNested Loop)

17. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=24.26..24.27 rows=1 width=4) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_acao_evento2 on syo_acao (cost=0.43..24.25 rows=3 width=4) (never executed)

  • Index Cond: (id_evento = e.id_evento)
  • Filter: (tp_acao <> 'ENCAMINHAMENTO'::text)
Planning time : 3.778 ms
Execution time : 0.221 ms