High Frequency of Session Characteristic Commands in Metabase Queries

Get Help
1

Hi There,

I have faced an issue with the frequency of certain SQL commands being executed in our Metabase instance. I've noticed that commands related to setting session characteristics are being logged excessively, which might be affecting performance and resources.

Issue Description

After running a query to analyze the requests made by the user "metabase," I observed the following results:

High Frequency Commands:

  • set session characteristics as transaction read only: 7267 occurrences
  • set session characteristics as transaction isolation level read committed: 7267 occurrences
  • set session characteristics as transaction read write: 7267 occurrences

These commands seem to be executed repetitively during a specific time frame (from 2024-10-07 19:00:00 to 2024-10-08 11:00:00).

I would like to understand why this is happening and how we can reduce the frequency of these commands.

Thanks,
Mohammad Sharabati

2

these will not affect performance at all since they're a setting in your DB. The reason this is happening is because: Add ability to set transaction isolation level · Issue #13254 · metabase/metabase · GitHub