Wednesday, October 6, 2021

[google-cloud-sql-discuss] storage/speckle/postgres/extensions/google_insights/google_insights.c:1102: Unable to report sampled query plan

After enabling Query Insights, our Cloud SQL Postgres logs are full of logs like this:

"LOG: storage/speckle/postgres/extensions/google_insights/google_insights.c:1102: Unable to report sampled query plan for SELECT xxx due to hashtable size limit"

How do I fix this? It's very spammy, makes it hard to find useful logs, and seems to indicate that some portion of our database's queries are not actually being tracked by Query Insights. Would increasing the query length for Query Insights fix this?

--
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/259747e8-ae31-44c9-a83f-ade417114c91n%40googlegroups.com.

No comments:

Post a Comment