GCP CloudSQL Query Insights
Query Insights is a free service provided by Google that lets you see metrics into your queries. It is available for MySQL and PostgreSQL. With Query Insights you can see CPU usage, execution time, number of times the query has been run etc.
Warning: Enabling this service will incur a small downtime of two or three minutes.
Here's an image of what Query Insights provides:

How to enable
https://cloud.google.com/sql/docs/postgres/using-query-insights


Permissions
If you'd like to give someone permissions to view Query Insights, see this article: Cloud SQL Query Insights permissions (https://app.clickup.com/2496230/docs/2c5q6-69975/2c5q6-235935)