explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XV2v

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 32,678.503 ↓ 0.0 0 1

Sort (cost=105,532.95..105,532.96 rows=1 width=126) (actual time=32,678.503..32,678.503 rows=0 loops=1)

  • Sort Key: projav.cdempresa, titcr.cdfilial, projav.seqprocesso
  • Sort Method: quicksort Memory: 25kB
2. 0.001 32,678.459 ↓ 0.0 0 1

Nested Loop (cost=0.99..105,532.94 rows=1 width=126) (actual time=32,678.459..32,678.459 rows=0 loops=1)

  • Join Filter: (titcr.cdfilial = projav.cdfilial)
3. 1,506.937 32,678.458 ↓ 0.0 0 1

Nested Loop (cost=0.43..105,524.35 rows=1 width=142) (actual time=32,678.458..32,678.458 rows=0 loops=1)

4. 2,358.385 2,358.385 ↓ 19,789.2 1,800,821 1

Seq Scan on global_e_processojavacr projavcr (cost=0.00..104,753.80 rows=91 width=56) (actual time=0.020..2,358.385 rows=1,800,821 loops=1)

  • Filter: ((cdfilial = cdfilialorigem) AND (seqprocesso = seqprocessoorigem))
  • Rows Removed by Filter: 1867548
5. 28,813.136 28,813.136 ↓ 0.0 0 1,800,821

Index Scan using conrec_titulocr_idx2 on conrec_titulocr titcr (cost=0.43..8.46 rows=1 width=105) (actual time=0.016..0.016 rows=0 loops=1,800,821)

  • Index Cond: ((cdfilial = projavcr.cdfilial) AND (cdtipodoc = projavcr.cdtipodoc) AND (nrtitulo = projavcr.nrtitulo) AND (parcela = projavcr.parcela))
  • Filter: (idtransmite = 'Z'::bpchar)
  • Rows Removed by Filter: 1
6. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_global_e_processojava on global_e_processojava projav (cost=0.56..8.58 rows=1 width=21) (never executed)

  • Index Cond: ((cdempresa = projavcr.cdempresa) AND (cdfilial = projavcr.cdfilial) AND (seqprocesso = projavcr.seqprocesso))
  • Filter: (idsituacao <> 'E'::bpchar)