explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EWCX : VIAMAR

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.145 ↑ 6.0 1 1

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

2. 0.026 0.100 ↓ 7.5 15 1

Nested Loop (cost=0.84..17.26 rows=2 width=18) (actual time=0.029..0.100 rows=15 loops=1)

3. 0.016 0.058 ↓ 5.3 16 1

Nested Loop (cost=0.71..16.75 rows=3 width=12) (actual time=0.026..0.058 rows=16 loops=1)

4. 0.011 0.011 ↑ 1.0 1 1

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

  • Index Cond: (id_evento = 1682662)
5. 0.031 0.031 ↓ 16.0 16 1

Index Scan using syo_tipoevento_select on syo_tipoevento tp (cost=0.28..8.30 rows=1 width=34) (actual time=0.012..0.031 rows=16 loops=1)

  • Index Cond: ((id_grupoevento = e.id_grupoevento) AND (id_tipoevento = e.id_tipoevento))
6. 0.016 0.016 ↑ 1.0 1 16

Index Scan using syo_campanhatelefonia_pkey on syo_campanhatelefonia ct (cost=0.13..0.16 rows=1 width=14) (actual time=0.001..0.001 rows=1 loops=16)

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

Index Only Scan using syo_lista_eventos_agente on syo_encaminhamento en (cost=0.43..15.40 rows=3 width=8) (actual time=0.002..0.002 rows=0 loops=15)

  • Index Cond: ((id_evento = 1682662) AND (id_statusagenteativo = 'S'::text) AND (id_empresa = tp.id_empresa))
  • Heap Fetches: 1
Planning time : 0.733 ms
Execution time : 0.188 ms