QUERY PLAN
Aggregate (cost=12.60..12.61 rows=1 width=8)
-> Seq Scan on promotion (cost=0.00..12.60 rows=1 width=0)
Filter: (((start_date)::text <= '2025-06-15'::text) AND ((end_date)::text >= '2025-06-15'::text) AND ((start_time)::text <= '08:29'::text) AND ((end_time)::text >= '08:29'::text) AND (is_deleted = 0) AND (is_active = 1))