AI 지원 문제 해결은 표준 PostgreSQL 구성을 기반으로 유용한 정보를 제공합니다. 분리된 스토리지, 캐싱, 열 형식 엔진, 최적화된 백그라운드 프로세스를 비롯한 AlloyDB의 고유한 아키텍처로 인해 특정 검사 및 권장사항이 실제 AlloyDB 성능 측정항목과 다를 수 있습니다. AI 지원 문제 해결 권장사항을 시작점으로 고려하고 AlloyDB 문서에서 명확한 안내를 참고하는 것이 좋습니다.
최상의 결과를 얻으려면 Google Cloud 콘솔에서 AI 지원 문제 해결을 사용 설정한 후 24시간 동안 기다려 AlloyDB가 인스턴스, 데이터베이스, 쿼리의 평균 성능 기준을 빌드하도록 하세요.
Gemini Cloud Assist를 설정한 후 서비스가 전파될 때까지 5분 정도 기다려야 AlloyDB에서 AI 지원 문제 해결을 사용 설정할 수 있습니다.
필수 역할 및 권한
AI 지원 문제 해결을 사용하는 데 필요한 권한을 얻으려면 관리자에게 AlloyDB 인스턴스를 호스팅하는 프로젝트에 대한 데이터베이스 통계 뷰어 (roles/databaseinsights.viewer) IAM 역할을 부여해 달라고 요청하세요.
역할 부여에 대한 자세한 내용은 프로젝트, 폴더, 조직에 대한 액세스 관리를 참조하세요.
이 사전 정의된 역할에는 AI 지원 문제 해결을 사용하는 데 필요한 권한이 포함되어 있습니다. 필요한 정확한 권한을 보려면 필수 권한 섹션을 펼치세요.
AlloyDB 인스턴스에 AI 지원 문제 해결을 사용 설정하면 AlloyDB가 데이터베이스의 성능을 분석하고 쿼리 실행 시 이상치를 감지할 수 있습니다. AlloyDB에서 쿼리 성능의 이상치를 감지하거나 높은 시스템 부하를 식별하면 AI 지원 문제 해결을 통해 증거를 기반으로 상황을 분석하고 추천을 제공할 수 있습니다.
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-09-04(UTC)"],[],[],null,["# Monitor and troubleshoot with AI assistance\n\n\u003cbr /\u003e\n\nThis document describes how you can use AI assistance to help you monitor and troubleshoot\nyour AlloyDB for PostgreSQL resources. You can\nuse the AI-assisted troubleshooting tools of AlloyDB\nand [Gemini Cloud Assist](/gemini/docs/cloud-assist/overview) to\n[improve query performance](#improve-query-performance) and\n[monitor system performance](#monitor-system-performance).\n| As an early-stage technology, Gemini for Google Cloud\n| products can generate output that seems plausible but is factually incorrect. We recommend that you\n| validate all output from Gemini for Google Cloud products before you use it.\n| For more information, see\n| [Gemini for Google Cloud and responsible AI](/gemini/docs/discover/responsible-ai).\n\nLimitations\n-----------\n\nThe following limitations apply to AI-assisted troubleshooting in AlloyDB:\n\n- AI-assisted troubleshooting offers valuable insights based on standard PostgreSQL configurations. AlloyDB's unique architecture, including its disaggregated storage, caching, columnar engine, and optimized background processes, means that certain checks and recommendations can differ from actual AlloyDB performance metrics. We recommend that you consider AI-assisted troubleshooting recommendations as starting points and refer to the [AlloyDB documentation](/alloydb/docs/overview) for definitive guidance.\n- For the best results, wait 24 hours after you [enable AI-assisted troubleshooting](#enable-ai-assisted-ts) in the Google Cloud console to let AlloyDB build a baseline of the average performance of your instance, database, and queries.\n- AI-assisted troubleshooting isn't supported for the following AlloyDB configurations:\n - Instances inside a [VPC Service Controls perimeter](/vpc-service-controls/docs/overview)\n - Instances enabled with [Access Transparency](/assured-workloads/access-transparency/docs/overview)\n\nBefore you begin\n----------------\n\n[Ensure that\nGemini Cloud Assist is set up for your Google Cloud user account\nand project](/gemini/docs/cloud-assist/set-up-gemini).\n\nAfter you set up Gemini Cloud Assist,\nyou might need to wait five minutes to let the service propagate\nbefore you can enable AI-assisted troubleshooting\nin AlloyDB.\n\n\u003cbr /\u003e\n\n### Required roles and permissions\n\n\nTo get the permissions that\nyou need to use AI-assisted troubleshooting,\n\nask your administrator to grant you the\n\n\n[Database insights viewer](/iam/docs/roles-permissions/databaseinsights#databaseinsights.viewer) (`roles/databaseinsights.viewer`)\nIAM role on the project that hosts the AlloyDB instance.\n\n\nFor more information about granting roles, see [Manage access to projects, folders, and organizations](/iam/docs/granting-changing-revoking-access).\n\n\nThis predefined role contains\n\nthe permissions required to use AI-assisted troubleshooting. To see the exact permissions that are\nrequired, expand the **Required permissions** section:\n\n\n#### Required permissions\n\nThe following permissions are required to use AI-assisted troubleshooting:\n\n- ` databaseinsights.performanceIssues.detect `\n- ` databaseinsights.performanceIssues.investigate`\n\n\nYou might also be able to get\nthese permissions\nwith [custom roles](/iam/docs/creating-custom-roles) or\nother [predefined roles](/iam/docs/roles-overview#predefined).\n\nEnable AI-assisted troubleshooting\n----------------------------------\n\nWhen you enable AI-assisted troubleshooting for your AlloyDB instance,\nAlloyDB can analyze the performance of your databases and detect\nanomalies in the execution of your queries. When AlloyDB detects\nanomalies in query performance or identifies high system\nload, AI-assisted troubleshooting helps you analyze the situation with evidence\nand provides recommendations.\n\nTo enable AI-assisted troubleshooting\nfor your AlloyDB instance, do the following:\n\n1. In the Google Cloud console, go to the **Clusters** page.\n\n [Go to Clusters](https://console.cloud.google.com/alloydb/clusters)\n2. From the list of clusters and instances, click an instance.\n\n3. Click **Query insights**.\n\n4. Click either **Enable** or **Edit settings**.\n\n5. In the **Edit query insights settings** tab, select the **Enable advanced query insights features for AlloyDB** checkbox.\n\n By default, this turns on the **AI-assisted troubleshooting** checkbox.\n | **Note:** Enabling advanced query insights features requires you to restart your instance.\n6. Click **Save**.\n\nFor more information about enabling advanced query insights, see\n[Improve query performance using advanced query insights](/alloydb/docs/using-advanced-query-insights#enable-advanced-features).\n\n\nOpen Gemini Cloud Assist\n------------------------\n\nTo use Gemini Cloud Assist with AlloyDB,\ndo the following:\n\n1. In the Google Cloud console, go to the **Clusters** page.\n[Go to Clusters](https://console.cloud.google.com/alloydb/clusters)\n2. From the list of clusters and instances, click an instance.\n3. Click **Query insights**.\n4. To open the **[Cloud Assist panel](/gemini/docs/cloud-assist-panel)** , click spark **Open or close Gemini AI chat**.\n5. In the **Cloud Assist panel**, enter a prompt that describes the information that you're interested in.\n6. After you enter the prompt, click send **Send prompt**. Gemini returns a response to your prompt based on information from the last hour.\n\nImprove query performance\n-------------------------\n\nUse AI assistance to troubleshoot individual slow queries in AlloyDB\nin using the **Query insights** dashboard.\nFor more information, see [Troubleshoot slow queries with AI assistance](/alloydb/docs/troubleshoot/slow-queries-ai).\n\nYou can also use Gemini Cloud Assist to enter prompts to help\nyou improve the performance of your queries. Gemini Cloud Assist\nanswers questions for the selected AlloyDB instance and database.\n\n### Examples of query performance prompts\n\nMonitor system performance\n--------------------------\n\nYou can use AI assistance to analyze database load in AlloyDB from the\n**Overview** page or the **Query insights** dashboard.\n\nFor more information, see\n[Troubleshoot high database load with AI assistance](/alloydb/docs/troubleshoot/high-database-load-ai).\n\n\nYou can also use Gemini Cloud Assist to enter prompts to gather\ninformation about your system performance. Gemini Cloud Assist\nanswers questions for the selected AlloyDB instance.\n\n### Examples of system performance prompts\n\nGet index recommendations\n-------------------------\n\n| **Note:** You don't need to enable AI-assisted troubleshooting to obtain index recommendations.\n\nYou can obtain index recommendations from AlloyDB in query insights.\n\nFor more information, see\n[Index advisor overview](/alloydb/docs/index-advisor-overview).\n\n\nIn addition, using Gemini Cloud Assist, you can get more\ninformation about how to use indexes in your databases.\nGemini Cloud Assist answers questions for the\nselected AlloyDB instance.\n\n### Examples of index recommendation prompts\n\nMonitor active queries\n----------------------\n\n| **Note:** You don't need to enable AI-assisted troubleshooting to monitor active queries.\n\nUse the **Query insights** dashboard to monitor active queries, and if necessary,\nterminate long-running processes.\n\nFor more information, see\n[Monitor active queries](/alloydb/docs/monitor-active-queries).\n\n\nIn addition, using Gemini Cloud Assist, you can enter prompts\nto find out more information about queries that cause high latency or CPU load.\nGemini Cloud Assist answers questions for the selected\nAlloyDB instance.\n\n### Examples of active query prompts\n\nWhat's next\n-----------\n\n- Learn how to [write better prompts](/gemini/docs/discover/write-prompts).\n- Learn how to use the [Gemini Cloud Assist panel](/gemini/docs/cloud-assist-panel).\n- Read [Use Gemini for AI assistance and development](/gemini/docs/overview)\n- Learn [how and when Gemini\n for Google Cloud uses your data](/gemini/docs/discover/data-governance)."]]
