As I assume monitoring of temp utilization use information from pg_stat_database.
But statistics is updated when query is completed. If the query is running some days and temp utilization grows, so monitoring not signal about this problem.
May be more usefull to monitor the size of $PGDATA/base/pgsql_tmp ?
As I assume monitoring of temp utilization use information from pg_stat_database.
But statistics is updated when query is completed. If the query is running some days and temp utilization grows, so monitoring not signal about this problem.
May be more usefull to monitor the size of $PGDATA/base/pgsql_tmp ?