explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W44B

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

Nested Loop (cost=1.27..48.12 rows=6 width=10) (actual time=0.018..0.018 rows=0 loops=1)

2. 0.001 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.84..17.26 rows=2 width=18) (actual time=0.017..0.017 rows=0 loops=1)

3. 0.002 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.71..16.75 rows=3 width=12) (actual time=0.016..0.016 rows=0 loops=1)

4. 0.014 0.014 ↓ 0.0 0 1

Index Scan using syo_evento_dsresultado on syo_evento e (cost=0.43..8.45 rows=1 width=30) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (id_evento = 5642779)
5. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((id_grupoevento = e.id_grupoevento) AND (id_tipoevento = e.id_tipoevento))
6. 0.000 0.000 ↓ 0.0 0

Index Scan using syo_campanhatelefonia_pkey on syo_campanhatelefonia ct (cost=0.13..0.16 rows=1 width=14) (never executed)

  • Index Cond: (id_campanhatelefonia = tp.id_campanhatelefonia)
7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using syo_lista_eventos_agente on syo_encaminhamento en (cost=0.43..15.40 rows=3 width=8) (never executed)

  • Index Cond: ((id_evento = 5642779) AND (id_statusagenteativo = 'S'::text) AND (id_empresa = tp.id_empresa))
  • Heap Fetches: 0
Planning time : 0.987 ms
Execution time : 0.142 ms