explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h5XI : sei

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

GroupAggregate (cost=19.13..135.11 rows=1 width=144) (actual rows= loops=)

  • Group Key: prju.aspr_seq_chave, prju.clpr_seq_chave, prju.esor_seq_chave_orgao_julgador, prju.pedi_seq_chave_referencia
2. 0.000 0.000 ↓ 0.0

Sort (cost=19.13..19.13 rows=1 width=124) (actual rows= loops=)

  • Sort Key: prju.aspr_seq_chave, prju.clpr_seq_chave, prju.esor_seq_chave_orgao_julgador
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.73..19.12 rows=1 width=124) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.44..16.60 rows=1 width=120) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.15..14.08 rows=1 width=120) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.72..11.42 rows=1 width=60) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.43..8.90 rows=1 width=60) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.14..6.39 rows=1 width=64) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..3.87 rows=1 width=58) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using ix_jf_prju_pedi_referencia on jf_prju_processo_judicial prju (cost=0.57..2.46 rows=1 width=54) (actual rows= loops=)

  • Index Cond: (pedi_seq_chave_referencia = 44683)
  • Filter: (sior_seq_chave <> 4)
11. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_jd_aspr on jd_aspr_assunto_processual aspr (cost=0.28..1.40 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (aspr_seq_chave = prju.aspr_seq_chave)
12. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (clpr_seq_chave = prju.clpr_seq_chave)
13. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (pedi_seq_chave = prju.pedi_seq_chave_distribuicao)
14. 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 = prju.pedi_seq_chave_movimentacao)
15. 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=68) (actual rows= loops=)

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

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

  • Index Cond: (esor_seq_chave = prju.esor_seq_chave_orgao_julgador)
  • Filter: ((esor_bsq_segmento_just_n08 <> ALL ('{1,3}'::integer[])) AND (esor_bsq_tipo_unid_cnj_n08 <= 5))
17. 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=8) (actual rows= loops=)

  • Index Cond: (pedi_seq_chave = 44683)
18.          

SubPlan (for GroupAggregate)

19. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_crsc on tcrsc_criterio_sist_classe tcrsc_criterio_sist_classe_6 (cost=0.28..28.52 rows=40 width=4) (actual rows= loops=)

  • Index Cond: ((crex_seq_chave = 24) AND (sior_seq_chave = prju.sior_seq_chave))
20. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_crsc on tcrsc_criterio_sist_classe tcrsc_criterio_sist_classe_7 (cost=0.28..28.52 rows=40 width=4) (actual rows= loops=)

  • Index Cond: ((crex_seq_chave = 24) AND (sior_seq_chave = prju.sior_seq_chave))
21. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_crsc on tcrsc_criterio_sist_classe tcrsc_criterio_sist_classe_4 (cost=0.28..28.52 rows=40 width=4) (actual rows= loops=)

  • Index Cond: ((crex_seq_chave = 24) AND (sior_seq_chave = prju.sior_seq_chave))
22. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_crsc on tcrsc_criterio_sist_classe tcrsc_criterio_sist_classe_5 (cost=0.28..28.52 rows=40 width=4) (actual rows= loops=)

  • Index Cond: ((crex_seq_chave = 24) AND (sior_seq_chave = prju.sior_seq_chave))
23. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_crsc on tcrsc_criterio_sist_classe tcrsc_criterio_sist_classe_2 (cost=0.28..28.52 rows=40 width=4) (actual rows= loops=)

  • Index Cond: ((crex_seq_chave = 24) AND (sior_seq_chave = prju.sior_seq_chave))
24. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_crsc on tcrsc_criterio_sist_classe tcrsc_criterio_sist_classe_3 (cost=0.28..28.52 rows=40 width=4) (actual rows= loops=)

  • Index Cond: ((crex_seq_chave = 24) AND (sior_seq_chave = prju.sior_seq_chave))
25. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_crsc on tcrsc_criterio_sist_classe (cost=0.28..28.52 rows=40 width=4) (actual rows= loops=)

  • Index Cond: ((crex_seq_chave = 24) AND (sior_seq_chave = prju.sior_seq_chave))
26. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_crsc on tcrsc_criterio_sist_classe tcrsc_criterio_sist_classe_1 (cost=0.28..28.52 rows=40 width=4) (actual rows= loops=)

  • Index Cond: ((crex_seq_chave = 24) AND (sior_seq_chave = prju.sior_seq_chave))