Package org.odpi.openmetadata.adapters.connectors.postgres.survey

Class PostgresDatabaseStatsExtractor

java.lang.Object

org.odpi.openmetadata.frameworks.auditlog.AuditLoggingBase

org.odpi.openmetadata.adapters.connectors.postgres.survey.PostgresDatabaseStatsExtractor

public class PostgresDatabaseStatsExtractor
extends AuditLoggingBase

PostgresDatabaseStatsExtractor gathers the statistics that PostgreSQL keeps about its databases, schemas, tables and columns, and turns them into survey annotations.

The connections passed to it are expected to be in auto-commit mode, so that every query is its own short transaction. Each schema is surveyed with its own set of queries, and a query that fails is logged and skipped, so one inaccessible schema or dropped table leaves a gap in the results rather than ending the survey.

Field Summary

Fields inherited from class org.odpi.openmetadata.frameworks.auditlog.AuditLoggingBase

auditLog

Constructor Summary

Constructors

Constructor	Description
PostgresDatabaseStatsExtractor(List<String> validDatabases, List<String> excludedSchemas, List<String> includedSchemas, SurveyActionServiceConnector surveyActionServiceConnector, AuditLog auditLog, String surveyActionServiceName)	Constructor sets up the list of databases to process, the schemas within them to survey, and the connection to the database.
PostgresDatabaseStatsExtractor(List<String> validDatabases, SurveyActionServiceConnector surveyActionServiceConnector)	Constructor sets up the list of databases to process and the connection to the database.

Method Summary

Methods inherited from class org.odpi.openmetadata.frameworks.auditlog.AuditLoggingBase

logExceptionRecord, logExceptionRecord, logRecord, logRecord

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

PostgresDatabaseStatsExtractor

public PostgresDatabaseStatsExtractor(List<String> validDatabases,
 SurveyActionServiceConnector surveyActionServiceConnector)

Constructor sets up the list of databases to process and the connection to the database. Every schema in those databases is surveyed.

Parameters:

validDatabases - list of database names

surveyActionServiceConnector - calling connector

PostgresDatabaseStatsExtractor

public PostgresDatabaseStatsExtractor(List<String> validDatabases,
 List<String> excludedSchemas,
 List<String> includedSchemas,
 SurveyActionServiceConnector surveyActionServiceConnector,
 AuditLog auditLog,
 String surveyActionServiceName)

Constructor sets up the list of databases to process, the schemas within them to survey, and the connection to the database.

Parameters:

validDatabases - list of database names

excludedSchemas - schemas to leave out (null means none are excluded)

includedSchemas - the only schemas to survey (null means all that are not excluded); takes precedence over excludedSchemas

surveyActionServiceConnector - calling connector

auditLog - logging destination for queries that fail (may be null)

surveyActionServiceName - name of the calling survey action service, for the audit log