explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N66

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 30,507.366 ↓ 0.0 0 1

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

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

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

3. 1,323.291 30,507.329 ↓ 0.0 0 1

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

4. 2,171.723 2,171.723 ↓ 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.015..2,171.723 rows=1,800,821 loops=1)

  • Filter: ((cdfilial = cdfilialorigem) AND (seqprocesso = seqprocessoorigem))
  • Rows Removed by Filter: 1867548
5. 27,012.315 27,012.315 ↓ 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.015..0.015 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)
Planning time : 5.571 ms
Execution time : 30,507.564 ms