Query Insights, "Times called" seems way off sometimes.

[Tobias Groothuyse]

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.

[gonzalezwalter]

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.