explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qCHW

Settings
# exclusive inclusive rows x rows loops node
1. 4.178 4.178 ↑ 7.8 599 1

Seq Scan on bonus_template bt (cost=0.00..1,120.45 rows=4,652 width=719) (actual time=0.023..4.178 rows=599 loops=1)

  • Filter: ((((status_id)::text = 'UPCOMING'::text) AND (COALESCE(from_date, (now() - '1 day'::interval)) <= now())) OR (((status_id)::text = 'ACTIVE'::text) AND ((COALESCE(from_date, (now() - '1 day'::interval)) > now()) OR (COALESCE(to_date, (now() + '1 day'::interval)) < now()))) OR (((status_id)::text = 'EXPIRED'::text) AND (COALESCE(to_date, (now() + '1 day'::interval)) >= now())))
  • Rows Removed by Filter: 7692
Planning time : 0.103 ms
Execution time : 4.238 ms