Which Temp we need?
select * from disk_storage where storage_usage ilike '%temp%'; ?
Just need to confirm , it will be storage_usage as TEMP showing in the result of disk_storage?
It refers to temp space allocated in the storage_locations, by default is in in the /data folder. You can verify in table select * from storage_locations; what do you have, if you want to add more, just add another storage location as usage TEMP.