> can you try removing that index and running ANALYZE on the db? on it > maybe it assumes the timestamp index will be useless It might not be wrong, a lot of my data has been created in a short amount of time (~3 days), but I don't really know the context of this query