explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wLUO : Optimization for: Optimization for: Optimization for: plan #IkBn; plan #Ugqm; plan #oIwj

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 16.973 63.231 ↓ 3.0 5,141 1

Hash Join (cost=5,482.83..8,110.63 rows=1,713 width=1,055) (actual time=38.921..63.231 rows=5,141 loops=1)

  • Hash Cond: ((fec.ccm_clave_acceso)::text = (cnc.cnc_clave_acceso)::text)
2. 7.354 7.354 ↑ 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.003..7.354 rows=49,794 loops=1)

3. 4.847 38.904 ↓ 2.9 5,152 1

Hash (cost=5,460.91..5,460.91 rows=1,754 width=781) (actual time=38.904..38.904 rows=5,152 loops=1)

  • Buckets: 8192 (originally 2048) Batches: 1 (originally 1) Memory Usage: 1502kB
4. 22.302 34.057 ↓ 3.0 5,275 1

Hash Join (cost=300.25..5,460.91 rows=1,754 width=781) (actual time=1.811..34.057 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))
5. 9.985 9.985 ↓ 1.0 87,650 1

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

6. 1.271 1.770 ↑ 1.0 5,275 1

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

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

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