explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WGr7

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 209.296 122,780.136 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=388.79..6,624,503.35 rows=1,570 width=9,085) (actual time=1,391.588..122,780.136 rows=1,000 loops=1)

2. 8.317 8,139.840 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=388.22..23,817.67 rows=1,570 width=6,648) (actual time=297.460..8,139.840 rows=1,000 loops=1)

3. 7.756 7,972.523 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=387.80..23,107.18 rows=1,570 width=6,640) (actual time=290.865..7,972.523 rows=1,000 loops=1)

4. 7.917 7,920.767 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=387.38..22,412.45 rows=1,570 width=6,586) (actual time=285.594..7,920.767 rows=1,000 loops=1)

5. 8.375 7,874.850 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=386.95..21,688.66 rows=1,570 width=6,431) (actual time=277.592..7,874.850 rows=1,000 loops=1)

6. 10.458 7,156.475 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=386.39..20,758.94 rows=1,570 width=6,430) (actual time=267.202..7,156.475 rows=1,000 loops=1)

7. 7.535 7,115.017 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=385.96..20,048.44 rows=1,570 width=6,429) (actual time=261.877..7,115.017 rows=1,000 loops=1)

8. 7.148 7,081.482 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=385.54..19,349.79 rows=1,570 width=6,417) (actual time=261.821..7,081.482 rows=1,000 loops=1)

9. 9.119 7,060.334 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=385.26..18,855.24 rows=1,570 width=6,378) (actual time=261.560..7,060.334 rows=1,000 loops=1)

10. 9.952 7,015.215 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=384.83..18,144.79 rows=1,570 width=6,366) (actual time=254.726..7,015.215 rows=1,000 loops=1)

11. 12.228 6,991.263 ↑ 1.6 1,000 1

Hash Left Join (cost=384.55..17,658.09 rows=1,570 width=5,972) (actual time=254.696..6,991.263 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = enviceprefb72.cd_cpf)
12. 9.848 6,966.038 ↑ 1.6 1,000 1

Hash Left Join (cost=330.58..17,598.22 rows=1,570 width=5,538) (actual time=241.664..6,966.038 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = enprefb72.cd_cpf)
13. 13.488 6,940.746 ↑ 1.6 1,000 1

Hash Left Join (cost=260.66..17,522.40 rows=1,570 width=5,095) (actual time=226.172..6,940.746 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = enpdmb72.cd_cpf)
14. 7.966 6,910.338 ↑ 1.6 1,000 1

Hash Left Join (cost=116.32..17,372.16 rows=1,570 width=4,836) (actual time=209.193..6,910.338 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = ennacb72.cd_cpf)
15. 7.115 6,892.457 ↑ 1.6 1,000 1

Hash Left Join (cost=84.04..17,333.98 rows=1,570 width=4,011) (actual time=199.255..6,892.457 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = endepb72.cd_cpf)
16. 6.643 6,885.292 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=81.23..17,325.28 rows=1,570 width=3,716) (actual time=199.119..6,885.292 rows=1,000 loops=1)

17. 5.865 6,827.649 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=80.79..16,602.32 rows=1,570 width=3,593) (actual time=193.337..6,827.649 rows=1,000 loops=1)

18. 5.880 6,787.784 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=80.37..15,899.73 rows=1,570 width=3,578) (actual time=193.264..6,787.784 rows=1,000 loops=1)

19. 5.389 6,762.904 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=79.96..15,204.99 rows=1,570 width=3,499) (actual time=193.183..6,762.904 rows=1,000 loops=1)

20. 7.112 6,708.515 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=79.54..14,502.38 rows=1,570 width=3,304) (actual time=187.098..6,708.515 rows=1,000 loops=1)

21. 6.696 6,655.403 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=79.12..13,799.79 rows=1,570 width=3,292) (actual time=187.018..6,655.403 rows=1,000 loops=1)

22. 10.738 6,596.707 ↑ 1.6 1,000 1

Hash Left Join (cost=78.69..13,089.28 rows=1,570 width=3,284) (actual time=180.477..6,596.707 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = oabmgprev.cd_cpf)
23. 4.914 6,577.032 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=6.07..13,010.76 rows=1,570 width=3,184) (actual time=171.397..6,577.032 rows=1,000 loops=1)

24. 5.184 6,553.118 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=5.66..12,312.09 rows=1,570 width=2,983) (actual time=171.318..6,553.118 rows=1,000 loops=1)

25. 5.230 6,528.934 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=5.37..11,821.47 rows=1,570 width=2,976) (actual time=171.297..6,528.934 rows=1,000 loops=1)

26. 6.233 6,490.704 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=4.95..11,118.83 rows=1,570 width=2,556) (actual time=171.215..6,490.704 rows=1,000 loops=1)

27. 8.010 6,453.471 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=4.53..10,408.23 rows=1,570 width=2,318) (actual time=166.625..6,453.471 rows=1,000 loops=1)

28. 6.607 6,192.461 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=4.25..9,917.60 rows=1,570 width=2,215) (actual time=155.552..6,192.461 rows=1,000 loops=1)

29. 3.958 1,620.854 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=3.68..8,843.14 rows=1,570 width=2,120) (actual time=119.330..1,620.854 rows=1,000 loops=1)

30. 5.031 1,602.896 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=3.40..8,356.43 rows=1,570 width=1,108) (actual time=119.272..1,602.896 rows=1,000 loops=1)

31. 6.645 1,512.865 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=2.83..7,369.98 rows=1,570 width=1,015) (actual time=98.650..1,512.865 rows=1,000 loops=1)

32. 4.516 1,417.220 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=2.26..6,292.18 rows=1,570 width=151) (actual time=79.717..1,417.220 rows=1,000 loops=1)

33. 5.112 1,151.704 ↑ 1.6 1,000 1

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

34. 5.286 120.592 ↑ 1.6 1,000 1

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

35. 34.306 34.306 ↑ 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=27.749..34.306 rows=1,000 loops=1)

  • Index Cond: (nu_pagina = 500)
36. 81.000 81.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.079..0.081 rows=1 loops=1,000)

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

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

  • Index Cond: (pf.cd_cpf = cd_cpf)
38. 261.000 261.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.261..0.261 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
39. 89.000 89.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.087..0.089 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
40. 85.000 85.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.084..0.085 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
41. 14.000 14.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.014..0.014 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
42. 4,565.000 4,565.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.548..4.565 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
43. 253.000 253.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.251..0.253 rows=1 loops=1,000)

  • Index Cond: ((e.sg_uf = sg_uf) AND ((e.nm_municipio)::text = (nm_municipio)::text))
44. 31.000 31.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.031..0.031 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
45. 33.000 33.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.033..0.033 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
46. 19.000 19.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.019..0.019 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
47. 19.000 19.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.019..0.019 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
48. 1.137 8.937 ↑ 1.0 1,983 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 239kB
49. 7.800 7.800 ↑ 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.009..7.800 rows=1,983 loops=1)

50. 52.000 52.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.052..0.052 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
51. 46.000 46.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.046..0.046 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
  • Heap Fetches: 0
52. 49.000 49.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.049..0.049 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
53. 19.000 19.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.019..0.019 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
54. 34.000 34.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.034..0.034 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
55. 51.000 51.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.051..0.051 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
56. 0.029 0.050 ↑ 1.0 36 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
57. 0.021 0.021 ↑ 1.0 36 1

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

58. 0.544 9.915 ↑ 1.0 457 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 179kB
59. 9.371 9.371 ↑ 1.0 457 1

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

60. 1.733 16.920 ↓ 1.2 2,852 1

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

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

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

62. 0.749 15.444 ↓ 1.0 850 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 406kB
63. 14.695 14.695 ↓ 1.0 850 1

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

64. 0.698 12.997 ↓ 1.4 740 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 328kB
65. 12.299 12.299 ↓ 1.4 740 1

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

66. 14.000 14.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.014..0.014 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
67. 36.000 36.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.036..0.036 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
  • Heap Fetches: 0
68. 14.000 14.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.014..0.014 rows=0 loops=1,000)

  • Index Cond: (cd_cpf_socio = pf.cd_cpf)
69. 26.000 26.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.026..0.026 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
  • Heap Fetches: 0
70. 31.000 31.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.031..0.031 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
71. 710.000 710.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.709..0.710 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
72. 38.000 38.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.038..0.038 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
73. 44.000 44.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.044..0.044 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
74. 159.000 159.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.159..0.159 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
75. 79.000 79.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.076..0.079 rows=1 loops=1,000)

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

SubPlan (forNested Loop Left Join)

77. 18.000 18.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.018..0.018 rows=1 loops=1,000)

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

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

  • Filter: (cd_raca = (pf.cd_raca)::bpchar)
  • Rows Removed by Filter: 5
79. 13.000 13.000 ↑ 1.0 1 1,000

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

  • Filter: (cd_grau_instrucao = (pf.cd_grau_instrucao)::bpchar)
  • Rows Removed by Filter: 10
80. 3.000 1,218.000 ↓ 0.0 0 1,000

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

81. 1,215.000 1,215.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.215..1.215 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
  • Heap Fetches: 212
82. 6.000 342.000 ↑ 1.0 1 1,000

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

83. 336.000 336.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.316..0.336 rows=0 loops=1,000)

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

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

  • Group Key: p.cd_cpf
85. 43.000 43.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.043..0.043 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
86. 22.000 208.000 ↓ 0.0 0 1,000

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

  • Group Key: totalizadores_processos.cpf
87. 186.000 186.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.091..0.186 rows=2 loops=1,000)

  • Index Cond: (cpf = (pf.cd_cpf)::text)
88. 11.000 33.000 ↑ 1.0 1 1,000

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

89. 22.000 22.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.022..0.022 rows=0 loops=1,000)

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

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

  • Group Key: pessoa_ibama_embargos.cd_cpf
91. 45.000 45.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.045..0.045 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
92. 34.000 32,393.000 ↓ 0.0 0 1,000

GroupAggregate (cost=1.14..1,747.57 rows=442 width=44) (actual time=32.393..32.393 rows=0 loops=1,000)

  • Group Key: r_1.cd_cpf
93. 12.194 32,359.000 ↑ 221.0 2 1,000

Nested Loop (cost=1.14..1,733.20 rows=442 width=54) (actual time=8.190..32.359 rows=2 loops=1,000)

94. 4,119.000 4,119.000 ↑ 221.0 2 1,000

Index Scan using relacionamentos_cd_cpf_idx on relacionamentos r_1 (cost=0.57..496.71 rows=442 width=29) (actual time=0.878..4.119 rows=2 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
95. 28,227.806 28,227.806 ↑ 1.0 1 1,501

Index Scan using pessoa_fisica_kruger_cd_cpf_idx on pessoa_fisica pff (cost=0.57..2.79 rows=1 width=37) (actual time=18.801..18.806 rows=1 loops=1,501)

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

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

  • Group Key: r_2.cd_cpf
97. 67.000 67.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.067..0.067 rows=0 loops=1,000)

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

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

  • Group Key: c.cfocdcpfprofissional
99. 234.000 234.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.217..0.234 rows=0 loops=1,000)

  • Index Cond: (cfocdcpfprofissional = pf.cd_cpf)
100. 3.000 109.000 ↓ 0.0 0 1,000

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

  • Group Key: m.cpf
101. 106.000 106.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.089..0.106 rows=0 loops=1,000)

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

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

  • Group Key: m_1.cpf
103. 2.558 82.000 ↓ 0.0 0 1,000

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

104. 11.000 11.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.011..0.011 rows=0 loops=1,000)

  • Index Cond: (cpf = pf.cd_cpf)
105. 68.442 68.442 ↑ 2.0 1 11

Index Scan using idxmedicosespecialidadeatuacaoid on "medicosEspecialidadeAtuacao" me (cost=0.42..3.76 rows=2 width=61) (actual time=6.221..6.222 rows=1 loops=11)

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

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

  • Group Key: m_2.cpf
107. 2.723 48.000 ↓ 0.0 0 1,000

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

108. 10.000 10.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.010..0.010 rows=0 loops=1,000)

  • Index Cond: (cpf = pf.cd_cpf)
109. 35.277 35.277 ↑ 1.0 1 11

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

  • Index Cond: ((id)::text = m_2.id)
110. 4.000 19.000 ↑ 1.0 1 1,000

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

111. 15.000 15.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.015..0.015 rows=0 loops=1,000)

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

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

113. 15.000 15.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.015..0.015 rows=0 loops=1,000)

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

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

115. 12.000 12.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.012..0.012 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
116. 11.000 218.000 ↑ 1.0 1 1,000

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

117. 207.000 207.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.188..0.207 rows=0 loops=1,000)

  • Index Cond: (cd_cpf_empreendimento = pf.cd_cpf)
118. 12.000 884.000 ↑ 1.0 1 1,000

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

119. 872.000 872.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.739..0.872 rows=0 loops=1,000)

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

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

121. 226.000 226.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.201..0.226 rows=0 loops=1,000)

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

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

123. 244.000 244.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.236..0.244 rows=0 loops=1,000)

  • Index Cond: (((pf.cd_cpf)::character varying(11))::bpchar = cd_cpf)
124. 53.000 37,974.000 ↑ 1.0 1 1,000

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

125. 6.577 37,921.000 ↓ 0.0 0 1,000

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

126. 5.379 29,562.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=3.67..9.43 rows=1 width=278) (actual time=23.010..29.562 rows=0 loops=1,000)

127. 4.895 23,994.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=3.11..8.84 rows=1 width=273) (actual time=18.505..23.994 rows=0 loops=1,000)

128. 4.480 18,208.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=2.55..8.24 rows=1 width=256) (actual time=13.868..18.208 rows=0 loops=1,000)

129. 5.496 18,075.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=2.26..7.92 rows=1 width=241) (actual time=13.750..18.075 rows=0 loops=1,000)

130. 5.753 16,575.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=1.69..7.30 rows=1 width=178) (actual time=12.736..16.575 rows=0 loops=1,000)

131. 8.380 12,010.000 ↓ 0.0 0 1,000

Nested Loop (cost=1.13..6.70 rows=1 width=170) (actual time=9.519..12.010 rows=0 loops=1,000)

132. 3,447.000 3,447.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.696..3.447 rows=0 loops=1,000)

  • Index Cond: ((cd_doc_socio)::text = (pf.cd_cpf)::text)
  • Filter: (length((cd_doc_socio)::text) = 11)
133. 8,554.620 8,554.620 ↑ 1.0 1 460

Index Scan using empresa_cd_cnpj_idx on empresa e_2 (cost=0.56..2.78 rows=1 width=125) (actual time=18.520..18.597 rows=1 loops=460)

  • Index Cond: (cd_cnpj = (s_2.cd_cnpj_empresa)::bpchar)
134. 4,559.247 4,559.247 ↓ 0.0 0 459

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=9.108..9.933 rows=0 loops=459)

  • Index Cond: (cd_cnpj = e_2.cd_cnpj)
135. 1,494.504 1,494.504 ↑ 1.0 1 459

Index Scan using cnae_principal_etl_pkey on cnae_principal c_2 (cost=0.56..0.61 rows=1 width=78) (actual time=2.562..3.256 rows=1 loops=459)

  • Index Cond: (cd_cnpj = e_2.cd_cnpj)
136. 128.520 128.520 ↓ 0.0 0 459

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.280..0.280 rows=0 loops=459)

  • Index Cond: (cd_cnpj = e_2.cd_cnpj)
  • Heap Fetches: 0
137. 5,781.105 5,781.105 ↑ 1.0 1 459

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=12.594..12.595 rows=1 loops=459)

  • Index Cond: (e_2.cd_cnpj = cd_cnpj)
138. 5,562.621 5,562.621 ↑ 1.0 1 459

Index Scan using junta_comercial_pkey on junta_comercial cs (cost=0.56..0.59 rows=1 width=20) (actual time=12.101..12.119 rows=1 loops=459)

  • Index Cond: (e_2.cd_cnpj = cd_cnpj)
139. 8,352.423 8,352.423 ↑ 1.0 1 459

Index Scan using faturamento_presumido_cd_cnpj_idx2 on faturamento_presumido fp (cost=0.56..0.64 rows=1 width=76) (actual time=17.973..18.197 rows=1 loops=459)

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

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

141. 1.673 593.000 ↓ 0.0 0 1,000

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

142. 1.523 540.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=3.66..10.54 rows=1 width=271) (actual time=0.420..0.540 rows=0 loops=1,000)

143. 1.716 502.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=3.09..9.94 rows=1 width=266) (actual time=0.394..0.502 rows=0 loops=1,000)

144. 1.541 460.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=2.53..9.34 rows=1 width=249) (actual time=0.365..0.460 rows=0 loops=1,000)

145. 2.340 458.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=2.25..9.03 rows=1 width=234) (actual time=0.363..0.458 rows=0 loops=1,000)

146. 2.175 440.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=1.69..8.41 rows=1 width=171) (actual time=0.346..0.440 rows=0 loops=1,000)

147. 4.806 398.000 ↓ 0.0 0 1,000

Nested Loop (cost=1.13..7.82 rows=1 width=163) (actual time=0.318..0.398 rows=0 loops=1,000)

148. 317.000 317.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.256..0.317 rows=0 loops=1,000)

  • Index Cond: ((cd_doc_socio)::text = (pf.cd_cpf)::text)
  • Filter: (length((cd_doc_socio)::text) = 11)
149. 76.194 76.194 ↑ 1.0 1 27

Index Scan using empresa_cd_cnpj_idx on empresa e_3 (cost=0.56..2.78 rows=1 width=125) (actual time=2.821..2.822 rows=1 loops=27)

  • Index Cond: (cd_cnpj = (s_3.cd_cnpj_empresa)::bpchar)
150. 39.825 39.825 ↓ 0.0 0 27

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=1.311..1.475 rows=0 loops=27)

  • Index Cond: (cd_cnpj = e_3.cd_cnpj)
151. 15.660 15.660 ↑ 1.0 1 27

Index Scan using cnae_principal_etl_pkey on cnae_principal c_3 (cost=0.56..0.61 rows=1 width=78) (actual time=0.579..0.580 rows=1 loops=27)

  • Index Cond: (cd_cnpj = e_3.cd_cnpj)
152. 0.459 0.459 ↓ 0.0 0 27

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.017..0.017 rows=0 loops=27)

  • Index Cond: (cd_cnpj = e_3.cd_cnpj)
  • Heap Fetches: 0
153. 40.284 40.284 ↑ 1.0 1 27

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=1.490..1.492 rows=1 loops=27)

  • Index Cond: (e_3.cd_cnpj = cd_cnpj)
154. 36.477 36.477 ↑ 1.0 1 27

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

  • Index Cond: (e_3.cd_cnpj = cd_cnpj)
155. 51.327 51.327 ↑ 1.0 1 27

Index Scan using faturamento_presumido_cd_cnpj_idx2 on faturamento_presumido fp_1 (cost=0.56..0.64 rows=1 width=76) (actual time=1.899..1.901 rows=1 loops=27)

  • Index Cond: (e_3.cd_cnpj = cd_cnpj)
156. 42.000 1,410.000 ↑ 1.0 1 1,000

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

157. 3.110 1,368.000 ↓ 0.0 0 1,000

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

158. 2.896 1,271.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=3.66..14.94 rows=2 width=282) (actual time=1.048..1.271 rows=0 loops=1,000)

159. 3.552 1,182.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=3.10..13.74 rows=2 width=277) (actual time=0.972..1.182 rows=0 loops=1,000)

160. 3.672 1,107.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=2.54..12.54 rows=2 width=260) (actual time=0.916..1.107 rows=0 loops=1,000)

161. 3.230 1,096.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=2.26..11.92 rows=2 width=245) (actual time=0.907..1.096 rows=0 loops=1,000)

162. 3.674 1,063.000 ↓ 0.0 0 1,000

Nested Loop Left Join (cost=1.69..10.68 rows=2 width=182) (actual time=0.879..1.063 rows=0 loops=1,000)

163. 7.611 992.000 ↓ 0.0 0 1,000

Nested Loop (cost=1.13..9.50 rows=2 width=174) (actual time=0.834..0.992 rows=0 loops=1,000)

164. 860.000 860.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=0.724..0.860 rows=0 loops=1,000)

  • Index Cond: ((cd_doc_socio)::text = (pf.cd_cpf)::text)
  • Filter: (length((cd_doc_socio)::text) = 11)
165. 124.389 124.389 ↑ 1.0 1 459

Index Scan using empresa_cd_cnpj_idx on empresa e_4 (cost=0.56..2.78 rows=1 width=125) (actual time=0.271..0.271 rows=1 loops=459)

  • Index Cond: (cd_cnpj = s_4.cd_cnpj)
166. 67.326 67.326 ↓ 0.0 0 458

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.135..0.147 rows=0 loops=458)

  • Index Cond: (cd_cnpj = e_4.cd_cnpj)
167. 29.770 29.770 ↑ 1.0 1 458

Index Scan using cnae_principal_etl_pkey on cnae_principal c_4 (cost=0.56..0.61 rows=1 width=78) (actual time=0.062..0.065 rows=1 loops=458)

  • Index Cond: (cd_cnpj = e_4.cd_cnpj)
168. 7.328 7.328 ↓ 0.0 0 458

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.016..0.016 rows=0 loops=458)

  • Index Cond: (cd_cnpj = e_4.cd_cnpj)
  • Heap Fetches: 0
169. 71.448 71.448 ↑ 1.0 1 458

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.156..0.156 rows=1 loops=458)

  • Index Cond: (e_4.cd_cnpj = cd_cnpj)
170. 86.104 86.104 ↑ 1.0 1 458

Index Scan using junta_comercial_pkey on junta_comercial cs_2 (cost=0.56..0.59 rows=1 width=20) (actual time=0.187..0.188 rows=1 loops=458)

  • Index Cond: (e_4.cd_cnpj = cd_cnpj)
171. 93.890 93.890 ↑ 1.0 1 458

Index Scan using faturamento_presumido_cd_cnpj_idx2 on faturamento_presumido fp_2 (cost=0.56..0.64 rows=1 width=76) (actual time=0.192..0.205 rows=1 loops=458)

  • Index Cond: (e_4.cd_cnpj = cd_cnpj)
172. 50.000 7,657.000 ↑ 1.0 1 1,000

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

173. 7,607.000 7,607.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.105..7.607 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
174. 55.000 10,380.000 ↑ 1.0 1 1,000

Aggregate (cost=18.57..18.58 rows=1 width=32) (actual time=10.380..10.380 rows=1 loops=1,000)

175. 10,325.000 10,325.000 ↑ 7.0 2 1,000

Index Scan using en_historico_funcional_cnseg_nova_cd_cpf_idx1 on en_historico_funcional_cnseg f_3 (cost=0.57..17.31 rows=14 width=174) (actual time=3.555..10.325 rows=2 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
176. 23.000 132.000 ↑ 1.0 1 1,000

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

177. 3.000 109.000 ↓ 0.0 0 1,000

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

178. 106.000 106.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.105..0.106 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
179. 20.000 6,999.000 ↑ 1.0 1 1,000

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

180. 6,979.000 6,979.000 ↑ 17.0 1 1,000

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

  • Index Cond: (cpf = pf.cd_cpf)
181. 5.000 31.000 ↑ 1.0 1 1,000

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

182. 26.000 26.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.020..0.026 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
183. 8.000 310.000 ↓ 0.0 0 1,000

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

  • Group Key: imovel.cd_cpf
184. 302.000 302.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.201..0.302 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
185. 59.000 5,766.000 ↓ 0.0 0 1,000

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

  • Group Key: veiculo.cd_cpf
186. 7.404 5,707.000 ↓ 0.0 0 1,000

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

187. 3,778.000 3,778.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.731..3.778 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
188. 1,921.596 1,921.596 ↓ 0.0 0 474

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=4.054..4.054 rows=0 loops=474)

  • Index Cond: (cd_placa = veiculo.cd_placa)
  • Filter: ((cd_cpf = pf.cd_cpf) AND (cd_cpf = veiculo.cd_cpf))
189. 2.000 32.000 ↓ 0.0 0 1,000

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

  • Group Key: veiculo_1.cd_cpf
190. 2.874 30.000 ↓ 0.0 0 1,000

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

191. 27.000 27.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.027..0.027 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
  • Filter: (de_classificacao = 'PESADO'::bpchar)
  • Rows Removed by Filter: 0
192. 0.126 0.126 ↓ 0.0 0 9

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.014..0.014 rows=0 loops=9)

  • Index Cond: (cd_placa = veiculo_1.cd_placa)
  • Filter: ((cd_cpf = pf.cd_cpf) AND (cd_cpf = veiculo_1.cd_cpf))
193. 32.000 1,408.000 ↑ 1.0 1 1,000

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

194. 1,376.000 1,376.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.506..1.376 rows=1 loops=1,000)

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

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

196. 73.000 73.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.073..0.073 rows=0 loops=1,000)

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

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

198. 69.000 69.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.069..0.069 rows=0 loops=1,000)

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

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

200. 31.000 31.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.031..0.031 rows=0 loops=1,000)

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

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

202. 78.000 78.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.077..0.078 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
203. 6.000 436.000 ↓ 0.0 0 1,000

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

  • Group Key: afastamento_pf.cd_cpf
204. 430.000 430.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.242..0.430 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
205. 11.000 63.000 ↑ 1.0 1 1,000

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

206. 2.000 52.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.052..0.052 rows=0 loops=1,000)

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

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

208. 23.000 23.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.023..0.023 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf_prop)
209. 22.000 22.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.022..0.022 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf_oper)
210. 26.000 4,337.000 ↑ 1.0 1 1,000

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

211. 4,311.000 4,311.000 ↑ 713.0 2 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.217..4.311 rows=2 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
Planning time : 7,407.504 ms
Execution time : 122,794.295 ms