pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "version": "16", "link_map": {"/zh/docs/16/monitoring-stats.html": "/docs/16/monitoring-stats.html"}, "body_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "0ba5b19ec1e5f045d73bd39e7ba62f375a2ecc6f8f83ea7e1d576019654686f3", "content_hash": "93cc0d7dced2f2e1e953aa099cabbd460e573d3a2f916c7fd2e53278476136df", "source_database": "center", "source_revision": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "tables_zh": [], "documented": true, "description": ["I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002"], "manual_html": "", "manual_path": "/docs/16/monitoring-stats.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/16/monitoring-stats.html", "method": "same-major semantic node", "sha256": "602e708943074767e7aad252e93938422e388dae22bd99fc583e93f7689395ba", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[17]/div[4]/div[1]/table[0]/tbody[2]/tr[17]/td[0]/p[1]"]}, {"url": "/docs/16/protocol-overview.html", "method": "same-major semantic node", "sha256": "44bc52e9e7ea6a128300584836e839d6a6b6b161cadff330571034de65b26ac1", "language": "zh", "matched_nodes": ["#PROTOCOL-OVERVIEW/div[9]/p[1]/span[2]/span[0]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "The context of an I/O operation. Possible values are:\n\nnormal: The default or standard context for a type of I/O operation. For example, by default, relation data is read into and written out from shared buffers. Thus, reads and writes of relation data to and from shared buffers are tracked in context normal. vacuum: I/O operations performed outside of shared buffers while vacuuming and analyzing permanent relations. Temporary table vacuums use the same local buffer pool as other temporary table IO operations and are tracked in context normal. bulkread: Certain large read I/O operations done outside of shared buffers, for example, a sequential scan of a large table. bulkwrite: Certain large write I/O operations done outside of shared buffers, such as COPY.", "/versions/16/facts/0/label": "View", "/versions/16/facts/1/label": "Field", "/versions/16/facts/2/label": "SQL type", "/versions/16/facts/2/value": "text", "/versions/16/facts/3/label": "Units named in the field definition", "/versions/16/facts/3/value": "Not specified", "/versions/16/facts/4/label": "Reset observation", "/versions/16/facts/4/value": "Time at which these statistics were last reset.", "/versions/16/related/0/label": "pg_stat_io columns", "/versions/16/related/1/label": "Statistics collection and reset functions", "/versions/16/sections/0/title": "View semantics", "/versions/16/sections/1/title": "Collection and reset context", "/versions/16/sections/2/title": "Inspect this field", "/versions/16/sections/0/paragraphs/0": "The pg_stat_io view will contain one row for each combination of backend type, target I/O object, and I/O context, showing cluster-wide I/O statistics. Combinations which do not make sense are omitted.\n\nCurrently, I/O on relations (e.g. tables, indexes) is tracked. However, relation I/O which bypasses shared buffers (e.g. when moving a table from one tablespace to another) is currently not tracked.", "/versions/16/sections/1/paragraphs/0": "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.", "/versions/16/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "225dc7d61b97433ed8f33a358ce214baaf6c01aa9ce607c91fe36956d2610fdd", "canonical_center_text_hash": "93cc0d7dced2f2e1e953aa099cabbd460e573d3a2f916c7fd2e53278476136df"}, "description_zh": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "comparison_data": {"view": "pg_stat_io", "field": "context", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "9b45bae767bdbc5ac5dbb33aeb424ef31004ac1e05f18d84666962894ca0b8fa", "manual_language": "zh", "units_mentioned": [], "description_zh_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "17": {"view": "pg_stat_io", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "field": "context", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_io/?v=17", "label": "pg_stat_io \u5b57\u6bb5"}, {"url": "/docs/17/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sources": [{"url": "/docs/17/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 17 English manual", "sha256": "007af6e8ab39b925963273ec3ba7f06f8ee6fbfaad821f07a1dc78383dbb9b99"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/17/monitoring-stats.html#", "anchor": "", "column": "context", "locale": "zh-Hans", "version": "17", "build_id": 105, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "ad63a74417862b28cba663bd779186633505e5da37845bce5f2e4bf62ee55c2b", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:7340767258d21c21b36f373f1fff6bab2be18e0daca13a865129db6105c09efd"}, "body_sha256": "9b9740b1678775e4b64782dc8965e0ea42a8cb9c167898f1fcce5a749910bd7e", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "text", "center_zh": {"title": "pg_stat_io.context", "locale": "zh-Hans", "source": {"key": "pg_stat_io-context", "locale": "zh-Hans", "version": "17", "text_hash": "8ad88c6c988eb2e15090a8306fa0df73065480448145185881b79dd3983f9bbd", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/17/monitoring-stats.html#", "anchor": "", "column": "context", "locale": "zh-Hans", "version": "17", "build_id": 105, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "ad63a74417862b28cba663bd779186633505e5da37845bce5f2e4bf62ee55c2b", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:7340767258d21c21b36f373f1fff6bab2be18e0daca13a865129db6105c09efd"}, "body_sha256": "9b9740b1678775e4b64782dc8965e0ea42a8cb9c167898f1fcce5a749910bd7e", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "description_zh_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "version": "17", "link_map": {"/zh/docs/17/monitoring-stats.html": "/docs/17/monitoring-stats.html"}, "body_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "999388ae146edfb6a825dfda3033b8b681c134f5897407e376e00de58c79edfa", "content_hash": "8ad88c6c988eb2e15090a8306fa0df73065480448145185881b79dd3983f9bbd", "source_database": "center", "source_revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "tables_zh": [], "documented": true, "description": ["I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002"], "manual_html": "", "manual_path": "/docs/17/monitoring-stats.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/17/monitoring-stats.html", "method": "same-major semantic node", "sha256": "5cd346cc373a5a006b07664d9969d4c630c8ea55dea33b8f3211f061ce43e54f", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[17]/div[4]/div[1]/table[0]/tbody[2]/tr[17]/td[0]/p[1]"]}, {"url": "/docs/17/protocol-overview.html", "method": "same-major semantic node", "sha256": "de94711d992bef74aad52fe8a723d81aa9b37a606d96b711bf9faa999a7bb3f5", "language": "zh", "matched_nodes": ["#PROTOCOL-OVERVIEW/div[9]/p[1]/span[2]/span[0]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "The context of an I/O operation. Possible values are:\n\nnormal: The default or standard context for a type of I/O operation. For example, by default, relation data is read into and written out from shared buffers. Thus, reads and writes of relation data to and from shared buffers are tracked in context normal. vacuum: I/O operations performed outside of shared buffers while vacuuming and analyzing permanent relations. Temporary table vacuums use the same local buffer pool as other temporary table I/O operations and are tracked in context normal. bulkread: Certain large read I/O operations done outside of shared buffers, for example, a sequential scan of a large table. bulkwrite: Certain large write I/O operations done outside of shared buffers, such as COPY.", "/versions/17/facts/0/label": "View", "/versions/17/facts/1/label": "Field", "/versions/17/facts/2/label": "SQL type", "/versions/17/facts/2/value": "text", "/versions/17/facts/3/label": "Units named in the field definition", "/versions/17/facts/3/value": "Not specified", "/versions/17/facts/4/label": "Reset observation", "/versions/17/facts/4/value": "Time at which these statistics were last reset.", "/versions/17/related/0/label": "pg_stat_io columns", "/versions/17/related/1/label": "Statistics collection and reset functions", "/versions/17/sections/0/title": "View semantics", "/versions/17/sections/1/title": "Collection and reset context", "/versions/17/sections/2/title": "Inspect this field", "/versions/17/sections/0/paragraphs/0": "The pg_stat_io view will contain one row for each combination of backend type, target I/O object, and I/O context, showing cluster-wide I/O statistics. Combinations which do not make sense are omitted.\n\nCurrently, I/O on relations (e.g. tables, indexes) is tracked. However, relation I/O which bypasses shared buffers (e.g. when moving a table from one tablespace to another) is currently not tracked.", "/versions/17/sections/1/paragraphs/0": "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.", "/versions/17/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "b19b58ccc6ac65852a8f833a7ed72862fa28049a4da5ce12a7b26caf5406aa75", "canonical_center_text_hash": "8ad88c6c988eb2e15090a8306fa0df73065480448145185881b79dd3983f9bbd"}, "description_zh": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "comparison_data": {"view": "pg_stat_io", "field": "context", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "9b45bae767bdbc5ac5dbb33aeb424ef31004ac1e05f18d84666962894ca0b8fa", "manual_language": "zh", "units_mentioned": [], "description_zh_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "18": {"view": "pg_stat_io", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "field": "context", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_io/?v=18", "label": "pg_stat_io \u5b57\u6bb5"}, {"url": "/docs/18/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 18 English manual", "sha256": "aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/18/monitoring-stats.html#", "anchor": "", "column": "context", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b"}, "body_sha256": "a5021a2943fd277bab7e2c61a836e11b1d673f5058b60e385c7b4046483aafb2", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O \u548c WAL \u6d3b\u52a8\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "text", "center_zh": {"title": "pg_stat_io.context", "locale": "zh-Hans", "source": {"key": "pg_stat_io-context", "locale": "zh-Hans", "version": "18", "text_hash": "bcb282c1aaa0184b7410aab8c0daae3fd4b42f1e4a55df5cd344e414b545544a", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/18/monitoring-stats.html#", "anchor": "", "column": "context", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b"}, "body_sha256": "a5021a2943fd277bab7e2c61a836e11b1d673f5058b60e385c7b4046483aafb2", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O \u548c WAL \u6d3b\u52a8\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "description_zh_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "version": "18", "link_map": {"/zh/docs/18/monitoring-stats.html": "/docs/18/monitoring-stats.html"}, "body_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "58ada51eebcbadd98dd6136b1d6bef446a5608fc91ea7df1d78be929e7e5b9be", "content_hash": "bcb282c1aaa0184b7410aab8c0daae3fd4b42f1e4a55df5cd344e414b545544a", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "tables_zh": [], "documented": true, "description": ["I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002"], "manual_html": "", "manual_path": "/docs/18/monitoring-stats.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O \u548c WAL \u6d3b\u52a8\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/18/monitoring-stats.html", "method": "same-major semantic node", "sha256": "ff0b10c5fb4b75c247e38b7ad0e8a50fa0b6ebaa25e68c8c67a1ca972bda40b1", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[17]/div[4]/div[1]/table[0]/tbody[2]/tr[19]/td[0]/p[1]"]}, {"url": "/docs/18/protocol-overview.html", "method": "same-major semantic node", "sha256": "3f1aa8bd4dbef58e9a82e8cf4c82829a4df7416cfa83dd61c18e9e25060f22da", "language": "zh", "matched_nodes": ["#PROTOCOL-OVERVIEW/div[9]/p[1]/span[2]/span[0]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "The context of an I/O operation. Possible values are:\n\nnormal: The default or standard context for a type of I/O operation. For example, by default, relation data is read into and written out from shared buffers. Thus, reads and writes of relation data to and from shared buffers are tracked in context normal. init: I/O operations performed while creating the WAL segments are tracked in context init. vacuum: I/O operations performed outside of shared buffers while vacuuming and analyzing permanent relations. Temporary table vacuums use the same local buffer pool as other temporary table I/O operations and are tracked in context normal. bulkread: Certain large read I/O operations done outside of shared buffers, for example, a sequential scan of a large table. bulkwrite: Certain large write I/O operations done outside of shared buffers, such as COPY.", "/versions/18/facts/0/label": "View", "/versions/18/facts/1/label": "Field", "/versions/18/facts/2/label": "SQL type", "/versions/18/facts/2/value": "text", "/versions/18/facts/3/label": "Units named in the field definition", "/versions/18/facts/3/value": "Not specified", "/versions/18/facts/4/label": "Reset observation", "/versions/18/facts/4/value": "Time at which these statistics were last reset.", "/versions/18/related/0/label": "pg_stat_io columns", "/versions/18/related/1/label": "Statistics collection and reset functions", "/versions/18/sections/0/title": "View semantics", "/versions/18/sections/1/title": "Collection and reset context", "/versions/18/sections/2/title": "Inspect this field", "/versions/18/sections/0/paragraphs/0": "The pg_stat_io view will contain one row for each combination of backend type, target I/O object, and I/O context, showing cluster-wide I/O statistics. Combinations which do not make sense are omitted.\n\nCurrently, I/O on relations (e.g. tables, indexes) and WAL activity are tracked. However, relation I/O which bypasses shared buffers (e.g. when moving a table from one tablespace to another) is currently not tracked.", "/versions/18/sections/1/paragraphs/0": "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.", "/versions/18/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "99a32faadbe6b34fa5713cc413fe6545670fa3cb8cdf2230420f594abff86e05", "canonical_center_text_hash": "bcb282c1aaa0184b7410aab8c0daae3fd4b42f1e4a55df5cd344e414b545544a"}, "description_zh": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "comparison_data": {"view": "pg_stat_io", "field": "context", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "9b45bae767bdbc5ac5dbb33aeb424ef31004ac1e05f18d84666962894ca0b8fa", "manual_language": "zh", "units_mentioned": [], "description_zh_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "center_zh_rendered": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "19": {"view": "pg_stat_io", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "field": "context", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_io/?v=19", "label": "pg_stat_io \u5b57\u6bb5"}, {"url": "/docs/19/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19rc1/postgresql-19rc1.tar.bz2", "label": "19rc1", "major": "19", "channel": "preview", "revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "source_sha256": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "manual_fingerprint": "63afc6091780ed5e52920ff9ef5adb6aa7dfcc82f8f413ed36ad46095788488d", "catalog_fingerprint": "da7a8a4e03b72cd120b91ffdff4265e065ccad9eab9964fc3eb1279a58464eb8"}, "sources": [{"url": "/docs/19/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 19 English manual", "sha256": "650f6d5aceb2bb6fe0ed91640c7292c21e805a6d2912eff129665318c942274c"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/19/monitoring-stats.html#", "anchor": "", "column": "context", "locale": "zh-Hans", "version": "19", "build_id": 109, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "38f7e14f495b50d93ec5fe73e5630957512a3cbd01aa83c8d7dd33abfeedbb62", "source_revision": "sha256:af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:65fda1f1b62a89992b84014c9157e61b67dbe8190e93945826efec668fad038c"}, "body_sha256": "4bb0e37f850bbaff81e0206c25ecd266816ddf7b00d4bfed5ec24ae64c42fe58", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O \u548c WAL \u6d3b\u52a8\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "text", "center_zh": {"title": "pg_stat_io.context", "locale": "zh-Hans", "source": {"key": "pg_stat_io-context", "locale": "zh-Hans", "version": "19", "text_hash": "c6eaaad5cc4cea3d2b7caf2a6502a188c0260bf55bd0431fd8192b455e38252d", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/19/monitoring-stats.html#", "anchor": "", "column": "context", "locale": "zh-Hans", "version": "19", "build_id": 109, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "38f7e14f495b50d93ec5fe73e5630957512a3cbd01aa83c8d7dd33abfeedbb62", "source_revision": "sha256:af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:65fda1f1b62a89992b84014c9157e61b67dbe8190e93945826efec668fad038c"}, "body_sha256": "4bb0e37f850bbaff81e0206c25ecd266816ddf7b00d4bfed5ec24ae64c42fe58", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O \u548c WAL \u6d3b\u52a8\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "description_zh_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "version": "19", "link_map": {"/zh/docs/19/monitoring-stats.html": "/docs/19/monitoring-stats.html"}, "body_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "018080fc08a7f65390f75327ca6c862a2cad78d2617d3dff9065819471060ad8", "content_hash": "c6eaaad5cc4cea3d2b7caf2a6502a188c0260bf55bd0431fd8192b455e38252d", "source_database": "center", "source_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "tables_zh": [], "documented": true, "description": ["I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002"], "manual_html": "", "manual_path": "/docs/19/monitoring-stats.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O \u548c WAL \u6d3b\u52a8\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/19/monitoring-stats.html", "method": "same-major semantic node", "sha256": "024434288428f15560d48c78af2e836ca669a4217589cfaeb2f16b72123b501a", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[18]/div[4]/div[1]/table[0]/tbody[2]/tr[19]/td[0]/p[1]"]}, {"url": "/docs/19/protocol-overview.html", "method": "same-major semantic node", "sha256": "4650a5af6514ccd289c59f90ba62490b00e797ee04c02359ef9e2174c1f276ed", "language": "zh", "matched_nodes": ["#PROTOCOL-OVERVIEW/div[9]/p[1]/span[2]/span[0]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "The context of an I/O operation. Possible values are:\n\nnormal: The default or standard context for a type of I/O operation. For example, by default, relation data is read into and written out from shared buffers. Thus, reads and writes of relation data to and from shared buffers are tracked in context normal. init: I/O operations performed while creating the WAL segments are tracked in context init. vacuum: I/O operations performed outside of shared buffers while vacuuming and analyzing permanent relations. Temporary table vacuums use the same local buffer pool as other temporary table I/O operations and are tracked in context normal. bulkread: Certain large read I/O operations done outside of shared buffers, for example, a sequential scan of a large table. bulkwrite: Certain large write I/O operations done outside of shared buffers, such as COPY.", "/versions/19/facts/0/label": "View", "/versions/19/facts/1/label": "Field", "/versions/19/facts/2/label": "SQL type", "/versions/19/facts/2/value": "text", "/versions/19/facts/3/label": "Units named in the field definition", "/versions/19/facts/3/value": "Not specified", "/versions/19/facts/4/label": "Reset observation", "/versions/19/facts/4/value": "Time at which these statistics were last reset.", "/versions/19/related/0/label": "pg_stat_io columns", "/versions/19/related/1/label": "Statistics collection and reset functions", "/versions/19/sections/0/title": "View semantics", "/versions/19/sections/1/title": "Collection and reset context", "/versions/19/sections/2/title": "Inspect this field", "/versions/19/sections/0/paragraphs/0": "The pg_stat_io view will contain one row for each combination of backend type, target I/O object, and I/O context, showing cluster-wide I/O statistics. Combinations which do not make sense are omitted.\n\nCurrently, I/O on relations (e.g. tables, indexes) and WAL activity are tracked. However, relation I/O which bypasses shared buffers (e.g. when moving a table from one tablespace to another) is currently not tracked.", "/versions/19/sections/1/paragraphs/0": "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.", "/versions/19/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "c967ad7aad064234f3f76a8ae65a79b8d48ab336a90fea6530b19eafc084443d", "canonical_center_text_hash": "c6eaaad5cc4cea3d2b7caf2a6502a188c0260bf55bd0431fd8192b455e38252d"}, "description_zh": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "comparison_data": {"view": "pg_stat_io", "field": "context", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "9b45bae767bdbc5ac5dbb33aeb424ef31004ac1e05f18d84666962894ca0b8fa", "manual_language": "zh", "units_mentioned": [], "description_zh_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "source_revalidation": {"kind": "static-same-version-source-and-manual-replay", "audit": "wiki-audit-20261023", "runtime_rerun": false, "compared_fields": "documented field type and description, source-only view expressions", "source_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "previous_source_revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}}, "20": {"view": "pg_stat_io", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "field": "context", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_io/?v=20", "label": "pg_stat_io \u5b57\u6bb5"}, {"url": "/docs/devel/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "source_sha256": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "manual_fingerprint": "4afd3a8e29953000e176877e161458a2febaeaac5a5e16986595d3acc2418c7d", "catalog_fingerprint": "e519e6916a731ce8fb9bca3edb12410227f73e01ccd43fb6f5fb98276f08985f"}, "sources": [{"url": "/docs/devel/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 20 English manual", "sha256": "12af0ae255e3b04952990efae8e4e9d07926556da23734d34f43b9a37126c84f"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/devel/monitoring-stats.html#", "anchor": "", "column": "context", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "2c8d45a2fe11aec2ee727b94ac68e60b7a0523a1aa2d43629f9368d42f544d40", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235"}, "body_sha256": "fa1355979c22918eff8aa614ab8b6434598a943fea1bf5cefd57c050f823b360", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O \u548c WAL \u6d3b\u52a8\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "text", "center_zh": {"title": "pg_stat_io.context", "locale": "zh-Hans", "source": {"key": "pg_stat_io-context", "locale": "zh-Hans", "version": "20", "text_hash": "221efb7d03c7b8a8f9d5a42657a24042f3d2988d98b07fb746650552dd566b0b", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/devel/monitoring-stats.html#", "anchor": "", "column": "context", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "2c8d45a2fe11aec2ee727b94ac68e60b7a0523a1aa2d43629f9368d42f544d40", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235"}, "body_sha256": "fa1355979c22918eff8aa614ab8b6434598a943fea1bf5cefd57c050f823b360", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O \u548c WAL \u6d3b\u52a8\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "description_zh_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "version": "20", "link_map": {"/zh/docs/devel/monitoring-stats.html": "/docs/devel/monitoring-stats.html"}, "body_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "608e7ce02d62e22e7067b350f170d6f13cec1228631d93123295502d34d95483", "content_hash": "221efb7d03c7b8a8f9d5a42657a24042f3d2988d98b07fb746650552dd566b0b", "source_database": "center", "source_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "tables_zh": [], "documented": true, "description": ["I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002"], "manual_html": "", "manual_path": "/docs/devel/monitoring-stats.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O \u548c WAL \u6d3b\u52a8\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/devel/monitoring-stats.html", "method": "same-major semantic node", "sha256": "1d9a086fb4c6fdd9a56d3a7a28e8c164354ef0bf50c402f06ebe174538f96a4f", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[18]/div[4]/div[1]/table[0]/tbody[2]/tr[19]/td[0]/p[1]"]}, {"url": "/docs/devel/protocol-overview.html", "method": "same-major semantic node", "sha256": "fe7aff6a941aef6be4870c7704bca095984a81fd5019f420b67c9917f3831028", "language": "zh", "matched_nodes": ["#PROTOCOL-OVERVIEW/div[9]/p[1]/span[2]/span[0]"]}], "language": "zh", "original_text": {"/summary": "The context of an I/O operation. Possible values are:\n\nnormal: The default or standard context for a type of I/O operation. For example, by default, relation data is read into and written out from shared buffers. Thus, reads and writes of relation data to and from shared buffers are tracked in context normal. init: I/O operations performed while creating the WAL segments are tracked in context init. vacuum: I/O operations performed outside of shared buffers while vacuuming and analyzing permanent relations. Temporary table vacuums use the same local buffer pool as other temporary table I/O operations and are tracked in context normal. bulkread: Certain large read I/O operations done outside of shared buffers, for example, a sequential scan of a large table. bulkwrite: Certain large write I/O operations done outside of shared buffers, such as COPY.", "/versions/20/description/0": "The context of an I/O operation. Possible values are:\n\nnormal: The default or standard context for a type of I/O operation. For example, by default, relation data is read into and written out from shared buffers. Thus, reads and writes of relation data to and from shared buffers are tracked in context normal. init: I/O operations performed while creating the WAL segments are tracked in context init. vacuum: I/O operations performed outside of shared buffers while vacuuming and analyzing permanent relations. Temporary table vacuums use the same local buffer pool as other temporary table I/O operations and are tracked in context normal. bulkread: Certain large read I/O operations done outside of shared buffers, for example, a sequential scan of a large table. bulkwrite: Certain large write I/O operations done outside of shared buffers, such as COPY.", "/versions/20/facts/0/label": "View", "/versions/20/facts/1/label": "Field", "/versions/20/facts/2/label": "SQL type", "/versions/20/facts/2/value": "text", "/versions/20/facts/3/label": "Units named in the field definition", "/versions/20/facts/3/value": "Not specified", "/versions/20/facts/4/label": "Reset observation", "/versions/20/facts/4/value": "Time at which these statistics were last reset.", "/versions/20/related/0/label": "pg_stat_io columns", "/versions/20/related/1/label": "Statistics collection and reset functions", "/versions/20/sections/0/title": "View semantics", "/versions/20/sections/1/title": "Collection and reset context", "/versions/20/sections/2/title": "Inspect this field", "/versions/20/sections/0/paragraphs/0": "The pg_stat_io view will contain one row for each combination of backend type, target I/O object, and I/O context, showing cluster-wide I/O statistics. Combinations which do not make sense are omitted.\n\nCurrently, I/O on relations (e.g. tables, indexes) and WAL activity are tracked. However, relation I/O which bypasses shared buffers (e.g. when moving a table from one tablespace to another) is currently not tracked.", "/versions/20/sections/1/paragraphs/0": "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.", "/versions/20/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "cfc606e51fcd112bbd4e08aef8f96a5b24a883599ea6a7cd0d7b01fc211432b2", "canonical_center_text_hash": "221efb7d03c7b8a8f9d5a42657a24042f3d2988d98b07fb746650552dd566b0b"}, "description_zh": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "comparison_data": {"view": "pg_stat_io", "field": "context", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "9b45bae767bdbc5ac5dbb33aeb424ef31004ac1e05f18d84666962894ca0b8fa", "manual_language": "zh", "units_mentioned": [], "description_zh_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "source_revalidation": {"kind": "static-same-version-source-and-manual-replay", "audit": "wiki-audit-20261023", "runtime_rerun": false, "compared_fields": "documented field type and description, source-only view expressions", "source_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "previous_source_revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}}}}, "snapshot": {"view": "pg_stat_io", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "field": "context", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_io/?v=18", "label": "pg_stat_io \u5b57\u6bb5"}, {"url": "/docs/18/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 18 English manual", "sha256": "aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/18/monitoring-stats.html#", "anchor": "", "column": "context", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b"}, "body_sha256": "a5021a2943fd277bab7e2c61a836e11b1d673f5058b60e385c7b4046483aafb2", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O \u548c WAL \u6d3b\u52a8\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "text", "center_zh": {"title": "pg_stat_io.context", "locale": "zh-Hans", "source": {"key": "pg_stat_io-context", "locale": "zh-Hans", "version": "18", "text_hash": "bcb282c1aaa0184b7410aab8c0daae3fd4b42f1e4a55df5cd344e414b545544a", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "text"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "\u672a\u6307\u5b9a"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u8fd9\u4e9b\u7edf\u8ba1\u4fe1\u606f\u4e0a\u6b21\u88ab\u91cd\u7f6e\u7684\u65f6\u95f4\u3002"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/18/monitoring-stats.html#", "anchor": "", "column": "context", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "monitoring-stats.html", "extraction": "exact-catalog-field", "source_hash": "0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b"}, "body_sha256": "a5021a2943fd277bab7e2c61a836e11b1d673f5058b60e385c7b4046483aafb2", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O \u548c WAL \u6d3b\u52a8\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "description_zh_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "version": "18", "link_map": {"/zh/docs/18/monitoring-stats.html": "/docs/18/monitoring-stats.html"}, "body_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "58ada51eebcbadd98dd6136b1d6bef446a5608fc91ea7df1d78be929e7e5b9be", "content_hash": "bcb282c1aaa0184b7410aab8c0daae3fd4b42f1e4a55df5cd344e414b545544a", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "tables_zh": [], "documented": true, "description": ["I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002"], "manual_html": "", "manual_path": "/docs/18/monitoring-stats.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["pg_stat_io \u89c6\u56fe\u4e3a\u540e\u7aef\u7c7b\u578b\u3001\u76ee\u6807 I/O \u5bf9\u8c61\u548c I/O \u4e0a\u4e0b\u6587\u7684\u6bcf\u79cd\u7ec4\u5408\u63d0\u4f9b\u4e00\u884c\uff0c\u663e\u793a\u6574\u4e2a\u96c6\u7fa4\u7684 I/O \u7edf\u8ba1\u4fe1\u606f\uff1b\u65e0\u610f\u4e49\u7684\u7ec4\u5408\u4f1a\u7701\u7565\u3002\u76ee\u524d\u8ddf\u8e2a\u5173\u7cfb\uff08\u5982\u8868\u3001\u7d22\u5f15\uff09\u7684 I/O \u548c WAL \u6d3b\u52a8\uff0c\u4f46\u4e0d\u8ddf\u8e2a\u7ed5\u8fc7\u5171\u4eab\u7f13\u51b2\u533a\u7684\u5173\u7cfb I/O\uff08\u4f8b\u5982\u5c06\u8868\u4ece\u4e00\u4e2a\u8868\u7a7a\u95f4\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u8868\u7a7a\u95f4\uff09\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/18/monitoring-stats.html", "method": "same-major semantic node", "sha256": "ff0b10c5fb4b75c247e38b7ad0e8a50fa0b6ebaa25e68c8c67a1ca972bda40b1", "language": "zh", "matched_nodes": ["#MONITORING-STATS/div[17]/div[4]/div[1]/table[0]/tbody[2]/tr[19]/td[0]/p[1]"]}, {"url": "/docs/18/protocol-overview.html", "method": "same-major semantic node", "sha256": "3f1aa8bd4dbef58e9a82e8cf4c82829a4df7416cfa83dd61c18e9e25060f22da", "language": "zh", "matched_nodes": ["#PROTOCOL-OVERVIEW/div[9]/p[1]/span[2]/span[0]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "The context of an I/O operation. Possible values are:\n\nnormal: The default or standard context for a type of I/O operation. For example, by default, relation data is read into and written out from shared buffers. Thus, reads and writes of relation data to and from shared buffers are tracked in context normal. init: I/O operations performed while creating the WAL segments are tracked in context init. vacuum: I/O operations performed outside of shared buffers while vacuuming and analyzing permanent relations. Temporary table vacuums use the same local buffer pool as other temporary table I/O operations and are tracked in context normal. bulkread: Certain large read I/O operations done outside of shared buffers, for example, a sequential scan of a large table. bulkwrite: Certain large write I/O operations done outside of shared buffers, such as COPY.", "/versions/18/facts/0/label": "View", "/versions/18/facts/1/label": "Field", "/versions/18/facts/2/label": "SQL type", "/versions/18/facts/2/value": "text", "/versions/18/facts/3/label": "Units named in the field definition", "/versions/18/facts/3/value": "Not specified", "/versions/18/facts/4/label": "Reset observation", "/versions/18/facts/4/value": "Time at which these statistics were last reset.", "/versions/18/related/0/label": "pg_stat_io columns", "/versions/18/related/1/label": "Statistics collection and reset functions", "/versions/18/sections/0/title": "View semantics", "/versions/18/sections/1/title": "Collection and reset context", "/versions/18/sections/2/title": "Inspect this field", "/versions/18/sections/0/paragraphs/0": "The pg_stat_io view will contain one row for each combination of backend type, target I/O object, and I/O context, showing cluster-wide I/O statistics. Combinations which do not make sense are omitted.\n\nCurrently, I/O on relations (e.g. tables, indexes) and WAL activity are tracked. However, relation I/O which bypasses shared buffers (e.g. when moving a table from one tablespace to another) is currently not tracked.", "/versions/18/sections/1/paragraphs/0": "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.", "/versions/18/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "99a32faadbe6b34fa5713cc413fe6545670fa3cb8cdf2230420f594abff86e05", "canonical_center_text_hash": "bcb282c1aaa0184b7410aab8c0daae3fd4b42f1e4a55df5cd344e414b545544a"}, "description_zh": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "comparison_data": {"view": "pg_stat_io", "field": "context", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "9b45bae767bdbc5ac5dbb33aeb424ef31004ac1e05f18d84666962894ca0b8fa", "manual_language": "zh", "units_mentioned": [], "description_zh_html": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "center_zh_rendered": "pg_stat_io.context \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_iocontexttextI/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u6709\uff1a\n\nnormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6 context\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5173\u7cfb\u6570\u636e\u4f1a\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u5173\u7cfb\u6570\u636e\u4e0e\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u95f4\u7684\u8bfb\u5199\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u4f1a\u5728 context \u4e3a init \u65f6\u8ddf\u8e2a\u3002 vacuum\uff1a\u5bf9\u6c38\u4e45\u5173\u7cfb\u6267\u884c\u6e05\u7406\u548c\u5206\u6790\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u6e05\u7406\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u5171\u7528\u540c\u4e00\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u56e0\u6b64\u4f1a\u5728 context \u4e3a normal \u65f6\u8ddf\u8e2a\u3002 bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u8bfb\u53d6 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982\u5bf9\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002 bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u578b\u5199\u5165 I/O \u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}