{"kind": "metric", "major": "18", "item": {"slug": "pg_stat_io-context", "name": "pg_stat_io.context", "name_zh": "", "category": "pg_stat_io", "summary": "I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u5305\u62ec\uff1anormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6\u4e0a\u4e0b\u6587\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5173\u7cfb\u6570\u636e\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\uff0c\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u8fd9\u7c7b\u8bfb\u5199\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u5728 init \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002vacuum\uff1a\u6e05\u7406\u548c\u5206\u6790\u6c38\u4e45\u5173\u7cfb\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u7684\u6e05\u7406\u4f7f\u7528\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u76f8\u540c\u7684\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u8bfb\u53d6\u64cd\u4f5c\uff0c\u4f8b\u5982\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u5199\u5165\u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002", "aliases": ["context", "pg_stat_io"], "content_hash": "19c588957a1a9a3f4ae1e2f6534776e11bd8a2d5e05bb3643c4533bb0fe0a0f6", "versions": {"16": {"view": "pg_stat_io", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "\u6587\u672c"}, {"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=16", "label": "pg_stat_io \u5b57\u6bb5"}, {"url": "/docs/16/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "16.15", "major": "16", "channel": "stable", "revision": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "sources": [{"url": "https://pg.center/docs/16/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 16 English manual", "sha256": "a4c274defe8a41ff2895040cd542b5499063b844669ff3336de1a1317c3fe086", "language": "en", "original_url": "/docs/16/monitoring-stats.html#PG-STAT-IO-VIEW"}], "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", "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "documented": true, "description": ["I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u5305\u62ec\uff1anormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6\u4e0a\u4e0b\u6587\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5173\u7cfb\u6570\u636e\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\uff0c\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u8fd9\u7c7b\u8bfb\u5199\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002vacuum\uff1a\u6e05\u7406\u548c\u5206\u6790\u6c38\u4e45\u5173\u7cfb\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u7684\u6e05\u7406\u4f7f\u7528\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u76f8\u540c\u7684\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u8bfb\u53d6\u64cd\u4f5c\uff0c\u4f8b\u5982\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u5199\u5165\u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002"], "manual_html": "", "manual_path": "/docs/16/monitoring-stats.html", "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"}, "comparison_data": {"view": "pg_stat_io", "field": "context", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "9b45bae767bdbc5ac5dbb33aeb424ef31004ac1e05f18d84666962894ca0b8fa", "units_mentioned": []}, "17": {"view": "pg_stat_io", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "\u6587\u672c"}, {"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": "https://pg.center/docs/17/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 17 English manual", "sha256": "007af6e8ab39b925963273ec3ba7f06f8ee6fbfaad821f07a1dc78383dbb9b99", "language": "en", "original_url": "/docs/17/monitoring-stats.html#PG-STAT-IO-VIEW"}], "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", "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "documented": true, "description": ["I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u5305\u62ec\uff1anormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6\u4e0a\u4e0b\u6587\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5173\u7cfb\u6570\u636e\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\uff0c\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u8fd9\u7c7b\u8bfb\u5199\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002vacuum\uff1a\u6e05\u7406\u548c\u5206\u6790\u6c38\u4e45\u5173\u7cfb\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u7684\u6e05\u7406\u4f7f\u7528\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u76f8\u540c\u7684\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u8bfb\u53d6\u64cd\u4f5c\uff0c\u4f8b\u5982\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u5199\u5165\u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002"], "manual_html": "", "manual_path": "/docs/17/monitoring-stats.html", "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"}, "comparison_data": {"view": "pg_stat_io", "field": "context", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "9b45bae767bdbc5ac5dbb33aeb424ef31004ac1e05f18d84666962894ca0b8fa", "units_mentioned": []}, "18": {"view": "pg_stat_io", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "\u6587\u672c"}, {"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": "https://pg.center/docs/18/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 18 English manual", "sha256": "aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722", "language": "en", "original_url": "/docs/18/monitoring-stats.html#PG-STAT-IO-VIEW"}], "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", "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "documented": true, "description": ["I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u5305\u62ec\uff1anormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6\u4e0a\u4e0b\u6587\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5173\u7cfb\u6570\u636e\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\uff0c\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u8fd9\u7c7b\u8bfb\u5199\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u5728 init \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002vacuum\uff1a\u6e05\u7406\u548c\u5206\u6790\u6c38\u4e45\u5173\u7cfb\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u7684\u6e05\u7406\u4f7f\u7528\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u76f8\u540c\u7684\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u8bfb\u53d6\u64cd\u4f5c\uff0c\u4f8b\u5982\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u5199\u5165\u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002"], "manual_html": "", "manual_path": "/docs/18/monitoring-stats.html", "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"}, "comparison_data": {"view": "pg_stat_io", "field": "context", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "9b45bae767bdbc5ac5dbb33aeb424ef31004ac1e05f18d84666962894ca0b8fa", "units_mentioned": []}, "19": {"view": "pg_stat_io", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "\u6587\u672c"}, {"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/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "https://pg.center/docs/19/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 19 English manual", "sha256": "26e1b6632bdf05ebe081987cb60ab4ded526eec7db73e41316fbd69466c494fe", "language": "en", "original_url": "/docs/19/monitoring-stats.html#PG-STAT-IO-VIEW"}], "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", "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "documented": true, "description": ["I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u5305\u62ec\uff1anormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6\u4e0a\u4e0b\u6587\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5173\u7cfb\u6570\u636e\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\uff0c\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u8fd9\u7c7b\u8bfb\u5199\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u5728 init \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002vacuum\uff1a\u6e05\u7406\u548c\u5206\u6790\u6c38\u4e45\u5173\u7cfb\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u7684\u6e05\u7406\u4f7f\u7528\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u76f8\u540c\u7684\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u8bfb\u53d6\u64cd\u4f5c\uff0c\u4f8b\u5982\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u5199\u5165\u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002"], "manual_html": "", "manual_path": "/docs/19/monitoring-stats.html", "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"}, "comparison_data": {"view": "pg_stat_io", "field": "context", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "9b45bae767bdbc5ac5dbb33aeb424ef31004ac1e05f18d84666962894ca0b8fa", "units_mentioned": []}, "20": {"view": "pg_stat_io", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "\u6587\u672c"}, {"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": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "https://pg.center/docs/devel/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 20 English manual", "sha256": "dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251", "language": "en", "original_url": "/docs/devel/monitoring-stats.html#PG-STAT-IO-VIEW"}], "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", "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "documented": true, "description": ["I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u5305\u62ec\uff1anormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6\u4e0a\u4e0b\u6587\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5173\u7cfb\u6570\u636e\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\uff0c\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u8fd9\u7c7b\u8bfb\u5199\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u5728 init \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002vacuum\uff1a\u6e05\u7406\u548c\u5206\u6790\u6c38\u4e45\u5173\u7cfb\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u7684\u6e05\u7406\u4f7f\u7528\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u76f8\u540c\u7684\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u8bfb\u53d6\u64cd\u4f5c\uff0c\u4f8b\u5982\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u5199\u5165\u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002"], "manual_html": "", "manual_path": "/docs/devel/monitoring-stats.html", "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"}, "comparison_data": {"view": "pg_stat_io", "field": "context", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "9b45bae767bdbc5ac5dbb33aeb424ef31004ac1e05f18d84666962894ca0b8fa", "units_mentioned": []}}}, "snapshot": {"view": "pg_stat_io", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_io"}, {"label": "\u5b57\u6bb5", "value": "context"}, {"label": "SQL \u7c7b\u578b", "value": "\u6587\u672c"}, {"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": "https://pg.center/docs/18/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 18 English manual", "sha256": "aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722", "language": "en", "original_url": "/docs/18/monitoring-stats.html#PG-STAT-IO-VIEW"}], "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", "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "documented": true, "description": ["I/O \u64cd\u4f5c\u7684\u4e0a\u4e0b\u6587\u3002\u53ef\u80fd\u7684\u503c\u5305\u62ec\uff1anormal\uff1a\u67d0\u7c7b I/O \u64cd\u4f5c\u7684\u9ed8\u8ba4\u6216\u6807\u51c6\u4e0a\u4e0b\u6587\u3002\u4f8b\u5982\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5173\u7cfb\u6570\u636e\u8bfb\u5165\u5171\u4eab\u7f13\u51b2\u533a\uff0c\u5e76\u4ece\u5171\u4eab\u7f13\u51b2\u533a\u5199\u51fa\uff0c\u56e0\u6b64\u8fd9\u7c7b\u8bfb\u5199\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002init\uff1a\u521b\u5efa WAL \u6bb5\u65f6\u6267\u884c\u7684 I/O \u64cd\u4f5c\u5728 init \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002vacuum\uff1a\u6e05\u7406\u548c\u5206\u6790\u6c38\u4e45\u5173\u7cfb\u65f6\uff0c\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684 I/O \u64cd\u4f5c\u3002\u4e34\u65f6\u8868\u7684\u6e05\u7406\u4f7f\u7528\u4e0e\u5176\u4ed6\u4e34\u65f6\u8868 I/O \u64cd\u4f5c\u76f8\u540c\u7684\u672c\u5730\u7f13\u51b2\u6c60\uff0c\u5728 normal \u4e0a\u4e0b\u6587\u4e2d\u7edf\u8ba1\u3002bulkread\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u8bfb\u53d6\u64cd\u4f5c\uff0c\u4f8b\u5982\u5927\u8868\u7684\u987a\u5e8f\u626b\u63cf\u3002bulkwrite\uff1a\u67d0\u4e9b\u5728\u5171\u4eab\u7f13\u51b2\u533a\u4e4b\u5916\u6267\u884c\u7684\u5927\u91cf\u5199\u5165\u64cd\u4f5c\uff0c\u4f8b\u5982 COPY\u3002"], "manual_html": "", "manual_path": "/docs/18/monitoring-stats.html", "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"}, "comparison_data": {"view": "pg_stat_io", "field": "context", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "9b45bae767bdbc5ac5dbb33aeb424ef31004ac1e05f18d84666962894ca0b8fa", "units_mentioned": []}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}