O recommender de instância inativa do Cloud SQL ajuda
a detectar instâncias que podem estar inativas e fornece
insights e recomendações para ajudar a reduzir custos. Nesta página,
descrevemos como esse recomendador funciona e como usá-lo.
Como funciona
O recomendador de instâncias inativas do Cloud SQL analisa as métricas de uso de instâncias
principais que têm mais de 30 dias. Para cada instância, o recomendador
considera os valores de determinadas métricas
em um período de observação dos últimos 30 dias. O recomendador não
analisa réplicas de leitura.
Se o nível de atividade dentro do período de observação estiver abaixo de um determinado
limite, o recomendador estima que a instância está inativa. As recomendações são
geradas a cada 24 horas para encerrar essas instâncias.
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.RECOMMENDER/recommendations
Substitua:
PROJECT_ID: o ID do projeto
LOCATION: uma região, como us-central1.
RECOMMENDER: o ID do recomendador como IdleRecommender.
Se o recomendador detectar instâncias inativas, ele as listará em uma
tabela. Cada linha mostra o nome da instância, uma breve recomendação, o local
e a data da última atualização.
Ver insights e recomendações detalhadas
Para ter acesso a insights e recomendações detalhadas sobre instâncias inativas, use o
console do Google Cloud, o gcloud ou a API Recommender.
Console
Para ter acesso a insights sobre uma instância inativa no console do Google Cloud, clique no botão de recomendação na lista de instâncias.
gcloud
Para visualizar insights e recomendações detalhadas sobre instâncias inativas usando gcloud, execute o
comando gcloud recommender insights list
da seguinte forma:
gcloud recommender insights list \
--project=PROJECT_ID \
--location=LOCATION \
--insight-type=google.cloudsql.instance.INSIGHT_TYPE
Substitua:
PROJECT_ID: o ID do projeto
LOCATION: uma região, como us-central1.
INSIGHT_TYPE: o ID do tipo de insight, como ActivityInsight.
API
Para visualizar insights e recomendações detalhadas sobre instâncias inativas usando a
API Recommendations, chame o método
insights.list
da seguinte forma:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.INSIGHT_TYPE/insights
Substitua:
PROJECT_ID: o ID do projeto
LOCATION: uma região, como us-central1.
INSIGHT_TYPE: o ID do tipo de insight, como ActivityInsight.
Um painel será exibido mostrando insights sobre a instância inativa. As categorias de informações
a seguir são fornecidas com alguns gráficos de apoio.
Campos
Descrições e métricas relacionadas
Uso do disco (mudança de bytes)
Utilização de dados em bytes. Amostras coletadas a cada 60 segundos.
Pertence a database/disk/bytes_used.
Utilização máxima de CPU
A utilização máxima da CPU como uma porcentagem.
Pertence a database/cpu/utilization.
Utilização máxima da memória
A utilização máxima da memória como porcentagem.
Pertence a database/memory/utilization.
Número máximo de operações de leitura de disco
O número máximo de operações de leitura.
Pertence a database/disk/read_ops_count.
Número máximo de operações de gravação de disco
O número máximo de operações de gravação.
Pertence a database/disk/write_ops_count.
Datas de início e término da observação
As datas de início e término do período de observação de 30 dias.
A tabela a seguir lista os insights e as recomendações que o recomendador de instâncias inativas
do Cloud SQL pode gerar para ajudar a reduzir custos. Os subtipos
são visíveis nos resultados da gcloud e da API.
Insight
Recomendação
A instância mostrou níveis baixos de atividade
durante o período de observação.
Subtipo: LOW_ACTIVITY
Investigue para verificar se a instância pode
ser encerrada para reduzir custos.
Subtipo: SHUTDOWN_INSTANCE
Aplicar recomendações
Avalie as recomendações com atenção e siga um destes procedimentos:
Para examinar a recomendação, clique em Visualizar instância.
Um banner aparecerá na parte superior da página com uma recomendação.
Você pode descobrir que a instância está intencionalmente inativa e não precisa
desativá-la. No caso de uma inatividade acidental, é possível interromper
e excluir a instância. A interrupção
da instância suspende as cobranças referentes a esse recurso. Os dados da instância não são afetados
e as cobranças por armazenamento e endereços IP continuam sendo aplicadas.
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Informações incorretas ou exemplo de código","incorrectInformationOrSampleCode","thumb-down"],["Não contém as informações/amostras de que eu preciso","missingTheInformationSamplesINeed","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Outro","otherDown","thumb-down"]],["Última atualização 2025-09-04 UTC."],[],[],null,["# Identify idle Cloud SQL instances\n\n\u003cbr /\u003e\n\nMySQL \\| [PostgreSQL](/sql/docs/postgres/recommender-sql-idle \"View this page for the PostgreSQL database engine\") \\| [SQL Server](/sql/docs/sqlserver/recommender-sql-idle \"View this page for the SQL Server database engine\")\n\n\u003cbr /\u003e\n\nThe Cloud SQL idle instance [recommender](/recommender/docs/overview) helps\nyou detect instances that might be idle and provides you\ninsights and recommendations to help you reduce costs. This page describes how\nthis recommender works and how to use it.\n\nHow it works\n------------\n\nThe Cloud SQL idle instance recommender analyzes the usage metrics of primary\ninstances that are older than 30 days. For each instance, the recommender\nconsiders the values of certain [metrics](/monitoring/api/metrics_gcp_c#gcp-cloudsql)\nwithin an observation period spanning the last 30 days. The recommender does not\nanalyze read replicas.\n\nIf the activity level within the observation period is below a certain\nthreshold, the recommender estimates that the instance is idle. Recommendations are\ngenerated every 24 hours for shutting down such instances.\n| **Warning:** It's highly recommended that you evaluate the insights and in-context charts. Consult with the appropriate team to determine whether the flagged instance is inadvertently idle and can be deleted.\n\nPricing\n-------\n\nThe Cloud SQL idle instance recommender is in the *Standard* [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 [roles](/sql/docs/mysql/project-access-control#roles).\n\n For more information about roles, see [understanding roles](/iam/docs/understanding-roles) and [granting IAM permissions](/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 idle Cloud SQL instance recommendations\n--------------------------------------------\n\nYou can list idle instance recommendations by\nusing the Google Cloud console, `gcloud`, or the Recommender API. \n\n### Console\n\nTo list recommendations about idle instances by using the\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)\n2. Click **View all** on the idle instance recommendations banner.\n\nAlternatively, follow these steps:\n\n1. Go to the **Recommendation Hub**.\n\n [Go to the Recommendation Hub](https://console.cloud.google.com/home/recommendations/)\n\n For more information, see\n [Getting started with Recommendation Hub](/recommender/docs/recommendation-hub/identify-configuration-problems).\n2. In the **Reduce Cloud SQL instance cost** card, click **View all**.\n\n3. Click the **Shut down instance** tab.\n\n### gcloud\n\nTo list recommendations about idle instances by using `gcloud`, 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.RECOMMENDER\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- \u003cvar translate=\"no\"\u003eRECOMMENDER\u003c/var\u003e: The ID of the recommender as `IdleRecommender`.\n\n### API\n\nTo list recommendations about idle instances by using the\n[Recommendations API](/recommender/docs/using-api), call the\n[`recommendations.list`](/recommender/docs/reference/rest/v1beta1/projects.locations.recommenders.recommendations/list)\nmethod as follows. \n\n```\nGET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.RECOMMENDER/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, such as `us-central1`.\n- \u003cvar translate=\"no\"\u003eRECOMMENDER\u003c/var\u003e: The ID of the recommender as `IdleRecommender`.\n\nIf the recommender detects idle instances, it lists them in a\ntable. Each row shows the instance name, a brief recommendation, the location,\nand the last refresh date.\n\nView insights and detailed recommendations\n------------------------------------------\n\nYou can view insights and detailed recommendations about idle instances by\nusing the Google Cloud console, `gcloud`, or the Recommender API. \n\n### Console\n\nTo view insights about an idle instance by using the\nGoogle Cloud console, click the recommendation button in the list of instances.\n\n### gcloud\n\nTo view insights and detailed recommendations about idle instances by 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.INSIGHT_TYPE\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- \u003cvar translate=\"no\"\u003eINSIGHT_TYPE\u003c/var\u003e: The ID of the insight type as `ActivityInsight`.\n\n### API\n\nTo view insights and detailed recommendations about idle instances by using the\n[Recommendations API](/recommender/docs/using-api), call the\n[`insights.list`](/recommender/docs/reference/rest/v1beta1/projects.locations.insightTypes.insights/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.INSIGHT_TYPE/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- \u003cvar translate=\"no\"\u003eINSIGHT_TYPE\u003c/var\u003e: The ID of the insight type as `ActivityInsight`.\n\nA panel appears showing insights about the idle instance. The following\ncategories of information are provided along with some supporting charts.\n\nThe following table lists the insight and recommendation that the Cloud SQL\nidle instance recommender might generate to help you reduce costs. The subtypes\nare visible in the `gcloud` and API results.\n\nApply recommendations\n---------------------\n\nEvaluate the recommendations carefully and do any of the following:\n\n- To examine the recommendation, click **View instance**.\n\n A banner appears at the top of the page providing a recommendation.\n\n You might find that the instance is intentionally idle and you don't need to shut\n it down. If it's inadvertently idle, you can [stop](/sql/docs/mysql/start-stop-restart-instance#stop)\n and [delete](/sql/docs/mysql/delete-instance) the instance. Stopping an\n instance suspends instance charges. The instance data is unaffected,\n and charges for storage and IP addresses continue to apply.\n\n Exercise caution when [stopping](/sql/docs/mysql/start-stop-restart-instance#stop)\n or [deleting](/sql/docs/mysql/delete-instance) an instance. To avoid\n the loss of data, [create a backup](/sql/docs/mysql/backup-recovery/backing-up#on-demand) first.\n- To dismiss the recommendation so that it's de-emphasized and appears dimmed,\n click **Dismiss**.\n\n- To close the panel without applying or dismissing the recommendation, click\n **Cancel**.\n\nYou can also [export these recommendations to BigQuery](/recommender/docs/bq-export/export-recommendations-to-bq)\nand examine them by using [Looker Studio](/bigquery/docs/visualize-looker-studio) or [Looker](/bigquery/docs/looker).\n\nWhat's next\n-----------\n\n- [Monitor disk availability](/sql/docs/mysql/using-ood-recommender)\n- [Reduce overprovisioned Cloud SQL instances](/sql/docs/mysql/recommender-sql-overprovisioned)\n- [Blog: Maximize your Cloud ROI](https://cloud.google.com/blog/products/management-tools/active-assist-comes-to-google-cloud)\n- [Blog: Do more with less](https://cloud.google.com/blog/products/databases/reduce-cloud-sql-costs-with-optimizations-by-active-assist)\n- [Google Cloud recommenders](/recommender/docs/recommenders)"]]
