\dP
列出分区关系。如果 pattern 被指定，则只列出名称与模式匹配的条目。修饰符 t （表）和 i （索引）可以附加到命令，过滤要列出的关系类型。默认情况下，列出分区表和索引。
当前查看 PostgreSQL 18.6。
说明
列出分区关系。如果 pattern 被指定，则只列出名称与模式匹配的条目。修饰符 t （表）和 i （索引）可以附加到命令，过滤要列出的关系类型。默认情况下，列出分区表和索引。
- 客户端
- psql 18.6
- 区分大小写的写法
- \dP
用法
\dP[itnx+] [ pattern ]本版手册中的写法
| 命令 | 手册中的后缀修饰符 |
|---|---|
| \dP | itnx+ |
手册定义
\dP[itnx+] [pattern]-
列出分区关系。如果
pattern被指定，则只列出名称与模式匹配的条目。修饰符t（表）和i（索引）可以附加到命令，过滤要列出的关系类型。默认情况下，列出分区表和索引。如果使用修饰符
n（“nested”），或指定了模式，则将包括非根分区关系，并显示一列，给出每个分区关系的父级。如果在命令名后追加
x，结果会以扩展模式显示。如果在命令名后追加+，则还会显示每个关系分区大小的总和以及关系描述。如果n与+组合使用，则会显示两个大小：一个包括直接附加的叶分区的总大小，另一个显示包括间接附加子分区在内的所有分区总大小。
相关条目
文档与源码
来源构建
- 版本
- 18.6
- 构建
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- 来源指纹
ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8
版本比较
PostgreSQL 17 → 18: 属性变化。
以下差异保留原始字段名与英文源描述。
--- PostgreSQL 17
+++ PostgreSQL 18
@@ -1,12 +1,12 @@
{
- "definition": "Lists partitioned relations. If pattern is specified, only entries whose name matches the pattern are listed. The modifiers t (tables) and i (indexes) can be appended to the command, filtering the kind of relations to list. By default, partitioned tables and indexes are listed. If the modifier n ( “ nested ” ) is used, or a pattern is specified, then non-root partitioned relations are included, and a column is shown displaying the parent of each partitioned relation. If + is appended to the command name, the sum of the sizes of each relation's partitions is also displayed, along with the relation's description. If n is combined with + , two sizes are shown: one including the total size of directly-attached leaf partitions, and another showing the total size of all partitions, including indirectly attached sub-partitions.",
+ "definition": "Lists partitioned relations. If pattern is specified, only entries whose name matches the pattern are listed. The modifiers t (tables) and i (indexes) can be appended to the command, filtering the kind of relations to list. By default, partitioned tables and indexes are listed. If the modifier n ( “ nested ” ) is used, or a pattern is specified, then non-root partitioned relations are included, and a column is shown displaying the parent of each partitioned relation. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, the sum of the sizes of each relation's partitions is also displayed, along with the relation's description. If n is combined with + , two sizes are shown: one including the total size of directly-attached leaf partitions, and another showing the total size of all partitions, including indirectly attached sub-partitions.",
"modifiers": [
{
"command": "\\dP",
- "modifiers": "itn+"
+ "modifiers": "itnx+"
}
],
- "signature": "\\dP[itn+] [ pattern ]",
+ "signature": "\\dP[itnx+] [ pattern ]",
"spellings": [
"\\dP"
]比较已记录的接口与属性，排除来源指纹和构建元数据。某个样本中没有记录，不能据此判断实际引入或移除的版本。
相关条目
导出 JSON · 返回psql 命令 · 收录范围为 PostgreSQL 12 至 20；最早采样版本不一定是实际引入版本。