explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HUxX

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 0.288 ↑ 1.0 3 1

Nested Loop (cost=0.42..31.85 rows=3 width=128) (actual time=0.187..0.288 rows=3 loops=1)

2. 0.019 0.140 ↑ 1.0 3 1

Nested Loop (cost=0.28..26.50 rows=3 width=10) (actual time=0.111..0.140 rows=3 loops=1)

3. 0.073 0.073 ↑ 1.0 3 1

Seq Scan on ed_aulas_previstas_etapa (cost=0.00..1.60 rows=3 width=10) (actual time=0.066..0.073 rows=3 loops=1)

  • Filter: (ed_disciplina_turma = 24975)
  • Rows Removed by Filter: 45
4. 0.048 0.048 ↑ 1.0 1 3

Index Scan using pk_ed_etapa_periodo on ed_etapa_periodo (cost=0.28..8.30 rows=1 width=8) (actual time=0.016..0.016 rows=1 loops=3)

  • Index Cond: (ed_etapa_periodo = ed_aulas_previstas_etapa.ed_etapa_periodo)
5. 0.024 0.024 ↑ 1.0 1 3

Index Scan using pk_ed_etapa on ed_etapa (cost=0.14..0.16 rows=1 width=122) (actual time=0.008..0.008 rows=1 loops=3)

  • Index Cond: (ed_etapa = ed_etapa_periodo.ed_etapa)
6.          

SubPlan (forNested Loop)

7. 0.045 0.102 ↑ 1.0 1 3

Aggregate (cost=1.62..1.63 rows=1 width=8) (actual time=0.034..0.034 rows=1 loops=3)

8. 0.057 0.057 ↓ 1.5 3 3

Seq Scan on ed_aulas_previstas_etapa ape (cost=0.00..1.60 rows=2 width=2) (actual time=0.013..0.019 rows=3 loops=3)

  • Filter: (ed_disciplina_turma = ed_aulas_previstas_etapa.ed_disciplina_turma)
  • Rows Removed by Filter: 45