You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded

Question

Options

• AView Cloud SQL operations to view historical query information.
• BWhite a Logs Explorer query to identify database queries with high execution times.
• CReview application logs to identify database calls.
• DUse the Query Insights dashboard to identify high execution times.

• A
  3% (2)
• B
  5% (3)
• C
  9% (6)
• D
  83% (54)

Explanation

The Query Insights dashboard is a built-in Cloud SQL feature specifically designed for query performance analysis. It provides visibility into query execution times, resource consumption, and slow query identification directly within the Cloud Console-no additional configuration or log parsing needed. Cloud SQL operations logs (A) track administrative actions, not query performance. Logs Explorer (B) does not surface per-query execution metrics from Cloud SQL in a usable way. Application logs (C) may show database call durations from the app side but do not provide database-level query statistics or execution plans.

No community discussion yet for this question.