explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FFia : Optimalized

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

Seq Scan on reports.ui_cdc_s1_smena s_1 (cost=0.00..60,434.66 rows=5,260 width=115) (actual time=0.112..555.299 rows=96,725 loops=1)

  • Filter: ((s_1.stav >= 91) AND (date_trunc('week'::text, s_1.zacatek) >= '2018-07-30 00:00:00'::timestamp without time zone) AND (date_trunc('week'::text, s_1.zacatek) <= '2018-12-31 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1,255,171
  • Buffers: shared hit=30,017
Planning time : 0.073 ms
Execution time : 559.906 ms