仅索引扫描
已记录的来源状态与原始语言说明；缺少版本证据时明确标为未知。
来源快照记录 PostgreSQL 8.1–18 的变化节点；历史矩阵独立记录 7.4–18 的状态。两者均未记录 PostgreSQL 19 或 20 的支持状态，较新版本明确保留为未知。这些来源声明与运行测量相互独立。
索引和约束
说明
也称为"覆盖索引"，当查询中的所有列都被索引覆盖时，允许直接从索引中获取数据来满足查询。这消除了之前必须访问表页面以获取可见性信息的要求，现在改为使用可见性映射来替代。
所选版本: PostgreSQL 18
支持
比较版本
原始文档链接
已记录旧标识: 217
完整来源事实与出处
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "index-only-scans",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "Index-only scans",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "Index-only scans",
"NameLocale": "en",
"GroupKey": "indexing-constraints",
"GroupName": "Indexing \u0026 Constraints",
"GroupLocale": "en",
"Ordinal": 13,
"GroupOrder": 2,
"Facts": {
"feature": {
"description": "Also known as \"covering indexes\", allows data in indexes to satisfy queries where all columns in a given query are covered by the index. This removes the requirement of having to visit the table pages, which was required previously to get visibility information, but now the visibility map is used instead.",
"name": "Index-only scans",
"versions": {
"9.2": "Yes"
}
},
"group": "Indexing \u0026 Constraints",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"Supported": true,
"Original": "Yes"
},
{
"Version": "11",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"Supported": true,
"Original": "Yes"
},
{
"Version": "12",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"Supported": true,
"Original": "Yes"
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"Supported": true,
"Original": "Yes"
},
{
"Version": "14",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"Supported": true,
"Original": "Yes"
},
{
"Version": "15",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"Supported": true,
"Original": "Yes"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"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": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.3",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.4",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.5",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.6",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.2",
"Supported": true,
"Original": "Yes"
}
],
"Texts": [
{
"Locale": "en",
"Title": "Index-only scans",
"BodyHTML": "\u003cp\u003eAlso known as \u0026#34;covering indexes\u0026#34;, allows data in indexes to satisfy queries where all columns in a given query are covered by the index. This removes the requirement of having to visit the table pages, which was required previously to get visibility information, but now the visibility map is used instead.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "1dcd2f571c7162af64022f4cb199574f3058702e4bc3341f98886dee4cd5b875",
"Payload": {
"description": "Also known as \"covering indexes\", allows data in indexes to satisfy queries where all columns in a given query are covered by the index. This removes the requirement of having to visit the table pages, which was required previously to get visibility information, but now the visibility map is used instead.",
"name": "Index-only scans",
"versions": {
"9.2": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "仅索引扫描",
"BodyHTML": "\u003cp\u003e也称为\u0026#34;覆盖索引\u0026#34;，当查询中的所有列都被索引覆盖时，允许直接从索引中获取数据来满足查询。这消除了之前必须访问表页面以获取可见性信息的要求，现在改为使用可见性映射来替代。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "a672d62ead0fa8266d117136b755697024813a643716aa603fd0ee97e4d09d60",
"Payload": {
"description": "也称为\"覆盖索引\"，当查询中的所有列都被索引覆盖时，允许直接从索引中获取数据来满足查询。这消除了之前必须访问表页面以获取可见性信息的要求，现在改为使用可见性映射来替代。",
"name": "仅索引扫描"
}
}
],
"GroupTitles": {
"en": "Indexing \u0026 Constraints",
"zh-Hans": "索引和约束"
},
"LegacyIDs": [
"217"
]
}