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.