QUERY PLAN
Aggregate (cost=1299.05..1299.06 rows=1 width=8)
-> Seq Scan on tbl_api_log a (cost=0.00..1298.96 rows=36 width=0)
Filter: ((url ~~* '%v2/sales-contract%'::text) AND ("time" >= '2025-07-23 00:00:00'::timestamp without time zone) AND ("time" < '2025-07-24 00:00:00'::timestamp without time zone))