Monitor and troubleshoot with Gemini assistance

Preview — Gemini in Databases

This feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms. You can process personal data for this feature as outlined in the Cloud Data Processing Addendum, subject to the obligations and restrictions described in the agreement under which you access Google Cloud. Pre-GA features are available "as is" and might have limited support. For more information, see the launch stage descriptions.

This document describes how you can use Gemini in Databases assistance to help you monitor and troubleshoot your AlloyDB for PostgreSQL resources.

• Improve query performance
• Improve system performance
• Improve index usage
• Monitor active queries

Before you begin

Ensure that Gemini in Databases is set up for your organization.

Improve query performance

As an early-stage technology, Gemini for Google Cloud products can generate output that seems plausible but is factually incorrect. We recommend that you validate all output from Gemini for Google Cloud products before you use it. For more information, see Gemini for Google Cloud and responsible AI.

To improve query performance for AlloyDB using Gemini assistance, follow these steps:

1. In the Google Cloud console, go to the Clusters page.
Go to Clusters
2. From the list of clusters and instances, click an instance.
3. Click Query Insights.
4. Click Executed Queries.
5. To open the Gemini pane, click sparkGemini.
6. In the Gemini pane, enter a prompt that describes the information that you're interested in—for example:
   • "Summarize database query trends by users."
   • "Which of my queries have high latency for this database instance?"
   • "What is the slowest query for this database in this instance?"
   • "What are the wait times for the query ID = <hash id>> in this database?"
   Gemini assistance answers questions for your current database instance.
7. To send the prompt, click Send. Gemini returns a response to your prompt based on information from the last hour.

Improve system performance

To improve system performance for AlloyDB using Gemini assistance, follow these steps:

1. In the Google Cloud console, go to the Clusters page.
Go to Clusters
2. From the list of clusters and instances, click an instance.
3. Click Query Insights.
4. To open Gemini, click sparkGemini.
5. In the Gemini pane, enter a prompt that describes the information you're interested in—for example:
   • "How many error log entries are there for this database instance?"
   • "What was the CPU utilization for this database instance around 2 PM today?"
   • "Were there any restarts in the last 7 days for this database?"
   • "When was the last instance update event in the last 24 hours for this database?"
6. To send the prompt, click Send. Gemini returns a response to your prompt based on information from the last hour.

Improve index usage

To improve index performance for AlloyDB using Gemini assistance, follow these steps:

1. In the Google Cloud console, go to the Clusters page.
Go to Clusters
2. From the list of clusters and instances, click an instance.
3. Click Query Insights.
4. Click Executed Queries.
5. To open Gemini, click spark Gemini.
6. In the Gemini pane, enter a prompt that describes the information you're interested in—for example, "What are the top queries that require indexes in my database instance?"
   Gemini assistance answers questions for your current database instance.
7. To send the prompt, click Send. Gemini returns a response to your prompt based on information from the last hour.

Monitor active queries

To improve the performance of active queries for AlloyDB using Gemini assistance, follow these steps:

1. In the Google Cloud console, go to the Clusters page.
Go to Clusters
2. From the list of clusters and instances, click an instance.
3. Click Query Insights.
4. Click Active Queries.
5. To open Gemini, click spark Gemini.
6. In the Gemini pane, enter a prompt that describes the information you're interested in—for example:
   • "What are the top queries running for this database instance?"
   • "Are there any active queries with transaction duration > 1 min for this database instance"
   Gemini assistance answers questions for your current database instance.
7. To send the prompt, click Send. Gemini returns a response to your prompt based on information from the last hour.

What's next

Learn more about the following:

• Query insights
• Enhanced query insights
• System insights
• Index advisor
• Active queries