EXPLAIN (WAL) support
Recorded source states and original language descriptions. Missing version evidence stays unknown.
The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.
Backend
Description
EXPLAIN can now track WAL usage information along with auto_explain, autovacuum, and pg_stat_statements.
For more information, please see the documentation on EXPLAIN.
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 348
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "explain-wal-support",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "EXPLAIN (WAL) support",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "EXPLAIN (WAL) support",
"NameLocale": "en",
"GroupKey": "backend",
"GroupName": "Backend",
"GroupLocale": "en",
"Ordinal": 8,
"GroupOrder": 0,
"Facts": {
"feature": {
"description": "[EXPLAIN](https://www.postgresql.org/docs/13/sql-explain.html) can now track WAL usage information along with [auto_explain](https://www.postgresql.org/docs/13/auto-explain.html), [autovacuum](https://www.postgresql.org/docs/13/routine-vacuuming.html#AUTOVACUUM), and [pg_stat_statements](https://www.postgresql.org/docs/13/pgstatstatements.html).\r\n\r\nFor more information, please see the documentation on [EXPLAIN](https://www.postgresql.org/docs/13/sql-explain.html).",
"name": "EXPLAIN (WAL) support",
"versions": {
"13": "Yes"
}
},
"group": "Backend",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "11",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "12",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "13",
"Supported": true,
"Original": "Yes"
},
{
"Version": "14",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "13",
"Supported": true,
"Original": "Yes"
},
{
"Version": "15",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "13",
"Supported": true,
"Original": "Yes"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "13",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "13",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "13",
"Supported": true,
"Original": "Yes"
},
{
"Version": "8.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.0",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.5",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.6",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
}
],
"Texts": [
{
"Locale": "en",
"Title": "EXPLAIN (WAL) support",
"BodyHTML": "\u003cp\u003e\u003ca href=\"https://www.postgresql.org/docs/13/sql-explain.html\" rel=\"nofollow\"\u003eEXPLAIN\u003c/a\u003e can now track WAL usage information along with \u003ca href=\"https://www.postgresql.org/docs/13/auto-explain.html\" rel=\"nofollow\"\u003eauto_explain\u003c/a\u003e, \u003ca href=\"https://www.postgresql.org/docs/13/routine-vacuuming.html#AUTOVACUUM\" rel=\"nofollow\"\u003eautovacuum\u003c/a\u003e, and \u003ca href=\"https://www.postgresql.org/docs/13/pgstatstatements.html\" rel=\"nofollow\"\u003epg_stat_statements\u003c/a\u003e.\u003c/p\u003e\n\u003cp\u003eFor more information, please see the documentation on \u003ca href=\"https://www.postgresql.org/docs/13/sql-explain.html\" rel=\"nofollow\"\u003eEXPLAIN\u003c/a\u003e.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "676b2be6675733fb95dc943fa5f73e1861677b9361d4e8c9a139eb5f3a6b325b",
"Payload": {
"description": "[EXPLAIN](https://www.postgresql.org/docs/13/sql-explain.html) can now track WAL usage information along with [auto_explain](https://www.postgresql.org/docs/13/auto-explain.html), [autovacuum](https://www.postgresql.org/docs/13/routine-vacuuming.html#AUTOVACUUM), and [pg_stat_statements](https://www.postgresql.org/docs/13/pgstatstatements.html).\r\n\r\nFor more information, please see the documentation on [EXPLAIN](https://www.postgresql.org/docs/13/sql-explain.html).",
"name": "EXPLAIN (WAL) support",
"versions": {
"13": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "EXPLAIN (WAL) 支持",
"BodyHTML": "\u003cp\u003e\u003ca href=\"https://www.postgresql.org/docs/13/sql-explain.html\" rel=\"nofollow\"\u003eEXPLAIN\u003c/a\u003e 现在可以跟踪 WAL 使用信息，同时支持 \u003ca href=\"https://www.postgresql.org/docs/13/auto-explain.html\" rel=\"nofollow\"\u003eauto_explain\u003c/a\u003e、\u003ca href=\"https://www.postgresql.org/docs/13/routine-vacuuming.html#AUTOVACUUM\" rel=\"nofollow\"\u003eautovacuum\u003c/a\u003e 和 \u003ca href=\"https://www.postgresql.org/docs/13/pgstatstatements.html\" rel=\"nofollow\"\u003epg_stat_statements\u003c/a\u003e。\u003c/p\u003e\n\u003cp\u003e更多信息请参阅 \u003ca href=\"https://www.postgresql.org/docs/13/sql-explain.html\" rel=\"nofollow\"\u003eEXPLAIN\u003c/a\u003e 文档。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "f653208cd466685fe5f1680cc15e91bd75bc156d5112e26b1f1f088aeeeb32fe",
"Payload": {
"description": "[EXPLAIN](https://www.postgresql.org/docs/13/sql-explain.html) 现在可以跟踪 WAL 使用信息，同时支持 [auto_explain](https://www.postgresql.org/docs/13/auto-explain.html)、[autovacuum](https://www.postgresql.org/docs/13/routine-vacuuming.html#AUTOVACUUM) 和 [pg_stat_statements](https://www.postgresql.org/docs/13/pgstatstatements.html)。\n\n更多信息请参阅 [EXPLAIN](https://www.postgresql.org/docs/13/sql-explain.html) 文档。",
"name": "EXPLAIN (WAL) 支持"
}
}
],
"GroupTitles": {
"en": "Backend",
"zh-Hans": "后端"
},
"LegacyIDs": [
"348"
]
}