{"kind": "metric", "major": "18", "item": {"slug": "pg_stat_io-context", "name": "pg_stat_io.context", "name_zh": "", "category": "pg_stat_io", "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.", "aliases": ["context", "pg_stat_io"], "content_hash": "03a1bec6b4d150a85efa4e0cb2aa1da3e2d64a686798d65dcc14f5ea49c0cc3c", "versions": {"16": {"view": "pg_stat_io", "facts": [{"label": "View", "value": "pg_stat_io"}, {"label": "Field", "value": "context"}, {"label": "SQL type", "value": "text"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "Time at which these statistics were last reset."}], "field": "context", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_io/?v=16", "label": "pg_stat_io columns"}, {"url": "/docs/16/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "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": "/docs/16/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 16 English manual", "sha256": "a4c274defe8a41ff2895040cd542b5499063b844669ff3336de1a1317c3fe086"}], "sections": [{"title": "View semantics", "paragraphs": ["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."]}, {"title": "Collection and reset context", "paragraphs": ["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "text", "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "documented": true, "description": ["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."], "manual_html": "", "manual_path": "/docs/16/monitoring-stats.html", "source_only": false, "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": "View", "value": "pg_stat_io"}, {"label": "Field", "value": "context"}, {"label": "SQL type", "value": "text"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "Time at which these statistics were last reset."}], "field": "context", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_io/?v=17", "label": "pg_stat_io columns"}, {"url": "/docs/17/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "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"}], "sections": [{"title": "View semantics", "paragraphs": ["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."]}, {"title": "Collection and reset context", "paragraphs": ["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "text", "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "documented": true, "description": ["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."], "manual_html": "", "manual_path": "/docs/17/monitoring-stats.html", "source_only": false, "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": "View", "value": "pg_stat_io"}, {"label": "Field", "value": "context"}, {"label": "SQL type", "value": "text"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "Time at which these statistics were last reset."}], "field": "context", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_io/?v=18", "label": "pg_stat_io columns"}, {"url": "/docs/18/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "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"}], "sections": [{"title": "View semantics", "paragraphs": ["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."]}, {"title": "Collection and reset context", "paragraphs": ["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "text", "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "documented": true, "description": ["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."], "manual_html": "", "manual_path": "/docs/18/monitoring-stats.html", "source_only": false, "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": "View", "value": "pg_stat_io"}, {"label": "Field", "value": "context"}, {"label": "SQL type", "value": "text"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "Time at which these statistics were last reset."}], "field": "context", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_io/?v=19", "label": "pg_stat_io columns"}, {"url": "/docs/19/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "/docs/19/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 19 English manual", "sha256": "26e1b6632bdf05ebe081987cb60ab4ded526eec7db73e41316fbd69466c494fe"}], "sections": [{"title": "View semantics", "paragraphs": ["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."]}, {"title": "Collection and reset context", "paragraphs": ["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "text", "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "documented": true, "description": ["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."], "manual_html": "", "manual_path": "/docs/19/monitoring-stats.html", "source_only": false, "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": "View", "value": "pg_stat_io"}, {"label": "Field", "value": "context"}, {"label": "SQL type", "value": "text"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "Time at which these statistics were last reset."}], "field": "context", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_io/?v=20", "label": "pg_stat_io columns"}, {"url": "/docs/devel/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "/docs/devel/monitoring-stats.html#PG-STAT-IO-VIEW", "path": "monitoring-stats.html", "label": "PostgreSQL 20 English manual", "sha256": "dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251"}], "sections": [{"title": "View semantics", "paragraphs": ["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."]}, {"title": "Collection and reset context", "paragraphs": ["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "text", "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "documented": true, "description": ["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."], "manual_html": "", "manual_path": "/docs/devel/monitoring-stats.html", "source_only": false, "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": "View", "value": "pg_stat_io"}, {"label": "Field", "value": "context"}, {"label": "SQL type", "value": "text"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "Time at which these statistics were last reset."}], "field": "context", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_io/?v=18", "label": "pg_stat_io columns"}, {"url": "/docs/18/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "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"}], "sections": [{"title": "View semantics", "paragraphs": ["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."]}, {"title": "Collection and reset context", "paragraphs": ["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."]}, {"code": "SELECT context FROM pg_catalog.pg_stat_io;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "text", "signature": "SELECT context FROM pg_catalog.pg_stat_io;", "documented": true, "description": ["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."], "manual_html": "", "manual_path": "/docs/18/monitoring-stats.html", "source_only": false, "comparison_data": {"view": "pg_stat_io", "field": "context", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "9b45bae767bdbc5ac5dbb33aeb424ef31004ac1e05f18d84666962894ca0b8fa", "units_mentioned": []}, "comparison": {"left": "15", "right": "16", "status": "added", "diff": "--- PostgreSQL 15\n+++ PostgreSQL 16\n@@ -1 +1,6 @@\n-Not recorded in this version\n+{\n+  \"field\": \"context\",\n+  \"sql_type\": \"text\",\n+  \"units_mentioned\": [],\n+  \"view\": \"pg_stat_io\"\n+}"}}