Skip to main content

Database Advisory Overview

The pgpulse Database Advisory is your proactive partner in database management. It doesn't just show you what's happening; it tells you what to do about it.

Guidance, not Auto-Changes​

Advisory recommendations are meant to be read and understood by humans. pgpulse will never make changes to your database schema or configuration automatically. Every recommendation is a starting point for your team to investigate and ship safely.

How to read an Advisory​

Each advisory item includes:

  • Title: A clear statement of the issue.
  • Severity: How urgently you should act.
  • Context: The specific telemetry and query patterns that triggered the advice.
  • Action: A concrete recommendation (e.g., "Add an index on users.email").

Severity Levels​

  • Info: Best practices and optimizations that aren't currently causing pain but will improve long-term health.
  • Warning: Issues that are currently impacting performance or represent a near-term reliability risk.
  • Critical: Immediate threats to database stability or items currently causing outages.