CREATE STATISTICS - "OR" and "IN/ANY" statistics
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
Extend statistics can help the query planner provided better plans for queries that have "OR".clauses as well as "IN/ANY" lookups over lists. For more information, please see https://www.postgresql.org/docs/13/planner-stats.html#PLANNER-STATS-EXTENDED
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 335
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "create-statistics-or-and-inany-statistics",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "CREATE STATISTICS - \"OR\" and \"IN/ANY\" statistics",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "CREATE STATISTICS - \"OR\" and \"IN/ANY\" statistics",
"NameLocale": "en",
"GroupKey": "performance",
"GroupName": "Performance",
"GroupLocale": "en",
"Ordinal": 9,
"GroupOrder": 5,
"Facts": {
"feature": {
"description": "Extend statistics can help the query planner provided better plans for queries that have \"OR\".clauses as well as \"IN/ANY\" lookups over lists. For more information, please see https://www.postgresql.org/docs/13/planner-stats.html#PLANNER-STATS-EXTENDED",
"name": "CREATE STATISTICS - \"OR\" and \"IN/ANY\" statistics",
"versions": {
"13": "Yes"
}
},
"group": "Performance",
"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": "CREATE STATISTICS - \"OR\" and \"IN/ANY\" statistics",
"BodyHTML": "\u003cp\u003eExtend statistics can help the query planner provided better plans for queries that have \u0026#34;OR\u0026#34;.clauses as well as \u0026#34;IN/ANY\u0026#34; lookups over lists. For more information, please see https://www.postgresql.org/docs/13/planner-stats.html#PLANNER-STATS-EXTENDED\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "eedd79531f8362968e97402f80d6723c32d4d3f85e1898384dede4a685d46760",
"Payload": {
"description": "Extend statistics can help the query planner provided better plans for queries that have \"OR\".clauses as well as \"IN/ANY\" lookups over lists. For more information, please see https://www.postgresql.org/docs/13/planner-stats.html#PLANNER-STATS-EXTENDED",
"name": "CREATE STATISTICS - \"OR\" and \"IN/ANY\" statistics",
"versions": {
"13": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "CREATE STATISTICS - \"OR\" 和 \"IN/ANY\" 统计信息",
"BodyHTML": "\u003cp\u003e扩展统计信息可以帮助查询规划器为具有 \u0026#34;OR\u0026#34; 子句以及 \u0026#34;IN/ANY\u0026#34; 列表查找的查询提供更好的计划。更多信息请参见 https://www.postgresql.org/docs/13/planner-stats.html#PLANNER-STATS-EXTENDED\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "2d951866ee4eb52bec1eb80599e2e71b315ccb39edc1cf0b9d5b84cf5027c3c2",
"Payload": {
"description": "扩展统计信息可以帮助查询规划器为具有 \"OR\" 子句以及 \"IN/ANY\" 列表查找的查询提供更好的计划。更多信息请参见 https://www.postgresql.org/docs/13/planner-stats.html#PLANNER-STATS-EXTENDED",
"name": "CREATE STATISTICS - \"OR\" 和 \"IN/ANY\" 统计信息"
}
}
],
"GroupTitles": {
"en": "Performance",
"zh-Hans": "性能"
},
"LegacyIDs": [
"335"
]
}