AI SQL Tuner Studio vs pgwatch

AI SQL Tuner Studio is a Windows tool for analyzing and tuning SQL queries. Its supported databases include Microsoft SQL Server, Azure SQL Database, and Azure SQL Managed Instance. The listed capabilities cover query analysis, wait and lock analysis, and query plan capture, giving database users several ways to examine query behavior. The free plan costs nothing and is limited to SQL Server Developer Edition. Paid plans are billed monthly: Standard costs $10 a month and Pro costs $15 a month, and each lists up to 2 server connections. Corporate costs $20 a month and lists unlimited server connections. The site also lists a 14-day trial. The product is listed for Windows, rather than web or mobile platforms. Buyers can compare the free edition's database-edition restriction with paid plans' connection allowances when deciding which plan fits their setup.

pgwatch is a free, open-source metrics collector and visualization solution for PostgreSQL databases. A remote daemon periodically connects to databases and reads PostgreSQL statistics using a normal database user, without special database rights or server-side extensions. Grafana presents the metrics and lets users add graphs; optional alerts can go through Mail, Slack, or PagerDuty. Metrics can be extended using pure SQL, and supported storage options include PostgreSQL, Prometheus, JSON File, and RPC. A built-in web interface manages databases and metric definitions and displays logs. pgwatch supports PostgreSQL 14 and newer, including single instances, high-availability clusters, pooled environments using PgBouncer or Pgpool II, and Patroni cluster managers. It is self-hosted, with a one-minute Docker installation described alongside custom installation options. The FAQ says it can be deployed fully on premises. Some operating-system metrics may be unavailable on cloud-managed PostgreSQL services because of platform restrictions.