QUERY PLAN
Aggregate (cost=347.15..347.16 rows=1 width=8)
-> Seq Scan on tbl_api_log a (cost=0.00..346.22 rows=371 width=0)
Filter: ((url ~~* '%v2%'::text) AND ("time" >= '2025-07-12 00:00:00'::timestamp without time zone) AND ("time" < '2025-07-13 00:00:00'::timestamp without time zone))