explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3dIC

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.018 66,939.490 ↑ 1.0 1 1

Aggregate (cost=1,690.72..1,690.73 rows=1 width=8) (actual time=66,939.486..66,939.490 rows=1 loops=1)

2. 0.057 66,939.472 ↑ 1.0 1 1

Nested Loop (cost=5.27..1,690.72 rows=1 width=8) (actual time=46,588.365..66,939.472 rows=1 loops=1)

  • Join Filter: (dh21.codn_conce = dh12.codn_conce)
  • Rows Removed by Join Filter: 167
3. 0.024 66,938.743 ↑ 1.0 42 1

Merge Join (cost=5.27..1,643.49 rows=44 width=12) (actual time=46,587.629..66,938.743 rows=42 loops=1)

  • Merge Cond: (dh21.nro_liqui = dh22.nro_liqui)
4. 66,938.326 66,938.326 ↑ 66.6 42 1

Index Scan using ix_dh21_key_nro_liqui on dh21 (cost=0.57..4,580,877.69 rows=2,797 width=16) (actual time=46,587.241..66,938.326 rows=42 loops=1)

  • Filter: (nro_legaj = 912)
  • Rows Removed by Filter: 80750926
5. 0.246 0.393 ↓ 43.0 43 1

Sort (cost=4.58..4.59 rows=1 width=4) (actual time=0.383..0.393 rows=43 loops=1)

  • Sort Key: dh22.nro_liqui
  • Sort Method: quicksort Memory: 25kB
6. 0.147 0.147 ↓ 7.0 7 1

Seq Scan on dh22 (cost=0.00..4.58 rows=1 width=4) (actual time=0.074..0.147 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
7. 0.012 0.672 ↓ 2.0 4 42

Materialize (cost=0.00..45.91 rows=2 width=4) (actual time=0.006..0.016 rows=4 loops=42)

8. 0.660 0.660 ↓ 2.0 4 1

Seq Scan on dh12 (cost=0.00..45.90 rows=2 width=4) (actual time=0.238..0.660 rows=4 loops=1)

  • Filter: (tipo_ganan = 8)
  • Rows Removed by Filter: 468
Planning time : 0.688 ms