HomeMogDBMogDB StackUqbar
v3.0

Documentation:v3.0

Supported Versions:

PG_GTT_STATS

PG_GTT_STATS displays statistics about a single column in all global temporary tables of the current session by calling pg_get_gtt_relstats.

Table 1 PG_GTT_STATS columns

Name Type Description
schemaname name Schema name.
tablename name Name of a global temporary table.
attname name Attribute name.
inherited boolean Specifies whether to collect statistics for objects that have inheritance relationship.
null_frac real Percentage of column entries that are null.
avg_width integer Average stored width, in bytes, of non-null entries.
n_distinct real Number of distinct, non-null data values in the column.
most_common_vals text[] List of the most common values, which is sorted by occurrence frequency.
most_common_freqs real[] Frequencies of the most common values.
histogram_bounds text[] Data distribution (excluding the most common values) in a frequency histogram description column.
correlation real Correlation coefficient.
most_common_elems text[] List of the most common element values, which is used for the array type or some other type.
most_common_elem_freqs real[] Frequencies of the most common element values.
elem_count_histogram real[] Array type histogram.
Copyright © 2011-2024 www.enmotech.com All rights reserved.