CREATE STATISTICS - multicolumn
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.
Performance
Description
CREATE STATISTICS provides the ability to collect statistics over multiple columns, which can be used by the optimizer to generate better query plans.
https://www.postgresql.org/docs/current/sql-createstatistics.html
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 317
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "create-statistics-multicolumn",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "CREATE STATISTICS - multicolumn",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "CREATE STATISTICS - multicolumn",
"NameLocale": "en",
"GroupKey": "performance",
"GroupName": "Performance",
"GroupLocale": "en",
"Ordinal": 8,
"GroupOrder": 5,
"Facts": {
"feature": {
"description": "CREATE STATISTICS provides the ability to collect statistics over multiple columns, which can be used by the optimizer to generate better query plans.\r\n\r\nhttps://www.postgresql.org/docs/current/sql-createstatistics.html",
"name": "CREATE STATISTICS - multicolumn",
"versions": {
"10": "Yes"
}
},
"group": "Performance",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "10",
"Supported": true,
"Original": "Yes"
},
{
"Version": "11",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "10",
"Supported": true,
"Original": "Yes"
},
{
"Version": "12",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "10",
"Supported": true,
"Original": "Yes"
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "10",
"Supported": true,
"Original": "Yes"
},
{
"Version": "14",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "10",
"Supported": true,
"Original": "Yes"
},
{
"Version": "15",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "10",
"Supported": true,
"Original": "Yes"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "10",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "10",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "10",
"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": "CREATE STATISTICS - multicolumn",
"BodyHTML": "\u003cp\u003eCREATE STATISTICS provides the ability to collect statistics over multiple columns, which can be used by the optimizer to generate better query plans.\u003c/p\u003e\n\u003cp\u003ehttps://www.postgresql.org/docs/current/sql-createstatistics.html\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "c1d96a82d9ef6f9838238a4f0e87a5a2b67896628ad5d738854065d11a24f28e",
"Payload": {
"description": "CREATE STATISTICS provides the ability to collect statistics over multiple columns, which can be used by the optimizer to generate better query plans.\r\n\r\nhttps://www.postgresql.org/docs/current/sql-createstatistics.html",
"name": "CREATE STATISTICS - multicolumn",
"versions": {
"10": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "CREATE STATISTICS - 多列",
"BodyHTML": "\u003cp\u003eCREATE STATISTICS 提供了收集多列统计信息的能力，优化器可以使用这些信息生成更好的查询计划。\u003c/p\u003e\n\u003cp\u003ehttps://www.postgresql.org/docs/current/sql-createstatistics.html\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "aa6cea0895430905a97fdee892397b37e696e295f46a31e1ec20c0d5727c89ba",
"Payload": {
"description": "CREATE STATISTICS 提供了收集多列统计信息的能力，优化器可以使用这些信息生成更好的查询计划。\n\nhttps://www.postgresql.org/docs/current/sql-createstatistics.html",
"name": "CREATE STATISTICS - 多列"
}
}
],
"GroupTitles": {
"en": "Performance",
"zh-Hans": "性能"
},
"LegacyIDs": [
"317"
]
}