QUERY PLAN
Aggregate (cost=11.55..11.56 rows=1 width=8)
-> Seq Scan on promotion (cost=0.00..11.55 rows=1 width=0)
Filter: (((start_date)::text <= '2025-04-20'::text) AND ((end_date)::text >= '2025-04-20'::text) AND ((start_time)::text <= '07:55'::text) AND ((end_time)::text >= '07:55'::text) AND (is_deleted = 0) AND (is_active = 1))