QUERY PLAN
Aggregate (cost=3731.58..3731.59 rows=1 width=8)
-> Seq Scan on tbl_api_log a (cost=0.00..3731.57 rows=1 width=0)
Filter: ((url ~~* '%get-unread%'::text) AND ("time" >= '2025-09-15 00:00:00'::timestamp without time zone) AND ("time" < '2025-09-16 00:00:00'::timestamp without time zone))