pg_stat_database.temp_bytes
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.
Reading PG 18·Select a recorded version
- View
- pg_stat_database
- Field
- temp_bytes
- 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_bytes
- manual path
- /docs/18/monitoring-stats.html
- signature
- SELECT temp_bytes FROM pg_catalog.pg_stat_database;
- source only
- false
- sql type
- bigint
- units mentioned
- Unknown
- view
- pg_stat_database
Definition PG 18
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.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f