Enable database.instrument_queries with SQLite

Grafana
,
1

Hello!

I have a Grafana OSS (v11.5.1) deployed in an EKS cluster with the default SQLite database using an AWS EFS volume.

I wanted to check the latency of the database queries and wanted to enable instrument_queries but got the following error:

Error: ✗ provide Resource DB: the Resource API is attempting to 
leverage the database from core Grafana defined in the 
[database] INI section since a database configuration was not 
provided in the [resource_api] section. But we detected that the 
key `instrument_queries` is enabled in [database], and that 
setup is currently unsupported. Please, consider disabling 
that flag

Excerpt of the Helm Chart’s values yaml file:

grafana:
  grafana.ini:
    database:
      log_queries: true
      instrument_queries: true
#    resource_api:
#      db_log_queries: false
#      db_type: sqlite3

After reading the previous error, I checked in the Administration → General → Settings this resource_api setting, but if try to set db_type: sqlite3, I got another error:

Error: ✗ provide Resource DB: invalid db type specified: sqlite3

I also enabled log_queries, but want to have Prometheus metrics if possible.

So, my question is, it is possible to instrument the queries with my current setup or I am doing something wrong?

Thank you for your help!