Diagnose database health from the CLI

July 29, 2026

The pscale CLI now includes two read-only diagnostic commands for Postgres and Vitess databases:

• pscale insights — server-side analysis of production traffic:
  • insights queries — top queries ranked by total time, count, p99 latency, rows read, and more
  • insights errors — failing query patterns with error messages
  • insights anomalies — detected resource anomalies (CPU, memory, IOPS, rows)
  • insights recommendations — schema recommendations with ready-to-apply DDL
• pscale inspect — live point-in-time checks over a read-only connection (same credential model as pscale sql): table and index sizes, unused and redundant indexes, long-running queries, locks, bloat, vacuum stats, replication slots, and more. Run inspect all for a combined report, or pick individual checks like locks or table-sizes.

Both commands support --format json (and csv for individual inspect checks) for scripting and agents.

Read the CLI docs · inspect