PG_GTT_STATS

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.