Index
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form
A
- AbstractCheckOnHost<T extends io.github.mfvanek.pg.model.dbobject.DbObject> - Class in io.github.mfvanek.pg.core.checks.host
-
An abstract implementation of the
DatabaseCheckOnHostinterface, providing a framework for checks to be performed on a specific PostgreSQL host. - AbstractCheckOnHost(Class<T>, PgConnection, CheckInfo) - Constructor for class io.github.mfvanek.pg.core.checks.host.AbstractCheckOnHost
-
Constructs an instance of AbstractCheckOnHost with the specified parameters.
- ACROSS_CLUSTER - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.ExecutionTopology
-
Across the entire database cluster.
- AnyObjectExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
AnyObjectmodel. - apply(PgConnection) - Method in class io.github.mfvanek.pg.core.checks.host.StandardChecksOnHost
-
Constructs the standard set of database checks for a given PostgreSQL connection.
B
- BLOAT_PERCENTAGE - Static variable in class io.github.mfvanek.pg.core.checks.extractors.IndexWithBloatExtractor
-
Represents the column name used to retrieve bloat percentage from the database result set.
- BLOAT_SIZE - Static variable in class io.github.mfvanek.pg.core.checks.extractors.IndexWithBloatExtractor
-
Represents the column name used to retrieve bloat size from the database result set.
- BLOATED_INDEXES - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for indexes bloat.
- BLOATED_TABLES - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for tables bloat.
- BTREE_INDEXES_ON_ARRAY_COLUMNS - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for B-tree indexes on array columns.
- BtreeIndexesOnArrayColumnsCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for B-tree indexes on array columns on a specific host.
- BtreeIndexesOnArrayColumnsCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.BtreeIndexesOnArrayColumnsCheckOnHost
-
Constructs a new instance of
BtreeIndexesOnArrayColumnsCheckOnHost.
C
- check() - Method in interface io.github.mfvanek.pg.core.checks.common.DatabaseCheckOnHost
-
Executes the check in the default schema.
- check(PgContext) - Method in interface io.github.mfvanek.pg.core.checks.common.DatabaseCheckOnHost
-
Executes the check in the specified schema.
- check(PgContext, Predicate<? super T>) - Method in interface io.github.mfvanek.pg.core.checks.common.DatabaseCheckOnHost
-
Executes the check in the specified schema.
- check(PgContext, Predicate<? super T>) - Method in class io.github.mfvanek.pg.core.checks.host.AbstractCheckOnHost
-
Executes the check in the specified schema.
- check(Predicate<? super T>) - Method in interface io.github.mfvanek.pg.core.checks.common.DatabaseCheckOnHost
-
Executes the check in the default schema.
- checkInfo - Variable in class io.github.mfvanek.pg.core.checks.host.AbstractCheckOnHost
-
Represents the configuration and metadata for a specific diagnostic or check to be performed on a PostgreSQL host.
- CheckInfo - Interface in io.github.mfvanek.pg.core.checks.common
-
Represents an entity that can identify, process, and execute SQL-based checks or diagnostics.
- CheckNameAware - Interface in io.github.mfvanek.pg.core.checks.common
-
Allows getting information about check (diagnostic) name.
- CheckTypeAware - Interface in io.github.mfvanek.pg.core.checks.common
-
Allows getting information about check (diagnostic) type.
- clock() - Static method in class io.github.mfvanek.pg.core.utils.ClockHolder
-
Allows getting currently set
Clockinstance. - ClockHolder - Class in io.github.mfvanek.pg.core.utils
-
Utility class to work with
Clock. - COLUMN_TYPE - Static variable in class io.github.mfvanek.pg.core.checks.extractors.ColumnWithTypeExtractor
-
Column name constant representing the type of column in the database.
- ColumnExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
Columnmodel. - COLUMNS_NOT_FOLLOWING_NAMING_CONVENTION - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for columns whose names do not follow the naming convention.
- COLUMNS_WITH_FIXED_LENGTH_VARCHAR - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for columns with a fixed length varchar type.
- COLUMNS_WITH_JSON_TYPE - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for columns with
JSONtype. - COLUMNS_WITH_MONEY_TYPE - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for columns with
moneytype. - COLUMNS_WITH_SERIAL_TYPES - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for columns of serial types that are not primary keys.
- COLUMNS_WITH_TIMESTAMP_OR_TIMETZ_TYPE - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for columns with
timestamportimetztype. - COLUMNS_WITHOUT_DESCRIPTION - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for columns without description.
- ColumnsDataParser - Class in io.github.mfvanek.pg.core.utils
-
Utility class for parsing raw column information and generating
Columnobjects associated with a specific database table. - ColumnsNotFollowingNamingConventionCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for columns whose names do not follow the naming convention (that have to be enclosed in double-quotes) on a specific host.
- ColumnsNotFollowingNamingConventionCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.ColumnsNotFollowingNamingConventionCheckOnHost
-
Constructs a new instance of
ColumnsNotFollowingNamingConventionCheckOnHost. - ColumnsWithFixedLengthVarcharCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for columns with a fixed length varchar type on a specific host.
- ColumnsWithFixedLengthVarcharCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.ColumnsWithFixedLengthVarcharCheckOnHost
-
Constructs a new instance of
ColumnsWithFixedLengthVarcharCheckOnHost. - ColumnsWithJsonTypeCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for columns with
JSONtype on a specific host. - ColumnsWithJsonTypeCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.ColumnsWithJsonTypeCheckOnHost
-
Constructs a new instance of
ColumnsWithJsonTypeCheckOnHost. - ColumnsWithMoneyTypeCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for columns with
moneytype on a specific host. - ColumnsWithMoneyTypeCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.ColumnsWithMoneyTypeCheckOnHost
-
Constructs a new instance of
ColumnsWithMoneyTypeCheckOnHost. - ColumnsWithoutDescriptionCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for columns without description on a specific host.
- ColumnsWithoutDescriptionCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.ColumnsWithoutDescriptionCheckOnHost
-
Constructs a new instance of
ColumnsWithoutDescriptionCheckOnHost. - ColumnsWithSerialTypesCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for columns of serial types that are not primary keys on a specific host.
- ColumnsWithSerialTypesCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.ColumnsWithSerialTypesCheckOnHost
-
Constructs a new instance of
ColumnsWithSerialTypesCheckOnHost. - ColumnsWithTimestampOrTimetzTypeCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for columns with
timestamportimetztype on a specific host. - ColumnsWithTimestampOrTimetzTypeCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.ColumnsWithTimestampOrTimetzTypeCheckOnHost
-
Constructs a new instance of
ColumnsWithTimestampOrTimetzTypeCheckOnHost. - ColumnWithSerialTypeExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
ColumnWithSerialTypemodel. - ColumnWithTypeExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
ColumnWithTypemodel. - CONSTRAINT_NAME - Static variable in class io.github.mfvanek.pg.core.checks.extractors.ForeignKeyExtractor
-
Represents the column name "constraint_name" in a ResultSet.
- ConstraintExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
Constraintmodel.
D
- DatabaseCheckOnHost<T extends io.github.mfvanek.pg.model.dbobject.DbObject> - Interface in io.github.mfvanek.pg.core.checks.common
-
Represents a check (or diagnostic) to be performed on a specific PostgreSQL host.
- Diagnostic - Enum Class in io.github.mfvanek.pg.core.checks.common
-
A list of standard diagnostics with corresponding SQL queries and query executors.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.AbstractCheckOnHost
-
Executes the check in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.BtreeIndexesOnArrayColumnsCheckOnHost
-
Returns B-tree indexes on array columns in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.ColumnsNotFollowingNamingConventionCheckOnHost
-
Returns columns whose names do not follow the naming convention in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.ColumnsWithFixedLengthVarcharCheckOnHost
-
Returns columns with fixed length varchar type in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.ColumnsWithJsonTypeCheckOnHost
-
Returns columns with JSON type in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.ColumnsWithMoneyTypeCheckOnHost
-
Returns columns with a money type in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.ColumnsWithoutDescriptionCheckOnHost
-
Returns columns without description (comment) in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.ColumnsWithSerialTypesCheckOnHost
-
Returns columns with serial types that are not primary keys in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.ColumnsWithTimestampOrTimetzTypeCheckOnHost
-
Returns columns with
timestamportimetztype in the specified schema. - doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.DuplicatedForeignKeysCheckOnHost
-
Returns duplicated (completely identical) foreign keys in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.DuplicatedIndexesCheckOnHost
-
Returns duplicated (completely identical) indexes in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.ForeignKeysNotCoveredWithIndexCheckOnHost
-
Returns foreign keys without associated indexes in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.ForeignKeysWithUnmatchedColumnTypeCheckOnHost
-
Returns foreign keys where the type of the constrained column does not match the type in the referenced table.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.FunctionsWithoutDescriptionCheckOnHost
-
Returns procedures/functions without description (comment) in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.IndexesWithBloatCheckOnHost
-
Returns indexes that are bloated in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.IndexesWithBooleanCheckOnHost
-
Returns indexes that contain boolean values in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.IndexesWithNullValuesCheckOnHost
-
Returns indexes that contain null values in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.IndexesWithTimestampInTheMiddleCheckOnHost
-
Returns indexes with timestamp\timestamptz in the middle in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.IndexesWithUnnecessaryWhereClauseCheckOnHost
-
Returns indexes with unnecessary where-clause on not null column in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.IntersectedForeignKeysCheckOnHost
-
Returns intersected (partially identical) foreign keys in the specified schema (except completely identical).
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.IntersectedIndexesCheckOnHost
-
Returns intersected (partially identical) indexes in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.InvalidIndexesCheckOnHost
-
Returns invalid (broken) indexes in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.NotValidConstraintsCheckOnHost
-
Returns not valid constraints in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.ObjectsNotFollowingNamingConventionCheckOnHost
-
Returns objects whose names do not follow the naming convention in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.PossibleObjectNameOverflowCheckOnHost
-
Returns objects whose names have a length of
max_identifier_lengthin the specified schema. - doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.PrimaryKeysThatMostLikelyNaturalKeysCheckOnHost
-
Returns primary keys that are most likely natural keys in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.PrimaryKeysWithSerialTypesCheckOnHost
-
Returns primary keys with columns of serial types in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.PrimaryKeysWithVarcharCheckOnHost
-
Returns primary keys with columns of fixed length varchar in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.SequenceOverflowCheckOnHost
-
Returns sequences that are close to overflow in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.TablesNotLinkedToOthersCheckOnHost
-
Returns tables that are no longer in use or were created by mistake.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.TablesWhereAllColumnsNullableExceptPrimaryKeyCheckOnHost
-
Returns tables that have all columns besides the primary key that are nullable in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.TablesWherePrimaryKeyColumnsNotFirstCheckOnHost
-
Returns tables where the primary key columns are not first in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.TablesWithBloatCheckOnHost
-
Returns tables that are bloated in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.TablesWithMissingIndexesCheckOnHost
-
Returns tables with potentially missing indexes in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.TablesWithoutDescriptionCheckOnHost
-
Returns tables without description (comment) in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.TablesWithoutPrimaryKeyCheckOnHost
-
Returns tables without a primary key in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.TablesWithZeroOrOneColumnCheckOnHost
-
Returns tables with zero or one column in the specified schema.
- doCheck(PgContext) - Method in class io.github.mfvanek.pg.core.checks.host.UnusedIndexesCheckOnHost
-
Returns unused indexes in the specified schema.
- DUPLICATED_FOREIGN_KEYS - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for duplicated (completely identical) foreign keys.
- DUPLICATED_INDEXES - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for duplicated (completely identical) indexes.
- DuplicatedForeignKeysCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for duplicated (completely identical) foreign keys on a specific host.
- DuplicatedForeignKeysCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.DuplicatedForeignKeysCheckOnHost
-
Constructs a new instance of
DuplicatedForeignKeysCheckOnHost. - DuplicatedForeignKeysExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
DuplicatedForeignKeysmodel. - DuplicatedIndexesCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for duplicated (completely identical) indexes on a specific host.
- DuplicatedIndexesCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.DuplicatedIndexesCheckOnHost
-
Constructs a new instance of
DuplicatedIndexesCheckOnHost. - DuplicatedIndexesExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
DuplicatedIndexesmodel.
E
- executeQuery(PgConnection, PgContext, String, ResultSetExtractor<T>) - Method in interface io.github.mfvanek.pg.core.checks.common.QueryExecutor
-
Executes the specified SQL query using the provided
PgConnectionandPgContext, and extracts the results using the givenResultSetExtractor. - executeQuery(PgConnection, String, ResultSetExtractor<T>) - Method in interface io.github.mfvanek.pg.core.statistics.StatisticsQueryExecutor
-
Executes an SQL query on the given PostgreSQL connection and maps the result set into a list of objects using the provided
ResultSetExtractor. - executeQuery(PgConnection, String, ResultSetExtractor<T>) - Static method in class io.github.mfvanek.pg.core.utils.QueryExecutors
-
Executes a given SQL query and extracts results using the provided
ResultSetExtractor. - executeQuery(PgContext, ResultSetExtractor<T>) - Method in class io.github.mfvanek.pg.core.checks.host.AbstractCheckOnHost
-
Executes a query associated with a diagnostic and extracts the result.
- executeQueryWithBloatThreshold(PgConnection, PgContext, String, ResultSetExtractor<T>) - Static method in class io.github.mfvanek.pg.core.utils.QueryExecutors
-
Executes a given SQL query within the context of the provided schema name and bloat threshold.
- executeQueryWithRemainingPercentageThreshold(PgConnection, PgContext, String, ResultSetExtractor<T>) - Static method in class io.github.mfvanek.pg.core.utils.QueryExecutors
-
Executes a given SQL query within the context of the provided schema name and remaining percentage threshold.
- executeQueryWithSchema(PgConnection, PgContext, String, ResultSetExtractor<T>) - Static method in class io.github.mfvanek.pg.core.utils.QueryExecutors
-
Executes a given SQL query within the context of the provided schema name.
- ExecutionTopology - Enum Class in io.github.mfvanek.pg.core.checks.common
-
Defines the place where the diagnostic should be executed.
- extractData(ResultSet) - Method in interface io.github.mfvanek.pg.core.checks.common.ResultSetExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.AnyObjectExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.ColumnExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.ColumnWithSerialTypeExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.ColumnWithTypeExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.ConstraintExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.DuplicatedForeignKeysExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.DuplicatedIndexesExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.ForeignKeyExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.IndexExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.IndexWithBloatExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.IndexWithColumnsExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.IndexWithNullableColumnExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.IndexWithSingleColumnExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.SequenceStateExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.StoredFunctionExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.TableExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.TableWithBloatExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.TableWithColumnsExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.TableWithMissingIndexExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model. - extractData(ResultSet) - Method in class io.github.mfvanek.pg.core.checks.extractors.UnusedIndexExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model.
F
- FOREIGN_KEYS_WITH_UNMATCHED_COLUMN_TYPE - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for foreign keys where the type of the constrained column does not match the type in the referenced table.
- FOREIGN_KEYS_WITHOUT_INDEX - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for foreign keys without associated indexes.
- ForeignKeyExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
ForeignKeymodel. - ForeignKeysNotCoveredWithIndexCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for foreign keys without associated indexes on a specific host.
- ForeignKeysNotCoveredWithIndexCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.ForeignKeysNotCoveredWithIndexCheckOnHost
-
Constructs a new instance of
ForeignKeysNotCoveredWithIndexCheckOnHost. - ForeignKeysWithUnmatchedColumnTypeCheckOnHost - Class in io.github.mfvanek.pg.core.checks.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.
- ForeignKeysWithUnmatchedColumnTypeCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.ForeignKeysWithUnmatchedColumnTypeCheckOnHost
-
Constructs a new instance of
ForeignKeysWithUnmatchedColumnTypeCheckOnHost. - FUNCTIONS_WITHOUT_DESCRIPTION - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for procedures/functions without description.
- FunctionsWithoutDescriptionCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for procedures/functions without description on a specific host.
- FunctionsWithoutDescriptionCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.FunctionsWithoutDescriptionCheckOnHost
-
Constructs a new instance of
FunctionsWithoutDescriptionCheckOnHost.
G
- getExecutionTopology() - Method in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Retrieves the place where the diagnostic should be executed.
- getExecutionTopology() - Method in class io.github.mfvanek.pg.core.checks.common.StandardCheckInfo
-
Retrieves the place where the diagnostic should be executed.
- getExecutionTopology() - Method in interface io.github.mfvanek.pg.core.checks.common.TopologyAware
-
Retrieves the place where the diagnostic should be executed.
- getExecutionTopology() - Method in class io.github.mfvanek.pg.core.checks.host.AbstractCheckOnHost
-
Retrieves the place where the diagnostic should be executed.
- getHost() - Method in class io.github.mfvanek.pg.core.checks.host.AbstractCheckOnHost
- getHost() - Method in class io.github.mfvanek.pg.core.statistics.StatisticsMaintenanceOnHostImpl
- getLastStatsResetTimestamp() - Method in interface io.github.mfvanek.pg.core.statistics.StatisticsAware
-
Retrieves the time at which database statistics were last reset.
- getLastStatsResetTimestamp() - Method in interface io.github.mfvanek.pg.core.statistics.StatisticsMaintenanceOnHost
-
Retrieves the time at which database statistics were last reset on current host.
- getLastStatsResetTimestamp() - Method in class io.github.mfvanek.pg.core.statistics.StatisticsMaintenanceOnHostImpl
-
Retrieves the time at which database statistics were last reset on current host.
- getName() - Method in interface io.github.mfvanek.pg.core.checks.common.CheckNameAware
-
Retrieves the name of the check (diagnostic).
- getName() - Method in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Retrieves the name of the check (diagnostic).
- getName() - Method in class io.github.mfvanek.pg.core.checks.common.StandardCheckInfo
-
Retrieves the name of the check (diagnostic).
- getName() - Method in class io.github.mfvanek.pg.core.checks.host.AbstractCheckOnHost
-
Retrieves the name of the check (diagnostic).
- getQueryExecutor() - Method in interface io.github.mfvanek.pg.core.checks.common.CheckInfo
-
Retrieves the lambda which executes the associated SQL query.
- getQueryExecutor() - Method in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Retrieves the lambda which executes the associated SQL query.
- getQueryExecutor() - Method in class io.github.mfvanek.pg.core.checks.common.StandardCheckInfo
-
Retrieves the lambda which executes the associated SQL query.
- getQueryForCheck(String) - Static method in class io.github.mfvanek.pg.core.utils.SqlQueryReader
-
Constructs a SQL query by determining the corresponding SQL file name from the given check name and reading the query from that file.
- getQueryFromFile(String) - Static method in class io.github.mfvanek.pg.core.utils.SqlQueryReader
-
Reads a SQL query from a file located in the "sql" resource directory, validates the file name, and processes the content to replace named parameters with placeholders.
- getSqlQuery() - Method in interface io.github.mfvanek.pg.core.checks.common.CheckInfo
-
Retrieves the associated JDBC-compatible SQL query.
- getSqlQuery() - Method in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Retrieves the associated JDBC-compatible SQL query.
- getSqlQuery() - Method in class io.github.mfvanek.pg.core.checks.common.StandardCheckInfo
-
Retrieves the associated JDBC-compatible SQL query.
- getType() - Method in interface io.github.mfvanek.pg.core.checks.common.RawTypeAware
-
Retrieves original java type.
- getType() - Method in class io.github.mfvanek.pg.core.checks.host.AbstractCheckOnHost
-
Retrieves original java type.
I
- INDEX_NAME - Static variable in class io.github.mfvanek.pg.core.checks.extractors.IndexExtractor
-
Represents the column name "index_name" in a ResultSet.
- INDEX_SIZE - Static variable in class io.github.mfvanek.pg.core.checks.extractors.IndexExtractor
-
Represents the column name "index_size" in a ResultSet.
- INDEXES_WITH_BOOLEAN - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for indexes that contain boolean values.
- INDEXES_WITH_NULL_VALUES - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for indexes with null values.
- INDEXES_WITH_TIMESTAMP_IN_THE_MIDDLE - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for indexes in which columns with the timestamp\timestamptz type are not the last.
- INDEXES_WITH_UNNECESSARY_WHERE_CLAUSE - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for indexes with unnecessary where-clause on a not null column.
- IndexesWithBloatCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for indexes bloat on a specific host.
- IndexesWithBloatCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.IndexesWithBloatCheckOnHost
-
Constructs a new instance of
IndexesWithBloatCheckOnHost. - IndexesWithBooleanCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for indexes that contain boolean values on a specific host.
- IndexesWithBooleanCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.IndexesWithBooleanCheckOnHost
-
Constructs a new instance of
IndexesWithBooleanCheckOnHost. - IndexesWithNullValuesCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for indexes with null values on a specific host.
- IndexesWithNullValuesCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.IndexesWithNullValuesCheckOnHost
-
Constructs a new instance of
IndexesWithNullValuesCheckOnHost. - IndexesWithTimestampInTheMiddleCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for indexes in which columns with the timestamp\timestamptz type are not the last on a specific host.
- IndexesWithTimestampInTheMiddleCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.IndexesWithTimestampInTheMiddleCheckOnHost
-
Constructs a new instance of
IndexesWithTimestampInTheMiddleCheckOnHost. - IndexesWithUnnecessaryWhereClauseCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for indexes with unnecessary where-clause on a not null column on a specific host.
- IndexesWithUnnecessaryWhereClauseCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.IndexesWithUnnecessaryWhereClauseCheckOnHost
-
Constructs a new instance of
IndexesWithUnnecessaryWhereClauseCheckOnHost. - IndexExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
Indexmodel. - IndexWithBloatExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
IndexWithBloatmodel. - IndexWithColumnsExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data with multiple columns to
IndexWithColumnsmodel. - IndexWithNullableColumnExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
IndexWithColumnsmodel. - IndexWithSingleColumnExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data with only one column to
IndexWithColumnsmodel. - INTERSECTED_FOREIGN_KEYS - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for intersected (partially identical) foreign keys.
- INTERSECTED_INDEXES - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for intersected (partially identical) indexes.
- IntersectedForeignKeysCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for intersected (partially identical) foreign keys on a specific host.
- IntersectedForeignKeysCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.IntersectedForeignKeysCheckOnHost
-
Constructs a new instance of
IntersectedForeignKeysCheckOnHost. - IntersectedIndexesCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for intersected (partially identical) indexes on a specific host.
- IntersectedIndexesCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.IntersectedIndexesCheckOnHost
-
Constructs a new instance of
IntersectedIndexesCheckOnHost. - INVALID_INDEXES - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for invalid (broken) indexes.
- InvalidIndexesCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for invalid (broken) indexes on a specific host.
- InvalidIndexesCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.InvalidIndexesCheckOnHost
-
Constructs a new instance of
InvalidIndexesCheckOnHost. - io.github.mfvanek.pg.core.checks.common - package io.github.mfvanek.pg.core.checks.common
-
Common checks related classes and interfaces.
- io.github.mfvanek.pg.core.checks.extractors - package io.github.mfvanek.pg.core.checks.extractors
-
Result-set extractors.
- io.github.mfvanek.pg.core.checks.host - package io.github.mfvanek.pg.core.checks.host
-
Checks on host related classes and interfaces.
- io.github.mfvanek.pg.core.statistics - package io.github.mfvanek.pg.core.statistics
-
Statistics related classes and interfaces.
- io.github.mfvanek.pg.core.utils - package io.github.mfvanek.pg.core.utils
-
Utility classes for executing SQL queries.
- io.github.mfvanek.pg.core.utils.exception - package io.github.mfvanek.pg.core.utils.exception
-
Custom checks exceptions.
- isAcrossCluster() - Method in interface io.github.mfvanek.pg.core.checks.common.TopologyAware
-
Shows whether diagnostic results should be collected from all nodes in the cluster.
- isRuntime() - Method in interface io.github.mfvanek.pg.core.checks.common.CheckTypeAware
-
Defines whether this check/diagnostic is runtime (make sense to perform only on a production database with real data and statistics).
- isRuntime() - Method in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Defines whether this check/diagnostic is runtime (make sense to perform only on a production database with real data and statistics).
- isRuntime() - Method in class io.github.mfvanek.pg.core.checks.common.StandardCheckInfo
-
Defines whether this check/diagnostic is runtime (make sense to perform only on a production database with real data and statistics).
- isRuntime() - Method in class io.github.mfvanek.pg.core.checks.host.AbstractCheckOnHost
-
Defines whether this check/diagnostic is runtime (make sense to perform only on a production database with real data and statistics).
- isStatic() - Method in interface io.github.mfvanek.pg.core.checks.common.CheckTypeAware
-
Defines whether this check/diagnostic is static (can be run in unit/integration tests on an empty database).
M
- mapRow(ResultSet, int) - Method in interface io.github.mfvanek.pg.core.checks.common.ResultSetExtractor
-
Converts the current row of the given
ResultSetto an arbitrary domain model.
N
- NamedParametersParser - Class in io.github.mfvanek.pg.core.utils
-
Utility class for parsing SQL queries containing named parameters and replacing them with positional placeholders (e.g., '?').
- NOT_VALID_CONSTRAINTS - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for not valid constraints.
- NotValidConstraintsCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for not valid constraints on a specific host.
- NotValidConstraintsCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.NotValidConstraintsCheckOnHost
-
Constructs a new instance of
NotValidConstraintsCheckOnHost.
O
- OBJECT_NAME - Static variable in class io.github.mfvanek.pg.core.checks.extractors.AnyObjectExtractor
-
Represents the column name "object_name" in a ResultSet.
- OBJECT_TYPE - Static variable in class io.github.mfvanek.pg.core.checks.extractors.AnyObjectExtractor
-
Represents the column name "object_type" in a ResultSet.
- OBJECTS_NOT_FOLLOWING_NAMING_CONVENTION - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for objects whose names do not follow the naming convention.
- ObjectsNotFollowingNamingConventionCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for objects whose names do not follow the naming convention (that have to be enclosed in double-quotes) on a specific host.
- ObjectsNotFollowingNamingConventionCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.ObjectsNotFollowingNamingConventionCheckOnHost
-
Constructs a new instance of
ObjectsNotFollowingNamingConventionCheckOnHost. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.AnyObjectExtractor
-
Creates
AnyObjectExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.ColumnExtractor
-
Creates
ColumnExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.ColumnWithSerialTypeExtractor
-
Creates
ColumnWithSerialTypeExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.ColumnWithTypeExtractor
-
Creates
ColumnWithTypeExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.ConstraintExtractor
-
Creates
ConstraintExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.IndexExtractor
-
Creates
IndexExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.IndexWithBloatExtractor
-
Creates
IndexWithBloatExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.IndexWithColumnsExtractor
-
Creates
IndexWithColumnsExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.IndexWithNullableColumnExtractor
-
Creates
IndexWithNullableColumnExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.IndexWithSingleColumnExtractor
-
Creates
IndexWithSingleColumnExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.SequenceStateExtractor
-
Creates
SequenceStateExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.StoredFunctionExtractor
-
Creates
StoredFunctionExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.TableExtractor
-
Creates
TableExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.TableWithBloatExtractor
-
Creates
TableWithBloatExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.TableWithColumnsExtractor
-
Creates
TableWithColumnsExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.TableWithMissingIndexExtractor
-
Creates
TableWithMissingIndexExtractorinstance. - of() - Static method in class io.github.mfvanek.pg.core.checks.extractors.UnusedIndexExtractor
-
Creates
UnusedIndexExtractorinstance. - of(String) - Static method in class io.github.mfvanek.pg.core.checks.extractors.DuplicatedForeignKeysExtractor
-
Creates
DuplicatedForeignKeysExtractorinstance. - of(String) - Static method in class io.github.mfvanek.pg.core.checks.extractors.DuplicatedIndexesExtractor
-
Creates a new
DuplicatedIndexesExtractorwith the specified prefix for the target column name. - ofDefault() - Static method in class io.github.mfvanek.pg.core.checks.extractors.ForeignKeyExtractor
-
Creates default
ForeignKeyExtractorinstance. - ofStatic(String, String) - Static method in class io.github.mfvanek.pg.core.checks.common.StandardCheckInfo
-
Creates a
CheckInfoinstance with the given name and SQL query for a static check. - ON_PRIMARY - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.ExecutionTopology
-
Only on the primary host.
P
- parse(String) - Static method in class io.github.mfvanek.pg.core.utils.NamedParametersParser
-
Parses the given SQL query, replacing named parameters with positional parameters.
- parseRawColumnsInForeignKeyOrIndex(String, String...) - Static method in class io.github.mfvanek.pg.core.utils.ColumnsDataParser
-
Parses raw column definitions and generates a list of
Columnobjects related to a specific table, typically used within contexts such as foreign keys or indexes. - parseRawColumnsInTable(String, String...) - Static method in class io.github.mfvanek.pg.core.utils.ColumnsDataParser
-
Parses raw column definitions and generates a list of
Columnobjects associated with a specific table. - pgConnection - Variable in class io.github.mfvanek.pg.core.checks.host.AbstractCheckOnHost
-
A connection to a specific host in the cluster.
- POSSIBLE_OBJECT_NAME_OVERFLOW - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for objects whose names have a length of
max_identifier_length. - PossibleObjectNameOverflowCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for objects whose names have a length of
max_identifier_length(usually it is 63) on a specific host. - PossibleObjectNameOverflowCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.PossibleObjectNameOverflowCheckOnHost
-
Constructs a new instance of
PossibleObjectNameOverflowCheckOnHost. - PRIMARY_KEYS_THAT_MOST_LIKELY_NATURAL_KEYS - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for primary keys that are the most likely natural keys.
- PRIMARY_KEYS_WITH_SERIAL_TYPES - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for primary keys columns with serial types (smallserial/serial/bigserial).
- PRIMARY_KEYS_WITH_VARCHAR - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for primary keys with columns of a fixed length varchar type.
- PrimaryKeysThatMostLikelyNaturalKeysCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for primary keys that are the most likely natural keys on a specific host.
- PrimaryKeysThatMostLikelyNaturalKeysCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.PrimaryKeysThatMostLikelyNaturalKeysCheckOnHost
-
Constructs a new instance of
PrimaryKeysThatMostLikelyNaturalKeysCheckOnHost. - PrimaryKeysWithSerialTypesCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for primary keys columns with serial types (smallserial/serial/bigserial) on a specific host.
- PrimaryKeysWithSerialTypesCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.PrimaryKeysWithSerialTypesCheckOnHost
-
Constructs a new instance of
PrimaryKeysWithSerialTypesCheckOnHost. - PrimaryKeysWithVarcharCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for primary keys with columns of a fixed length varchar(32/36/38) type on a specific host.
- PrimaryKeysWithVarcharCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.PrimaryKeysWithVarcharCheckOnHost
-
Constructs a new instance of
PrimaryKeysWithVarcharCheckOnHost.
Q
- QueryExecutor - Interface in io.github.mfvanek.pg.core.checks.common
-
An abstraction of sql query executor.
- QueryExecutors - Class in io.github.mfvanek.pg.core.utils
-
Utility class for executing SQL queries with various context parameters.
R
- RawTypeAware<T extends io.github.mfvanek.pg.model.dbobject.DbObject> - Interface in io.github.mfvanek.pg.core.checks.common
-
Allows getting information about the original generic type.
- ReadQueryFromFileException - Exception in io.github.mfvanek.pg.core.utils.exception
-
Custom unchecked exception for IO errors while reading sql query from file.
- ReadQueryFromFileException(String, IOException) - Constructor for exception io.github.mfvanek.pg.core.utils.exception.ReadQueryFromFileException
-
Constructs a new
ReadQueryFromFileExceptionwith the specified SQL file name and the cause of the error. - resetStatistics() - Method in interface io.github.mfvanek.pg.core.statistics.StatisticsAware
-
Resets all statistics counters for the current database to zero.
- resetStatistics() - Method in interface io.github.mfvanek.pg.core.statistics.StatisticsMaintenanceOnHost
-
Resets all statistics counters for the current database on current host to zero.
- resetStatistics() - Method in class io.github.mfvanek.pg.core.statistics.StatisticsMaintenanceOnHostImpl
-
Resets all statistics counters for the current database on current host to zero.
- ResultSetExtractor<T> - Interface in io.github.mfvanek.pg.core.checks.common
-
A mapper from raw data to a domain model.
S
- SEQUENCE_OVERFLOW - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for sequence overflow.
- SequenceOverflowCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for sequence overflow on a specific host.
- SequenceOverflowCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.SequenceOverflowCheckOnHost
-
Constructs a new instance of
SequenceOverflowCheckOnHost. - SequenceStateExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
SequenceStatemodel. - setClock(Clock) - Static method in class io.github.mfvanek.pg.core.utils.ClockHolder
-
Atomically sets the
ClockHolder.CLOCK_REFERENCEtonewClockand returns the old value. - SqlQueryReader - Class in io.github.mfvanek.pg.core.utils
-
Utility class for reading SQL query files and parsing their content.
- StandardCheckInfo - Class in io.github.mfvanek.pg.core.checks.common
-
Standard implementation of the
CheckInfointerface. - StandardCheckInfo(String, ExecutionTopology, String, QueryExecutor, boolean) - Constructor for class io.github.mfvanek.pg.core.checks.common.StandardCheckInfo
-
Constructs a new instance of StandardCheckInfo with the specified parameters.
- StandardCheckInfo(String, String, QueryExecutor, boolean) - Constructor for class io.github.mfvanek.pg.core.checks.common.StandardCheckInfo
-
Constructs a new instance of StandardCheckInfo with the default execution topology (ON_PRIMARY).
- StandardChecksOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
A utility class that provides standard checks to be performed on a specific PostgreSQL host.
- StandardChecksOnHost() - Constructor for class io.github.mfvanek.pg.core.checks.host.StandardChecksOnHost
-
Constructs an instance of
StandardChecksOnHost. - StatisticsAware - Interface in io.github.mfvanek.pg.core.statistics
-
A set of methods to manage statistics.
- StatisticsMaintenanceOnHost - Interface in io.github.mfvanek.pg.core.statistics
-
An entry point for managing statistics on the specified host.
- StatisticsMaintenanceOnHostImpl - Class in io.github.mfvanek.pg.core.statistics
-
Implementation of the StatisticsMaintenanceOnHost interface, responsible for handling database statistics on a specific PostgreSQL host.
- StatisticsMaintenanceOnHostImpl(PgConnection) - Constructor for class io.github.mfvanek.pg.core.statistics.StatisticsMaintenanceOnHostImpl
-
Constructs a new instance of the
StatisticsMaintenanceOnHostImplclass, leveraging the providedPgConnectionto manage database statistics on a specific PostgreSQL host. - StatisticsQueryExecutor - Interface in io.github.mfvanek.pg.core.statistics
-
An abstraction of SQL query executor without schema.
- StoredFunctionExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
StoredFunctionmodel.
T
- TABLE_NAME - Static variable in class io.github.mfvanek.pg.core.checks.extractors.TableExtractor
-
Represents the column name "table_name" in a ResultSet.
- TABLE_SIZE - Static variable in class io.github.mfvanek.pg.core.checks.extractors.TableExtractor
-
Represents the column name "table_size" in a ResultSet.
- TableExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
Tablemodel. - TABLES_NOT_LINKED_TO_OTHERS - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for tables that are not linked to other tables.
- TABLES_WHERE_ALL_COLUMNS_NULLABLE_EXCEPT_PK - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for tables that have all columns besides the primary key that are nullable.
- TABLES_WHERE_PRIMARY_KEY_COLUMNS_NOT_FIRST - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for tables where the primary key column is not the first column in the table.
- TABLES_WITH_MISSING_INDEXES - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for tables with potentially missing indexes.
- TABLES_WITH_ZERO_OR_ONE_COLUMN - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for tables with zero or one columns.
- TABLES_WITHOUT_DESCRIPTION - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for tables without description.
- TABLES_WITHOUT_PRIMARY_KEY - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for tables without a primary key.
- TablesNotLinkedToOthersCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for tables that are not linked to other tables on a specific host.
- TablesNotLinkedToOthersCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.TablesNotLinkedToOthersCheckOnHost
-
Constructs a new instance of
TablesNotLinkedToOthersCheckOnHost. - TablesWhereAllColumnsNullableExceptPrimaryKeyCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for tables that have all columns besides the primary key that are nullable on a specific host.
- TablesWhereAllColumnsNullableExceptPrimaryKeyCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.TablesWhereAllColumnsNullableExceptPrimaryKeyCheckOnHost
-
Constructs a new instance of
TablesWhereAllColumnsNullableExceptPrimaryKeyCheckOnHost. - TablesWherePrimaryKeyColumnsNotFirstCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for tables where the primary key column is not the first column in the table on a specific host.
- TablesWherePrimaryKeyColumnsNotFirstCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.TablesWherePrimaryKeyColumnsNotFirstCheckOnHost
-
Constructs a new instance of
TablesWherePrimaryKeyColumnsNotFirstCheckOnHost. - TablesWithBloatCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for tables bloat on a specific host.
- TablesWithBloatCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.TablesWithBloatCheckOnHost
-
Constructs a new instance of
TablesWithBloatCheckOnHost. - TablesWithMissingIndexesCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for tables with potentially missing indexes on a specific host.
- TablesWithMissingIndexesCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.TablesWithMissingIndexesCheckOnHost
-
Constructs a new instance of
TablesWithMissingIndexesCheckOnHost. - TablesWithoutDescriptionCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for tables without description on a specific host.
- TablesWithoutDescriptionCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.TablesWithoutDescriptionCheckOnHost
-
Constructs a new instance of
TablesWithoutDescriptionCheckOnHost. - TablesWithoutPrimaryKeyCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for tables without a primary key on a specific host.
- TablesWithoutPrimaryKeyCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.TablesWithoutPrimaryKeyCheckOnHost
-
Constructs a new instance of
TablesWithoutPrimaryKeyCheckOnHost. - TablesWithZeroOrOneColumnCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for tables with zero or one columns on a specific host.
- TablesWithZeroOrOneColumnCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.TablesWithZeroOrOneColumnCheckOnHost
-
Constructs a new instance of
TablesWithZeroOrOneColumnCheckOnHost. - TableWithBloatExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
TableWithBloatmodel. - TableWithColumnsExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
TableWithColumnsmodel. - TableWithMissingIndexExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
TableWithMissingIndexmodel. - TopologyAware - Interface in io.github.mfvanek.pg.core.checks.common
-
Allows getting information about the execution topology.
- type - Variable in class io.github.mfvanek.pg.core.checks.host.AbstractCheckOnHost
-
An original java type representing a database object.
U
- UNUSED_INDEXES - Enum constant in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Check for unused indexes.
- UnusedIndexesCheckOnHost - Class in io.github.mfvanek.pg.core.checks.host
-
Check for unused indexes on a specific host.
- UnusedIndexesCheckOnHost(PgConnection) - Constructor for class io.github.mfvanek.pg.core.checks.host.UnusedIndexesCheckOnHost
-
Constructs a new instance of
UnusedIndexesCheckOnHost. - UnusedIndexExtractor - Class in io.github.mfvanek.pg.core.checks.extractors
-
A mapper from raw data to
UnusedIndexmodel.
V
- valueOf(String) - Static method in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Returns the enum constant of this class with the specified name.
- valueOf(String) - Static method in enum class io.github.mfvanek.pg.core.checks.common.ExecutionTopology
-
Returns the enum constant of this class with the specified name.
- values() - Static method in enum class io.github.mfvanek.pg.core.checks.common.Diagnostic
-
Returns an array containing the constants of this enum class, in the order they are declared.
- values() - Static method in enum class io.github.mfvanek.pg.core.checks.common.ExecutionTopology
-
Returns an array containing the constants of this enum class, in the order they are declared.
W
- withPrefix(String) - Static method in class io.github.mfvanek.pg.core.checks.extractors.ForeignKeyExtractor
-
Creates
ForeignKeyExtractorinstance for duplicated/intersected constraint fields with given prefix.
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form