ClusterControl Documentation
Use the menu below or the search below to learn everything you need to know about ClusterControl

5.6.6. Performance

Database performance monitoring and advisors.

5.6.6.1. DB Variables

DB Variables provide a quick overview of TimeScaleDB variables that are set across all your database nodes. You can use the Search text field to filter the result.

Note

Red text means that the variable setting is different. In some cases that is acceptable (e.g., IP address of the node).

5.6.6.2. Advisors

Lists of scheduled Advisors created in Developer Studio using ClusterControl DSL.

  • Expand all
    • Expands all advisors with detailed.
  • Collapse all
    • Lists the advisors summary.
  • Filter by status
    • Shows advisors based on status - Ok, Warning, Critical.
  • DB Instance
    • The database server the advisor running on.
  • Status
    • Advisor status - Ok, Warning, Critical.
  • Advice
    • The advisor’s decision based on the justification.
  • Justification
    • The result of advisors’ execution.

5.6.6.3. DB Growth

Provides a summary of your database and table growth on daily basis so you can track the dataset growth on your databases. Click on listed database will further detail the growth summary per table in the bottom section. Click on “Refresh Data” to trigger a job to re-calculate the database size.

5.6.6.4. Schema Analyzer

Analyzes database tables for missing primary keys and redundant indexes. ClusterControl will periodically check the schemas for these (default every 8 hours or every after CMON restart), and raise an alarm if necessary.