Counters with TTL

gistfile1.sql

CREATE TABLE hits (
      hit text PRIMARY KEY,
      counter counter
    ) WITH COMPACT STORAGE;

UPDATE hits USING TTL 3600 SET counter = counter + 1 WHERE hit='api-call-some-hour';