Schema growth statistics


Job details

Name: Schema growth statistics
Platform: Postgres
Category: Capacity
Description: Collects and analyzes schema growth statistics from data collected by
Long description: Collects and analyzes schema growth statistics from data collected by
Version: 1.8
Default schedule: 30 6 * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘postgres’]/.[hasengine=‘YES’ & newer_than_ninetwo = ‘1′]

Parameters

Name Default value Description
keep data for 90 The number of days to keep the data for.
ignore schema pg_catalog,information_schema,public,pg_toast Schemas you do not want to list in report.
ignore database Databases you do not want to list in report.

Job Summary

select schema_name, db_name, data_size, index_size, trans_log_size, total_size, histr_date from dbw_schema_growth_histr;

Key Components and Operations

Scheduled Operations

Additional Operations

Overall, this job orchestrates a comprehensive approach to monitor schema growth within PostgreSQL databases, providing insights through scheduled reports and handling exceptions for a smooth operational framework within the dbWatch environment.