explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sx9q : teste sei

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

Sort (cost=38.81..38.82 rows=1 width=1,109) (actual rows= loops=)

  • Sort Key: aspr.aspr_dsc_assunto_extend_n06, pdmv.pedi_bsq_chave, pddt.pedi_bsq_chave, proc.proc_dsc_processo_formatado
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.43..38.80 rows=1 width=1,109) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.14..36.29 rows=1 width=1,029) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.00..33.92 rows=1 width=1,011) (actual rows= loops=)

  • Join Filter: (judicialconsultation.sior_seq_chave = sior.sior_seq_chave)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.00..32.81 rows=1 width=933) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.57..30.15 rows=1 width=718) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.28..27.63 rows=1 width=664) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.99..25.11 rows=1 width=664) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.70..22.59 rows=1 width=664) (actual rows= loops=)

  • Join Filter: (judicialconsultation.esor_seq_chave_orgao_julgador = eooj.esor_seq_chave)
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.42..20.08 rows=1 width=668) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.14..17.57 rows=1 width=543) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.85..15.06 rows=1 width=431) (actual rows= loops=)

  • Join Filter: (judicialconsultation.napr_seq_chave = napr.napr_seq_chave)
13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.85..13.90 rows=1 width=353) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.43..11.25 rows=1 width=293) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.14..8.74 rows=1 width=205) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..6.22 rows=1 width=124) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Index Scan using ix_jf_prju_pedi_ref_proc on jf_prju_processo_judicial judicialconsultation (cost=0.57..3.71 rows=1 width=54) (actual rows= loops=)

  • Index Cond: (pedi_seq_chave_referencia = 44686)
  • Filter: (prju_qtd_expediente_mes > 0)
18. 0.000 0.000 ↓ 0.0

Index Scan using pk_jd_aspr on jd_aspr_assunto_processual aspr (cost=0.29..2.50 rows=1 width=78) (actual rows= loops=)

  • Index Cond: (aspr_seq_chave = judicialconsultation.aspr_seq_chave)
19. 0.000 0.000 ↓ 0.0

Index Scan using pk_jd_clpr on jd_clpr_classe_processual clpr (cost=0.29..2.51 rows=1 width=89) (actual rows= loops=)

  • Index Cond: (clpr_seq_chave = judicialconsultation.clpr_seq_chave)
20. 0.000 0.000 ↓ 0.0

Index Scan using ix_jb_prff_flfp on jd_flfp_fluxo_fila_processo flfp (cost=0.29..2.50 rows=1 width=96) (actual rows= loops=)

  • Index Cond: (flfp_seq_chave = judicialconsultation.flfp_seq_chave)
21. 0.000 0.000 ↓ 0.0

Index Scan using pk_jd_lopr on jd_lopr_localizacao_processo lopr (cost=0.42..2.64 rows=1 width=68) (actual rows= loops=)

  • Index Cond: (lopr_seq_chave = judicialconsultation.lopr_seq_chave)
22. 0.000 0.000 ↓ 0.0

Seq Scan on jd_napr_natureza_processo napr (cost=0.00..1.07 rows=7 width=80) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Index Scan using pk_cd_cola on cd_cola_colaborador cola (cost=0.29..2.51 rows=1 width=120) (actual rows= loops=)

  • Index Cond: (cola_seq_chave = judicialconsultation.cola_seq_chave_magistrado)
24. 0.000 0.000 ↓ 0.0

Index Scan using pk_cd_esor on cd_esor_estrutura_organizacion eogb (cost=0.28..2.50 rows=1 width=133) (actual rows= loops=)

  • Index Cond: (esor_seq_chave = judicialconsultation.esor_seq_chave_gabinete)
25. 0.000 0.000 ↓ 0.0

Index Scan using ix_cd_esor on cd_esor_estrutura_organizacion eooj (cost=0.28..2.50 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (esor_bsq_chave_n08 = 2370)
26. 0.000 0.000 ↓ 0.0

Index Scan using pk_cd_pedi on cd_pedi_periodo_diario pddt (cost=0.29..2.51 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (pedi_seq_chave = judicialconsultation.pedi_seq_chave_distribuicao)
27. 0.000 0.000 ↓ 0.0

Index Scan using pk_cd_pedi on cd_pedi_periodo_diario pdmv (cost=0.29..2.51 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (pedi_seq_chave = judicialconsultation.pedi_seq_chave_movimentacao)
28. 0.000 0.000 ↓ 0.0

Index Scan using pk_cd_pedi on cd_pedi_periodo_diario pdrf (cost=0.29..2.51 rows=1 width=62) (actual rows= loops=)

  • Index Cond: (pedi_seq_chave = 44686)
29. 0.000 0.000 ↓ 0.0

Index Scan using pk_jd_proc on jd_proc_processo proc (cost=0.43..2.65 rows=1 width=219) (actual rows= loops=)

  • Index Cond: (proc_seq_chave = judicialconsultation.proc_seq_chave)
30. 0.000 0.000 ↓ 0.0

Seq Scan on cd_sior_sistema_origem sior (cost=0.00..1.05 rows=5 width=82) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Index Scan using pk_jd_sipr on jd_sipr_situacao_processo sipr (cost=0.14..2.36 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (sipr_seq_chave = judicialconsultation.sipr_seq_chave)
32. 0.000 0.000 ↓ 0.0

Index Scan using pk_jd_timo on jd_timo_tipo_movimento timo (cost=0.29..2.51 rows=1 width=88) (actual rows= loops=)

  • Index Cond: (timo_seq_chave = judicialconsultation.timo_seq_chave)