explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PPfC

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=319,000.79..368,189.61 rows=1 width=1,367) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=319,000.51..368,189.31 rows=1 width=1,316) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=319,000.36..368,189.15 rows=1 width=1,294) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=319,000.23..368,189.00 rows=1 width=1,278) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=319,000.10..368,188.84 rows=1 width=1,264) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=318,999.96..368,188.69 rows=1 width=1,241) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=318,999.54..368,187.96 rows=1 width=1,036) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=318,999.11..368,187.32 rows=1 width=1,034) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=318,998.68..368,186.64 rows=1 width=1,015) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=318,998.26..368,185.66 rows=1 width=903) (actual rows= loops=)

  • Join Filter: ((pessoadocu1_.id_estado_expedidor)::integer = (estado7_.id_estado)::integer)
11. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=318,998.26..368,184.06 rows=1 width=885) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=318,997.97..368,183.75 rows=1 width=796) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Gather (cost=318,997.70..368,183.45 rows=1 width=778) (actual rows= loops=)

  • Workers Planned: 2
14. 0.000 0.000 ↓ 0.0

Hash Join (cost=317,997.70..367,183.35 rows=1 width=778) (actual rows= loops=)

  • Hash Cond: ((this_.id_pessoa)::integer = (pessoadocu1_.id_pessoa)::integer)
15. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=257,006.68..303,767.80 rows=646,540 width=556) (actual rows= loops=)

  • Hash Cond: ((usuarioloc4_.id_usuario_localizacao)::integer = (usuarioloc4_1_.id_pessoa_assit_adv_local)::integer)
16. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=256,986.82..302,050.76 rows=646,540 width=542) (actual rows= loops=)

  • Hash Cond: ((this_2_.id_usuario_localizacao_inicial)::integer = (usuarioloc4_.id_usuario_localizacao)::integer)
17. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=210,125.29..253,492.06 rows=646,540 width=521) (actual rows= loops=)

  • Hash Cond: ((this_.id_pessoa)::integer = (this_5_.id_pessoa_juridica)::integer)
18. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=204,224.67..245,894.28 rows=646,540 width=409) (actual rows= loops=)

  • Hash Cond: ((this_.id_pessoa)::integer = (this_4_.id_pessoa_fisica)::integer)
19. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=149,677.51..189,649.95 rows=646,540 width=242) (actual rows= loops=)

  • Hash Cond: ((this_.id_pessoa)::integer = (this_3_.id_pessoa_autoridade)::integer)
20. 0.000 0.000 ↓ 0.0

Hash Join (cost=149,552.00..187,827.27 rows=646,540 width=234) (actual rows= loops=)

  • Hash Cond: ((this_.id_pessoa)::integer = this_2_.id_usuario)
21. 0.000 0.000 ↓ 0.0

Hash Join (cost=70,338.14..106,916.24 rows=646,540 width=25) (actual rows= loops=)

  • Hash Cond: ((this_1_.id_usuario)::integer = (this_.id_pessoa)::integer)
22. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on tb_usuario this_1_ (cost=0.00..34,877.71 rows=647,771 width=6) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Hash (cost=50,941.95..50,941.95 rows=1,551,695 width=19) (actual rows= loops=)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 102,762kB
24. 0.000 0.000 ↓ 0.0

Seq Scan on tb_pessoa this_ (cost=0.00..50,941.95 rows=1,551,695 width=19) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Hash (cost=59,821.16..59,821.16 rows=1,551,416 width=209) (actual rows= loops=)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 282,251kB
26. 0.000 0.000 ↓ 0.0

Seq Scan on tb_usuario_login this_2_ (cost=0.00..59,821.16 rows=1,551,416 width=209) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Hash (cost=67.45..67.45 rows=4,645 width=8) (actual rows= loops=)

  • Buckets: 8,192 Batches: 1 Memory Usage: 245kB
28. 0.000 0.000 ↓ 0.0

Seq Scan on tb_pessoa_autoridade this_3_ (cost=0.00..67.45 rows=4,645 width=8) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Hash (cost=37,362.07..37,362.07 rows=1,374,807 width=167) (actual rows= loops=)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 147,836kB
30. 0.000 0.000 ↓ 0.0

Seq Scan on tb_pessoa_fisica this_4_ (cost=0.00..37,362.07 rows=1,374,807 width=167) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Hash (cost=3,765.83..3,765.83 rows=170,783 width=112) (actual rows= loops=)

  • Buckets: 262,144 Batches: 1 Memory Usage: 16,519kB
32. 0.000 0.000 ↓ 0.0

Seq Scan on tb_pessoa_juridica this_5_ (cost=0.00..3,765.83 rows=170,783 width=112) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Hash (cost=37,544.57..37,544.57 rows=745,357 width=21) (actual rows= loops=)

  • Buckets: 1,048,576 Batches: 1 Memory Usage: 44,170kB
34. 0.000 0.000 ↓ 0.0

Seq Scan on tb_usuario_localizacao usuarioloc4_ (cost=0.00..37,544.57 rows=745,357 width=21) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Hash (cost=11.05..11.05 rows=705 width=14) (actual rows= loops=)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
36. 0.000 0.000 ↓ 0.0

Seq Scan on tb_pessoa_assist_adv_local usuarioloc4_1_ (cost=0.00..11.05 rows=705 width=14) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Hash (cost=60,991.00..60,991.00 rows=1 width=230) (actual rows= loops=)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
38. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..60,991.00 rows=1 width=230) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Seq Scan on tb_tipo_doc_identificacao tipodocume2_ (cost=0.00..1.20 rows=2 width=45) (actual rows= loops=)

  • Filter: (cd_tp_documento_identificacao = ANY ('{CPF,CPJ}'::bpchar[]))
40. 0.000 0.000 ↓ 0.0

Index Scan using idx_tb_pessoa_doc_identificacao1 on tb_pess_doc_identificacao pessoadocu1_ (cost=0.43..30,494.89 rows=1 width=185) (actual rows= loops=)

  • Index Cond: (cd_tp_documento_identificacao = tipodocume2_.cd_tp_documento_identificacao)
  • Filter: (in_ativo AND (NOT in_usado_falsamente) AND (((nr_documento_identificacao)::text = '34498591100'::text) OR ((nr_documento_identificacao)::text = '344.985.911-00'::text)))
41. 0.000 0.000 ↓ 0.0

Index Scan using tb_pessoa_assist_proc_local_pkey on tb_pess_assist_proc_local usuarioloc4_2_ (cost=0.28..0.30 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((usuarioloc4_.id_usuario_localizacao)::integer = (id_pessoa_assist_proc_local)::integer)
42. 0.000 0.000 ↓ 0.0

Index Scan using tb_usuario_localizacao_magistrado_servidor_pkey on tb_usu_local_mgtdo_servdor usuarioloc5_ (cost=0.29..0.31 rows=1 width=89) (actual rows= loops=)

  • Index Cond: ((usuarioloc4_.id_usuario_localizacao)::integer = (id_usu_local_mgstrado_servidor)::integer)
43. 0.000 0.000 ↓ 0.0

Seq Scan on tb_estado estado7_ (cost=0.00..1.27 rows=27 width=18) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Index Scan using tb_pessoa_juridica_pkey on tb_pessoa_juridica pessoajuri9_ (cost=0.42..0.98 rows=1 width=112) (actual rows= loops=)

  • Index Cond: ((this_3_.id_orgao_vinculacao)::integer = (id_pessoa_juridica)::integer)
45. 0.000 0.000 ↓ 0.0

Index Scan using tb_pessoa_pkey on tb_pessoa pessoajuri9_1_ (cost=0.43..0.68 rows=1 width=19) (actual rows= loops=)

  • Index Cond: ((pessoajuri9_.id_pessoa_juridica)::integer = (id_pessoa)::integer)
46. 0.000 0.000 ↓ 0.0

Index Scan using tb_usuario_pkey on tb_usuario pessoajuri9_2_ (cost=0.43..0.64 rows=1 width=6) (actual rows= loops=)

  • Index Cond: ((pessoajuri9_.id_pessoa_juridica)::integer = (id_usuario)::integer)
47. 0.000 0.000 ↓ 0.0

Index Scan using tb_usuario_pkey on tb_usuario_login pessoajuri9_3_ (cost=0.43..0.73 rows=1 width=209) (actual rows= loops=)

  • Index Cond: ((pessoajuri9_.id_pessoa_juridica)::integer = id_usuario)
48. 0.000 0.000 ↓ 0.0

Index Scan using tb_escolaridade_pkey on tb_escolaridade escolarida10_ (cost=0.13..0.15 rows=1 width=23) (actual rows= loops=)

  • Index Cond: ((this_4_.id_escolaridade)::integer = (id_escolaridade)::integer)
49. 0.000 0.000 ↓ 0.0

Index Scan using tb_estado_civil_pkey on tb_estado_civil estadocivi11_ (cost=0.13..0.15 rows=1 width=14) (actual rows= loops=)

  • Index Cond: ((this_4_.id_estado_civil)::integer = (id_estado_civil)::integer)
50. 0.000 0.000 ↓ 0.0

Index Scan using tb_etnia_pkey on tb_etnia etnia12_ (cost=0.13..0.15 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((this_4_.id_etnia)::integer = (id_etnia)::integer)
51. 0.000 0.000 ↓ 0.0

Index Scan using tb_pais_pkey on tb_pais pais13_ (cost=0.14..0.16 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (this_4_.id_pais = id_pais)
52. 0.000 0.000 ↓ 0.0

Index Scan using tb_profissao_pkey on tb_profissao profissao14_ (cost=0.28..0.30 rows=1 width=47) (actual rows= loops=)

  • Index Cond: ((this_4_.id_profissao)::integer = (id_profissao)::integer)