All Classes and Interfaces

Class
Description
Check for B-tree indexes on array columns on all hosts in the cluster.
Utility class providing various collection-related utility methods.
Check for columns whose names do not follow naming convention (that have to be enclosed in double-quotes) on all hosts in the cluster.
Check for columns with fixed length varchar type on all hosts in the cluster.
Check for columns with json type on all hosts in the cluster.
Check for columns without description on all hosts in the cluster.
Check for columns of serial types that are not primary keys on all hosts in the cluster.
An abstract check on database structure.
 
Implementation of DatabaseManagement.
Check for duplicated (completely identical) foreign keys on all hosts in the cluster.
Check for duplicated (completely identical) indexes on all hosts in the cluster.
Check for foreign keys without associated indexes on all hosts in the cluster.
Check for foreign keys where the type of the constrained column does not match the type in the referenced table on all hosts in the cluster.
Check for procedures/functions without description on all hosts in the cluster.
Check for indexes bloat on all hosts in the cluster.
Check for indexes that contain boolean values on all hosts in the cluster.
Check for indexes with null values on all hosts in the cluster.
Check for indexes with unnecessary where-clause on not null column on all hosts in the cluster.
Check for intersected (partially identical) foreign keys on all hosts in the cluster.
Check for intersected (partially identical) indexes on all hosts in the cluster.
Check for invalid (broken) indexes on all hosts in the cluster.
Check for not valid constraint on all hosts in the cluster.
Check for objects whose names do not follow naming convention (that have to be enclosed in double-quotes) on all hosts in the cluster.
Check for objects whose names have a length of max_identifier_length (usually it is 63) on all hosts in the cluster.
Check for primary keys that are most likely natural keys on all hosts in the cluster.
Check for primary keys columns with serial types (smallserial/serial/bigserial) on all hosts in the cluster.
Check for primary keys with columns of fixed length varchar(32/36/38) type on all hosts in the cluster.
Check for sequence overflow on all hosts in the cluster.
Check for tables that are not linked to other tables on all hosts in the cluster.
Check for tables bloat on all hosts in the cluster.
Check for tables with missing indexes on all hosts in the cluster.
Check for tables without description on all hosts in the cluster.
Check for tables without primary key on all hosts in the cluster.
Check for tables with zero or one column on all hosts in the cluster.
Check for unused indexes on all hosts in the cluster.