explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 4.933 277.855 ↓ 20.9 5,141 1

Nested Loop (cost=396.73..3,642.55 rows=246 width=1,055) (actual time=4.135..277.855 rows=5,141 loops=1)

2. 9.073 15.872 ↓ 7.0 5,141 1

Hash Join (cost=396.31..2,445.73 rows=739 width=982) (actual time=3.802..15.872 rows=5,141 loops=1)

  • Hash Cond: ((fec.ccm_clave_acceso)::text = (cnc.cnc_clave_acceso)::text)
3. 3.169 3.846 ↑ 1.0 7,066 1

Bitmap Heap Scan on fe_comprobante fec (cost=135.63..2,150.88 rows=7,140 width=274) (actual time=0.819..3.846 rows=7,066 loops=1)

  • Recheck Cond: ((ccm_documento)::text = 'NCC'::text)
  • Heap Blocks: exact=992
4. 0.677 0.677 ↑ 1.0 7,066 1

Bitmap Index Scan on idx_fe_comprobante_ccm_documento (cost=0.00..133.84 rows=7,140 width=0) (actual time=0.677..0.677 rows=7,066 loops=1)

  • Index Cond: ((ccm_documento)::text = 'NCC'::text)
5. 1.858 2.953 ↑ 1.0 5,152 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 1160kB
6. 1.095 1.095 ↑ 1.0 5,275 1

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

7. 257.050 257.050 ↑ 1.0 1 5,141

Index Scan using ccomproba_uk_llave on ccomproba ccm (cost=0.42..1.61 rows=1 width=73) (actual time=0.050..0.050 rows=1 loops=5,141)

  • Index Cond: ((ccm_periodo = cnc.cnc_periodo) AND (cti_id = cnc.cti_id) AND (pve_id = cnc.pve_id) AND (ccm_numero = cnc.cnc_numero))