explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yNZJL

Settings
# exclusive inclusive rows x rows loops node
1. 5.649 27.368 ↓ 1.0 8,153 1

HashAggregate (cost=1,671.15..1,891.97 rows=8,030 width=8) (actual time=26.400..27.368 rows=8,153 loops=1)

  • Group Key: model_id, (to_char((to_date((yearweek)::text, 'IYYYIW'::text) - '1 day'::interval), 'IYYYMM'::text))::integer
2. 21.719 21.719 ↓ 1.0 24,459 1

Seq Scan on model_20_80_store (cost=0.00..1,548.91 rows=24,448 width=8) (actual time=1.171..21.719 rows=24,459 loops=1)

  • Filter: ((yearweek >= 202,038) AND (yearweek <= 202,040) AND (store_id = 230))
  • Rows Removed by Filter: 24,459
Planning time : 0.092 ms
Execution time : 27.733 ms