explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ENIM : Optimization for: plan #3dIC

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 0.071 ↑ 1.0 1 1

Aggregate (cost=7,559.81..7,559.82 rows=1 width=8) (actual time=0.071..0.071 rows=1 loops=1)

2. 0.000 0.068 ↓ 0.0 0 1

Nested Loop (cost=0.57..7,559.80 rows=1 width=8) (actual time=0.068..0.068 rows=0 loops=1)

  • Join Filter: (dh21.codn_conce = dh12.codn_conce)
3. 0.006 0.068 ↓ 0.0 0 1

Nested Loop (cost=0.57..7,524.74 rows=32 width=12) (actual time=0.068..0.068 rows=0 loops=1)

  • Join Filter: (dh21.nro_liqui = dh22.nro_liqui)
4. 0.041 0.041 ↓ 7.0 7 1

Seq Scan on dh22 (cost=0.00..3.75 rows=1 width=4) (actual time=0.015..0.041 rows=7 loops=1)

  • Filter: ((date_part('month'::text, (fec_emisi)::timestamp without time zone) = '2'::double precision) AND (date_part('year'::text, (fec_emisi)::timestamp without time zone) = '2019'::double precision))
  • Rows Removed by Filter: 63
5. 0.021 0.021 ↓ 0.0 0 7

Index Scan using ix_dh21_key_nro_legaj_nro_cargo on dh21 (cost=0.57..7,493.17 rows=2,225 width=16) (actual time=0.003..0.003 rows=0 loops=7)

  • Index Cond: (nro_legaj = 21992)
6. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..25.99 rows=19 width=4) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Seq Scan on dh12 (cost=0.00..25.90 rows=19 width=4) (never executed)

  • Filter: (tipo_ganan = 7)
Planning time : 0.423 ms