# Retention policy not working

**URL:** <https://community.influxdata.com/t/retention-policy-not-working/3307>\
**Category:** Systems\
**Created:** [December 5, 2017, 2:05pm UTC](https://community.influxdata.com/t/retention-policy-not-working/3307 "2017-12-05T14:05:48Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Abhijit\_Mitra](https://avatars.discourse-cdn.com/v4/letter/a/a5b964/32.png) [@Abhijit\_Mitra](https://community.influxdata.com/u/Abhijit_Mitra)\
**Post date:** [December 5, 2017, 2:05pm UTC](https://community.influxdata.com/t/retention-policy-not-working/3307/1 "2017-12-05T14:05:48Z")

</div>

Hi all,  
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?