explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3ObS : teste sei

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

Hash Join (cost=962.41..4,200,782.18 rows=8,725,052 width=1,127) (actual rows= loops=)

  • Hash Cond: (judicialconsultation.aspr_seq_chave = aspr.aspr_seq_chave)
2. 0.000 0.000 ↓ 0.0

Index Scan using ix_jf_prju_pedi_referencia on jf_prju_processo_judicial judicialconsultation (cost=0.57..4,079,850.88 rows=8,725,052 width=134) (actual rows= loops=)

  • Index Cond: (pedi_seq_chave_referencia = 44676)
3. 0.000 0.000 ↓ 0.0

Hash (cost=804.15..804.15 rows=12,615 width=993) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on jd_aspr_assunto_processual aspr (cost=0.00..804.15 rows=12,615 width=993) (actual rows= loops=)