2026.08.2 Release

Docker tag: quay.io/pganalyze/enterprise:v2026.08.2

Notes

  • This is a patch release on top of 2026.08.0 and 2026.08.1
    • This release does not have any new database migrations, and is easy to apply (or rollback)
    • If you’re upgrading from a release before 2026.08.0, be sure to read those release notes, and follow the recommended upgrade steps
  • This release contains important security fixes, including an update to Ruby 3.4.13. We recommend all installations upgrade.
  • Single Sign-On: Only accept sign-in requests for the configured DOMAIN_NAME
    • When the DOMAIN_NAME setting is set, Single Sign-On (SAML, LDAP) and connecting the Slack integration now only work when pganalyze is accessed under that hostname. Requests arriving under a different hostname or IP address are rejected with an “Authentication error” message.
    • Before upgrading, verify that DOMAIN_NAME matches the hostname your users and your Identity Provider use to reach pganalyze. The value must be a hostname only, without a protocol or port (e.g. pganalyze.example.com). Installations that do not set DOMAIN_NAME will continue accepting all hosts, but show a warning in the log.
  • Workbooks Collector Workflow: Require current Postgres minor versions on the connected server
    • In an abundance of caution, this requires that a server used with the Collector Workflow is patched against the November 2026 set of Postgres minor releases (18.7, 17.12, 16.16, 15.20, 14.25) to avoid potential privilege escalation through Postgres vulnerabilities. Note this may produce a false positive in case a provider patched the server without bumping up the minor version.

Features

  • Update combined collector from v0.74.0 to v0.76.0
    • See the collector changelog for 0.75.0 and 0.76.0 for the full details
    • This includes security fixes in the collector, such as the pg_query_go update addressing GHSA-6ggm-xmc9-8ffg
  • Connection Traces: Link to autovacuum runs
    • The Connection Traces view now links to autovacuum runs that are currently in progress. Previously they would show up as <unparsable query> and not provide any additional information.
  • pganalyze MCP Server: Add new get_system_stats tool for system metrics
  • pganalyze MCP Server: Return more details in existing tools
    • get_tables now includes the index ID and a link for each index, backend details include information about the running query, and issue references link to the relevant pages
  • pganalyze MCP Server: Add .devin.ai and ampcode.com to the default OAuth DCR redirect host allowlist
  • Accessibility: Improve color contrast and screen reader labels throughout the app

Bugfixes and other improvements

  • Schema Statistics:
    • Correctly show the autovacuum_enabled state in the VACUUM/ANALYZE Activity tab when set to any truthy value
    • Don’t treat every table as changed when the collector version changes
    • Mark constraints as removed when a table loses its last constraint
  • Index Advisor:
    • Fix costing of hypothetical scans when generating index recommendations for submitted queries
    • Add a 30 minute timeout to index selection runs, and enforce the runtime limit while generating index candidates
  • Query Analysis: Fix analysis of queries that use subscripted array constructors, like (ARRAY[...])[1]
  • Queries: Fix EXPLAIN plan list timing out on queries with many captured plans
  • API: Omit databases that no longer exist on the server
  • OAuth: Improve scope handling for older OAuth clients
    • OAuth clients (such as MCP clients) that registered before a scope was introduced no longer fail to authorize when requesting all supported scopes. They are now granted the scopes they registered for.
  • Neon, Supabase, PlanetScale: Correctly record the system type for these providers
  • Connection Traces: Validate the backend identifier when looking up backend details
  • Server Settings: Show the system scope as a separate cell in Debug Info
  • Organization Settings: Fix styling of the remove member panel
  • Add logging to the daily Check-Up worker
  • Enterprise license check: Keep the existing license file if the license server can’t be reached or returns an error
    • Previously the license file would be overwritten with the error response, or deleted. Invalid license file contents are now handled more gracefully, and errors from the daily license refresh are logged.

Performance

  • Query Advisor: Speed up the check-up for inefficient index use
  • Server Groups: Avoid N+1 queries when loading summary statistics

Security

GraphQL API changes

  • Add supportsCpuMetrics, supportsMemoryMetrics, supportsIoMetrics and supportsNetworkMetrics fields to SystemInfoType
  • Add vacuumRun field to backends, linking to the in-progress autovacuum run
  • Add postgres_outdated status to the Workbooks Collector Workflow status
  • getBackendDetails: Return an error for invalid backend locators
  • getLogLineDetails: Return an error for OAuth tokens with the “restricted read” scope, unless the collector filters all log secret kinds
  • getQueryExplains: Cap the returned EXPLAIN plans to 50 when a time range is passed, matching the existing cap without a time range

Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →