Solve database bottlenecks faster with the latest query insights for Cloud SQL Enterprise Plus

Cloud SQL Enterprise Plus edition provides high performance and availability for demanding applications with enhanced read and write performance. And high-performance applications often require that you tune the underlying database services. 

To help application developers and DBAs build and deploy high performing applications, we’ve added new capabilities to query insights for Cloud SQL Enterprise Plus edition. This new database observability offering builds on top of the existing query insights capabilities in Cloud SQL Enterprise edition, and provides a unified and comprehensive observability experience that helps developers and database teams optimize performance faster than ever. Query insights for Cloud SQL Enterprise Plus edition captures and analyzes query telemetry and statistics to surface key performance indicators, diagnostic reports, and recommendations to enhance performance in an easy-to-consume format in the Google Cloud console. These signals and recommendations help application developers and database teams observe and tune overall database performance quickly, easily, and efficiently.

With the new enhanced capabilities in query insights for Cloud SQL Enterprise Plus edition, you can:

• Solve nuanced database performance issues faster than ever before. Access fine-grained database metrics such as wait events to conduct deeper root-cause analysis. With richer, near-real-time diagnostics, you can easily analyze query executions at a granular level. Query insights for Cloud SQL Enterprise Plus edition also helps you detect query plan regressions by capturing plans for all unique query executions and highlighting the rate-determining step for each execution.

• Control your active query executions. Gain visibility into the queries currently running in your system. You can also choose to terminate sub-optimally running queries to unblock other critical queries and manage system resources better.

• Enhance database performance with intelligent recommendations tailored for dynamic workloads. Query insights for Cloud SQL Enterprise Plus edition automatically analyzes workloads, highlights performance issues, and provides recommendations to solve them. It looks for common problems like missing indexes, missing or incorrect flags, etc. to help optimize queries and tune databases.

• Use an AI-powered chat interface to ask your performance-related questions. Query insights for Cloud SQL Enterprise Plus editions comes along with an AI-powered natural language interface that provides advanced troubleshooting tips and tailored recommendations to make the resolution of complex database problems easier.

Let’s look at these capabilities in more detail.

Detailed query plans with 30-day telemetry 

With 30 days of telemetry data, you can analyze long-term trends and identify recurring issues in query performance. By reviewing detailed query execution plans and comparing them over time, you can pinpoint inefficiencies and make data-driven optimizations for sustained database improvements.

Wait events 

Wait events in query insights help you identify where your database is stuck, such as on disk I/O or locks. This enables faster diagnosis of performance bottlenecks and smarter resource optimization.

Index recommendations 

Index recommendations help you identify performance bottlenecks by detecting missing indexes and providing precise, actionable recommendations to improve query performance. These recommendations offer specific SQL index-creation commands, showing their potential performance impact and highlighting the impacted queries, thereby streamlining the process of database performance optimization.

Get started

Query insights for Cloud SQL Enterprise Plus edition democratizes access to enterprise-grade observability for tier-1 workloads on Google Cloud managed databases. Empowered by these advanced performance management capabilities, get ready to simplify complex workflows, monitor database health, write better queries, and meaningfully optimize system performance. This reduces mean-time-to-resolution for database performance issues, and allows application developers and database teams to focus more on the core business logic.

Query insights for Cloud SQL Enterprise Plus edition is now available in preview. Simply access query insights within the console and begin monitoring and managing your database performance. To get started, please visit our documentation.