explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IkBn

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 5.536 53.852 ↓ 1.0 7,066 1

Hash Right Join (cost=2,537.89..7,725.63 rows=7,064 width=1,055) (actual time=8.282..53.852 rows=7,066 loops=1)

  • Hash Cond: ((cnc.cnc_clave_acceso)::text = (fec.ccm_clave_acceso)::text)
2. 24.112 42.983 ↑ 1.0 5,275 1

Hash Right Join (cost=300.25..5,460.91 rows=5,275 width=781) (actual time=2.907..42.983 rows=5,275 loops=1)

  • Hash Cond: ((ccm.pve_id = cnc.pve_id) AND (ccm.ccm_periodo = cnc.cnc_periodo) AND (ccm.cti_id = cnc.cti_id) AND (ccm.ccm_numero = cnc.cnc_numero))
3. 16.045 16.045 ↓ 1.0 87,650 1

Seq Scan on ccomproba ccm (cost=0.00..2,075.47 rows=87,647 width=73) (actual time=0.017..16.045 rows=87,650 loops=1)

4. 1.529 2.826 ↑ 1.0 5,275 1

Hash (cost=194.75..194.75 rows=5,275 width=708) (actual time=2.826..2.826 rows=5,275 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 1182kB
5. 1.297 1.297 ↑ 1.0 5,275 1

Seq Scan on cnotacre cnc (cost=0.00..194.75 rows=5,275 width=708) (actual time=0.029..1.297 rows=5,275 loops=1)

6. 2.491 5.333 ↓ 1.0 7,066 1

Hash (cost=2,149.34..2,149.34 rows=7,064 width=274) (actual time=5.333..5.333 rows=7,066 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 2220kB
7. 2.057 2.842 ↓ 1.0 7,066 1

Bitmap Heap Scan on fe_comprobante fec (cost=135.04..2,149.34 rows=7,064 width=274) (actual time=0.903..2.842 rows=7,066 loops=1)

  • Recheck Cond: ((ccm_documento)::text = 'NCC'::text)
  • Heap Blocks: exact=992
8. 0.785 0.785 ↓ 1.0 7,066 1

Bitmap Index Scan on idx_fe_comprobante_ccm_documento (cost=0.00..133.27 rows=7,064 width=0) (actual time=0.785..0.785 rows=7,066 loops=1)

  • Index Cond: ((ccm_documento)::text = 'NCC'::text)