仅索引扫描
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.
No translation of this description is recorded. The original Chinese description is shown. The source label is retained in Chinese; no translated label is recorded.
索引和约束
Description
也称为"覆盖索引"，当查询中的所有列都被索引覆盖时，允许直接从索引中获取数据来满足查询。这消除了之前必须访问表页面以获取可见性信息的要求，现在改为使用可见性映射来替代。
Selected version: PostgreSQL 18
No
Compare versions
Original documentation links
Related source snapshot entry · The original source supplies this relationship; each matrix retains its own states.
Complete source facts and provenance
legacy · center · cb4c66080e565f5ffc077205ebd67d781b1679b5fa3105c708faba4e5854925f
{
"Key": "217",
"SourceKind": "legacy",
"SourceDatabase": "center",
"SourceTable": "featurematrix_feature",
"SourceKey": "217",
"SourceHash": "cb4c66080e565f5ffc077205ebd67d781b1679b5fa3105c708faba4e5854925f",
"Name": "仅索引扫描",
"NameLocale": "zh-Hans",
"GroupKey": "13",
"GroupName": "索引和约束",
"GroupLocale": "zh-Hans",
"Ordinal": 0,
"GroupOrder": 4,
"Facts": {
"featuredescription": "也称为\"覆盖索引\"，当查询中的所有列都被索引覆盖时，允许直接从索引中获取数据来满足查询。这消除了之前必须访问表页面以获取可见性信息的要求，现在改为使用可见性映射来替代。",
"featurename": "仅索引扫描",
"group_id": 13,
"id": 217,
"v10": 1,
"v11": 1,
"v12": 1,
"v13": 1,
"v14": 0,
"v15": 0,
"v16": 0,
"v17": 0,
"v18": 0,
"v74": 0,
"v80": 0,
"v81": 0,
"v82": 0,
"v83": 0,
"v84": 0,
"v90": 0,
"v91": 0,
"v92": 1,
"v93": 1,
"v94": 1,
"v95": 1,
"v96": 1
},
"Cells": [
{
"Version": "10",
"State": "yes",
"EvidenceKind": "legacy-database:v10",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "11",
"State": "yes",
"EvidenceKind": "legacy-database:v11",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "12",
"State": "yes",
"EvidenceKind": "legacy-database:v12",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "legacy-database:v13",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "14",
"State": "no",
"EvidenceKind": "legacy-database:v14",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "15",
"State": "no",
"EvidenceKind": "legacy-database:v15",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "16",
"State": "no",
"EvidenceKind": "legacy-database:v16",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "17",
"State": "no",
"EvidenceKind": "legacy-database:v17",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "18",
"State": "no",
"EvidenceKind": "legacy-database:v18",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "7.4",
"State": "no",
"EvidenceKind": "legacy-database:v74",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.0",
"State": "no",
"EvidenceKind": "legacy-database:v80",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.1",
"State": "no",
"EvidenceKind": "legacy-database:v81",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.2",
"State": "no",
"EvidenceKind": "legacy-database:v82",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.3",
"State": "no",
"EvidenceKind": "legacy-database:v83",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.4",
"State": "no",
"EvidenceKind": "legacy-database:v84",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.0",
"State": "no",
"EvidenceKind": "legacy-database:v90",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.1",
"State": "no",
"EvidenceKind": "legacy-database:v91",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.2",
"State": "yes",
"EvidenceKind": "legacy-database:v92",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "9.3",
"State": "yes",
"EvidenceKind": "legacy-database:v93",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "9.4",
"State": "yes",
"EvidenceKind": "legacy-database:v94",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "9.5",
"State": "yes",
"EvidenceKind": "legacy-database:v95",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "9.6",
"State": "yes",
"EvidenceKind": "legacy-database:v96",
"TransitionVersion": "",
"Supported": true,
"Original": 1
}
],
"Texts": [
{
"Locale": "zh-Hans",
"Title": "仅索引扫描",
"BodyHTML": "\u003cp\u003e也称为\u0026#34;覆盖索引\u0026#34;，当查询中的所有列都被索引覆盖时，允许直接从索引中获取数据来满足查询。这消除了之前必须访问表页面以获取可见性信息的要求，现在改为使用可见性映射来替代。\u003c/p\u003e\n",
"SourceHash": "cb4c66080e565f5ffc077205ebd67d781b1679b5fa3105c708faba4e5854925f",
"ContentHash": "a672d62ead0fa8266d117136b755697024813a643716aa603fd0ee97e4d09d60",
"Payload": {
"description": "也称为\"覆盖索引\"，当查询中的所有列都被索引覆盖时，允许直接从索引中获取数据来满足查询。这消除了之前必须访问表页面以获取可见性信息的要求，现在改为使用可见性映射来替代。",
"name": "仅索引扫描"
}
}
],
"GroupTitles": {
"zh-Hans": "索引和约束"
},
"RelatedKey": "index-only-scans"
}