All the space is being consumed by the below 2. So Shutdown Dremio and run
dremio-admin clean -j
jobs - 10GB
Profiles - 120 GB
This is going to take time as you have lots of profiles and jobs. Maybe you can do it in batches of 10 days and try? Is your rocksDB on premier SSD’s? See table in below link for IOPS per disk. Which one do you have?