In Google cloud, you can use Terraform to enable Query Insights for Cloud SQL which is for both Postgres and MySQL. Query Insights provides detailed query-level telemetry and monitoring data to empower our users to investigate performance issues. Here is a complete terraform template with query insights enabled.