explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xD7y : Optimization for: plan #WGr7

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 210.825 115,090.346 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=388.79..6,595,756.85 rows=1,570 width=9,085) (actual time=9.364..115,090.346 rows=1,000 loops=1)

2. 9.435 6,840.521 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=388.22..23,817.82 rows=1,570 width=6,648) (actual time=6.553..6,840.521 rows=1,000 loops=1)

3. 8.316 6,712.086 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=387.80..23,107.33 rows=1,570 width=6,640) (actual time=6.497..6,712.086 rows=1,000 loops=1)

4. 17.352 6,686.770 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=387.38..22,412.60 rows=1,570 width=6,586) (actual time=6.472..6,686.770 rows=1,000 loops=1)

5. 9.500 6,236.418 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=386.39..20,759.08 rows=1,570 width=6,430) (actual time=6.413..6,236.418 rows=1,000 loops=1)

6. 7.056 6,186.918 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=385.96..20,048.58 rows=1,570 width=6,429) (actual time=6.359..6,186.918 rows=1,000 loops=1)

7. 8.229 6,159.862 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=385.54..19,349.93 rows=1,570 width=6,417) (actual time=6.327..6,159.862 rows=1,000 loops=1)

8. 7.927 6,139.633 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=385.26..18,855.38 rows=1,570 width=6,378) (actual time=6.305..6,139.633 rows=1,000 loops=1)

9. 10.005 6,110.706 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=384.83..18,144.93 rows=1,570 width=6,366) (actual time=6.276..6,110.706 rows=1,000 loops=1)

10. 8.708 6,084.701 ↑ 1.6 1,000 1

Hash Left Join (cost=384.55..17,658.23 rows=1,570 width=5,972) (actual time=6.250..6,084.701 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = enviceprefb72.cd_cpf)
11. 9.024 6,075.231 ↑ 1.6 1,000 1

Hash Left Join (cost=330.58..17,598.36 rows=1,570 width=5,538) (actual time=5.449..6,075.231 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = enprefb72.cd_cpf)
12. 9.839 6,065.227 ↑ 1.6 1,000 1

Hash Left Join (cost=260.66..17,522.54 rows=1,570 width=5,095) (actual time=4.445..6,065.227 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = enpdmb72.cd_cpf)
13. 7.304 6,053.301 ↑ 1.6 1,000 1

Hash Left Join (cost=116.32..17,372.30 rows=1,570 width=4,836) (actual time=2.320..6,053.301 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = ennacb72.cd_cpf)
14. 6.234 6,045.516 ↑ 1.6 1,000 1

Hash Left Join (cost=84.04..17,334.12 rows=1,570 width=4,011) (actual time=1.818..6,045.516 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = endepb72.cd_cpf)
15. 5.656 6,039.233 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=81.23..17,325.42 rows=1,570 width=3,716) (actual time=1.737..6,039.233 rows=1,000 loops=1)

16. 5.649 5,989.577 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=80.79..16,602.46 rows=1,570 width=3,593) (actual time=1.652..5,989.577 rows=1,000 loops=1)

17. 7.847 5,964.928 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=80.37..15,899.87 rows=1,570 width=3,578) (actual time=1.618..5,964.928 rows=1,000 loops=1)

18. 6.914 5,936.081 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=79.96..15,205.13 rows=1,570 width=3,499) (actual time=1.581..5,936.081 rows=1,000 loops=1)

19. 5.501 5,912.167 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=79.54..14,502.51 rows=1,570 width=3,304) (actual time=1.540..5,912.167 rows=1,000 loops=1)

20. 5.802 5,887.666 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=79.12..13,799.93 rows=1,570 width=3,292) (actual time=1.456..5,887.666 rows=1,000 loops=1)

21. 10.489 5,814.864 ↑ 1.6 1,000 1

Hash Left Join (cost=78.69..13,089.42 rows=1,570 width=3,284) (actual time=1.427..5,814.864 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = oabmgprev.cd_cpf)
22. 6.054 5,803.400 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=6.07..13,010.90 rows=1,570 width=3,184) (actual time=0.421..5,803.400 rows=1,000 loops=1)

23. 6.148 5,779.346 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=5.66..12,312.23 rows=1,570 width=2,983) (actual time=0.399..5,779.346 rows=1,000 loops=1)

24. 6.193 5,760.198 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=5.37..11,821.60 rows=1,570 width=2,976) (actual time=0.358..5,760.198 rows=1,000 loops=1)

25. 6.174 5,730.005 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=4.95..11,118.97 rows=1,570 width=2,556) (actual time=0.336..5,730.005 rows=1,000 loops=1)

26. 7.651 5,702.831 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=4.53..10,408.37 rows=1,570 width=2,318) (actual time=0.314..5,702.831 rows=1,000 loops=1)

27. 6.726 5,671.180 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=4.25..9,917.74 rows=1,570 width=2,215) (actual time=0.290..5,671.180 rows=1,000 loops=1)

28. 4.604 1,450.454 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=3.68..8,843.23 rows=1,570 width=2,120) (actual time=0.256..1,450.454 rows=1,000 loops=1)

29. 6.117 1,433.850 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=3.40..8,356.52 rows=1,570 width=1,108) (actual time=0.240..1,433.850 rows=1,000 loops=1)

30. 7.786 1,346.733 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=2.83..7,370.05 rows=1,570 width=1,015) (actual time=0.207..1,346.733 rows=1,000 loops=1)

31. 4.501 1,294.947 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=2.26..6,292.19 rows=1,570 width=151) (actual time=0.172..1,294.947 rows=1,000 loops=1)

32. 4.844 1,097.446 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=1.70..5,364.03 rows=1,570 width=128) (actual time=0.143..1,097.446 rows=1,000 loops=1)

33. 5.736 63.602 ↑ 1.6 1,000 1

Nested Loop (cost=1.13..4,435.61 rows=1,570 width=119) (actual time=0.112..63.602 rows=1,000 loops=1)

34. 7.866 7.866 ↑ 1.6 1,000 1

Index Scan using solr_documento_pf_nu_pagina_idx8 on solr_documento_pf solr (cost=0.56..44.64 rows=1,570 width=12) (actual time=0.050..7.866 rows=1,000 loops=1)

  • Index Cond: (nu_pagina = 800)
35. 50.000 50.000 ↑ 1.0 1 1,000

Index Scan using pessoa_fisica_kruger_cd_cpf_idx on pessoa_fisica pf (cost=0.57..2.79 rows=1 width=119) (actual time=0.048..0.050 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = solr.id_doc)
36. 1,029.000 1,029.000 ↓ 0.0 0 1,000

Index Scan using pk_rg on rg (cost=0.56..0.58 rows=1 width=21) (actual time=0.986..1.029 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
37. 193.000 193.000 ↓ 0.0 0 1,000

Index Scan using en_obito_nova_pkey on en_obito_nova o (cost=0.56..0.58 rows=1 width=23) (actual time=0.193..0.193 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
38. 44.000 44.000 ↑ 1.0 1 1,000

Index Scan using pessoa_fisica_calc_cd_cpf_idx on pessoa_fisica_calc pfcalc (cost=0.57..0.68 rows=1 width=876) (actual time=0.043..0.044 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
39. 81.000 81.000 ↑ 1.0 1 1,000

Index Scan using eleitor_pkey on eleitor el (cost=0.57..0.62 rows=1 width=105) (actual time=0.080..0.081 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
40. 12.000 12.000 ↓ 0.0 0 1,000

Index Scan using pessoa_ceis_sancao_pkey on pessoa_ceis_sancao ceis (cost=0.28..0.30 rows=1 width=1,024) (actual time=0.012..0.012 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
41. 4,214.000 4,214.000 ↑ 1.0 1 1,000

Index Scan using endereco_teste_matheus_cd_cpf_idx on endereco e (cost=0.57..0.67 rows=1 width=107) (actual time=4.197..4.214 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
42. 24.000 24.000 ↑ 1.0 1 1,000

Index Scan using municipio_pkey on municipio mu (cost=0.28..0.30 rows=1 width=118) (actual time=0.023..0.024 rows=1 loops=1,000)

  • Index Cond: ((e.sg_uf = sg_uf) AND ((e.nm_municipio)::text = (nm_municipio)::text))
43. 21.000 21.000 ↓ 0.0 0 1,000

Index Scan using en_pgfn_dau_cd_cpf_idx1 on en_pgfn_dau dau (cost=0.42..0.44 rows=1 width=250) (actual time=0.021..0.021 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
44. 24.000 24.000 ↓ 0.0 0 1,000

Index Scan using en_prefeitura_chapeco_pkey on en_prefeitura_chapeco chapeco (cost=0.42..0.44 rows=1 width=420) (actual time=0.024..0.024 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
45. 13.000 13.000 ↓ 0.0 0 1,000

Index Scan using en_cadastro_municipal_cotia_pkey on en_cadastro_municipal_cotia cotia (cost=0.29..0.30 rows=1 width=19) (actual time=0.013..0.013 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
46. 18.000 18.000 ↓ 0.0 0 1,000

Index Scan using en_oab_mg_pkey on en_oab_mg oabmg (cost=0.42..0.44 rows=1 width=201) (actual time=0.018..0.018 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
47. 0.682 0.975 ↑ 1.0 1,983 1

Hash (cost=47.83..47.83 rows=1,983 width=100) (actual time=0.975..0.975 rows=1,983 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 239kB
48. 0.293 0.293 ↑ 1.0 1,983 1

Seq Scan on en_vesting_oab_prev_mg oabmgprev (cost=0.00..47.83 rows=1,983 width=100) (actual time=0.010..0.293 rows=1,983 loops=1)

49. 67.000 67.000 ↓ 0.0 0 1,000

Index Scan using deficiencia_pessoa_fisica_nova_pkey on deficiencia_pessoa_fisica defic (cost=0.42..0.44 rows=1 width=20) (actual time=0.061..0.067 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
50. 19.000 19.000 ↓ 0.0 0 1,000

Index Only Scan using en_aposentado_cd_cpf_idx on en_aposentado apos (cost=0.42..0.44 rows=1 width=12) (actual time=0.019..0.019 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
  • Heap Fetches: 0
51. 17.000 17.000 ↓ 0.0 0 1,000

Index Scan using pep_pkey on pep (cost=0.42..0.44 rows=1 width=195) (actual time=0.017..0.017 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
52. 21.000 21.000 ↓ 0.0 0 1,000

Index Scan using en_contratos_renault_pkey on en_contratos_renault encrenault (cost=0.41..0.43 rows=1 width=91) (actual time=0.021..0.021 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
53. 19.000 19.000 ↓ 0.0 0 1,000

Index Scan using cau_cd_cpf_idx on cau (cost=0.42..0.44 rows=1 width=15) (actual time=0.019..0.019 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
54. 44.000 44.000 ↓ 0.0 0 1,000

Index Scan using en_santander_agencias_piloto_pkey on en_santander_agencias_piloto sap (cost=0.43..0.45 rows=1 width=123) (actual time=0.044..0.044 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
55. 0.033 0.049 ↑ 1.0 36 1

Hash (cost=2.36..2.36 rows=36 width=295) (actual time=0.049..0.049 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
56. 0.016 0.016 ↑ 1.0 36 1

Seq Scan on en_bocaina72_deputados_estaduais endepb72 (cost=0.00..2.36 rows=36 width=295) (actual time=0.010..0.016 rows=36 loops=1)

57. 0.370 0.481 ↑ 1.0 457 1

Hash (cost=26.57..26.57 rows=457 width=825) (actual time=0.480..0.481 rows=457 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 179kB
58. 0.111 0.111 ↑ 1.0 457 1

Seq Scan on en_bocaina72_nacional ennacb72 (cost=0.00..26.57 rows=457 width=825) (actual time=0.007..0.111 rows=457 loops=1)

59. 1.628 2.087 ↓ 1.2 2,852 1

Hash (cost=114.15..114.15 rows=2,415 width=259) (actual time=2.087..2.087 rows=2,852 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 735kB
60. 0.459 0.459 ↓ 1.2 2,852 1

Seq Scan on en_bocaina72_pdm enpdmb72 (cost=0.00..114.15 rows=2,415 width=259) (actual time=0.006..0.459 rows=2,852 loops=1)

61. 0.771 0.980 ↓ 1.0 850 1

Hash (cost=59.41..59.41 rows=841 width=443) (actual time=0.980..0.980 rows=850 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 406kB
62. 0.209 0.209 ↓ 1.0 850 1

Seq Scan on en_bocaina72_prefeitos enprefb72 (cost=0.00..59.41 rows=841 width=443) (actual time=0.006..0.209 rows=850 loops=1)

63. 0.576 0.762 ↓ 1.4 740 1

Hash (cost=47.32..47.32 rows=532 width=434) (actual time=0.762..0.762 rows=740 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 328kB
64. 0.186 0.186 ↓ 1.4 740 1

Seq Scan on en_bocaina72_vice_prefeitos enviceprefb72 (cost=0.00..47.32 rows=532 width=434) (actual time=0.006..0.186 rows=740 loops=1)

65. 16.000 16.000 ↓ 0.0 0 1,000

Index Scan using en_bocaina72_vereadores_pkey on en_bocaina72_vereadores envereadoresb72 (cost=0.28..0.30 rows=1 width=394) (actual time=0.016..0.016 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
66. 21.000 21.000 ↓ 0.0 0 1,000

Index Only Scan using en_gps_seguranca_pf_pkey on en_gps_seguranca_pf egspf (cost=0.42..0.44 rows=1 width=12) (actual time=0.021..0.021 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
  • Heap Fetches: 0
67. 12.000 12.000 ↓ 0.0 0 1,000

Index Scan using en_quantidade_profissionais_ache_pkey on en_quantidade_profissionais_ache eqpa (cost=0.29..0.31 rows=1 width=39) (actual time=0.012..0.012 rows=0 loops=1,000)

  • Index Cond: (cd_cpf_socio = pf.cd_cpf)
68. 20.000 20.000 ↓ 0.0 0 1,000

Index Only Scan using ix_en_especialidades_ache_cpf on en_especialidades_ache eea (cost=0.42..0.44 rows=1 width=12) (actual time=0.020..0.020 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
  • Heap Fetches: 0
69. 40.000 40.000 ↓ 0.0 0 1,000

Index Scan using en_influenciados_ache_pkey on en_influenciados_ache eia (cost=0.42..0.44 rows=1 width=13) (actual time=0.040..0.040 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
70. 365.000 365.000 ↓ 0.0 0 1,000

Index Scan using cidades_visitadas_zona_eleitoral_ache_pkey on en_cidades_visitadas_zona_eleitoral_ache ecvzea (cost=0.56..0.58 rows=1 width=13) (actual time=0.365..0.365 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
71. 68.000 68.000 ↓ 0.0 0 1,000

Index Scan using idx_cafir_cnpj on cafir (cost=0.43..0.45 rows=1 width=167) (actual time=0.068..0.068 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
72. 17.000 17.000 ↓ 0.0 0 1,000

Index Scan using en_estacoes_cnseg_pkey on en_estacoes_cnseg eec (cost=0.41..0.43 rows=1 width=66) (actual time=0.017..0.017 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
73. 119.000 119.000 ↓ 0.0 0 1,000

Index Scan using ix_en_potencial_profissional_ache on en_potencial_profissional_ache ppache (cost=0.42..0.44 rows=1 width=20) (actual time=0.119..0.119 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
74. 38.000 38.000 ↑ 1.0 1 1,000

Index Scan using totalizadores_processos_judiciais_cpf_idx1 on totalizadores_processos_judiciais totalprocessojudic (cost=0.57..0.67 rows=1 width=24) (actual time=0.036..0.038 rows=1 loops=1,000)

  • Index Cond: (pf.cd_cpf = cpf)
75.          

SubPlan (for Nested Loop Left Join)

76. 19.000 19.000 ↑ 1.0 1 1,000

Index Scan using idx_situacao_id_situacao on situacao s (cost=0.14..2.36 rows=1 width=24) (actual time=0.019..0.019 rows=1 loops=1,000)

  • Index Cond: (id_situacao = pf.id_situacao_rf)
  • Filter: ((nm_tabela)::text = 'farm.cpf'::text)
77. 11.000 11.000 ↑ 1.0 1 1,000

Seq Scan on cat_raca r (cost=0.00..1.07 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=1,000)

  • Filter: (cd_raca = (pf.cd_raca)::bpchar)
  • Rows Removed by Filter: 5
78. 8.000 8.000 ↓ 0.0 0 1,000

Seq Scan on cat_grau_instrucao g (cost=0.00..1.14 rows=1 width=35) (actual time=0.006..0.008 rows=0 loops=1,000)

  • Filter: (cd_grau_instrucao = (pf.cd_grau_instrucao)::bpchar)
  • Rows Removed by Filter: 11
79. 3.000 1,267.000 ↓ 0.0 0 1,000

Limit (cost=0.56..1.68 rows=1 width=25) (actual time=1.266..1.267 rows=0 loops=1,000)

80. 1,264.000 1,264.000 ↓ 0.0 0 1,000

Index Only Scan using email_rf_pf_cd_cpf_de_email_idx on email_rf_pf e_1 (cost=0.56..3.91 rows=3 width=25) (actual time=1.263..1.264 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
  • Heap Fetches: 206
81. 6.000 223.000 ↑ 1.0 1 1,000

Aggregate (cost=2.66..2.67 rows=1 width=32) (actual time=0.223..0.223 rows=1 loops=1,000)

82. 217.000 217.000 ↓ 0.0 0 1,000

Index Scan using carteira_cliente_cd_cpf_idx on carteira_cliente cc (cost=0.43..2.65 rows=1 width=22) (actual time=0.207..0.217 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
83. 3.000 29.000 ↓ 0.0 0 1,000

GroupAggregate (cost=0.42..2.71 rows=1 width=44) (actual time=0.029..0.029 rows=0 loops=1,000)

  • Group Key: p.cd_cpf
84. 26.000 26.000 ↓ 0.0 0 1,000

Index Scan using pep_secundario_multinivel_cd_cpf_idx on pep_secundario_multinivel p (cost=0.42..2.64 rows=1 width=115) (actual time=0.026..0.026 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
85. 26.000 72.000 ↓ 0.0 0 1,000

GroupAggregate (cost=0.57..13.36 rows=10 width=44) (actual time=0.072..0.072 rows=0 loops=1,000)

  • Group Key: totalizadores_processos.cpf
86. 46.000 46.000 ↑ 5.0 2 1,000

Index Scan using totalizadores_processos_cpf_idx on totalizadores_processos (cost=0.57..12.66 rows=10 width=69) (actual time=0.034..0.046 rows=2 loops=1,000)

  • Index Cond: (cpf = (pf.cd_cpf)::text)
87. 14.000 29.000 ↑ 1.0 1 1,000

Aggregate (cost=2.66..2.67 rows=1 width=32) (actual time=0.029..0.029 rows=1 loops=1,000)

88. 15.000 15.000 ↓ 0.0 0 1,000

Index Scan using "listaInternacional_cpf_idx" on "listaInternacional" (cost=0.42..2.64 rows=1 width=67) (actual time=0.015..0.015 rows=0 loops=1,000)

  • Index Cond: (cpf = pf.cd_cpf)
89. 3.000 28.000 ↓ 0.0 0 1,000

GroupAggregate (cost=0.41..2.72 rows=1 width=44) (actual time=0.028..0.028 rows=0 loops=1,000)

  • Group Key: pessoa_ibama_embargos.cd_cpf
90. 25.000 25.000 ↓ 0.0 0 1,000

Index Scan using pessoa_ibama_embargos_cd_cpf_idx on pessoa_ibama_embargos (cost=0.41..2.63 rows=1 width=269) (actual time=0.025..0.025 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
91. 38.000 35,713.000 ↓ 0.0 0 1,000

GroupAggregate (cost=1.14..1,731.67 rows=438 width=44) (actual time=35.713..35.713 rows=0 loops=1,000)

  • Group Key: r_1.cd_cpf
92. 13.200 35,675.000 ↑ 219.0 2 1,000

Nested Loop (cost=1.14..1,717.43 rows=438 width=54) (actual time=8.483..35.675 rows=2 loops=1,000)

93. 5,078.000 5,078.000 ↑ 219.0 2 1,000

Index Scan using relacionamentos_cd_cpf_idx on relacionamentos r_1 (cost=0.57..492.13 rows=438 width=29) (actual time=0.983..5.078 rows=2 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
94. 30,583.800 30,583.800 ↑ 1.0 1 1,800

Index Scan using pessoa_fisica_kruger_cd_cpf_idx on pessoa_fisica pff (cost=0.57..2.79 rows=1 width=37) (actual time=16.971..16.991 rows=1 loops=1,800)

  • Index Cond: (cd_cpf = r_1.cd_cpf_relacionado)
95. 4.000 28.000 ↓ 0.0 0 1,000

GroupAggregate (cost=0.41..2.67 rows=1 width=44) (actual time=0.028..0.028 rows=0 loops=1,000)

  • Group Key: r_2.cd_cpf
96. 24.000 24.000 ↓ 0.0 0 1,000

Index Scan using registro_profissional_pkey on registro_profissional r_2 (cost=0.41..2.63 rows=1 width=119) (actual time=0.024..0.024 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
97. 5.000 173.000 ↓ 0.0 0 1,000

GroupAggregate (cost=0.42..17.59 rows=14 width=44) (actual time=0.173..0.173 rows=0 loops=1,000)

  • Group Key: c.cfocdcpfprofissional
98. 168.000 168.000 ↓ 0.0 0 1,000

Index Scan using cfo_profissional_cpf_idx on cfo_profissional c (cost=0.42..15.98 rows=14 width=133) (actual time=0.161..0.168 rows=0 loops=1,000)

  • Index Cond: (cfocdcpfprofissional = pf.cd_cpf)
99. 2.000 31.000 ↓ 0.0 0 1,000

GroupAggregate (cost=0.43..7.38 rows=5 width=44) (actual time=0.031..0.031 rows=0 loops=1,000)

  • Group Key: m.cpf
100. 29.000 29.000 ↓ 0.0 0 1,000

Index Scan using medicos_cpf_idx on medicos m (cost=0.43..7.11 rows=5 width=70) (actual time=0.029..0.029 rows=0 loops=1,000)

  • Index Cond: (cpf = pf.cd_cpf)
101. 2.000 24.000 ↓ 0.0 0 1,000

GroupAggregate (cost=0.85..26.03 rows=1 width=44) (actual time=0.024..0.024 rows=0 loops=1,000)

  • Group Key: m_1.cpf
102. 2.462 22.000 ↓ 0.0 0 1,000

Nested Loop (cost=0.85..26.00 rows=1 width=40) (actual time=0.022..0.022 rows=0 loops=1,000)

103. 12.000 12.000 ↓ 0.0 0 1,000

Index Scan using medicos_cpf_idx on medicos m_1 (cost=0.43..7.11 rows=5 width=45) (actual time=0.012..0.012 rows=0 loops=1,000)

  • Index Cond: (cpf = pf.cd_cpf)
104. 7.538 7.538 ↓ 0.0 0 2

Index Scan using idxmedicosespecialidadeatuacaoid on "medicosEspecialidadeAtuacao" me (cost=0.42..3.76 rows=2 width=61) (actual time=3.768..3.769 rows=0 loops=2)

  • Index Cond: ((id)::text = m_1.id)
105. 2.000 22.000 ↓ 0.0 0 1,000

GroupAggregate (cost=0.85..20.42 rows=1 width=44) (actual time=0.022..0.022 rows=0 loops=1,000)

  • Group Key: m_2.cpf
106. 2.642 20.000 ↓ 0.0 0 1,000

Nested Loop (cost=0.85..20.36 rows=1 width=84) (actual time=0.020..0.020 rows=0 loops=1,000)

107. 12.000 12.000 ↓ 0.0 0 1,000

Index Scan using medicos_cpf_idx on medicos m_2 (cost=0.43..7.11 rows=5 width=45) (actual time=0.012..0.012 rows=0 loops=1,000)

  • Index Cond: (cpf = pf.cd_cpf)
108. 5.358 5.358 ↑ 1.0 1 2

Index Scan using idxmedicosenderecoid on "medicosEndereco" me_1 (cost=0.42..2.64 rows=1 width=105) (actual time=2.679..2.679 rows=1 loops=2)

  • Index Cond: ((id)::text = m_2.id)
109. 5.000 18.000 ↑ 1.0 1 1,000

Aggregate (cost=2.55..2.56 rows=1 width=32) (actual time=0.018..0.018 rows=1 loops=1,000)

110. 13.000 13.000 ↓ 0.0 0 1,000

Index Scan using en_projeto_repo_new_pkey on en_projeto_repo pr (cost=0.29..2.51 rows=1 width=101) (actual time=0.013..0.013 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
111. 4.000 17.000 ↑ 1.0 1 1,000

Aggregate (cost=2.56..2.56 rows=1 width=32) (actual time=0.017..0.017 rows=1 loops=1,000)

112. 13.000 13.000 ↓ 0.0 0 1,000

Index Scan using idx_cpf_vendas_michelin on en_vendas_michelin evm (cost=0.28..2.50 rows=1 width=256) (actual time=0.013..0.013 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
113. 3.000 13.000 ↑ 1.0 1 1,000

Aggregate (cost=2.51..2.52 rows=1 width=32) (actual time=0.013..0.013 rows=1 loops=1,000)

114. 10.000 10.000 ↓ 0.0 0 1,000

Index Scan using idx_cpf_soma_vendas_michelin on en_soma_vendas_michelin evm_1 (cost=0.28..2.50 rows=1 width=24) (actual time=0.010..0.010 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
115. 12.000 48.000 ↑ 1.0 1 1,000

Aggregate (cost=7.58..7.59 rows=1 width=32) (actual time=0.048..0.048 rows=1 loops=1,000)

116. 36.000 36.000 ↓ 0.0 0 1,000

Index Scan using ambiental_cd_cpf_empreendimento_idx1 on ambiental a (cost=0.43..7.12 rows=5 width=179) (actual time=0.023..0.036 rows=0 loops=1,000)

  • Index Cond: (cd_cpf_empreendimento = pf.cd_cpf)
117. 14.000 545.000 ↑ 1.0 1 1,000

Aggregate (cost=2.82..2.83 rows=1 width=32) (actual time=0.545..0.545 rows=1 loops=1,000)

118. 531.000 531.000 ↓ 0.0 0 1,000

Index Scan using mte_seguro_desemprego_teste_pkey on mte_seguro_desemprego s_1 (cost=0.56..2.78 rows=1 width=110) (actual time=0.486..0.531 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
119. 10.000 151.000 ↑ 1.0 1 1,000

Aggregate (cost=7.58..7.59 rows=1 width=32) (actual time=0.151..0.151 rows=1 loops=1,000)

120. 141.000 141.000 ↓ 0.0 0 1,000

Index Scan using ans_cd_cpf_idx on ans a_1 (cost=0.43..7.09 rows=5 width=220) (actual time=0.141..0.141 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = ((pf.cd_cpf)::character varying(11))::bpchar)
121. 7.000 215.000 ↑ 1.0 1 1,000

Aggregate (cost=2.68..2.69 rows=1 width=32) (actual time=0.215..0.215 rows=1 loops=1,000)

122. 208.000 208.000 ↓ 0.0 0 1,000

Index Scan using cfc_contabilidade_cd_cpf_idx on cfc_contabilidade c_1 (cost=0.43..2.65 rows=1 width=66) (actual time=0.202..0.208 rows=0 loops=1,000)

  • Index Cond: (((pf.cd_cpf)::character varying(11))::bpchar = cd_cpf)
123. 49.000 25,470.000 ↑ 1.0 1 1,000

Aggregate (cost=10.31..10.32 rows=1 width=32) (actual time=25.470..25.470 rows=1 loops=1,000)

124. 5.962 25,421.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=4.23..10.09 rows=1 width=339) (actual time=20.596..25.421 rows=0 loops=1,000)

125. 5.472 18,319.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=3.67..9.43 rows=1 width=279) (actual time=14.859..18.319 rows=0 loops=1,000)

126. 3.654 14,566.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=3.11..8.84 rows=1 width=274) (actual time=11.760..14.566 rows=0 loops=1,000)

127. 4.208 11,905.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=2.54..8.23 rows=1 width=257) (actual time=9.496..11.905 rows=0 loops=1,000)

128. 5.072 11,864.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=2.25..7.92 rows=1 width=242) (actual time=9.466..11.864 rows=0 loops=1,000)

129. 5.072 10,389.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=1.69..7.29 rows=1 width=179) (actual time=8.352..10.389 rows=0 loops=1,000)

130. 7.440 10,228.000 ↓ 0.0 0 1,000

Nested Loop (cost=1.13..6.70 rows=1 width=171) (actual time=8.265..10.228 rows=0 loops=1,000)

131. 3,280.000 3,280.000 ↓ 0.0 0 1,000

Index Scan using idx_qsa_rec_fed_doc_socio on qsa_receita_federal s_2 (cost=0.57..3.91 rows=1 width=60) (actual time=2.575..3.280 rows=0 loops=1,000)

  • Index Cond: ((cd_doc_socio)::text = (pf.cd_cpf)::text)
  • Filter: (length((cd_doc_socio)::text) = 11)
132. 6,940.560 6,940.560 ↑ 1.0 1 440

Index Scan using empresa_cd_cnpj_idx on empresa e_2 (cost=0.56..2.78 rows=1 width=126) (actual time=15.736..15.774 rows=1 loops=440)

  • Index Cond: (cd_cnpj = (s_2.cd_cnpj_empresa)::bpchar)
133. 155.928 155.928 ↓ 0.0 0 438

Index Scan using empresa_func_rais_cd_cnpj_idx on empresa_func_rais f (cost=0.56..0.58 rows=1 width=23) (actual time=0.356..0.356 rows=0 loops=438)

  • Index Cond: (cd_cnpj = e_2.cd_cnpj)
134. 1,469.928 1,469.928 ↑ 1.0 1 438

Index Scan using cnae_principal_etl_pkey on cnae_principal c_2 (cost=0.56..0.61 rows=1 width=78) (actual time=2.999..3.356 rows=1 loops=438)

  • Index Cond: (cd_cnpj = e_2.cd_cnpj)
135. 36.792 36.792 ↓ 0.0 0 438

Index Only Scan using qsa_rf_prefeitura_chapeco_pkey on qsa_rf_prefeitura_chapeco pref (cost=0.29..0.31 rows=1 width=15) (actual time=0.084..0.084 rows=0 loops=438)

  • Index Cond: (cd_cnpj = e_2.cd_cnpj)
  • Heap Fetches: 0
136. 2,657.346 2,657.346 ↑ 1.0 1 438

Index Scan using en_cnae_principal_setor_pkey on en_cnae_principal_setor st (cost=0.56..0.59 rows=1 width=32) (actual time=6.058..6.067 rows=1 loops=438)

  • Index Cond: (e_2.cd_cnpj = cd_cnpj)
137. 3,747.528 3,747.528 ↑ 1.0 1 438

Index Scan using junta_comercial_pkey on junta_comercial cs (cost=0.56..0.59 rows=1 width=20) (actual time=8.554..8.556 rows=1 loops=438)

  • Index Cond: (e_2.cd_cnpj = cd_cnpj)
138. 7,096.038 7,096.038 ↑ 1.0 1 438

Index Scan using faturamento_presumido_cd_cnpj_idx2 on faturamento_presumido fp (cost=0.56..0.65 rows=1 width=75) (actual time=16.040..16.201 rows=1 loops=438)

  • Index Cond: (e_2.cd_cnpj = cd_cnpj)
139. 8.000 660.000 ↑ 1.0 1 1,000

Aggregate (cost=11.41..11.42 rows=1 width=32) (actual time=0.660..0.660 rows=1 loops=1,000)

140. 1.882 652.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=4.22..11.19 rows=1 width=332) (actual time=0.405..0.652 rows=0 loops=1,000)

141. 2.748 571.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=3.66..10.54 rows=1 width=272) (actual time=0.370..0.571 rows=0 loops=1,000)

142. 1.096 535.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=3.09..9.94 rows=1 width=267) (actual time=0.349..0.535 rows=0 loops=1,000)

143. 2.490 515.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=2.53..9.34 rows=1 width=250) (actual time=0.332..0.515 rows=0 loops=1,000)

144. 1.850 512.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=2.25..9.03 rows=1 width=235) (actual time=0.329..0.512 rows=0 loops=1,000)

145. 1.912 477.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=1.69..8.41 rows=1 width=172) (actual time=0.322..0.477 rows=0 loops=1,000)

146. 4.554 474.000 ↓ 0.0 0 1,000

Nested Loop (cost=1.13..7.82 rows=1 width=164) (actual time=0.319..0.474 rows=0 loops=1,000)

147. 360.000 360.000 ↓ 0.0 0 1,000

Index Scan using idx_qsa_junta_doc on qsa_junta_comercial s_3 (cost=0.56..5.02 rows=1 width=53) (actual time=0.241..0.360 rows=0 loops=1,000)

  • Index Cond: ((cd_doc_socio)::text = (pf.cd_cpf)::text)
  • Filter: (length((cd_doc_socio)::text) = 11)
148. 109.446 109.446 ↑ 1.0 1 34

Index Scan using empresa_cd_cnpj_idx on empresa e_3 (cost=0.56..2.78 rows=1 width=126) (actual time=3.218..3.219 rows=1 loops=34)

  • Index Cond: (cd_cnpj = (s_3.cd_cnpj_empresa)::bpchar)
149. 1.088 1.088 ↓ 0.0 0 34

Index Scan using empresa_func_rais_cd_cnpj_idx on empresa_func_rais f_1 (cost=0.56..0.58 rows=1 width=23) (actual time=0.032..0.032 rows=0 loops=34)

  • Index Cond: (cd_cnpj = e_3.cd_cnpj)
150. 33.150 33.150 ↑ 1.0 1 34

Index Scan using cnae_principal_etl_pkey on cnae_principal c_3 (cost=0.56..0.61 rows=1 width=78) (actual time=0.974..0.975 rows=1 loops=34)

  • Index Cond: (cd_cnpj = e_3.cd_cnpj)
151. 0.510 0.510 ↓ 0.0 0 34

Index Only Scan using qsa_jc_prefeitura_chapeco_pkey on qsa_jc_prefeitura_chapeco pref_1 (cost=0.28..0.30 rows=1 width=15) (actual time=0.015..0.015 rows=0 loops=34)

  • Index Cond: (cd_cnpj = e_3.cd_cnpj)
  • Heap Fetches: 0
152. 18.904 18.904 ↑ 1.0 1 34

Index Scan using en_cnae_principal_setor_pkey on en_cnae_principal_setor st_1 (cost=0.56..0.59 rows=1 width=32) (actual time=0.550..0.556 rows=1 loops=34)

  • Index Cond: (e_3.cd_cnpj = cd_cnpj)
153. 33.252 33.252 ↑ 1.0 1 34

Index Scan using junta_comercial_pkey on junta_comercial cs_1 (cost=0.56..0.59 rows=1 width=20) (actual time=0.977..0.978 rows=1 loops=34)

  • Index Cond: (e_3.cd_cnpj = cd_cnpj)
154. 79.118 79.118 ↓ 0.0 0 34

Index Scan using faturamento_presumido_cd_cnpj_idx2 on faturamento_presumido fp_1 (cost=0.56..0.65 rows=1 width=75) (actual time=2.327..2.327 rows=0 loops=34)

  • Index Cond: (e_3.cd_cnpj = cd_cnpj)
155. 40.000 3,518.000 ↑ 1.0 1 1,000

Aggregate (cost=16.68..16.69 rows=1 width=32) (actual time=3.518..3.518 rows=1 loops=1,000)

156. 3.775 3,478.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=4.22..16.25 rows=2 width=343) (actual time=2.593..3.478 rows=0 loops=1,000)

157. 3.049 3,375.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=3.66..14.94 rows=2 width=283) (actual time=2.534..3.375 rows=0 loops=1,000)

158. 4.012 3,323.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=3.10..13.74 rows=2 width=278) (actual time=2.502..3.323 rows=0 loops=1,000)

159. 2.708 3,289.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=2.54..12.54 rows=2 width=261) (actual time=2.472..3.289 rows=0 loops=1,000)

160. 4.124 3,281.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=2.25..11.92 rows=2 width=246) (actual time=2.465..3.281 rows=0 loops=1,000)

161. 3.416 3,261.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=1.69..10.68 rows=2 width=183) (actual time=2.450..3.261 rows=0 loops=1,000)

162. 8.107 3,247.000 ↓ 0.0 0 1,000

Nested Loop (cost=1.13..9.50 rows=2 width=175) (actual time=2.438..3.247 rows=0 loops=1,000)

163. 3,172.000 3,172.000 ↓ 0.0 0 1,000

Index Scan using idx_2qsa_unico_nova_atualizada_doc on qsa_unico s_4 (cost=0.57..3.91 rows=2 width=64) (actual time=2.384..3.172 rows=0 loops=1,000)

  • Index Cond: ((cd_doc_socio)::text = (pf.cd_cpf)::text)
  • Filter: (length((cd_doc_socio)::text) = 11)
164. 66.893 66.893 ↑ 1.0 1 443

Index Scan using empresa_cd_cnpj_idx on empresa e_4 (cost=0.56..2.78 rows=1 width=126) (actual time=0.151..0.151 rows=1 loops=443)

  • Index Cond: (cd_cnpj = s_4.cd_cnpj)
165. 10.584 10.584 ↓ 0.0 0 441

Index Scan using empresa_func_rais_cd_cnpj_idx on empresa_func_rais f_2 (cost=0.56..0.58 rows=1 width=23) (actual time=0.024..0.024 rows=0 loops=441)

  • Index Cond: (cd_cnpj = e_4.cd_cnpj)
166. 15.876 15.876 ↑ 1.0 1 441

Index Scan using cnae_principal_etl_pkey on cnae_principal c_4 (cost=0.56..0.61 rows=1 width=78) (actual time=0.033..0.036 rows=1 loops=441)

  • Index Cond: (cd_cnpj = e_4.cd_cnpj)
167. 5.292 5.292 ↓ 0.0 0 441

Index Only Scan using qsa_jc_prefeitura_chapeco_pkey on qsa_jc_prefeitura_chapeco pref_2 (cost=0.28..0.30 rows=1 width=15) (actual time=0.012..0.012 rows=0 loops=441)

  • Index Cond: (cd_cnpj = e_4.cd_cnpj)
  • Heap Fetches: 0
168. 29.988 29.988 ↑ 1.0 1 441

Index Scan using en_cnae_principal_setor_pkey on en_cnae_principal_setor st_2 (cost=0.56..0.59 rows=1 width=32) (actual time=0.068..0.068 rows=1 loops=441)

  • Index Cond: (e_4.cd_cnpj = cd_cnpj)
169. 48.951 48.951 ↑ 1.0 1 441

Index Scan using junta_comercial_pkey on junta_comercial cs_2 (cost=0.56..0.59 rows=1 width=20) (actual time=0.110..0.111 rows=1 loops=441)

  • Index Cond: (e_4.cd_cnpj = cd_cnpj)
170. 99.225 99.225 ↑ 1.0 1 441

Index Scan using faturamento_presumido_cd_cnpj_idx2 on faturamento_presumido fp_2 (cost=0.56..0.65 rows=1 width=75) (actual time=0.225..0.225 rows=1 loops=441)

  • Index Cond: (e_4.cd_cnpj = cd_cnpj)
171. 45.000 7,223.000 ↑ 1.0 1 1,000

Aggregate (cost=6.42..6.43 rows=1 width=32) (actual time=7.223..7.223 rows=1 loops=1,000)

172. 7,178.000 7,178.000 ↑ 4.0 1 1,000

Index Scan using en_historico_funcional_rais_atualizada_20190527_cd_cpf_idx on en_historico_funcional_rais (cost=0.57..6.14 rows=4 width=84) (actual time=3.230..7.178 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
173. 54.000 10,063.000 ↑ 1.0 1 1,000

Aggregate (cost=16.16..16.17 rows=1 width=32) (actual time=10.063..10.063 rows=1 loops=1,000)

174. 10,009.000 10,009.000 ↑ 12.0 1 1,000

Index Scan using en_historico_funcional_cnseg_nova_cd_cpf_idx1 on en_historico_funcional_cnseg f_3 (cost=0.57..15.08 rows=12 width=174) (actual time=3.258..10.009 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
175. 24.000 86.000 ↑ 1.0 1 1,000

Aggregate (cost=6.30..6.31 rows=1 width=32) (actual time=0.086..0.086 rows=1 loops=1,000)

176. 4.000 62.000 ↓ 0.0 0 1,000

Limit (cost=0.56..5.39 rows=7 width=230) (actual time=0.053..0.062 rows=0 loops=1,000)

177. 58.000 58.000 ↓ 0.0 0 1,000

Index Scan using en_emprego_atual_cd_cpf_idx on en_emprego_atual (cost=0.56..5.39 rows=7 width=230) (actual time=0.049..0.058 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
178. 27.000 10,225.000 ↑ 1.0 1 1,000

Aggregate (cost=21.56..21.57 rows=1 width=32) (actual time=10.225..10.225 rows=1 loops=1,000)

179. 10,198.000 10,198.000 ↑ 8.5 2 1,000

Index Scan using idx_cpf_bf on "bolsaFamilia" b (cost=0.57..20.67 rows=17 width=42) (actual time=0.853..10.198 rows=2 loops=1,000)

  • Index Cond: (cpf = pf.cd_cpf)
180. 4.000 21.000 ↑ 1.0 1 1,000

Aggregate (cost=2.57..2.58 rows=1 width=32) (actual time=0.021..0.021 rows=1 loops=1,000)

181. 17.000 17.000 ↓ 0.0 0 1,000

Index Scan using presidiario_pkey on presidiario p_1 (cost=0.29..2.51 rows=1 width=84) (actual time=0.017..0.017 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
182. 7.000 326.000 ↓ 0.0 0 1,000

GroupAggregate (cost=0.43..40.30 rows=30 width=44) (actual time=0.326..0.326 rows=0 loops=1,000)

  • Group Key: imovel.cd_cpf
183. 319.000 319.000 ↓ 0.0 0 1,000

Index Scan using idx_imovel_cd_cpf on imovel (cost=0.43..34.97 rows=30 width=156) (actual time=0.243..0.319 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
184. 60.000 4,414.000 ↓ 0.0 0 1,000

GroupAggregate (cost=0.99..9.83 rows=2 width=44) (actual time=4.414..4.414 rows=0 loops=1,000)

  • Group Key: veiculo.cd_cpf
185. 9.530 4,354.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=0.99..9.22 rows=2 width=252) (actual time=3.213..4.354 rows=0 loops=1,000)

186. 3,111.000 3,111.000 ↓ 0.0 0 1,000

Index Scan using veiculo_20170803_cd_cpf_idx on veiculo (cost=0.57..3.90 rows=2 width=212) (actual time=2.235..3.111 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
187. 1,233.470 1,233.470 ↓ 0.0 0 469

Index Scan using tmp_veiculos_vw_normalizados_final_sd984_pkey on veiculos_volkswagen_full vw (cost=0.43..2.65 rows=1 width=60) (actual time=2.630..2.630 rows=0 loops=469)

  • Index Cond: (cd_placa = veiculo.cd_placa)
  • Filter: ((cd_cpf = pf.cd_cpf) AND (cd_cpf = veiculo.cd_cpf))
  • Rows Removed by Filter: 0
188. 3.000 31.000 ↓ 0.0 0 1,000

GroupAggregate (cost=0.99..6.74 rows=1 width=44) (actual time=0.031..0.031 rows=0 loops=1,000)

  • Group Key: veiculo_1.cd_cpf
189. 2.813 28.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=0.99..6.57 rows=1 width=151) (actual time=0.028..0.028 rows=0 loops=1,000)

190. 25.000 25.000 ↓ 0.0 0 1,000

Index Scan using veiculo_20170803_cd_cpf_idx on veiculo veiculo_1 (cost=0.57..3.91 rows=1 width=111) (actual time=0.025..0.025 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
  • Filter: (de_classificacao = 'PESADO'::bpchar)
  • Rows Removed by Filter: 0
191. 0.187 0.187 ↓ 0.0 0 11

Index Scan using tmp_veiculos_vw_normalizados_final_sd984_pkey on veiculos_volkswagen_full vw_1 (cost=0.43..2.65 rows=1 width=60) (actual time=0.017..0.017 rows=0 loops=11)

  • Index Cond: (cd_placa = veiculo_1.cd_placa)
  • Filter: ((cd_cpf = pf.cd_cpf) AND (cd_cpf = veiculo_1.cd_cpf))
  • Rows Removed by Filter: 0
192. 29.000 913.000 ↑ 1.0 1 1,000

Aggregate (cost=479.95..479.97 rows=1 width=32) (actual time=0.913..0.913 rows=1 loops=1,000)

193. 884.000 884.000 ↑ 406.0 1 1,000

Index Scan using telefone_novo_pkey on telefone (cost=0.57..445.44 rows=406 width=103) (actual time=0.278..0.884 rows=1 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
194. 6.000 33.000 ↑ 1.0 1 1,000

Aggregate (cost=3.04..3.05 rows=1 width=32) (actual time=0.033..0.033 rows=1 loops=1,000)

195. 27.000 27.000 ↓ 0.0 0 1,000

Index Scan using idx_telefones_comerciais_novo_cd_cpf on telefones_comerciais tcpf (cost=0.56..2.90 rows=8 width=61) (actual time=0.027..0.027 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
196. 14.000 104.000 ↑ 1.0 1 1,000

Aggregate (cost=2.70..2.71 rows=1 width=32) (actual time=0.104..0.104 rows=1 loops=1,000)

197. 90.000 90.000 ↓ 0.0 0 1,000

Index Scan using idx_cpf_antt_autonomo on antt_autonomo_trat i (cost=0.42..2.64 rows=1 width=79) (actual time=0.089..0.090 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
198. 7.000 33.000 ↑ 1.0 1 1,000

Aggregate (cost=5.34..5.35 rows=1 width=32) (actual time=0.033..0.033 rows=1 loops=1,000)

199. 26.000 26.000 ↓ 0.0 0 1,000

Index Scan using en_corretores_susep_cd_cpf_idx on en_corretores_susep c_5 (cost=0.42..5.11 rows=4 width=62) (actual time=0.026..0.026 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
200. 14.000 47.000 ↑ 1.0 1 1,000

Aggregate (cost=3.15..3.16 rows=1 width=32) (actual time=0.047..0.047 rows=1 loops=1,000)

201. 33.000 33.000 ↓ 0.0 0 1,000

Index Scan using transparencia_cd_cpf_idx on transparencia (cost=0.43..3.01 rows=2 width=148) (actual time=0.028..0.033 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
202. 7.000 371.000 ↓ 0.0 0 1,000

GroupAggregate (cost=0.56..18.24 rows=18 width=44) (actual time=0.371..0.371 rows=0 loops=1,000)

  • Group Key: afastamento_pf.cd_cpf
203. 364.000 364.000 ↓ 0.0 0 1,000

Index Scan using idx_afastamento_pf_cpf on afastamento_pf (cost=0.56..17.20 rows=18 width=68) (actual time=0.161..0.364 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
204. 10.000 45.000 ↑ 1.0 1 1,000

Aggregate (cost=9.82..9.83 rows=1 width=32) (actual time=0.045..0.045 rows=1 loops=1,000)

205. 3.000 35.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on anac_aeronave a_2 (cost=2.82..9.47 rows=6 width=117) (actual time=0.035..0.035 rows=0 loops=1,000)

  • Recheck Cond: ((pf.cd_cpf = cd_cpf_prop) OR (pf.cd_cpf = cd_cpf_oper))
206. 5.000 32.000 ↓ 0.0 0 1,000

BitmapOr (cost=2.82..2.82 rows=6 width=0) (actual time=0.032..0.032 rows=0 loops=1,000)

207. 14.000 14.000 ↓ 0.0 0 1,000

Bitmap Index Scan on anac_aeronave_nova_cd_cpf_prop_idx1 (cost=0.00..1.41 rows=3 width=0) (actual time=0.014..0.014 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf_prop)
208. 13.000 13.000 ↓ 0.0 0 1,000

Bitmap Index Scan on anac_aeronave_nova_cd_cpf_oper_idx1 (cost=0.00..1.41 rows=3 width=0) (actual time=0.013..0.013 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf_oper)
209. 32.000 5,734.000 ↑ 1.0 1 1,000

Aggregate (cost=1,650.00..1,650.01 rows=1 width=32) (actual time=5.734..5.734 rows=1 loops=1,000)

210. 5,702.000 5,702.000 ↑ 475.3 3 1,000

Index Scan using pk_irpf_trat on irpf_trat i_1 (cost=0.57..1,596.52 rows=1,426 width=68) (actual time=3.611..5.702 rows=3 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
Planning time : 99.435 ms
Execution time : 115,106.660 ms