Best practive is to keep low value for rapids retention setting, default Delete rogue value is set to zero days in Rapids>setup page, try set to one or two days and wait for next nightly maintainece to purge all old data. Default nighly maintianence runs at 4:15am everyday.