explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yiPv

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 885.457 ↑ 1.0 1 1

Aggregate (cost=526,613.37..526,613.38 rows=1 width=8) (actual time=885.457..885.457 rows=1 loops=1)

2. 21.315 901.368 ↑ 2.0 1 1

Gather (cost=81,549.10..526,613.37 rows=2 width=0) (actual time=563.823..901.368 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.000 880.053 ↓ 0.0 0 3

Nested Loop (cost=80,549.10..525,613.17 rows=1 width=0) (actual time=773.143..880.053 rows=0 loops=3)

4. 0.000 880.046 ↓ 0.0 0 3

Nested Loop (cost=80,548.54..525,607.62 rows=1 width=15) (actual time=773.136..880.046 rows=0 loops=3)

5. 0.000 880.038 ↓ 0.0 0 3

Nested Loop (cost=80,547.98..525,599.02 rows=1 width=15) (actual time=773.129..880.038 rows=0 loops=3)

6. 449.013 880.023 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on cuenta_corriente nota (cost=80,547.55..525,590.57 rows=1 width=21) (actual time=773.115..880.023 rows=0 loops=3)

  • Recheck Cond: (cte_nrutoperador = '76783560'::numeric)
  • Filter: ((cte_niddocto = '1700000600'::numeric) AND ((cte_scodtipodocto)::text = 'NOCRE'::text))
  • Rows Removed by Filter: 1009889
  • Heap Blocks: exact=61872
7. 431.010 431.010 ↓ 1.0 3,029,678 1

Bitmap Index Scan on idx_consulta_cta_cte (cost=0.00..80,547.55 rows=2,947,065 width=0) (actual time=431.010..431.010 rows=3,029,678 loops=1)

  • Index Cond: (cte_nrutoperador = '76783560'::numeric)
8. 0.030 0.030 ↑ 1.0 1 1

Index Only Scan using pk_nota_credito on nota_credito (cost=0.43..8.45 rows=1 width=15) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((ncr_nidnotacredito = '1700000600'::numeric) AND (ncr_nrutoperador = '76783560'::numeric))
  • Heap Fetches: 1
9. 0.018 0.018 ↑ 1.0 1 1

Index Scan using idx_detalle_abono_cte_abono on detalle_abono_cte (cost=0.56..8.58 rows=1 width=23) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: ((dab_nidoperacionabono = nota.cte_nidoperacion) AND (dab_nrutoperador = '76783560'::numeric))
10. 0.016 0.016 ↑ 1.0 1 1

Index Only Scan using pk_cuenta_corriente on cuenta_corriente pago (cost=0.56..5.55 rows=1 width=15) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((cte_nidoperacion = detalle_abono_cte.dab_nidoperacioncargo) AND (cte_nrutoperador = '76783560'::numeric))
  • Heap Fetches: 1