{"Entry":{"collection":"metric","key":"pg_stat_database-temp_files","name":"pg_stat_database.temp_files","aliases":["temp_files","pg_stat_database"],"metadata":{"aliases":["temp_files","pg_stat_database"],"category":"pg_stat_database","content_hash":"8fd21e3c09adf9a9c8488f95ba6dd15773abd208126fbdd589259865de2c5a9c","derived_content_hash":"9f82d73793eba0bd36a5fa0bbbb1a99e0ae3c2fb8bab1b963a7a41e38ebd7562","imported_at":"2026-09-30T00:40:45.588233+08:00","name":"pg_stat_database.temp_files","name_zh":"","slug":"pg_stat_database-temp_files","summary":"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."}},"Definition":{"Collection":"metric","Key":"pg_stat_database-temp_files","SourceDatabase":"center","Version":"18","SourceTable":"statistics_metric","SourceKey":"pg_stat_database-temp_files","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"comparison_data":{"field":"temp_files","sql_type":"bigint","units_mentioned":[],"view":"pg_stat_database"},"comparison_hash":"ad9809c146dcc63a795eb8c84eda4e0c1a0ebb5d383bd6f2024a64a5562da686","description":["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."],"description_zh":"这个数据库中查询创建的临时文件的数量。所有临时文件都将被计数，而不顾及临时文件为什么被创建（例如，排序或 hash 运算），也不考虑 log_temp_files 设置。","description_zh_html":"\u003cp\u003epg_stat_database.temp_files 统计字段。\u003c/p\u003e\u003cdl\u003e\u003cdt\u003e视图\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003epg_stat_database\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e字段\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003etemp_files\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003eSQL 类型\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003ebigint\u003c/code\u003e\u003c/dd\u003e\u003c/dl\u003e\u003ch3\u003e同版本中文手册定义\u003c/h3\u003e\u003cp\u003e这个数据库中查询创建的临时文件的数量。所有临时文件都将被计数，而不顾及临时文件为什么被创建（例如，排序或 hash 运算），也不考虑 log_temp_files 设置。\u003c/p\u003e\u003cp\u003e\u003ca href=\"/zh/docs/18/monitoring-stats.html#\"\u003e查看完整中文手册与上下文\u003c/a\u003e。\u003c/p\u003e","documented":true,"facts":[{"label":"View","value":"pg_stat_database"},{"label":"Field","value":"temp_files"},{"label":"SQL type","value":"bigint"},{"label":"Units named in the field definition","value":"Not specified"},{"label":"Reset observation","value":"Time at which these statistics were last reset"}],"facts_zh":[{"label":"视图","value":"pg_stat_database"},{"label":"字段","value":"temp_files"},{"label":"SQL 类型","value":"bigint"},{"label":"字段定义记载的单位","value":"未指定"},{"label":"重置条件","value":"这些统计上次重置的时间"}],"field":"temp_files","manual_html":"","manual_path":"/docs/18/monitoring-stats.html","related":[{"label":"pg_stat_database columns","url":"/wiki/catalog/pg_stat_database/?v=18"},{"label":"Statistics collection and reset functions","url":"/docs/18/monitoring-stats.html"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[{"paragraphs":["The pg_stat_database view will contain one row for each database in the cluster, plus one for shared objects, showing database-wide statistics."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT temp_files FROM pg_catalog.pg_stat_database;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"sections_zh":[{"paragraphs":["pg_stat_database 视图将包含一行用于集簇中的每个数据库，加一行用于共享对象，显示数据库范围的统计信息。"],"title":"视图语义"},{"paragraphs":["重置范围和可见性请参阅下方同版本的统计信息收集与视图文档。不根据字段名称推断各字段的重置规则。"],"title":"采集与重置语义"},{"code":"SELECT temp_files FROM pg_catalog.pg_stat_database;","paragraphs":["示例查询；不表示已执行，也不提供实测值。"],"title":"查看此字段"}],"signature":"SELECT temp_files FROM pg_catalog.pg_stat_database;","source_only":false,"sources":[{"label":"PostgreSQL 18 English manual","path":"monitoring-stats.html","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","url":"/docs/18/monitoring-stats.html#PG-STAT-DATABASE-VIEW"}],"sql_type":"bigint","tables":[],"tables_zh":[],"units_mentioned":[],"view":"pg_stat_database","zh_from":{"authored_translation":"source-derived-structured-summary","body_sha256":"64b6119a1579bf52f906c95601fcfa05614cbf4f72291362a3e38ef420e32dce","kind":"same-version-chinese-manual-with-source-derived-structured-summary","manual":{"anchor":"","build_id":107,"column":"temp_files","extraction":"exact-catalog-field","locale":"zh-Hans","page_key":"monitoring-stats.html","source_hash":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","url":"/zh/docs/18/monitoring-stats.html#","version":"18"},"runtime_rerun":false,"source_facts_revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}},"ManualEvidence":{"manual_path":"/docs/18/monitoring-stats.html","release":{"channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"label":"PostgreSQL 18 English manual","path":"monitoring-stats.html","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","url":"/docs/18/monitoring-stats.html#PG-STAT-DATABASE-VIEW"}]},"MeasuredEvidence":{}},"Text":{"Collection":"metric","Key":"pg_stat_database-temp_files","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_database.temp_files","Summary":"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.","BodyHTML":"\u003cp\u003eNumber 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.\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"09120c1187f34145b640b044de3e5b858da7e85e71ed598337ed90db2f5cccd9","Payload":{"description":["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."],"manual_html":"","related":[{"label":"pg_stat_database columns","url":"/wiki/catalog/pg_stat_database/?v=18"},{"label":"Statistics collection and reset functions","url":"/docs/18/monitoring-stats.html"}],"sections":[{"paragraphs":["The pg_stat_database view will contain one row for each database in the cluster, plus one for shared objects, showing database-wide statistics."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT temp_files FROM pg_catalog.pg_stat_database;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"tables":[]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}