explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wRAW

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=104,098,455.03..104,910,456.63 rows=324,800,640 width=30) (actual rows= loops=)

  • Sort Key: wsndata.code, wsndata.item, wsndata.freq, wsndata.year_, wsndata.seq
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,033.74..44,524,848.72 rows=324,800,640 width=30) (actual rows= loops=)

  • Hash Cond: (((wsndata.year_)::integer = diffs.date_) AND (floor(((wsndata.code / 100))::double precision) = (diffs.idgroup)::double precision))
3. 0.000 0.000 ↓ 0.0

Seq Scan on wsndata (cost=0.00..25,288,471.49 rows=1,299,202,559 width=30) (actual rows= loops=)

  • Filter: ((freq)::text <> 'C'::text)
4. 0.000 0.000 ↓ 0.0

Hash (cost=970.41..970.41 rows=4,222 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

HashAggregate (cost=928.19..970.41 rows=4,222 width=8) (actual rows= loops=)

  • Group Key: diffs.date_, (diffs.idgroup)::double precision
6. 0.000 0.000 ↓ 0.0

Seq Scan on wsndata_year_daydiffs diffs (cost=0.00..717.13 rows=42,213 width=8) (actual rows= loops=)