{"Entry":{"collection":"func","key":"pg-mcv-list-items","name":"pg_mcv_list_items","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"11","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"12"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"687fadd57211b60ed779689e7b49b9cc8a4ac4192e8c8fb421047c0981ea65ca","derived_content_hash":"9dfab8407b32c9d1fe544e1103ea2824cbc611088995fb98ca75a21a80b9a0c5","first_version":"12","group":"statistics","group_label":"Statistics Information Functions","groups":["statistics"],"imported_at":"2026-09-27T17:57:29.746836+08:00","last_version":"20","name":"pg_mcv_list_items","name_key":"pg_mcv_list_items","position":32000,"present_in":["12","13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"wiki-repair-20261023:9f5d145789c6969a95dc59c7f58768f8c7f11f13355ef80b9d194803e363527e","receipt_sha256":"d7dd5366b059380b189bde29033f124b07f2de160b2f213a0f9d9b012715dd50","repair":"wiki-repair-20261023"},"signature":"pg_mcv_list_items ( pg_mcv_list ) → setof record","signature_count":1,"slug":"pg-mcv-list-items","source_rev":"wiki-repair-20261023:ca76d09135eda2aa5aa678ab548899a13db5c4a891eef816c581f70ad8843231","summary":"pg_mcv_list_items returns a set of records describing all items stored in a multi-column MCV list.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-mcv-list-items","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-mcv-list-items","SourceRevision":"wiki-repair-20261023:ca76d09135eda2aa5aa678ab548899a13db5c4a891eef816c581f70ad8843231","Facts":{"description":"pg_mcv_list_items returns a set of records describing all items stored in a multi-column MCV list. It returns the following columns:","description_html":"\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e returns a set of records describing all items stored in a multi-column MCV list. It returns the following columns:","description_zh":"pg_mcv_list_items 返回一组记录，描述存储在多列 MCV 列表中的所有项目。它返回以下列：","description_zh_html":"\u003cp\u003e同版本手册中的相关说明：\u003c/p\u003e\u003cpre class=\"synopsis\"\u003e\n\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e ( \u003ccode class=\"type\"\u003epg_mcv_list\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e\n\u003c/pre\u003e\u003cp\u003e\n\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e 返回一组记录，描述存储在多列 \u003cacronym class=\"acronym\"\u003eMCV\u003c/acronym\u003e 列表中的所有项目。它返回以下列：\n\n    \u003c/p\u003e\u003cdiv class=\"informaltable\"\u003e\u003ctable border=\"1\" class=\"informaltable\"\u003e\u003ccolgroup\u003e\u003ccol/\u003e\u003ccol/\u003e\u003ccol/\u003e\u003c/colgroup\u003e\u003cthead\u003e\u003ctr\u003e\u003cth\u003e名称\u003c/th\u003e\u003cth\u003e类型\u003c/th\u003e\u003cth\u003e描述\u003c/th\u003e\u003c/tr\u003e\u003c/thead\u003e\u003ctbody\u003e\u003ctr\u003e\u003ctd\u003e\u003ccode class=\"literal\"\u003eindex\u003c/code\u003e\u003c/td\u003e\u003ctd\u003e\u003ccode class=\"type\"\u003einteger\u003c/code\u003e\u003c/td\u003e\u003ctd\u003e \u003cacronym class=\"acronym\"\u003eMCV\u003c/acronym\u003e 列表中的项目索引\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003ccode class=\"literal\"\u003evalues\u003c/code\u003e\u003c/td\u003e\u003ctd\u003e\u003ccode class=\"type\"\u003etext[]\u003c/code\u003e\u003c/td\u003e\u003ctd\u003e存储在 MCV 项目中的值\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003ccode class=\"literal\"\u003enulls\u003c/code\u003e\u003c/td\u003e\u003ctd\u003e\u003ccode class=\"type\"\u003eboolean[]\u003c/code\u003e\u003c/td\u003e\u003ctd\u003e标识 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e 值的标志\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003ccode class=\"literal\"\u003efrequency\u003c/code\u003e\u003c/td\u003e\u003ctd\u003e\u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e\u003c/td\u003e\u003ctd\u003e\u003cacronym class=\"acronym\"\u003eMCV\u003c/acronym\u003e 项目的频率\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003ccode class=\"literal\"\u003ebase_frequency\u003c/code\u003e\u003c/td\u003e\u003ctd\u003e\u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e\u003c/td\u003e\u003ctd\u003e\u003cacronym class=\"acronym\"\u003eMCV\u003c/acronym\u003e 项目的基础频率\u003c/td\u003e\u003c/tr\u003e\u003c/tbody\u003e\u003c/table\u003e\u003c/div\u003e\u003cp\u003e\n\u003c/p\u003e\u003cp\u003e\n\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e 函数可以这样使用：\n\n\u003c/p\u003e\u003cpre class=\"programlisting\"\u003e\nSELECT m.* FROM pg_statistic_ext join pg_statistic_ext_data on (oid = stxoid),\n                pg_mcv_list_items(stxdmcv) m WHERE stxname = 'stts';\n\u003c/pre\u003e\u003cp\u003e\n\u003ccode class=\"type\"\u003epg_mcv_list\u003c/code\u003e 类型的值只能从 \u003ccode class=\"structname\"\u003epg_statistic_ext_data\u003c/code\u003e.\u003ccode class=\"structfield\"\u003estxdmcv\u003c/code\u003e 列中获取。\n   \u003c/p\u003e","doc":{"anchor":"FUNCTIONS-STATISTICS-MCV","file":"functions-statistics.html","slug":"18"},"group":"statistics","group_label":"Statistics Information Functions","lang":"en","layout":"table-new","pages":["functions-statistics.html"],"prose_only":false,"signatures":[{"description":"pg_mcv_list_items returns a set of records describing all items stored in a multi-column MCV list. It returns the following columns:","description_html":"\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e returns a set of records describing all items stored in a multi-column MCV list. It returns the following columns:","description_zh":"pg_mcv_list_items 返回一组记录，描述存储在多列 MCV 列表中的所有项目。它返回以下列：","description_zh_html":"\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e 返回一组记录，描述存储在多列 \u003cacronym class=\"acronym\"\u003eMCV\u003c/acronym\u003e 列表中的所有项目。它返回以下列：","examples":[],"html":"\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e ( \u003ccode class=\"type\"\u003epg_mcv_list\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e","returns":"setof record","text":"pg_mcv_list_items ( pg_mcv_list ) → setof record","translation_provenance":{"entry":{"key":"pg-mcv-list-items","signature_index":0,"version":"18"},"inputs":[],"kind":"same-version-chinese-manual-exact-paragraph-or-cell","locale":"zh-Hans","source_hashes":{"/Users/vonng/pgsty/pgdoc/en/18.6/html/functions-statistics.html":"d65f8acf93b498c24d5c4e88e6c8606b5ac5770d3b8ab183b4289d7b91509bd0","/Users/vonng/pgsty/pgdoc/zh/18/html/functions-statistics.html":"12536767000e086712f862899623a7b747e563917deb73eaeabea9728ae33feb","chinese_fragment_sha256":"406042ac8f8614aa40d9ee8da22734a38a6c8e903d816e55e57ceb9ddb744e9b","original_english_description_sha256":"e9fb70acf4c5d7d805ce7c89c564aa0467765d4370b0e5fc688020d9caa02fc5"},"source_paths":["/Users/vonng/pgsty/pgdoc/en/18.6/html/functions-statistics.html","/Users/vonng/pgsty/pgdoc/zh/18/html/functions-statistics.html"],"translation_ledger":{"kind":"reviewed-signature-description-ledger","path":"/Users/vonng/pgsty/pg.center/tmp/wiki-repair-20261023/core/signature-translations.json","sha256":"0addc72547dfaa642f2673ad85e898c6317517a79985ed470234ff47123d7f15"},"version":"18"},"zh_from":"same-version-chinese-manual-exact-paragraph-or-cell"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-statistics.html","sha256":"12536767000e086712f862899623a7b747e563917deb73eaeabea9728ae33feb"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-STATISTICS-MCV","file":"functions-statistics.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-mcv-list-items","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_mcv_list_items","Summary":"pg_mcv_list_items returns a set of records describing all items stored in a multi-column MCV list. It returns the following columns:","BodyHTML":"\u003ccode\u003epg_mcv_list_items\u003c/code\u003e returns a set of records describing all items stored in a multi-column MCV list. It returns the following columns:","SourceRevision":"wiki-repair-20261023:ca76d09135eda2aa5aa678ab548899a13db5c4a891eef816c581f70ad8843231","ContentHash":"36384c063883a1c9f229ebcdef7c121840d50c25a73626a5237f20acbfabc714","Payload":{"description":"pg_mcv_list_items returns a set of records describing all items stored in a multi-column MCV list. It returns the following columns:","description_html":"\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e returns a set of records describing all items stored in a multi-column MCV list. It returns the following columns:","signatures":[{"description":"pg_mcv_list_items returns a set of records describing all items stored in a multi-column MCV list. It returns the following columns:","description_html":"\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e returns a set of records describing all items stored in a multi-column MCV list. It returns the following columns:","description_zh":"pg_mcv_list_items 返回一组记录，描述存储在多列 MCV 列表中的所有项目。它返回以下列：","description_zh_html":"\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e 返回一组记录，描述存储在多列 \u003cacronym class=\"acronym\"\u003eMCV\u003c/acronym\u003e 列表中的所有项目。它返回以下列：","examples":[],"html":"\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e ( \u003ccode class=\"type\"\u003epg_mcv_list\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e","returns":"setof record","text":"pg_mcv_list_items ( pg_mcv_list ) → setof record","translation_provenance":{"entry":{"key":"pg-mcv-list-items","signature_index":0,"version":"18"},"inputs":[],"kind":"same-version-chinese-manual-exact-paragraph-or-cell","locale":"zh-Hans","source_hashes":{"/Users/vonng/pgsty/pgdoc/en/18.6/html/functions-statistics.html":"d65f8acf93b498c24d5c4e88e6c8606b5ac5770d3b8ab183b4289d7b91509bd0","/Users/vonng/pgsty/pgdoc/zh/18/html/functions-statistics.html":"12536767000e086712f862899623a7b747e563917deb73eaeabea9728ae33feb","chinese_fragment_sha256":"406042ac8f8614aa40d9ee8da22734a38a6c8e903d816e55e57ceb9ddb744e9b","original_english_description_sha256":"e9fb70acf4c5d7d805ce7c89c564aa0467765d4370b0e5fc688020d9caa02fc5"},"source_paths":["/Users/vonng/pgsty/pgdoc/en/18.6/html/functions-statistics.html","/Users/vonng/pgsty/pgdoc/zh/18/html/functions-statistics.html"],"translation_ledger":{"kind":"reviewed-signature-description-ledger","path":"/Users/vonng/pgsty/pg.center/tmp/wiki-repair-20261023/core/signature-translations.json","sha256":"0addc72547dfaa642f2673ad85e898c6317517a79985ed470234ff47123d7f15"},"version":"18"},"zh_from":"same-version-chinese-manual-exact-paragraph-or-cell"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"e88cf660fa3b468d7b9ff82a856ef27cca9605c64b7d302f5bfa4fc8217df977","Text":"pg_mcv_list_items ( pg_mcv_list ) → setof record","Returns":"setof record","Payload":{"description":"pg_mcv_list_items returns a set of records describing all items stored in a multi-column MCV list. It returns the following columns:","description_html":"\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e returns a set of records describing all items stored in a multi-column MCV list. It returns the following columns:","description_zh":"pg_mcv_list_items 返回一组记录，描述存储在多列 MCV 列表中的所有项目。它返回以下列：","description_zh_html":"\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e 返回一组记录，描述存储在多列 \u003cacronym class=\"acronym\"\u003eMCV\u003c/acronym\u003e 列表中的所有项目。它返回以下列：","examples":[],"html":"\u003ccode class=\"function\"\u003epg_mcv_list_items\u003c/code\u003e ( \u003ccode class=\"type\"\u003epg_mcv_list\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e","returns":"setof record","text":"pg_mcv_list_items ( pg_mcv_list ) → setof record","translation_provenance":{"entry":{"key":"pg-mcv-list-items","signature_index":0,"version":"18"},"inputs":[],"kind":"same-version-chinese-manual-exact-paragraph-or-cell","locale":"zh-Hans","source_hashes":{"/Users/vonng/pgsty/pgdoc/en/18.6/html/functions-statistics.html":"d65f8acf93b498c24d5c4e88e6c8606b5ac5770d3b8ab183b4289d7b91509bd0","/Users/vonng/pgsty/pgdoc/zh/18/html/functions-statistics.html":"12536767000e086712f862899623a7b747e563917deb73eaeabea9728ae33feb","chinese_fragment_sha256":"406042ac8f8614aa40d9ee8da22734a38a6c8e903d816e55e57ceb9ddb744e9b","original_english_description_sha256":"e9fb70acf4c5d7d805ce7c89c564aa0467765d4370b0e5fc688020d9caa02fc5"},"source_paths":["/Users/vonng/pgsty/pgdoc/en/18.6/html/functions-statistics.html","/Users/vonng/pgsty/pgdoc/zh/18/html/functions-statistics.html"],"translation_ledger":{"kind":"reviewed-signature-description-ledger","path":"/Users/vonng/pgsty/pg.center/tmp/wiki-repair-20261023/core/signature-translations.json","sha256":"0addc72547dfaa642f2673ad85e898c6317517a79985ed470234ff47123d7f15"},"version":"18"},"zh_from":"same-version-chinese-manual-exact-paragraph-or-cell"}}],"Spellings":null,"SQLState":null,"Evidence":null}