PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

FUNCTIONS / SYSTEM ADMINISTRATION FUNCTIONS

pg_clear_extended_stats

Clears data of an extended statistics object, as though the object was newly-created.

Development snapshot. These definitions may change before release.

Signatures & examples

pg_clear_extended_stats ( schemaname name, relname name, statistics_schemaname name, statistics_name name, inherited boolean ) → void

Clears data of an extended statistics object, as though the object was newly-created. The required arguments are schemaname and relname to specify the schema and table name of the relation whose statistics are cleared, as well as statistics_schemaname and statistics_name to specify the schema and extended statistics name of the extended statistics object to clear.

Version history 1

PG 18 → 19added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source