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?