pg_stat_database_temp_files Counter
Number of temporary files created by queries in this database. All temporary files are counted, regardless of why the temporary file was created (e.g., sorting or hashing), and regardless of the log_temp_files setting.
Source
Alerts
We do not have any alerts associated with this metric in our collection.