[google-cloud-sql-discuss] Re: Unable to see query plan samples for query insights

We were running into this issue too and by chance noticed after deleting an existing database with many schemas (40k+) that insights were suddenly available. I do not know if the issue is related to the schema counts, nor if it will return when it grows 'high' again.

On Wednesday, August 25, 2021 at 8:15:21 AM UTC-5 her...@shopbehold.com wrote:

Hi,

I am using query insights, but I am unable to see any query plan samples:

Looking at the database logs, I noticed these log messages:

storage/speckle/postgres/extensions/google_insights/google_insights.c:1102: Unable to report sampled query plan for <query> due to hashtable size limit

I cannot find any information on what hashtable this is referring to. Anyone have ideas on how to 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/e88ddc3e-1559-4b66-85de-0ea62f29454bn%40googlegroups.com.