explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VPo6

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

Sort (cost=3,594,009.22..3,594,009.22 rows=1 width=174) (actual rows= loops=)

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

Nested Loop (cost=2.27..3,594,009.21 rows=1 width=174) (actual rows= loops=)

  • Join Filter: (prju.timo_seq_chave = timo.timo_seq_chave)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.27..3,588,244.80 rows=1 width=163) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.84..3,588,243.09 rows=1 width=135) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.55..3,588,241.55 rows=1 width=135) (actual rows= loops=)

  • Join Filter: (prju.pedi_seq_chave_movimentacao = pdmv.pedi_seq_chave)
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.55..3,585,703.70 rows=1 width=135) (actual rows= loops=)

  • Join Filter: (prju.pedi_seq_chave_distribuicao = pddt.pedi_seq_chave)
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.55..3,583,165.84 rows=1 width=135) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.27..3,583,163.06 rows=1 width=139) (actual rows= loops=)

  • Join Filter: (prju.clpr_seq_chave = clpr.clpr_seq_chave)
9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.27..3,575,858.81 rows=1 width=106) (actual rows= loops=)

  • Join Filter: (prju.aspr_seq_chave = aspr.aspr_seq_chave)
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.27..3,572,054.67 rows=1 width=71) (actual rows= loops=)

  • Join Filter: (prju.cola_seq_chave_magistrado = cola.cola_seq_chave)
11. 0.000 0.000 ↓ 0.0

Index Scan using ix_cd_cola on cd_cola_colaborador cola (cost=0.41..2.63 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (cola_bsq_chave_matricula = '12671'::numeric)
12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..3,572,048.87 rows=254 width=75) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Scan using pk_cd_esor on cd_esor_estrutura_organizacion eooj (cost=0.28..5,825.27 rows=1 width=43) (actual rows= loops=)

  • Filter: (esor_bsq_chave_n08 = 1372)
14. 0.000 0.000 ↓ 0.0

Index Scan using ix_jf_prju_pedi_ref_esor_oj_bak on jf_prju_processo_judicial prju (cost=0.57..3,566,191.56 rows=3,204 width=40) (actual rows= loops=)

  • Index Cond: (esor_seq_chave_orgao_julgador = eooj.esor_seq_chave)
  • Filter: (prju_qtd_processo_novo_mes > 0)
15. 0.000 0.000 ↓ 0.0

Seq Scan on jd_aspr_assunto_processual aspr (cost=0.00..3,744.06 rows=4,806 width=43) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on jd_clpr_classe_processual clpr (cost=0.00..7,107.30 rows=15,756 width=41) (actual rows= loops=)

  • Filter: (clpr_bsq_chave_tipo_acao = 1)
17. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (esor_seq_chave = prju.esor_seq_chave_gabinete)
  • Filter: (esor_bsq_chave_n08 = 24694)
18. 0.000 0.000 ↓ 0.0

Seq Scan on cd_pedi_periodo_diario pddt (cost=0.00..1,847.38 rows=55,238 width=8) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on cd_pedi_periodo_diario pdmv (cost=0.00..1,847.38 rows=55,238 width=8) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Index Scan using ix_pedi_seq_chave on cd_pedi_periodo_diario pdrf (cost=0.29..1.52 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (pedi_seq_chave = prju.pedi_seq_chave_referencia)
  • Filter: (pedi_num_ano = 2019)
21. 0.000 0.000 ↓ 0.0

Index Scan using ix_proc_seq_chave on jd_proc_processo proc (cost=0.43..1.71 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (proc_seq_chave = prju.proc_seq_chave)
22. 0.000 0.000 ↓ 0.0

Seq Scan on jd_timo_tipo_movimento timo (cost=0.00..5,619.73 rows=11,573 width=45) (actual rows= loops=)