[google-cloud-sql-discuss] Re: Query insight doesn't work

6.  On a new CloudSQL instance everything works.

In the logs there queries for query insights:

 

We really need this feature. Can anyone help? :)

On Monday, February 8, 2021 at 2:45:54 PM UTC+1 Peter Kowenzowski wrote:

I''m trying to turn on this feature for 9.6 postgres which already exists for 2 years.

1. I waited for a few hours, but nothing pop up.

2. I enabled pg_stat_statements, but didn't help.

3. Regarding colab: it doesn't seem that I must do some additional steps except enabling query insights in GUI.

4. I try to enable google_insights extension manually, but I get an error:

Detail: Supported extensions are "bloom:1.0, btree_gin:1.0, btree_gist:1.2, chkpass:1.0, citext:1.3, cube:1.2, dblink:1.2, dict_int:1.0, dict_xsyn:1.0, earthdistance:1.1, fuzzystrmatch:1.1, hstore:1.4, intagg:1.1, intarray:1.2, ip4r:2.4, isn:1.1, lo:1.1, ltree:1.1, pg_buffercache:1.2, pg_prewarm:1.1, pg_stat_statements:1.4, pg_trgm:1.3, pgaudit:1.1.2, pgcrypto:1.3, pgrowlocks:1.2, pgstattuple:1.4, plpgsql:1.0, postgis:2.3.0, postgis_tiger_geocoder:2.3.0, postgis_topology:2.3.0, prefix:1.2.0, sslinfo:1.2, tablefunc:1.0, tsm_system_rows:1.0, tsm_system_time:1.0, unaccent:1.1, uuid-ossp:1.1, postgres_fdw:1.0, pg_freespacemap:1.2, pg_visibility:1.2, pageinspect:1.5, pgfincore:1.2, pg_repack:1.4.4, hll:2.12, plproxy:2.9.0".

5. I think query insights are somehow corrupted for our database. CloudSQL log with "insights" query:

6. I will try to enable query insights on a new CloudSQL instance.

On Friday, January 29, 2021 at 12:44:26 AM UTC+1 Jan Kleinert wrote:

If you just enabled it, it may take a few minutes before you start to see the data coming through. Is it working for you now?

On Thursday, January 28, 2021 at 12:38:08 PM UTC-5 pe...@airspace-intelligence.com wrote:

There is new feature called query insights. However, doesn't work for us:

--
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/7a1b513d-3d78-440d-ad69-83c8204cd42en%40googlegroups.com.