Skip to main content

Configuration > PgSQL_DatabaseSizing Job

The Configuration Job Group is designed to provide insight into details about the PostgreSQL environment and potential vulnerabilities related to instance configuration settings.

Configuration Job Group - PostgreSQL

The job in the Configuration Job Groups is:

  • PgSQL_DatabaseSizing Job - Provides details about PostgreSQL databases and overall database size

Analysis Tasks for the PgSQL_DatabaseSizing Job

Navigate to the Jobs > Databases > PostgreSQL > Configuration > PgSQL_DatabaseSizing > Configure node and select Analysis to view the analysis tasks.

CAUTION: Do not modify or deselect the selected analysis tasks. The analysis tasks are preconfigured for this job.

Analysis Selection

The default analysis tasks are:

  • Database Sizing Details - Provides details about PostgreSQL databases and sizing
  • Database Sizing Summary - Summarizes PostgreSQL database sizing by host

In addition to the tables and views created the analysis task, the PgSQL_DatabaseSizing Job produces the following pre-configured report.

ReportDescriptionDefault TagsReport Elements
Database SizingThis report highlights the size of databases in PostgreSQLNoneThis report is comprised of three elements: - Bar Chart – Displays top databases by size (MB) - Bar Chart – Displays sizes by host (GB) - Table – Provides database details