pg_stat_database_temp_bytes Counter
Total amount of data written to temporary files by queries in this database. All temporary files are counted, regardless of why the temporary file was created, and regardless of the log_temp_files setting.
Source
Alerts
We do not have any alerts associated with this metric in our collection.