explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UX7B

Settings
# exclusive inclusive rows x rows loops node
1. 220.928 56,778.957 ↑ 1.6 1,000 1

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

2. 9.286 5,197.029 ↑ 1.6 1,000 1

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

3. 9.121 5,153.743 ↑ 1.6 1,000 1

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

4. 8.800 5,129.622 ↑ 1.6 1,000 1

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

5. 8.512 5,055.822 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=386.95..21,688.80 rows=1,570 width=6,431) (actual time=316.283..5,055.822 rows=1,000 loops=1)

6. 9.280 4,554.310 ↑ 1.6 1,000 1

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

7. 8.015 4,486.030 ↑ 1.6 1,000 1

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

8. 8.781 4,458.015 ↑ 1.6 1,000 1

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

9. 8.730 4,434.234 ↑ 1.6 1,000 1

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

10. 9.175 4,373.504 ↑ 1.6 1,000 1

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

11. 12.399 4,347.329 ↑ 1.6 1,000 1

Hash Left Join (cost=384.55..17,658.23 rows=1,570 width=5,972) (actual time=248.829..4,347.329 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = enviceprefb72.cd_cpf)
12. 10.424 4,333.620 ↑ 1.6 1,000 1

Hash Left Join (cost=330.58..17,598.36 rows=1,570 width=5,538) (actual time=247.478..4,333.620 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = enprefb72.cd_cpf)
13. 12.162 4,321.607 ↑ 1.6 1,000 1

Hash Left Join (cost=260.66..17,522.54 rows=1,570 width=5,095) (actual time=245.868..4,321.607 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = enpdmb72.cd_cpf)
14. 7.625 4,306.107 ↑ 1.6 1,000 1

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

  • Hash Cond: (pf.cd_cpf = ennacb72.cd_cpf)
15. 7.895 4,297.483 ↑ 1.6 1,000 1

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

  • Hash Cond: (pf.cd_cpf = endepb72.cd_cpf)
16. 7.773 4,289.539 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=81.23..17,325.42 rows=1,570 width=3,716) (actual time=241.376..4,289.539 rows=1,000 loops=1)

17. 6.597 4,194.766 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=80.79..16,602.46 rows=1,570 width=3,593) (actual time=229.714..4,194.766 rows=1,000 loops=1)

18. 6.037 4,151.169 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=80.37..15,899.87 rows=1,570 width=3,578) (actual time=215.625..4,151.169 rows=1,000 loops=1)

19. 5.562 4,125.132 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=79.96..15,205.13 rows=1,570 width=3,499) (actual time=215.462..4,125.132 rows=1,000 loops=1)

20. 6.663 4,081.570 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=79.54..14,502.51 rows=1,570 width=3,304) (actual time=204.629..4,081.570 rows=1,000 loops=1)

21. 6.518 4,048.907 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=79.12..13,799.93 rows=1,570 width=3,292) (actual time=198.823..4,048.907 rows=1,000 loops=1)

22. 8.179 4,002.389 ↑ 1.6 1,000 1

Hash Left Join (cost=78.69..13,089.42 rows=1,570 width=3,284) (actual time=187.081..4,002.389 rows=1,000 loops=1)

  • Hash Cond: (pf.cd_cpf = oabmgprev.cd_cpf)
23. 6.048 3,992.362 ↑ 1.6 1,000 1

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

24. 7.372 3,968.314 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=5.66..12,312.23 rows=1,570 width=2,983) (actual time=184.730..3,968.314 rows=1,000 loops=1)

25. 5.576 3,946.942 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=5.37..11,821.60 rows=1,570 width=2,976) (actual time=184.648..3,946.942 rows=1,000 loops=1)

26. 6.208 3,904.366 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=4.95..11,118.97 rows=1,570 width=2,556) (actual time=172.696..3,904.366 rows=1,000 loops=1)

27. 7.439 3,859.158 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=4.53..10,408.37 rows=1,570 width=2,318) (actual time=164.936..3,859.158 rows=1,000 loops=1)

28. 8.498 3,825.719 ↑ 1.6 1,000 1

Nested Loop Left Join (cost=4.25..9,917.74 rows=1,570 width=2,215) (actual time=164.849..3,825.719 rows=1,000 loops=1)

29. 5.373 1,043.221 ↑ 1.6 1,000 1

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

30. 5.722 1,018.848 ↑ 1.6 1,000 1

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

31. 7.779 914.126 ↑ 1.6 1,000 1

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

32. 4.413 664.347 ↑ 1.6 1,000 1

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

33. 4.471 474.934 ↑ 1.6 1,000 1

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

34. 5.976 125.463 ↑ 1.6 1,000 1

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

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

  • Index Cond: (nu_pagina = 20000)
36. 85.000 85.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.083..0.085 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = solr.id_doc)
37. 345.000 345.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.304..0.345 rows=0 loops=1,000)

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

  • Index Cond: (pf.cd_cpf = cd_cpf)
39. 242.000 242.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.232..0.242 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
40. 99.000 99.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.092..0.099 rows=1 loops=1,000)

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

  • Index Cond: (cd_cpf = pf.cd_cpf)
42. 2,774.000 2,774.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=2.759..2.774 rows=1 loops=1,000)

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

  • Index Cond: ((e.sg_uf = sg_uf) AND ((e.nm_municipio)::text = (nm_municipio)::text))
44. 39.000 39.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.039..0.039 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf)
45. 37.000 37.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.037..0.037 rows=0 loops=1,000)

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

  • Index Cond: (pf.cd_cpf = cd_cpf)
47. 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)
48. 1.170 1.848 ↑ 1.0 1,983 1

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

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

50. 40.000 40.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.040..0.040 rows=0 loops=1,000)

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

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

  • Index Cond: (pf.cd_cpf = cd_cpf)
53. 20.000 20.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.020..0.020 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
54. 37.000 37.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.037..0.037 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
55. 87.000 87.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.087..0.087 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
56. 0.034 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
57. 0.015 0.015 ↑ 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.015 rows=36 loops=1)

58. 0.703 0.999 ↑ 1.0 457 1

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

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

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

60. 2.024 3.338 ↓ 1.2 2,852 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 735kB
61. 1.314 1.314 ↓ 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.012..1.314 rows=2,852 loops=1)

62. 0.935 1.589 ↓ 1.0 850 1

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

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

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

64. 0.805 1.310 ↓ 1.4 740 1

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

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

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

66. 17.000 17.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.017..0.017 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
67. 52.000 52.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.052..0.052 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
  • Heap Fetches: 0
68. 15.000 15.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.015..0.015 rows=0 loops=1,000)

  • Index Cond: (cd_cpf_socio = pf.cd_cpf)
69. 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
70. 59.000 59.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.059..0.059 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
71. 493.000 493.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.492..0.493 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
72. 65.000 65.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.065..0.065 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
73. 15.000 15.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.015..0.015 rows=0 loops=1,000)

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

  • Index Cond: (cd_cpf = pf.cd_cpf)
75. 117.000 117.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.114..0.117 rows=1 loops=1,000)

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

SubPlan (forNested Loop Left Join)

77. 12.000 12.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.011..0.012 rows=1 loops=1,000)

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

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

  • Filter: (cd_raca = (pf.cd_raca)::bpchar)
  • Rows Removed by Filter: 5
79. 7.000 7.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.006..0.007 rows=1 loops=1,000)

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

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

81. 328.000 328.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=0.328..0.328 rows=0 loops=1,000)

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

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

83. 139.000 139.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.132..0.139 rows=0 loops=1,000)

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

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

  • Group Key: p.cd_cpf
85. 44.000 44.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.044..0.044 rows=0 loops=1,000)

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

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

  • Group Key: totalizadores_processos.cpf
87. 189.000 189.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.113..0.189 rows=2 loops=1,000)

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

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

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

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

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

  • Group Key: pessoa_ibama_embargos.cd_cpf
91. 32.000 32.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.032..0.032 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
92. 27.000 9,776.000 ↓ 0.0 0 1,000

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

  • Group Key: r_1.cd_cpf
93. 10.724 9,749.000 ↑ 438.0 1 1,000

Nested Loop (cost=1.14..1,717.43 rows=438 width=54) (actual time=2.491..9.749 rows=1 loops=1,000)

94. 2,422.000 2,422.000 ↑ 438.0 1 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.522..2.422 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
95. 7,316.276 7,316.276 ↑ 1.0 1 1,294

Index Scan using pessoa_fisica_kruger_cd_cpf_idx on pessoa_fisica pff (cost=0.57..2.79 rows=1 width=37) (actual time=5.619..5.654 rows=1 loops=1,294)

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

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

  • Group Key: r_2.cd_cpf
97. 33.000 33.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.033..0.033 rows=0 loops=1,000)

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

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

  • Group Key: c.cfocdcpfprofissional
99. 57.000 57.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.057..0.057 rows=0 loops=1,000)

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

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

  • Group Key: m.cpf
101. 64.000 64.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.055..0.064 rows=0 loops=1,000)

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

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

  • Group Key: m_1.cpf
103. 2.072 30.000 ↓ 0.0 0 1,000

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

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

  • Index Cond: (cpf = pf.cd_cpf)
105. 15.928 15.928 ↓ 0.0 0 8

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

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

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

  • Group Key: m_2.cpf
107. 2.592 22.000 ↓ 0.0 0 1,000

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

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

  • Index Cond: (cpf = pf.cd_cpf)
109. 5.408 5.408 ↓ 0.0 0 8

Index Scan using idxmedicosenderecoid on "medicosEndereco" me_1 (cost=0.42..2.64 rows=1 width=105) (actual time=0.675..0.676 rows=0 loops=8)

  • Index Cond: ((id)::text = m_2.id)
110. 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)

111. 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)
112. 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)

113. 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)
114. 3.000 34.000 ↑ 1.0 1 1,000

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

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

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

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

117. 32.000 32.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.032..0.032 rows=0 loops=1,000)

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

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

119. 718.000 718.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.591..0.718 rows=0 loops=1,000)

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

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

121. 175.000 175.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.175..0.175 rows=0 loops=1,000)

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

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

123. 93.000 93.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.093..0.093 rows=0 loops=1,000)

  • Index Cond: (((pf.cd_cpf)::character varying(11))::bpchar = cd_cpf)
124. 47.000 8,088.000 ↑ 1.0 1 1,000

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

125. 4.296 8,041.000 ↓ 0.0 0 1,000

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

126. 5.418 6,331.000 ↓ 0.0 0 1,000

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

127. 3.470 5,974.000 ↓ 0.0 0 1,000

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

128. 4.912 5,363.000 ↓ 0.0 0 1,000

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

129. 5.404 5,347.000 ↓ 0.0 0 1,000

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

130. 4.814 3,975.000 ↓ 0.0 0 1,000

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

131. 7.890 3,784.000 ↓ 0.0 0 1,000

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

132. 1,475.000 1,475.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=1.232..1.475 rows=0 loops=1,000)

  • Index Cond: ((cd_doc_socio)::text = (pf.cd_cpf)::text)
  • Filter: (length((cd_doc_socio)::text) = 11)
133. 2,301.110 2,301.110 ↑ 1.0 1 463

Index Scan using empresa_cd_cnpj_idx on empresa e_2 (cost=0.56..2.78 rows=1 width=126) (actual time=4.934..4.970 rows=1 loops=463)

  • Index Cond: (cd_cnpj = (s_2.cd_cnpj_empresa)::bpchar)
134. 186.186 186.186 ↓ 0.0 0 462

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.403..0.403 rows=0 loops=462)

  • Index Cond: (cd_cnpj = e_2.cd_cnpj)
135. 1,366.596 1,366.596 ↑ 1.0 1 462

Index Scan using cnae_principal_etl_pkey on cnae_principal c_2 (cost=0.56..0.61 rows=1 width=78) (actual time=2.024..2.958 rows=1 loops=462)

  • Index Cond: (cd_cnpj = e_2.cd_cnpj)
136. 11.088 11.088 ↓ 0.0 0 462

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.024..0.024 rows=0 loops=462)

  • Index Cond: (cd_cnpj = e_2.cd_cnpj)
  • Heap Fetches: 0
137. 607.530 607.530 ↑ 1.0 1 462

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=1.314..1.315 rows=1 loops=462)

  • Index Cond: (e_2.cd_cnpj = cd_cnpj)
138. 351.582 351.582 ↑ 1.0 1 462

Index Scan using junta_comercial_pkey on junta_comercial cs (cost=0.56..0.59 rows=1 width=20) (actual time=0.759..0.761 rows=1 loops=462)

  • Index Cond: (e_2.cd_cnpj = cd_cnpj)
139. 1,705.704 1,705.704 ↑ 1.0 1 462

Index Scan using faturamento_presumido_cd_cnpj_idx2 on faturamento_presumido fp (cost=0.56..0.65 rows=1 width=75) (actual time=3.629..3.692 rows=1 loops=462)

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

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

141. 2.101 741.000 ↓ 0.0 0 1,000

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

142. 3.900 677.000 ↓ 0.0 0 1,000

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

143. 1.733 659.000 ↓ 0.0 0 1,000

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

144. 2.885 645.000 ↓ 0.0 0 1,000

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

145. 2.336 640.000 ↓ 0.0 0 1,000

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

146. 1.783 623.000 ↓ 0.0 0 1,000

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

147. 6.830 616.000 ↓ 0.0 0 1,000

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

148. 557.000 557.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.494..0.557 rows=0 loops=1,000)

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

Index Scan using empresa_cd_cnpj_idx on empresa e_3 (cost=0.56..2.78 rows=1 width=126) (actual time=0.328..0.370 rows=1 loops=141)

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

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.037..0.037 rows=0 loops=141)

  • Index Cond: (cd_cnpj = e_3.cd_cnpj)
151. 14.664 14.664 ↑ 1.0 1 141

Index Scan using cnae_principal_etl_pkey on cnae_principal c_3 (cost=0.56..0.61 rows=1 width=78) (actual time=0.092..0.104 rows=1 loops=141)

  • Index Cond: (cd_cnpj = e_3.cd_cnpj)
152. 2.115 2.115 ↓ 0.0 0 141

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=141)

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

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.086..0.087 rows=1 loops=141)

  • Index Cond: (e_3.cd_cnpj = cd_cnpj)
154. 14.100 14.100 ↑ 1.0 1 141

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

  • Index Cond: (e_3.cd_cnpj = cd_cnpj)
155. 61.899 61.899 ↑ 1.0 1 141

Index Scan using faturamento_presumido_cd_cnpj_idx2 on faturamento_presumido fp_1 (cost=0.56..0.65 rows=1 width=75) (actual time=0.438..0.439 rows=1 loops=141)

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

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

157. 3.068 1,857.000 ↓ 0.0 0 1,000

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

158. 4.216 1,831.000 ↓ 0.0 0 1,000

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

159. 4.748 1,809.000 ↓ 0.0 0 1,000

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

160. 3.236 1,786.000 ↓ 0.0 0 1,000

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

161. 9.452 1,772.000 ↓ 0.0 0 1,000

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

162. 3.704 1,734.000 ↓ 0.0 0 1,000

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

163. 7.658 1,720.000 ↓ 0.0 0 1,000

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

164. 1,657.000 1,657.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=1.283..1.657 rows=0 loops=1,000)

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

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

  • Index Cond: (cd_cnpj = s_4.cd_cnpj)
166. 10.296 10.296 ↓ 0.0 0 468

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.022..0.022 rows=0 loops=468)

  • Index Cond: (cd_cnpj = e_4.cd_cnpj)
167. 28.548 28.548 ↑ 1.0 1 468

Index Scan using cnae_principal_etl_pkey on cnae_principal c_4 (cost=0.56..0.61 rows=1 width=78) (actual time=0.056..0.061 rows=1 loops=468)

  • Index Cond: (cd_cnpj = e_4.cd_cnpj)
168. 10.764 10.764 ↓ 0.0 0 468

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.023..0.023 rows=0 loops=468)

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

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.039..0.039 rows=1 loops=468)

  • Index Cond: (e_4.cd_cnpj = cd_cnpj)
170. 17.784 17.784 ↑ 1.0 1 468

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

  • Index Cond: (e_4.cd_cnpj = cd_cnpj)
171. 22.932 22.932 ↑ 1.0 1 468

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.049..0.049 rows=1 loops=468)

  • Index Cond: (e_4.cd_cnpj = cd_cnpj)
172. 62.000 8,301.000 ↑ 1.0 1 1,000

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

173. 8,239.000 8,239.000 ↑ 2.0 2 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=2.971..8.239 rows=2 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
174. 75.000 9,058.000 ↑ 1.0 1 1,000

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

175. 8,983.000 8,983.000 ↑ 6.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..15.08 rows=12 width=174) (actual time=2.495..8.983 rows=2 loops=1,000)

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

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

177. 3.000 152.000 ↓ 0.0 0 1,000

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

178. 149.000 149.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.148..0.149 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
179. 16.000 3,850.000 ↑ 1.0 1 1,000

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

180. 3,834.000 3,834.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.275..3.834 rows=1 loops=1,000)

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

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

182. 19.000 19.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.019..0.019 rows=0 loops=1,000)

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

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

  • Group Key: imovel.cd_cpf
184. 121.000 121.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.097..0.121 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
185. 54.000 2,367.000 ↓ 0.0 0 1,000

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

  • Group Key: veiculo.cd_cpf
186. 6.984 2,313.000 ↓ 0.0 0 1,000

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

187. 2,278.000 2,278.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=1.770..2.278 rows=0 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
188. 28.016 28.016 ↓ 0.0 0 412

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=0.068..0.068 rows=0 loops=412)

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

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

  • Group Key: veiculo_1.cd_cpf
190. 1.880 23.000 ↓ 0.0 0 1,000

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

191. 21.000 21.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.021..0.021 rows=0 loops=1,000)

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

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.020..0.020 rows=0 loops=6)

  • 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
193. 34.000 954.000 ↑ 1.0 1 1,000

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

194. 920.000 920.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.362..0.920 rows=1 loops=1,000)

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

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

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

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

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

198. 84.000 84.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.084..0.084 rows=0 loops=1,000)

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

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

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

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

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

202. 57.000 57.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.050..0.057 rows=0 loops=1,000)

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

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

  • Group Key: afastamento_pf.cd_cpf
204. 271.000 271.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.157..0.271 rows=0 loops=1,000)

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

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

206. 3.000 48.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.048..0.048 rows=0 loops=1,000)

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

BitmapOr (cost=2.82..2.82 rows=6 width=0) (actual time=0.045..0.045 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. 18.000 18.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.018..0.018 rows=0 loops=1,000)

  • Index Cond: (pf.cd_cpf = cd_cpf_oper)
210. 25.000 3,064.000 ↑ 1.0 1 1,000

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

211. 3,039.000 3,039.000 ↑ 1,426.0 1 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=2.162..3.039 rows=1 loops=1,000)

  • Index Cond: (cd_cpf = pf.cd_cpf)
Planning time : 2,055.982 ms
Execution time : 56,794.717 ms