Schema growth collector


Job details

Name: Schema growth collector
Platform: Postgres
Category: Capacity
Description: Checks the size of the log file.
Long description: This job collects growth rate statistics for all schemas i all databases.
Version: 1.51
Default schedule: 10 6 * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘postgres’]/.[hasengine=‘YES’ & newer_than_ninetwo = ‘1′]

Parameters

Name Default value Description
ignore_databases 10 The list of databases to be ignored (separated by comma).

Job Summary

SELECT nspname, current_database() AS db, SUM(relpages), relkind::varchar 
FROM pg_class c 
JOIN pg_namespace n ON n.oid = c.relnamespace 
GROUP BY db, nspname, relkind;

Technical Details

Job Execution Process

Output Analysis

The outcome of this job is a detailed log of each schema’s growth within every monitored database, updating the table with current statistics. This allows for historical tracking and growth analysis, essential for database capacity planning and management.

Job Execution Results Representation