explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E4f5 : Optimization for: plan #n12T

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 34,267.653 44,089.903 ↓ 0.0 0 1

Insert on df_usage (cost=0.00..89,163.29 rows=929,330 width=3,058) (actual time=44,089.903..44,089.903 rows=0 loops=1)

2. 1,265.559 9,822.250 ↑ 1.4 662,923 1

Subquery Scan on *SELECT* (cost=0.00..89,163.29 rows=929,330 width=3,058) (actual time=0.028..9,822.250 rows=662,923 loops=1)

3. 8,556.691 8,556.691 ↑ 1.4 662,923 1

Seq Scan on df_usage_archive (cost=0.00..65,930.04 rows=929,330 width=441) (actual time=0.024..8,556.691 rows=662,923 loops=1)

  • Filter: ((market_period_from <= '2050'::numeric) AND (market_period_to >= '1950'::numeric) AND ((status_ind)::text = 'ARCHIVED'::text) AND (((market)::text ~~* '%Lib%'::text) OR ((market)::text ~~* '%Gov%'::text) OR ((market)::text ~~* '%Bus%'::text) OR ((market)::text ~~* '%Univ%'::text) OR ((market)::text ~~* '%Sch%'::text)))
  • Rows Removed by Filter: 357070