DROP STATISTICS
DROP STATISTICS — Remove extended statistics
Synopsis
DROP STATISTICS [ IF EXISTS ] name [, ...]
Description
DROP STATISTICS removes statistics objects from the database. Only the owner of the statistics object, the owner of the schema, or a superuser can drop a statistics object.
Parameters
IF EXISTS
name
The name of the statistics object to remove (optionally schema-qualified).
Examples
# Drop two statistics objects in different schemas, without failing if they do not exist:
DROP STATISTICS IF EXISTS
accounting.users_uid_creation,
public.grants_user_role;