All Classes and Interfaces
Class
Description
AbstractCheckOnHost<T extends io.github.mfvanek.pg.model.dbobject.DbObject>
An abstract implementation of the
DatabaseCheckOnHost interface, providing
a framework for checks to be performed on a specific PostgreSQL host.A mapper from raw data to
AnyObject model.Check for B-tree indexes on array columns on a specific host.
Represents an entity that can identify, process, and execute SQL-based checks or diagnostics.
Allows getting information about check (diagnostic) name.
Allows getting information about check (diagnostic) type.
Utility class to work with
Clock.A mapper from raw data to
Column model.Utility class for parsing raw column information and generating
Column objects associated with a specific database table.Check for columns whose names do not follow the naming convention (that have to be enclosed in double-quotes) on a specific host.
Check for columns with a fixed length varchar type on a specific host.
Check for columns with
JSON type on a specific host.Check for columns with
money type on a specific host.Check for columns without description on a specific host.
Check for columns of serial types that are not primary keys on a specific host.
Check for columns with
timestamp or timetz type on a specific host.A mapper from raw data to
ColumnWithSerialType model.A mapper from raw data to
ColumnWithType model.A mapper from raw data to
Constraint model.DatabaseCheckOnHost<T extends io.github.mfvanek.pg.model.dbobject.DbObject>
Represents a check (or diagnostic) to be performed on a specific PostgreSQL host.
A list of standard diagnostics with corresponding SQL queries and query executors.
Check for duplicated (completely identical) foreign keys on a specific host.
A mapper from raw data to
DuplicatedForeignKeys model.Check for duplicated (completely identical) indexes on a specific host.
A mapper from raw data to
DuplicatedIndexes model.Defines the place where the diagnostic should be executed.
A mapper from raw data to
ForeignKey model.Check for foreign keys without associated indexes on a specific host.
Check for foreign keys where the type of the constrained column does not match the type in the referenced table on a specific host.
Check for procedures/functions without description on a specific host.
Check for indexes bloat on a specific host.
Check for indexes that contain boolean values on a specific host.
Check for indexes with null values on a specific host.
Check for indexes in which columns with the timestamp\timestamptz type are not the last on a specific host.
Check for indexes with unnecessary where-clause on a not null column on a specific host.
A mapper from raw data to
Index model.A mapper from raw data to
IndexWithBloat model.A mapper from raw data with multiple columns to
IndexWithColumns model.A mapper from raw data to
IndexWithColumns model.A mapper from raw data with only one column to
IndexWithColumns model.Check for intersected (partially identical) foreign keys on a specific host.
Check for intersected (partially identical) indexes on a specific host.
Check for invalid (broken) indexes on a specific host.
Utility class for parsing SQL queries containing named parameters and replacing
them with positional placeholders (e.g., '?').
Check for not valid constraints on a specific host.
Check for objects whose names do not follow the naming convention (that have to be enclosed in double-quotes) on a specific host.
Check for objects whose names have a length of
max_identifier_length (usually it is 63) on a specific host.Check for primary keys that are the most likely natural keys on a specific host.
Check for primary keys columns with serial types (smallserial/serial/bigserial) on a specific host.
Check for primary keys with columns of a fixed length varchar(32/36/38) type on a specific host.
An abstraction of sql query executor.
Utility class for executing SQL queries with various context parameters.
RawTypeAware<T extends io.github.mfvanek.pg.model.dbobject.DbObject>
Allows getting information about the original generic type.
Custom unchecked exception for IO errors while reading sql query from file.
A mapper from raw data to a domain model.
Check for sequence overflow on a specific host.
A mapper from raw data to
SequenceState model.Utility class for reading SQL query files and parsing their content.
Standard implementation of the
CheckInfo interface.A utility class that provides standard checks to be performed on a specific PostgreSQL host.
A set of methods to manage statistics.
An entry point for managing statistics on the specified host.
Implementation of the StatisticsMaintenanceOnHost interface, responsible for
handling database statistics on a specific PostgreSQL host.
An abstraction of SQL query executor without schema.
A mapper from raw data to
StoredFunction model.A mapper from raw data to
Table model.Check for tables that are not linked to other tables on a specific host.
Check for tables that have all columns besides the primary key that are nullable on a specific host.
Check for tables where the primary key column is not the first column in the table on a specific host.
Check for tables bloat on a specific host.
Check for tables with potentially missing indexes on a specific host.
Check for tables without description on a specific host.
Check for tables without a primary key on a specific host.
Check for tables with zero or one columns on a specific host.
A mapper from raw data to
TableWithBloat model.A mapper from raw data to
TableWithColumns model.A mapper from raw data to
TableWithMissingIndex model.Allows getting information about the execution topology.
Check for unused indexes on a specific host.
A mapper from raw data to
UnusedIndex model.