explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5QhiP : VIGORITO

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

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

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

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

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

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

4. 0.004 0.090 ↓ 6.3 19 1

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

5. 0.019 0.019 ↑ 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.018..0.019 rows=1 loops=1)

  • Index Cond: (id_evento = 5642779)
  • Heap Fetches: 1
6. 0.067 0.067 ↓ 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.016..0.067 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.028 0.028 ↑ 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.028..0.028 rows=1 loops=1)

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