Unable to see query plan samples for query insights

[Herman Radtke]

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?

[Nathan Giebel]

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.