My aim is to retain data in my database for one hour. Data older than one hour should be automatically truncated.
For this I have created a retention policy as mentioned below:
CREATE RETENTION POLICY “one_hour” ON “prometheus” DURATION 1h REPLICATION 1 DEFAULT
But no data is getting purged at all.
What am I missing here?