PG_EXT_STATS
PG_EXT_STATS displays extension statistics stored in the PG_STATISTIC_EXT table. The extension statistics means multiple columns of statistics.
Name |
Type |
Reference |
Description |
---|---|---|---|
schemaname |
name |
PG_NAMESPACE.nspname |
Name of the schema that contains a table |
tablename |
name |
PG_CLASS.relname |
Name of a table |
attname |
int2vector |
PG_STATISTIC_EXT.stakey |
Indicates the columns to be combined for collecting statistics. |
inherited |
boolean |
- |
Includes inherited sub-columns if the value is true; otherwise, indicates the column in a specified table. |
null_frac |
real |
- |
Percentage of column combinations that are null to all records |
avg_width |
integer |
- |
Average width of column combinations. The unit is byte. |
n_distinct |
real |
- |
|
n_dndistinct |
real |
- |
Number of unique not-null data values in the dn1 column combination
|
most_common_vals |
anyarray |
- |
List of the most common values in a column combination. If this combination does not have the most common values, most_common_vals_null will be NULL. None of the most common values in most_common_vals is NULL. |
most_common_freqs |
real[] |
- |
List of the frequencies of the most common values, that is, the number of occurrences of each value divided by the total number of rows. (NULL if most_common_vals is NULL) |
most_common_vals_null |
anyarray |
- |
List of the most common values in a column combination. If this combination does not have the most common values, most_common_vals_null will be NULL. At least one of the common values in most_common_vals_null is NULL. |
most_common_freqs_null |
real[] |
- |
List of the frequencies of the most common values, that is, the number of occurrences of each value divided by the total number of rows. (NULL if most_common_vals_null is NULL) |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot