Technologies/PostgreSQL/temp_bytes
PostgreSQLPostgreSQLMetric

temp_bytes

Temp file bytes
Dimensions:None
Available on:DatadogDatadog (1)Native (1)PrometheusPrometheus (1)
Interface Metrics (3)
DatadogDatadog
The amount of data written to temporary files by queries in this database. This metric is tagged with db.
Dimensions:None
Native
Amount of data written to temporary files
Dimensions:None
PrometheusPrometheus
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.
Dimensions:None
Sources
postgresql.temp_bytesgithub.com
temp_bytesgithub.com
stat_database_temp_bytesgithub.com

Technical Annotations (2)

Configuration Parameters (1)
work_memrecommended: 16-64MB for OLTP, 128MB+ for OLAP
memory per sort/hash/join operation
Technical References (1)
work_memcomponent
Related Insights (1)
Inadequate work_mem causes query spill to diskwarning
▸