explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 51Nw

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.344 ↑ 1.0 1 1

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

2. 0.049 0.342 ↓ 0.0 0 1

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

  • Join Filter: (dh21.codn_conce = dh12.codn_conce)
  • Rows Removed by Join Filter: 798
3. 0.024 0.125 ↓ 1.3 42 1

Nested Loop (cost=0.57..7,524.74 rows=32 width=12) (actual time=0.053..0.125 rows=42 loops=1)

  • Join Filter: (dh21.nro_liqui = dh22.nro_liqui)
  • Rows Removed by Join Filter: 252
4. 0.038 0.038 ↓ 7.0 7 1

Seq Scan on dh22 (cost=0.00..3.75 rows=1 width=4) (actual time=0.016..0.038 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.063 0.063 ↑ 53.0 42 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.004..0.009 rows=42 loops=7)

  • Index Cond: (nro_legaj = 912)
6. 0.038 0.168 ↑ 1.0 19 42

Materialize (cost=0.00..25.99 rows=19 width=4) (actual time=0.000..0.004 rows=19 loops=42)

7. 0.130 0.130 ↑ 1.0 19 1

Seq Scan on dh12 (cost=0.00..25.90 rows=19 width=4) (actual time=0.013..0.130 rows=19 loops=1)

  • Filter: (tipo_ganan = 7)
  • Rows Removed by Filter: 453
Planning time : 0.365 ms