Browse categories
PostgreSQL releases
- PostgreSQL 15 (dev)
- PostgreSQL 14 (latest)
- PostgreSQL 13
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Useful links
Categories
See also

CREATE STATISTICS

A DDL command for creating an extended statistics object

CREATE STATISTICS is a DDL command for creating an extended statistics object.

CREATE STATISTICS was added in PostgreSQL 10.

Change history

PostgreSQL 14
- support for extended statistics on expressions added (commit a4d75c86)
PostgreSQL 10
- added (commit 7b504eb2)

References

PostgreSQL documentation: CREATE STATISTICS

Useful links

PostgreSQL: CREATE STATISTICS – advanced query optimization - February 2021 blog article by CyberTec

Categories

See also

ALTER STATISTICS, DROP STATISTICS, pg_stats_ext, pg_stats_ext_exprs