pg_stat_database.temp_files
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.
Reading PG 18·Select a recorded version
- View
- pg_stat_database
- Field
- temp_files
- SQL type
- bigint
- Units named in the field definition
- Not specified
- Reset observation
- Time at which these statistics were last reset
- documented
- true
- field
- temp_files
- manual path
- /docs/18/monitoring-stats.html
- signature
- SELECT temp_files FROM pg_catalog.pg_stat_database;
- source only
- false
- sql type
- bigint
- units mentioned
- Unknown
- view
- pg_stat_database
Definition PG 18
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.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f