SHOW STATISTICS (Experimental)

2020-02-16

New in v2.1: The SHOW STATISTICS statement lists table statistics used by the cost-based optimizer.

{{site.data.alerts.callout_danger}} This is an experimental feature. The interface and output are subject to change. {{site.data.alerts.end}}

Synopsis

{% include {{ page.version.version }}/sql/diagrams/show_stats.html %}

Required Privileges

No privileges are required to list table statistics.

Parameters

Parameter | Description ---------------+--------------- table_name | The name of the table you want to view statistics for.

Examples

List table statistics

> CREATE STATISTICS students ON id FROM students_by_list;
CREATE STATISTICS
> SHOW STATISTICS FOR TABLE students_by_list;
  statistics_name | column_names |             created              | row_count | distinct_count | null_count | histogram_id
+-----------------+--------------+----------------------------------+-----------+----------------+------------+--------------+
  students        | {"id"}       | 2018-10-26 15:06:34.320165+00:00 |         0 |              0 |          0 |         NULL
(1 row)

See Also