checkpointing purging works and also added not queries