Mengoptimalkan kueri dengan penggunaan memori yang tinggi
Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
MySQL | PostgreSQL | SQL Server
Halaman ini menjelaskan pemberi rekomendasi pengoptimalan kueri dengan memori tinggi Cloud SQL yang melaporkan kueri dengan penggunaan memori yang tinggi.
Pemberi rekomendasi ini melaporkan teks kueri yang dinormalisasi dari kueri yang dihentikan untuk mencegah error kehabisan memori dalam 24 jam terakhir. Kemudian, bagian ini memberikan rekomendasi tentang cara mengoptimalkan instance tersebut dan meningkatkan performa. Rekomendasi dibuat setiap hari.
Harga
Pemberi rekomendasi Cloud SQL untuk mengoptimalkan kueri memori tinggi berada dalam Tingkat harga pemberi rekomendasiStandar.
Sebelum memulai
Sebelum Anda dapat melihat rekomendasi dan insight, lakukan tindakan berikut:
Mencantumkan rekomendasi untuk mengoptimalkan kueri dengan penggunaan memori yang tinggi
Anda dapat membuat daftar rekomendasi untuk mengoptimalkan kueri dengan penggunaan memori yang tinggi menggunakan konsol Google Cloud , gcloud CLI, atau Recommender API.
Konsol
Untuk membuat daftar rekomendasi tentang performa instance menggunakan
Google Cloud konsol, ikuti langkah-langkah berikut:
Untuk membuat daftar rekomendasi pengoptimalan untuk kueri dengan penggunaan memori tinggi menggunakan gcloud CLI, jalankan perintah
gcloud recommender recommendations list
sebagai berikut:
LOCATION: Region tempat instance Anda berada, seperti us-central1.
API
Untuk mencantumkan rekomendasi pengoptimalan untuk kueri dengan penggunaan memori tinggi menggunakan
Recommendations API, panggil metode
recommendations.list
sebagai berikut:
GET https://recommender.googleapis.com/v1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations
Ganti kode berikut:
PROJECT_ID: Project ID Anda.
LOCATION: Region tempat instance Anda berada, seperti us-central1.
Jika pemberi rekomendasi melaporkan instance dengan kueri yang dihentikan, pemberi rekomendasi akan mencantumkannya dalam tabel. Setiap baris menampilkan nama instance, rekomendasi singkat, jenis mesin saat ini, jenis mesin yang direkomendasikan, lokasi, dan tanggal pembaruan terakhir.
Lihat insight dan rekomendasi mendetail
Anda dapat melihat insight dan rekomendasi mendetail untuk mengoptimalkan kueri dengan penggunaan memori tinggi menggunakan konsol Google Cloud ,
gcloud, atau Recommender API.
Konsol
Lakukan salah satu hal berikut:
Di halaman Rekomendasi Performa, klik kartu Rekomendasi performa, lalu klik Optimalkan Kueri Memori Tinggi. Panel rekomendasi akan muncul, yang berisi insight dan rekomendasi mendetail untuk instance.
Di halaman Instances, klik Optimize High Memory Queries. Daftar instance hanya menampilkan instance yang berlaku untuk rekomendasi.
gcloud CLI
Untuk melihat insight dan rekomendasi mendetail untuk mengoptimalkan kueri dengan penggunaan memori tinggi menggunakan gcloud, jalankan perintah
gcloud recommender insights list
sebagai berikut:
Untuk melihat insight dan rekomendasi mendetail untuk mengoptimalkan kueri dengan penggunaan memori tinggi menggunakan Recommendations API,
panggil metode insights.list
sebagai berikut:
GET https://recommender.googleapis.com/v1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights
Ganti kode berikut:
PROJECT_ID: ID Project Anda.
LOCATION: Region, seperti us-central1.
Menerapkan rekomendasi
Evaluasi rekomendasi tersebut dengan cermat dan lakukan salah satu tindakan berikut:
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-09-04 UTC."],[],[],null,["# Optimize queries with high memory usage\n\n\u003cbr /\u003e\n\nMySQL \\| PostgreSQL \\| SQL Server\n\n\u003cbr /\u003e\n\nThis page describes the Cloud SQL optimize high memory queries [recommender](/recommender/docs/overview) which reports queries with high memory utilization.\n\nThis recommender reports normalized query text of the queries terminated to prevent out-of-memory errors in the past 24 hours. It then provides recommendations on how to optimize such\ninstances and improve performance. Recommendations are generated daily.\n\nPricing\n-------\n\nThe Cloud SQL optimize high memory queries recommender is in the *Standard*\n[Recommender pricing tier](/recommender/pricing).\n\nBefore you begin\n----------------\n\nBefore you can view recommendations and insights, do the following:\n\n- To get the permissions to view and work with insights and recommendations, ensure that you have the required [Identity and Access Management (IAM) roles](/sql/docs/postgres/project-access-control#roles).\n\n For more information about IAM roles, see [IAM basic and predefined roles reference](/iam/docs/understanding-roles) and [Manage access to projects, folders, and organizations](/iam/docs/granting-changing-revoking-access).\n-\n\n\n Enable the Recommender API.\n\n\n [Enable the API](https://console.cloud.google.com/flows/enableapi?apiid=recommender.googleapis.com)\n\nList recommendations for optimizing queries with high memory usage\n------------------------------------------------------------------\n\nYou can list recommendations for optimizing queries with high memory usage\nusing the Google Cloud console, [gcloud CLI](/sdk/gcloud), or the Recommender API. \n\n### Console\n\nTo list recommendations about instance performance by using the\n\nGoogle Cloud console, follow these steps:\n\n1. Go to the **Cloud SQL Instances** page.\n\n[Go to Cloud SQL Instances](https://console.cloud.google.com/sql/instances)\n\n1. Click **Expand Details** on the **Improve instance health by investigating issues and acting on recommendations** banner.\n\nAlternatively, follow these steps:\n\n1. Go to the **Recommendation Hub** . See also [Find and apply recommendations with the Recommendations](/recommender/docs/recommendation-hub/identify-configuration-problems).\n\n [Go to the Recommendation Hub](https://console.cloud.google.com/home/recommendations/)\n2. Click **Performance** in the **All recommendations** card.\n\n### gcloud CLI\n\nTo list optimization recommendations for queries with high memory usage using gcloud CLI, run the\n[`gcloud recommender recommendations list`](/sdk/gcloud/reference/recommender/recommendations/list)\ncommand as follows: \n\n```\ngcloud recommender recommendations list \\\n--project=PROJECT_ID \\\n--location=LOCATION \\\n--recommender=google.cloudsql.instance.PerformanceRecommender \\\n--filter=recommenderSubtype=POSTGRES_OPTIMIZE_HIGH_MEMORY_QUERIES\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region where your instances are located, such as `us-central1`.\n\n### API\n\nTo list optimization recommendations for queries with high memory usage using the\n[Recommendations API](/recommender/docs/using-api), call the\n[`recommendations.list`](/recommender/docs/reference/rest/v1/projects.locations.recommenders.recommendations/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region where your instances are located, such as `us-central1`.\n\nIf the recommender reports instances with terminated queries, it lists them in a table. Each row shows the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.\n\nView insights and detailed recommendations\n------------------------------------------\n\nYou can view insights and detailed recommendations for optimizing queries with high memory usage using the Google Cloud console,\n`gcloud`, or the Recommender API. \n\n### Console\n\nDo one of the following:\n\n- On the **Performance Recommendations** page, click **Performance recommendations** card, click **Optimize High Memory Queries**. The recommendation panel appears, which contains insights and detailed recommendations for the instance.\n\n- On the **Instances** page, click **Optimize High Memory Queries**. The list of instances displays only those instances for which the recommendation applies.\n\n### gcloud CLI\n\nTo view insights and detailed recommendations for optimizing queries with high memory usage using `gcloud`, run the\n[`gcloud recommender insights list`](/sdk/gcloud/reference/recommender/insights/list)\ncommand as follows: \n\n```\ngcloud recommender insights list \\\n--project=PROJECT_ID \\\n--location=LOCATION \\\n--insight-type=google.cloudsql.instance.PerformanceInsight \\\n--filter=insightSubtype=POSTGRES_HIGH_MEMORY_QUERIES_TERMINATED_TO_PREVENT_OOM\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region, such as `us-central1`.\n\n### API\n\nTo view insights and detailed recommendations for optimizing queries with high memory usage using the [Recommendations API](/recommender/docs/using-api),\ncall the [`insights.list`](/recommender/docs/reference/rest/v1/projects.locations.insightTypes.insights/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region, such as `us-central1`.\n\nApply recommendations\n---------------------\n\nEvaluate the recommendation carefully and do any of the following:\n\n- For more information, see [Optimize instance high memory usage](/sql/docs/postgres/optimize-high-memory-usage).\n- To dismiss the recommendation so that it's de-emphasized and appears dimmed, click **Dismiss**.\n- To close the panel without applying or dismissing the recommendation, click **Cancel**.\n\nWhat's next\n-----------\n\n- [Google Cloud recommenders](/recommender/docs/recommenders)\n- [About database observability](/sql/docs/postgres/observability)"]]
