explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YRWm : Optimalized

Settings
# exclusive inclusive rows x rows loops node
1. 4,235.196 4,235.196 ↓ 18.4 96,725 1

Seq Scan on table s_1 (cost=0.00..87,472.58 rows=5,260 width=115) (actual time=0.958..4,235.196 rows=96,725 loops=1)

  • Filter: ((s_1.stav >= 91) AND (date_trunc('week'::text, s_1.zacatek) <= date_trunc('week'::text, date_trunc('week'::text, to_timestamp('2019-01-06 23:59:59'::text, 'YYYY-MM-DD HH24:mi:ss'::text)))) AND (date_trunc('week'::text, s_1.zacatek) >= date_trunc('week'::text, ((date_trunc('week'::text, to_timestamp('2018-12-31 00:00:00'::text, 'YYYY-MM-DD HH24:mi:ss'::text)) - '5 mons'::interval) + '1 day'::interval))))
  • Rows Removed by Filter: 1,255,171
  • Buffers: shared hit=30,017
Planning time : 0.166 ms
Execution time : 4,241.479 ms