explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WmJL

Settings
# exclusive inclusive rows x rows loops node
1. 43.975 72,644.597 ↑ 1.0 1 1

Limit (cost=1,930,548.47..1,930,548.58 rows=1 width=347) (actual time=72,600.631..72,644.597 rows=1 loops=1)

2. 0.086 72,600.622 ↑ 293.0 1 1

Unique (cost=1,930,548.47..1,930,582.16 rows=293 width=347) (actual time=72,600.576..72,600.622 rows=1 loops=1)

3. 31.720 72,600.536 ↑ 293.0 1 1

Sort (cost=1,930,548.47..1,930,549.20 rows=293 width=347) (actual time=72,600.490..72,600.536 rows=1 loops=1)

  • Sort Key: arquivo.dataupload DESC, arquivo.codigo, arquivo.codorigem, arquivo.nome, arquivo.apresentarportalcoordenador, arquivo.apresentarportalprofessor, arquivo.apresentarportalaluno, arquivo.descricao, arquivo.descricaoarquivo, arquivo.datadisponibilizacao, arquivo.dataindisponibilizacao, arquivo.manterdisponibilizacao, arquivo.controlardownload, arquivo.responsavelupload, arquivo.disciplina, arquivo.turma, arquivo.extensao, arquivo.apresentardeterminadoperiodo, arquivo.permitirarquivoresposta, arquivo.pastabasearquivo, arquivo.arquivoresposta, arquivo.professor, arquivo.niveleducacional, arquivo.cpfalunodocumentacao, arquivo.cpfrequerimento, arquivo.servidorarquivoonline, arquivo.indice, arquivo.agrupador, arquivo.indiceagrupador, arquivo.arquivoassinadodigitalmente, disciplina.codigo, disciplina.nome, turma.codigo, turma.identificadorturma, usuario.codigo, usuario.nome, professor.codigo, professor.nome, pessoa.codigo, pessoa.nome, curso.codigo, curso.nome, arquivo.arquivoassinadofuncionario, arquivo.arquivoassinadounidadeensino, arquivo.arquivoassinadounidadecertificadora
  • Sort Method: quicksort Memory: 297kB
4. 819.925 72,568.816 ↓ 1.8 534 1

Nested Loop Left Join (cost=250.94..1,930,536.46 rows=293 width=347) (actual time=279.796..72,568.816 rows=534 loops=1)

  • Join Filter: (arquivo.curso = curso.codigo)
  • Rows Removed by Join Filter: 29784
5. 46.498 70,983.135 ↓ 1.8 534 1

Nested Loop Left Join (cost=250.94..1,930,241.11 rows=293 width=323) (actual time=276.936..70,983.135 rows=534 loops=1)

6. 45.092 70,922.753 ↓ 1.8 534 1

Nested Loop Left Join (cost=250.52..1,927,932.92 rows=293 width=301) (actual time=276.868..70,922.753 rows=534 loops=1)

7. 45.666 70,863.243 ↓ 1.8 534 1

Nested Loop Left Join (cost=250.10..1,925,624.74 rows=293 width=271) (actual time=276.800..70,863.243 rows=534 loops=1)

8. 44.852 70,791.945 ↓ 1.8 534 1

Nested Loop Left Join (cost=249.81..1,924,163.37 rows=293 width=240) (actual time=276.706..70,791.945 rows=534 loops=1)

9. 43.640 70,723.063 ↓ 1.8 534 1

Nested Loop Left Join (cost=249.53..1,923,707.47 rows=293 width=216) (actual time=276.619..70,723.063 rows=534 loops=1)

10. 186.037 70,665.005 ↓ 1.8 534 1

Bitmap Heap Scan on arquivo (cost=249.25..1,923,476.30 rows=293 width=205) (actual time=276.543..70,665.005 rows=534 loops=1)

  • Recheck Cond: (((situacao)::text = 'AT'::text) AND ((origem)::text = ANY ('{IN,PR}'::text[])) AND ((origem)::text = 'IN'::text))
  • Filter: (apresentarportalprofessor AND ((niveleducacional)::text <> ''::text) AND ((professor = 119425) OR (SubPlan 1)))
  • Rows Removed by Filter: 3130
  • Heap Blocks: exact=177
11. 0.253 2.380 ↓ 0.0 0 1

BitmapAnd (cost=249.25..249.25 rows=604 width=0) (actual time=2.335..2.380 rows=0 loops=1)

12. 0.640 0.640 ↓ 2.4 3,783 1

Bitmap Index Scan on idx_arquivo_disc_datadisp_dataindisp_parcial (cost=0.00..40.16 rows=1,577 width=0) (actual time=0.594..0.640 rows=3,783 loops=1)

13. 1.487 1.487 ↓ 1.0 4,105 1

Bitmap Index Scan on idx_arquivo_codorigem_origem (cost=0.00..208.68 rows=4,103 width=0) (actual time=1.442..1.487 rows=4,105 loops=1)

  • Index Cond: ((origem)::text = 'IN'::text)
14.          

SubPlan (for Bitmap Heap Scan)

15. 708.027 70,476.588 ↓ 0.0 0 3,636

Append (cost=3,177.07..13,632.58 rows=1,598 width=4) (actual time=19.383..19.383 rows=0 loops=3,636)

16. 328.996 10,835.280 ↓ 0.0 0 3,636

Result (cost=3,177.07..11,219.85 rows=1,461 width=4) (actual time=2.980..2.980 rows=0 loops=3,636)

  • One-Time Filter: ((arquivo.curso IS NULL) AND (arquivo.turma IS NULL) AND (arquivo.disciplina IS NULL) AND (arquivo.professor IS NULL))
17. 0.000 10,506.284 ↑ 1,461.0 1 4

Hash Join (cost=3,177.07..11,219.85 rows=1,461 width=4) (actual time=2,626.560..2,626.571 rows=1 loops=4)

  • Hash Cond: (htdi.horarioturmadia = htd.codigo)
18. 0.000 200.336 ↑ 169.4 34 4

Gather (cost=1,000.00..9,006.58 rows=5,758 width=4) (actual time=29.139..50.084 rows=34 loops=4)

  • Workers Planned: 2
  • Workers Launched: 2
19. 506.128 506.128 ↑ 2.9 831 12 / 3

Parallel Seq Scan on horarioturmadiaitem htdi (cost=0.00..7,430.78 rows=2,399 width=4) (actual time=7.568..126.532 rows=831 loops=12)

  • Filter: (professor = 119425)
  • Rows Removed by Filter: 67974
20. 2,323.496 10,339.296 ↓ 1.0 19,257 4

Hash (cost=1,941.19..1,941.19 rows=18,870 width=8) (actual time=2,584.810..2,584.824 rows=19,257 loops=4)

  • Buckets: 32768 Batches: 1 Memory Usage: 677kB
21. 4,364.328 8,015.800 ↓ 1.0 19,257 4

Nested Loop (cost=16.25..1,941.19 rows=18,870 width=8) (actual time=32.611..2,003.950 rows=19,257 loops=4)

22. 85.093 1,095.472 ↑ 1.0 100 4

Hash Join (cost=15.96..153.25 rows=100 width=4) (actual time=31.841..273.868 rows=100 loops=4)

  • Hash Cond: (t.codigo = ht.turma)
23. 512.400 981.248 ↑ 2.0 514 4

Hash Join (cost=3.05..134.08 rows=1,052 width=4) (actual time=2.241..245.312 rows=514 loops=4)

  • Hash Cond: (t.curso = c.codigo)
24. 467.260 467.260 ↑ 1.0 4,147 4

Seq Scan on turma t (cost=0.00..119.47 rows=4,147 width=8) (actual time=0.095..116.815 rows=4,147 loops=4)

25. 0.748 1.588 ↑ 5.7 3 4

Hash (cost=2.84..2.84 rows=17 width=4) (actual time=0.378..0.397 rows=3 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
26. 0.840 0.840 ↑ 5.7 3 4

Seq Scan on curso c (cost=0.00..2.84 rows=17 width=4) (actual time=0.088..0.210 rows=3 loops=4)

  • Filter: ((arquivo.niveleducacional)::text = (niveleducacional)::text)
  • Rows Removed by Filter: 64
27. 14.372 29.131 ↑ 1.0 396 1

Hash (cost=7.96..7.96 rows=396 width=8) (actual time=29.058..29.131 rows=396 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
28. 14.759 14.759 ↑ 1.0 396 1

Seq Scan on horarioturma ht (cost=0.00..7.96 rows=396 width=8) (actual time=0.076..14.759 rows=396 loops=1)

29. 2,556.000 2,556.000 ↑ 1.0 193 400

Index Scan using fk_horarioturmadia_horarioturma on horarioturmadia htd (cost=0.29..15.93 rows=195 width=8) (actual time=0.094..6.390 rows=193 loops=400)

  • Index Cond: (horarioturma = ht.codigo)
30. 89.401 116.224 ↓ 0.0 0 3,632

Result (cost=13.63..1,321.12 rows=93 width=4) (actual time=0.032..0.032 rows=0 loops=3,632)

  • One-Time Filter: ((arquivo.turma IS NULL) AND (arquivo.disciplina IS NULL) AND (arquivo.professor IS NULL))
31. 0.038 26.823 ↑ 93.0 1 1

Nested Loop (cost=13.63..1,321.12 rows=93 width=4) (actual time=26.778..26.823 rows=1 loops=1)

32. 0.026 26.525 ↑ 1,202.0 1 1

Nested Loop (cost=13.20..253.33 rows=1,202 width=8) (actual time=26.477..26.525 rows=1 loops=1)

33. 0.021 26.350 ↑ 6.0 1 1

Nested Loop (cost=12.91..146.06 rows=6 width=4) (actual time=26.304..26.350 rows=1 loops=1)

34. 0.227 26.095 ↑ 6.0 1 1

Hash Join (cost=12.91..143.14 rows=6 width=8) (actual time=26.035..26.095 rows=1 loops=1)

  • Hash Cond: (t_1.codigo = ht_1.turma)
35. 3.632 3.632 ↑ 33.5 2 1

Seq Scan on turma t_1 (cost=0.00..129.84 rows=67 width=8) (actual time=3.559..3.632 rows=2 loops=1)

  • Filter: (curso = arquivo.curso)
  • Rows Removed by Filter: 4025
36. 10.346 22.236 ↑ 1.0 396 1

Hash (cost=7.96..7.96 rows=396 width=8) (actual time=22.191..22.236 rows=396 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
37. 11.890 11.890 ↑ 1.0 396 1

Seq Scan on horarioturma ht_1 (cost=0.00..7.96 rows=396 width=8) (actual time=0.072..11.890 rows=396 loops=1)

38. 0.075 0.234 ↑ 1.0 1 1

Materialize (cost=0.00..2.84 rows=1 width=4) (actual time=0.188..0.234 rows=1 loops=1)

39. 0.159 0.159 ↑ 1.0 1 1

Seq Scan on curso c_1 (cost=0.00..2.84 rows=1 width=4) (actual time=0.112..0.159 rows=1 loops=1)

  • Filter: (codigo = arquivo.curso)
  • Rows Removed by Filter: 54
40. 0.149 0.149 ↑ 195.0 1 1

Index Scan using fk_horarioturmadia_horarioturma on horarioturmadia htd_1 (cost=0.29..15.93 rows=195 width=8) (actual time=0.092..0.149 rows=1 loops=1)

  • Index Cond: (horarioturma = ht_1.codigo)
41. 0.260 0.260 ↑ 1.0 1 1

Index Scan using idx_horturdiaitem_horturmdia on horarioturmadiaitem htdi_1 (cost=0.42..0.88 rows=1 width=4) (actual time=0.204..0.260 rows=1 loops=1)

  • Index Cond: (horarioturmadia = htd_1.codigo)
  • Filter: (professor = 119425)
  • Rows Removed by Filter: 2
42. 181.253 58,361.063 ↓ 0.0 0 3,631

Result (cost=1.00..280.06 rows=15 width=4) (actual time=16.073..16.073 rows=0 loops=3,631)

  • One-Time Filter: ((arquivo.disciplina IS NULL) AND (arquivo.professor IS NULL))
43. 16,663.099 58,179.810 ↓ 0.0 0 3,615

Nested Loop (cost=1.00..280.06 rows=15 width=4) (actual time=16.094..16.094 rows=0 loops=3,615)

44. 16,029.058 27,217.335 ↑ 2.2 86 3,615

Nested Loop (cost=0.57..113.05 rows=188 width=8) (actual time=0.570..7.529 rows=86 loops=3,615)

45. 462.338 2,194.305 ↑ 1.0 1 3,615

Nested Loop (cost=0.28..20.11 rows=1 width=4) (actual time=0.443..0.607 rows=1 loops=3,615)

46. 590.751 1,406.235 ↑ 1.0 1 3,615

Nested Loop (cost=0.28..17.26 rows=1 width=8) (actual time=0.292..0.389 rows=1 loops=3,615)

47. 607.320 607.320 ↑ 1.0 1 3,615

Seq Scan on horarioturma ht_2 (cost=0.00..8.95 rows=1 width=8) (actual time=0.134..0.168 rows=1 loops=3,615)

  • Filter: (turma = arquivo.turma)
  • Rows Removed by Filter: 392
48. 208.164 208.164 ↑ 1.0 1 2,739

Index Scan using turma_pkey on turma t_2 (cost=0.28..8.30 rows=1 width=8) (actual time=0.051..0.076 rows=1 loops=2,739)

  • Index Cond: (codigo = arquivo.turma)
  • Filter: (curso = arquivo.curso)
  • Rows Removed by Filter: 0
49. 325.732 325.732 ↑ 1.0 1 2,692

Seq Scan on curso c_2 (cost=0.00..2.84 rows=1 width=4) (actual time=0.092..0.121 rows=1 loops=2,692)

  • Filter: (codigo = arquivo.curso)
  • Rows Removed by Filter: 64
50. 8,993.972 8,993.972 ↑ 1.7 115 2,692

Index Scan using fk_horarioturmadia_horarioturma on horarioturmadia htd_2 (cost=0.29..90.99 rows=195 width=8) (actual time=0.056..3.341 rows=115 loops=2,692)

  • Index Cond: (horarioturma = ht_2.codigo)
51. 14,299.376 14,299.376 ↓ 0.0 0 310,856

Index Scan using idx_horturdiaitem_horturmdia on horarioturmadiaitem htdi_2 (cost=0.42..0.88 rows=1 width=4) (actual time=0.046..0.046 rows=0 loops=310,856)

  • Index Cond: (horarioturmadia = htd_2.codigo)
  • Filter: (professor = 119425)
  • Rows Removed by Filter: 5
52. 77.550 77.550 ↓ 0.0 0 3,102

Result (cost=1.27..171.16 rows=1 width=4) (actual time=0.025..0.025 rows=0 loops=3,102)

  • One-Time Filter: ((arquivo.turma IS NULL) AND (arquivo.professor IS NULL))
53. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.27..171.16 rows=1 width=4) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.27..168.32 rows=1 width=8) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.99..153.51 rows=12 width=8) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..150.02 rows=12 width=4) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_horturdiaitem_disc_prof on horarioturmadiaitem htdi_3 (cost=0.42..50.30 rows=12 width=4) (never executed)

  • Index Cond: ((arquivo.disciplina = disciplina) AND (professor = 119425))
58. 0.000 0.000 ↓ 0.0 0

Index Scan using horarioturmadia_pkey on horarioturmadia htd_3 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Index Cond: (codigo = htdi_3.horarioturmadia)
59. 0.000 0.000 ↓ 0.0 0

Index Scan using horarioturma_pkey on horarioturma ht_3 (cost=0.27..0.29 rows=1 width=8) (never executed)

  • Index Cond: (codigo = htd_3.horarioturma)
60. 0.000 0.000 ↓ 0.0 0

Index Scan using turma_pkey on turma t_3 (cost=0.28..1.23 rows=1 width=8) (never executed)

  • Index Cond: (codigo = ht_3.turma)
  • Filter: (curso = arquivo.curso)
61. 0.000 0.000 ↓ 0.0 0

Seq Scan on curso c_3 (cost=0.00..2.84 rows=1 width=4) (never executed)

  • Filter: (codigo = arquivo.curso)
62. 85.209 86.856 ↓ 0.0 0 3,102

Result (cost=1.27..165.38 rows=1 width=4) (actual time=0.028..0.028 rows=0 loops=3,102)

  • One-Time Filter: ((arquivo.curso IS NULL) AND (arquivo.professor IS NULL))
63. 0.387 1.647 ↓ 0.0 0 9

Nested Loop (cost=1.27..165.38 rows=1 width=4) (actual time=0.176..0.183 rows=0 loops=9)

  • Join Filter: (t_4.curso = c_4.codigo)
64. 0.351 1.260 ↓ 0.0 0 9

Nested Loop (cost=1.27..161.87 rows=1 width=8) (actual time=0.134..0.140 rows=0 loops=9)

65. 0.324 0.909 ↓ 0.0 0 9

Nested Loop (cost=0.99..153.56 rows=1 width=8) (actual time=0.094..0.101 rows=0 loops=9)

66. 0.351 0.585 ↓ 0.0 0 9

Nested Loop (cost=0.71..150.02 rows=12 width=4) (actual time=0.058..0.065 rows=0 loops=9)

67. 0.234 0.234 ↓ 0.0 0 9

Index Scan using idx_horturdiaitem_disc_prof on horarioturmadiaitem htdi_4 (cost=0.42..50.30 rows=12 width=4) (actual time=0.020..0.026 rows=0 loops=9)

  • Index Cond: ((arquivo.disciplina = disciplina) AND (professor = 119425))
68. 0.000 0.000 ↓ 0.0 0

Index Scan using horarioturmadia_pkey on horarioturmadia htd_4 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Index Cond: (codigo = htdi_4.horarioturmadia)
69. 0.000 0.000 ↓ 0.0 0

Index Scan using horarioturma_pkey on horarioturma ht_4 (cost=0.27..0.29 rows=1 width=8) (never executed)

  • Index Cond: (codigo = htd_4.horarioturma)
  • Filter: (turma = arquivo.turma)
70. 0.000 0.000 ↓ 0.0 0

Index Scan using turma_pkey on turma t_4 (cost=0.28..8.30 rows=1 width=8) (never executed)

  • Index Cond: (codigo = arquivo.turma)
71. 0.000 0.000 ↓ 0.0 0

Seq Scan on curso c_4 (cost=0.00..2.67 rows=67 width=4) (never executed)

72. 72.594 204.732 ↓ 0.0 0 3,102

Result (cost=1.00..280.72 rows=15 width=4) (actual time=0.066..0.066 rows=0 loops=3,102)

  • One-Time Filter: ((arquivo.curso IS NULL) AND (arquivo.disciplina IS NULL) AND (arquivo.professor IS NULL))
73. 41.670 132.138 ↓ 0.0 0 9

Nested Loop (cost=1.00..280.72 rows=15 width=4) (actual time=14.675..14.682 rows=0 loops=9)

74. 30.204 62.496 ↑ 2.2 86 9

Nested Loop (cost=0.57..113.71 rows=188 width=8) (actual time=1.173..6.944 rows=86 loops=9)

75. 4.551 10.548 ↓ 0.0 0 9

Nested Loop (cost=0.28..20.77 rows=1 width=4) (actual time=1.090..1.172 rows=0 loops=9)

  • Join Filter: (t_5.curso = c_5.codigo)
  • Rows Removed by Join Filter: 19
76. 0.633 1.899 ↓ 0.0 0 9

Nested Loop (cost=0.28..17.26 rows=1 width=8) (actual time=0.144..0.211 rows=0 loops=9)

77. 1.035 1.035 ↓ 0.0 0 9

Seq Scan on horarioturma ht_5 (cost=0.00..8.95 rows=1 width=8) (actual time=0.079..0.115 rows=0 loops=9)

  • Filter: (turma = arquivo.turma)
  • Rows Removed by Filter: 396
78. 0.231 0.231 ↑ 1.0 1 3

Index Scan using turma_pkey on turma t_5 (cost=0.28..8.30 rows=1 width=8) (actual time=0.033..0.077 rows=1 loops=3)

  • Index Cond: (codigo = arquivo.turma)
79. 4.098 4.098 ↑ 1.2 58 3

Seq Scan on curso c_5 (cost=0.00..2.67 rows=67 width=4) (actual time=0.040..1.366 rows=58 loops=3)

80. 21.744 21.744 ↓ 1.3 259 3

Index Scan using fk_horarioturmadia_horarioturma on horarioturmadia htd_5 (cost=0.29..90.99 rows=195 width=8) (actual time=0.110..7.248 rows=259 loops=3)

  • Index Cond: (horarioturma = ht_5.codigo)
81. 27.972 27.972 ↓ 0.0 0 777

Index Scan using idx_horturdiaitem_horturmdia on horarioturmadiaitem htdi_5 (cost=0.42..0.88 rows=1 width=4) (actual time=0.036..0.036 rows=0 loops=777)

  • Index Cond: (horarioturmadia = htd_5.codigo)
  • Filter: (professor = 119425)
  • Rows Removed by Filter: 5
82. 86.856 86.856 ↓ 0.0 0 3,102

Result (cost=1.41..170.32 rows=12 width=4) (actual time=0.028..0.028 rows=0 loops=3,102)

  • One-Time Filter: ((arquivo.curso IS NULL) AND (arquivo.turma IS NULL) AND (arquivo.professor IS NULL))
83. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.41..170.32 rows=12 width=4) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.27..168.26 rows=12 width=8) (never executed)

85. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.99..153.51 rows=12 width=8) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..150.02 rows=12 width=4) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_horturdiaitem_disc_prof on horarioturmadiaitem htdi_6 (cost=0.42..50.30 rows=12 width=4) (never executed)

  • Index Cond: ((arquivo.disciplina = disciplina) AND (professor = 119425))
88. 0.000 0.000 ↓ 0.0 0

Index Scan using horarioturmadia_pkey on horarioturmadia htd_6 (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Index Cond: (codigo = htdi_6.horarioturmadia)
89. 0.000 0.000 ↓ 0.0 0

Index Scan using horarioturma_pkey on horarioturma ht_6 (cost=0.27..0.29 rows=1 width=8) (never executed)

  • Index Cond: (codigo = htd_6.horarioturma)
90. 0.000 0.000 ↓ 0.0 0

Index Scan using turma_pkey on turma t_6 (cost=0.28..1.23 rows=1 width=8) (never executed)

  • Index Cond: (codigo = ht_6.turma)
91. 0.000 0.000 ↓ 0.0 0

Index Only Scan using curso_pkey on curso c_6 (cost=0.14..0.16 rows=1 width=4) (never executed)

  • Index Cond: (codigo = t_6.curso)
  • Heap Fetches: 0
92. 14.418 14.418 ↓ 0.0 0 534

Index Scan using disciplina_pkey on disciplina (cost=0.28..0.79 rows=1 width=23) (actual time=0.027..0.027 rows=0 loops=534)

  • Index Cond: (arquivo.disciplina = codigo)
93. 24.030 24.030 ↑ 1.0 1 534

Index Scan using turma_pkey on turma (cost=0.28..1.56 rows=1 width=24) (actual time=0.045..0.045 rows=1 loops=534)

  • Index Cond: (arquivo.turma = codigo)
94. 25.632 25.632 ↑ 1.0 1 534

Index Scan using usuario_pkey on usuario (cost=0.29..4.99 rows=1 width=31) (actual time=0.048..0.048 rows=1 loops=534)

  • Index Cond: (arquivo.responsavelupload = codigo)
95. 14.418 14.418 ↓ 0.0 0 534

Index Scan using pessoa_pkey on pessoa professor (cost=0.42..7.88 rows=1 width=30) (actual time=0.027..0.027 rows=0 loops=534)

  • Index Cond: (arquivo.professor = codigo)
96. 13.884 13.884 ↓ 0.0 0 534

Index Scan using pessoa_pkey on pessoa (cost=0.42..7.88 rows=1 width=30) (actual time=0.026..0.026 rows=0 loops=534)

  • Index Cond: (arquivo.pessoa = codigo)
97. 764.623 765.756 ↑ 1.2 57 534

Materialize (cost=0.00..3.00 rows=67 width=21) (actual time=0.025..1.434 rows=57 loops=534)

98. 1.133 1.133 ↑ 1.0 67 1

Seq Scan on curso (cost=0.00..2.67 rows=67 width=21) (actual time=0.029..1.133 rows=67 loops=1)

Planning time : 54.149 ms
Execution time : 72,655.769 ms