If retention policy relies on the Shard cleanup which seems to be set to 24 hours. The clean-up should happen everyday (24 hours cycle). Instead of using count; can you run select first(fieldname)
So we the first timestamp can be viewed under the database.
