explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bgbs

Settings
# exclusive inclusive rows x rows loops node
1. 5,227.345 147,845.905 ↓ 0.0 0 1

Seq Scan on conrec_movimento mov (cost=0.00..90,493,021.33 rows=1,771,006 width=123) (actual time=147,845.905..147,845.905 rows=0 loops=1)

  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 3565464
2.          

SubPlan (forSeq Scan)

3. 0.000 142,618.560 ↓ 0.0 0 3,565,464

Nested Loop (cost=1.42..25.52 rows=1 width=0) (actual time=0.040..0.040 rows=0 loops=3,565,464)

4. 7,132.048 142,618.560 ↓ 0.0 0 3,565,464

Nested Loop (cost=0.99..17.05 rows=1 width=0) (actual time=0.040..0.040 rows=0 loops=3,565,464)

5. 64,178.352 64,178.352 ↑ 1.0 1 3,565,464

Index Scan using processojavacr_idx1 on global_e_processojavacr projavcr (cost=0.43..8.46 rows=1 width=21) (actual time=0.017..0.018 rows=1 loops=3,565,464)

  • Index Cond: ((cdfilialcr = mov.cdfilial) AND (cdtipodoc = mov.cdtipodoc) AND (nrtitulo = mov.nrtitulo) AND (parcela = mov.parcela))
  • Filter: (chseqmov = mov.chmovimentosb)
  • Rows Removed by Filter: 1
6. 71,308.160 71,308.160 ↓ 0.0 0 3,565,408

Index Scan using pk_global_e_processojava on global_e_processojava projav (cost=0.56..8.58 rows=1 width=21) (actual time=0.020..0.020 rows=0 loops=3,565,408)

  • Index Cond: ((cdempresa = projavcr.cdempresa) AND (cdfilial = projavcr.cdfilial) AND (seqprocesso = projavcr.seqprocesso))
  • Filter: (idsituacao = 'E'::bpchar)
  • Rows Removed by Filter: 1
7. 160.194 160.194 ↓ 0.0 0 53,398

Index Scan using conrec_titulocr_idx1 on conrec_titulocr titcr (cost=0.43..8.46 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=53,398)

  • Index Cond: (idtransmite = 'Z'::bpchar)
  • Filter: ((cdfilial = mov.cdfilial) AND (cdtipodoc = mov.cdtipodoc) AND (nrtitulo = mov.nrtitulo) AND (parcela = mov.parcela))