PostgreSQL No space left on device

Encounter the following error:

Failed to execute connection with error: ERROR: could not write to file “base/pgsql_tmp/pgsql_tmp436690.23”: No space left on device

I checked the admin console, it only utilize 9.2% of total storage, still plenty of space.

Please help to advice and troubleshoot