Advisory Types

pgpulse monitors dozens of different patterns and signals. Here are some of the most common types of advisories you'll see in your dashboard.

Missing Index Candidate: Identify high-impact queries that are currently performing sequential scans.
Query Latency Regression: Alerts you when a query starts performing significantly worse than its 7-day baseline.
Inefficient Query Pattern: Detection of common pitfalls like N+1 select patterns or cross-joins.
High Temporary File Usage: Detects queries that exceed work_mem and spill to disk.

Connection Saturation Risk: You are approaching your max_connections limit.
Lock Contention hotspot: Frequent blocking on specific tables or rows.
Vacuum Lag / Bloat Risk: Autovacuum isn't clearing dead rows fast enough.
IO Saturation Risk: Physical disk performance is reaching its limit.
Long-Running Transactions: Transactions held open for longer than 5 minutes.
Slow Queries by Endpoint: Aggregated view of how specific application routes are impacting the database.