Answer-first summary for fast verification
Answer: Use Query Insights for Cloud SQL.
To monitor database performance and identify applications with long-running and resource-intensive queries in Cloud SQL for PostgreSQL, the best approach is to use Query Insights for Cloud SQL. Query Insights provides detailed query performance analysis, including query execution times and resource usage, which is specifically designed to help identify problematic queries. While options A, C, and D provide monitoring capabilities, they do not offer the same level of detailed query performance analysis as Query Insights. Log messages (A) can provide some insights but are not as structured or detailed. The Cloud Monitoring dashboard (C) and Cloud SQL instance monitoring (D) offer general metrics and instance health monitoring but lack the specific query performance insights provided by Query Insights.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you monitor database performance in Cloud SQL for PostgreSQL to identify applications generating long-running and resource-intensive queries when managing multiple connections?
A
Use log messages produced by Cloud SQL.
B
Use Query Insights for Cloud SQL.
C
Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
D
Use Cloud SQL instance monitoring in the Google Cloud Console.
No comments yet.