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.

warning

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