Answer-first summary for fast verification
Answer: White a Logs Explorer query to identify database queries with high execution times., Use the Query Insights dashboard to identify high execution times.
To identify slow-running queries in a Cloud SQL for PostgreSQL instance, the most effective methods among the provided options are using the Query Insights dashboard and writing a Logs Explorer query. Query Insights is specifically designed to help identify and analyze query performance issues, including high execution times. Similarly, writing a Logs Explorer query allows you to filter and analyze database logs for queries with high execution times. Reviewing application logs (Option C) might provide some indirect information but is not as direct or efficient as the other two methods. Viewing Cloud SQL operations (Option A) is more about monitoring operations rather than analyzing query performance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As a Cloud SQL for PostgreSQL administrator with pgaudit disabled, users report slower query execution and degraded performance over recent months. How can you gather and analyze query performance data to pinpoint slow-running queries?
A
View Cloud SQL operations to view historical query information.
B
White a Logs Explorer query to identify database queries with high execution times.
C
Review application logs to identify database calls.
D
Use the Query Insights dashboard to identify high execution times.
No comments yet.