Statistics¶

Extended statistics on a table or materialized view (CREATE STATISTICS), which let the planner estimate columns that depend on each other

Properties¶

Property	Type	Required	Description
`name`	`string`	yes	Name.
`schema`	`string`	yes	Schema.
`owner`	`string`	yes	The role that owns the statistics object.
`table`	`string`	yes	The table or materialized view, schema-qualified.
`kinds`	array of (`ndistinct` \| `dependencies` \| `mcv`)	—	The kinds of statistics to collect; absent for all of them. Minimum items: `1`.
`elements`	array of `string`	yes	Each column, or a parenthesized expression, as written. Minimum items: `1`.
`target`	`integer`	—	ALTER STATISTICS ... SET STATISTICS.
`comment`	`string`	—	Comment.
`dependencies`	dependencies	—	Database objects this object is dependent upon.

No other properties are accepted.