explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IKQk

Settings
# exclusive inclusive rows x rows loops node
1. 0.222 6,090.386 ↓ 92.0 92 1

Nested Loop Left Join (cost=5.64..163.34 rows=1 width=16) (actual time=43.344..6,090.386 rows=92 loops=1)

2. 0.196 2.616 ↓ 92.0 92 1

Nested Loop (cost=5.64..163.32 rows=1 width=12) (actual time=0.111..2.616 rows=92 loops=1)

3. 0.135 1.776 ↓ 92.0 92 1

Nested Loop (cost=5.21..154.86 rows=1 width=12) (actual time=0.098..1.776 rows=92 loops=1)

4. 0.079 0.445 ↓ 92.0 92 1

Nested Loop (cost=4.92..150.54 rows=1 width=30) (actual time=0.069..0.445 rows=92 loops=1)

5. 0.038 0.078 ↑ 1.1 8 1

Bitmap Heap Scan on matriculaperiodo (cost=4.49..39.44 rows=9 width=13) (actual time=0.049..0.078 rows=8 loops=1)

  • Recheck Cond: ((matricula)::text = '16105000018'::text)
  • Heap Blocks: exact=8
6. 0.040 0.040 ↑ 1.1 8 1

Bitmap Index Scan on idx_matriculaperiodo_matricula_ano_semestre (cost=0.00..4.49 rows=9 width=0) (actual time=0.040..0.040 rows=8 loops=1)

  • Index Cond: ((matricula)::text = '16105000018'::text)
7. 0.288 0.288 ↓ 12.0 12 8

Index Scan using ch_matriculaperiodoturmadisciplina_matriculaperiodo on matriculaperiodoturmadisciplina (cost=0.43..12.33 rows=1 width=25) (actual time=0.011..0.036 rows=12 loops=8)

  • Index Cond: (matriculaperiodo = matriculaperiodo.codigo)
  • Filter: ((matricula)::text = '16105000018'::text)
8. 1.196 1.196 ↑ 1.0 1 92

Index Only Scan using matricula_pkey on matricula (cost=0.29..4.31 rows=1 width=9) (actual time=0.012..0.013 rows=1 loops=92)

  • Index Cond: (matricula = '16105000018'::text)
  • Heap Fetches: 92
9. 0.644 0.644 ↑ 1.0 1 92

Index Scan using index_historico_matriculaperiodoturmadisciplina on historico (cost=0.43..8.45 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=92)

  • Index Cond: (matriculaperiodoturmadisciplina = matriculaperiodoturmadisciplina.codigo)
10. 6,087.548 6,087.548 ↑ 1.0 1 92

Function Scan on jean_periodoauladisciplinaaluno horario (cost=0.00..0.01 rows=1 width=4) (actual time=66.169..66.169 rows=1 loops=92)

  • Filter: (professor_codigo IS NOT NULL)
Planning time : 1.516 ms
Execution time : 6,090.611 ms