explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CIeE : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #IkBn; plan #Ugqm; plan #oIwj; plan #wLUO; plan #Z1Rz; plan #px3m

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 19.825 79.380 ↓ 3.1 5,128 1

Hash Join (cost=5,630.80..8,258.21 rows=1,674 width=1,055) (actual time=52.131..79.380 rows=5,128 loops=1)

  • Hash Cond: ((fec.ccm_clave_acceso)::text = (cnc.cnc_clave_acceso)::text)
2. 7.448 7.448 ↑ 1.0 49,794 1

Seq Scan on fe_comprobante fec (cost=0.00..2,423.94 rows=49,794 width=274) (actual time=0.004..7.448 rows=49,794 loops=1)

3. 6.001 52.107 ↓ 3.0 5,130 1

Hash (cost=5,609.38..5,609.38 rows=1,714 width=781) (actual time=52.107..52.107 rows=5,130 loops=1)

  • Buckets: 8192 (originally 2048) Batches: 1 (originally 1) Memory Usage: 1496kB
4. 22.085 46.106 ↓ 3.1 5,246 1

Hash Join (cost=300.25..5,609.38 rows=1,714 width=781) (actual time=2.984..46.106 rows=5,246 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))
5. 21.106 21.106 ↓ 1.0 85,675 1

Seq Scan on ccomproba ccm (cost=0.00..2,294.59 rows=85,640 width=73) (actual time=0.008..21.106 rows=85,675 loops=1)

  • Filter: (ccm_estado = 2)
  • Rows Removed by Filter: 1975
6. 1.951 2.915 ↑ 1.0 5,275 1

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

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

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