explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 63ADL

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.182 ↑ 6.0 1 1

Merge Join (cost=15.25..21.26 rows=6 width=9) (actual time=0.181..0.182 rows=1 loops=1)

  • Merge Cond: (tp.id_empresa = en.id_empresa)
2. 0.024 0.162 ↓ 4.0 12 1

Sort (cost=11.88..11.92 rows=3 width=17) (actual time=0.162..0.162 rows=12 loops=1)

  • Sort Key: tp.id_empresa
  • Sort Method: quicksort Memory: 25kB
3. 0.018 0.138 ↓ 4.0 12 1

Nested Loop (cost=5.91..11.73 rows=3 width=17) (actual time=0.050..0.138 rows=12 loops=1)

4. 0.011 0.101 ↓ 6.3 19 1

Nested Loop (cost=5.04..8.63 rows=3 width=12) (actual time=0.047..0.101 rows=19 loops=1)

5. 0.017 0.017 ↑ 1.0 1 1

Index Only Scan using fk_evento_acao on syo_evento e (cost=3.34..4.55 rows=1 width=27) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (id_evento = 5642779)
  • Heap Fetches: 1
6. 0.073 0.073 ↓ 19.0 19 1

Index Scan using syo_tipoevento_select on syo_tipoevento tp (cost=1.70..4.02 rows=1 width=33) (actual time=0.024..0.073 rows=19 loops=1)

  • Index Cond: ((id_grupoevento = e.id_grupoevento) AND (id_tipoevento = e.id_tipoevento))
7. 0.019 0.019 ↑ 1.0 1 19

Index Scan using syo_campanhatelefonia_pkey on syo_campanhatelefonia ct (cost=0.87..0.98 rows=1 width=13) (actual time=0.001..0.001 rows=1 loops=19)

  • Index Cond: (id_campanhatelefonia = tp.id_campanhatelefonia)
8. 0.013 0.013 ↑ 33.0 1 1

Index Only Scan using syo_lista_eventos_agente on syo_encaminhamento en (cost=3.38..8.44 rows=33 width=8) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ((id_evento = 5642779) AND (id_statusagenteativo = 'S'::text))
  • Heap Fetches: 0
Planning time : 1.930 ms
Execution time : 0.269 ms