explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ugbG

Settings
# exclusive inclusive rows x rows loops node
1. 17.849 12,813.286 ↑ 2.0 9 1

Sort (cost=213,084.11..213,084.15 rows=18 width=7,643) (actual time=12,813.282..12,813.286 rows=9 loops=1)

  • Sort Key: vacinaapli0_.status, vacinaapli0_.dt_aplicacao DESC
  • Sort Method: quicksort Memory: 37kB
2. 0.139 12,795.437 ↑ 2.0 9 1

Nested Loop Left Join (cost=4.54..213,083.73 rows=18 width=7,643) (actual time=2,176.306..12,795.437 rows=9 loops=1)

  • Join Filter: (vacinaapli0_.cd_vacina = tipovacina47_.cd_vacina)
  • Rows Removed by Join Filter: 540
3. 0.035 12,795.298 ↑ 2.0 9 1

Nested Loop Left Join (cost=4.54..213,065.78 rows=18 width=7,610) (actual time=2,176.266..12,795.298 rows=9 loops=1)

4. 5.629 12,795.263 ↑ 2.0 9 1

Nested Loop Left Join (cost=4.11..212,913.59 rows=18 width=7,602) (actual time=2,176.255..12,795.263 rows=9 loops=1)

  • Join Filter: (vacinaapli0_.cd_usuario = usuario39_.cd_usuario)
  • Rows Removed by Join Filter: 18603
5. 12.126 12,789.634 ↑ 2.0 9 1

Nested Loop Left Join (cost=4.11..212,029.38 rows=18 width=7,569) (actual time=2,176.147..12,789.634 rows=9 loops=1)

  • Join Filter: (vacinaapli0_.cd_profissional_indicador = profission31_.cd_profissional_indicador)
  • Rows Removed by Join Filter: 306
6. 0.050 12,777.508 ↑ 2.0 9 1

Nested Loop Left Join (cost=4.11..212,018.78 rows=18 width=7,139) (actual time=2,164.088..12,777.508 rows=9 loops=1)

  • Join Filter: (vacinaapli0_.cd_domicilio = enderecodo29_.cd_domicilio)
  • Rows Removed by Join Filter: 9
7. 25.762 12,777.458 ↑ 2.0 9 1

Nested Loop Left Join (cost=4.11..212,017.50 rows=18 width=7,131) (actual time=2,164.064..12,777.458 rows=9 loops=1)

  • Join Filter: ((produtovac20_.cod_pro)::text = (produto43_.cod_pro)::text)
  • Rows Removed by Join Filter: 50382
8. 0.152 12,751.696 ↑ 2.0 9 1

Nested Loop Left Join (cost=4.11..210,289.06 rows=18 width=7,083) (actual time=2,145.774..12,751.696 rows=9 loops=1)

  • Join Filter: (produtovac20_.cd_vacina = tipovacina22_.cd_vacina)
  • Rows Removed by Join Filter: 540
9. 4.370 12,751.544 ↑ 2.0 9 1

Nested Loop Left Join (cost=4.11..210,271.11 rows=18 width=7,050) (actual time=2,145.725..12,751.544 rows=9 loops=1)

  • Join Filter: (vacinaapli0_.cd_produto_vacina = produtovac20_.cd_produto_vacina)
  • Rows Removed by Join Filter: 1827
10. 0.031 12,747.174 ↑ 2.0 9 1

Nested Loop Left Join (cost=4.11..210,211.76 rows=18 width=7,027) (actual time=2,141.623..12,747.174 rows=9 loops=1)

  • Join Filter: (vacinaapli0_.cd_registro_vacinas = registrova19_.cd_reg_vac)
11. 5.372 12,747.143 ↑ 2.0 9 1

Nested Loop Left Join (cost=4.11..210,139.61 rows=18 width=7,019) (actual time=2,141.607..12,747.143 rows=9 loops=1)

  • Join Filter: (vacinaapli0_.cd_usuario_canc = usuario15_.cd_usuario)
  • Rows Removed by Join Filter: 18603
12. 0.030 12,741.771 ↑ 2.0 9 1

Nested Loop Left Join (cost=4.11..209,255.40 rows=18 width=6,986) (actual time=2,141.532..12,741.771 rows=9 loops=1)

13. 0.059 12,741.741 ↑ 2.0 9 1

Nested Loop Left Join (cost=3.83..209,121.82 rows=18 width=6,978) (actual time=2,141.523..12,741.741 rows=9 loops=1)

  • Join Filter: (vacinaapli0_.cd_estrategia = calendario11_.cd_calendario)
  • Rows Removed by Join Filter: 74
14. 8.244 12,741.682 ↑ 2.0 9 1

Nested Loop Left Join (cost=3.83..209,118.28 rows=18 width=6,852) (actual time=2,141.504..12,741.682 rows=9 loops=1)

  • Join Filter: (vacinaapli0_.cd_motivo_vacina_especial = motivo10_.cd_motivo)
  • Rows Removed by Join Filter: 972
15. 50.433 12,733.438 ↑ 2.0 9 1

Nested Loop Left Join (cost=3.83..209,085.77 rows=18 width=6,805) (actual time=2,133.422..12,733.438 rows=9 loops=1)

  • Join Filter: (vacinaapli0_.empresa = empresa9_.empresa)
  • Rows Removed by Join Filter: 11718
16. 12.755 12,683.005 ↑ 2.0 9 1

Nested Loop Left Join (cost=3.83..208,667.67 rows=18 width=6,717) (actual time=2,133.072..12,683.005 rows=9 loops=1)

  • Join Filter: (vacinacale5_.cd_calendario_vacinacao = calendario27_.cd_calendario)
  • Rows Removed by Join Filter: 81
17. 28.657 12,670.250 ↑ 2.0 9 1

Nested Loop Left Join (cost=3.83..208,664.13 rows=18 width=6,591) (actual time=2,120.349..12,670.250 rows=9 loops=1)

  • Join Filter: (vacinacale5_.cd_usuario_canc = usuario21_.cd_usuario)
  • Rows Removed by Join Filter: 18612
18. 0.142 12,641.593 ↑ 2.0 9 1

Nested Loop Left Join (cost=3.83..207,779.92 rows=18 width=6,569) (actual time=2,094.025..12,641.593 rows=9 loops=1)

  • Join Filter: (vacinacale5_.cd_vacina = tipovacina18_.cd_vacina)
  • Rows Removed by Join Filter: 540
19. 12.029 12,641.451 ↑ 2.0 9 1

Nested Loop Left Join (cost=3.83..207,761.97 rows=18 width=6,536) (actual time=2,093.978..12,641.451 rows=9 loops=1)

  • Join Filter: (vacinaapli0_.cd_calendario = vacinacale5_.cd_calendario)
  • Rows Removed by Join Filter: 4221
20. 9.354 12,629.422 ↑ 2.0 9 1

Nested Loop Left Join (cost=3.83..207,621.48 rows=18 width=5,868) (actual time=2,082.894..12,629.422 rows=9 loops=1)

  • Join Filter: (profission3_.cod_cid = cidade45_.cod_cid)
  • Rows Removed by Join Filter: 51207
21. 15.337 12,620.068 ↑ 2.0 9 1

Nested Loop Left Join (cost=3.83..205,946.05 rows=18 width=5,848) (actual time=2,080.969..12,620.068 rows=9 loops=1)

  • Join Filter: (profission3_.cd_cnes_processo = cnesproces42_.cd_cnes_processo)
  • Rows Removed by Join Filter: 60
22. 49.016 12,604.731 ↑ 2.0 9 1

Nested Loop Left Join (cost=3.83..205,943.08 rows=18 width=5,840) (actual time=2,065.661..12,604.731 rows=9 loops=1)

23. 11.067 12,555.715 ↑ 2.0 9 1

Nested Loop Left Join (cost=2.42..205,783.12 rows=18 width=4,394) (actual time=2,026.551..12,555.715 rows=9 loops=1)

  • Join Filter: (usuariocad1_.cod_cid_nascimento = cidade48_.cod_cid)
  • Rows Removed by Join Filter: 51201
24. 5.307 12,544.648 ↑ 2.0 9 1

Nested Loop Left Join (cost=2.42..204,107.69 rows=18 width=4,374) (actual time=2,023.032..12,544.648 rows=9 loops=1)

  • Join Filter: (usuariocad1_.cd_usuario = usuario46_.cd_usuario)
  • Rows Removed by Join Filter: 18603
25. 12.699 12,539.341 ↑ 2.0 9 1

Nested Loop Left Join (cost=2.42..203,223.48 rows=18 width=4,341) (actual time=2,022.912..12,539.341 rows=9 loops=1)

  • Join Filter: (usuariocad1_.cd_raca = raca41_.cd_raca)
  • Rows Removed by Join Filter: 36
26. 0.028 12,526.642 ↑ 2.0 9 1

Nested Loop Left Join (cost=2.42..203,221.07 rows=18 width=4,255) (actual time=2,010.239..12,526.642 rows=9 loops=1)

  • Join Filter: (usuariocad1_.cd_estabelecimento_cerest = estabeleci37_.cd_estabelecimento_cerest)
27. 19.021 12,526.614 ↑ 2.0 9 1

Nested Loop Left Join (cost=2.42..203,196.94 rows=18 width=4,247) (actual time=2,010.226..12,526.614 rows=9 loops=1)

  • Join Filter: (usuariocad1_.cd_municipio_residencia = cidade36_.cod_cid)
  • Rows Removed by Join Filter: 51201
28. 3.970 12,507.593 ↑ 2.0 9 1

Nested Loop Left Join (cost=2.42..201,521.52 rows=18 width=4,227) (actual time=1,998.941..12,507.593 rows=9 loops=1)

  • Join Filter: (usuariocad1_.cd_etnia = etniaindig35_.cd_etnia)
  • Rows Removed by Join Filter: 2376
29. 9.962 12,503.623 ↑ 2.0 9 1

Nested Loop Left Join (cost=2.42..201,443.94 rows=18 width=4,194) (actual time=1,995.317..12,503.623 rows=9 loops=1)

  • Join Filter: (usuariocad1_.cd_local_permanencia = localperma34_.cd_local_permanencia)
  • Rows Removed by Join Filter: 9
30. 0.026 12,493.661 ↑ 2.0 9 1

Nested Loop Left Join (cost=2.42..201,442.66 rows=18 width=3,968) (actual time=1,985.374..12,493.661 rows=9 loops=1)

31. 0.064 12,493.635 ↑ 2.0 9 1

Nested Loop Left Join (cost=1.99..201,290.47 rows=18 width=3,930) (actual time=1,985.370..12,493.635 rows=9 loops=1)

32. 10.183 12,493.571 ↑ 2.0 9 1

Nested Loop Left Join (cost=1.56..201,138.23 rows=18 width=3,893) (actual time=1,985.361..12,493.571 rows=9 loops=1)

  • Join Filter: (usuariocad1_.cd_escolaridade = escolarida30_.cd_escolaridade)
  • Rows Removed by Join Filter: 108
33. 42.758 12,483.388 ↑ 2.0 9 1

Nested Loop Left Join (cost=1.56..201,133.84 rows=18 width=3,769) (actual time=1,975.207..12,483.388 rows=9 loops=1)

  • Join Filter: (usuariocad1_.cd_usu_cadsus = usuariocad28_.cd_usu_cadsus)
34. 22.792 12,440.630 ↑ 2.0 9 1

Nested Loop Left Join (cost=1.14..201,125.12 rows=18 width=3,753) (actual time=1,932.472..12,440.630 rows=9 loops=1)

  • Join Filter: (usuariocad1_.cd_usuario_cad = usuario26_.cd_usuario)
  • Rows Removed by Join Filter: 18603
35. 3.242 12,417.838 ↑ 2.0 9 1

Nested Loop Left Join (cost=1.14..200,240.92 rows=18 width=3,720) (actual time=1,914.719..12,417.838 rows=9 loops=1)

  • Join Filter: (usuariocad1_.empresa_responsavel = empresa25_.empresa)
  • Rows Removed by Join Filter: 11718
36. 0.634 12,414.596 ↑ 2.0 9 1

Nested Loop Left Join (cost=1.14..199,822.82 rows=18 width=3,632) (actual time=1,913.967..12,414.596 rows=9 loops=1)

  • Join Filter: (usuariocad1_.cd_pais_nascimento = pais23_.cd_pais)
  • Rows Removed by Join Filter: 3006
37. 25.401 12,413.962 ↑ 2.0 9 1

Nested Loop Left Join (cost=1.14..199,724.18 rows=18 width=3,612) (actual time=1,913.843..12,413.962 rows=9 loops=1)

  • Join Filter: ((usuariocad1_.cd_cbo)::text = (tabelacbo16_.cd_cbo)::text)
  • Rows Removed by Join Filter: 23697
38. 12,388.561 12,388.561 ↑ 2.0 9 1

Nested Loop Left Join (cost=1.14..198,945.36 rows=18 width=3,602) (actual time=1,891.469..12,388.561 rows=9 loops=1)

  • Join Filter: (usuariocad1_.cd_gerenciador_arquivo = gerenciado2_.cd_gerenciador_arquivo)