gp_stats_missing

The gp_toolkit.gp_stats_missing view shows tables that do not have statistics and therefore may require an ANALYZE be run on the table.

NOTE

By default, gp_stats_missing does not display data for materialized views. Refer to Use gp_toolkit for instructions on adding this data to the gp_stats_missing view output.

Column Description

Column	Description
smischema	Schema name
smitable	Table name
smisize	Whether this table has statistics. `false` if the table does not have row count and row sizing statistics recorded in the system catalog, which may indicate that the table needs to be analyzed. This will also be `false` if the table does not contain any rows. For example, the parent tables of partitioned tables are always empty and will always return a `false` result
smicols	Number of columns in the table
smirecs	The total number of columns in the table that have statistics recorded

smischema

Schema name

smitable

Table name

smisize

Whether this table has statistics. false if the table does not have row count and row sizing statistics recorded in the system catalog, which may indicate that the table needs to be analyzed. This will also be false if the table does not contain any rows. For example, the parent tables of partitioned tables are always empty and will always return a false result

smicols

Number of columns in the table

smirecs

The total number of columns in the table that have statistics recorded

gp_skew_idle_fractions

gp_table_indexes