[google-cloud-sql-discuss] Re: Query Insights, "Times called" seems way off sometimes.

Hello, 

If you believe the amount of times your application calls this query is vastly overestimated, I would recommend opening an investigation with issue tracker. 

It may be necessary to open a private investigation afterwards if this is requires an indepth investigation.  

On Friday, February 19, 2021 at 2:03:30 PM UTC-5 groot...@gmail.com wrote:

Hi everyone,

been using Cloud SQL for a couple of years now, I've just enabled "Query Insights" for my GCP Cloud SQL PostgreSQL database. It looks pretty sweet, but I'm noticing that the reported "Times called" for some queries is (way) too high compared to actual usage. Making me question all of the stats.This query for example, reports around 700k inserts, however this table only holds around 60k records (and no we do not bulk delete/truncate here).

Does anybody else experience these irregularities?I've also seen weird sample explains queries, for a high-frequence SELECT statement, that includes a MODIFYTABLE cost, which is not logical for inserts.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/e76d901f-d93e-4226-8f97-6ff878667ef3n%40googlegroups.com.