Skip to main content

SQL Statistic Settings


Turning on the collection of these extra SQL statistics will apply to all instances of that particular technology that have “Collect SQL Statistics” turned on in the instance settings.

From the left menu select Settings/SQL Statistics and then click the Edit button for the database technology you wish to collect extra SQL Statistics for.


Choosing which extended SQL Statistics to collect


We have descriptions of the SQL Statistics and what they mean in our Knowledge-base

Once you click into a particular database technology, you can choose which additional SQL Statistics to collect. These will be different depending on the technology as they are dependent on what the database vendor provides. The more SQL statistics you turn on, the more disk space you will need for your DBmarlin repository, therefore we suggest only turning on the ones that you need. After selecting all the statistics you would like collected, click the Update button to save the changes.



For the change to take effect you should restart one of your sensors of the same technology.

The set of SQL Statistics shown for each technology is the superset of all that are available across all versions of that technology. For example, if you have an older database version then it might not be possible to collect certain SQL Statistics if that SQL Statistic only became available in a later version of the database. In this case a value of 0 will be shown on the charts.

SQL Statistics Supported versions

In some cases, the SQL Statistics only became available in new releases of the database engine. These are the Database versions which allow collection of SQL Statistics.

Database engineSQL Stats supported
CockroachDB21.2 and above
Db210.5 and above
Informix14 and above
MySQL5.6 and above
MariaDB10 and above
Oracle11g and above
PostgreSQL9 and above
SAP HANA2 and above
SQL Server2008 and above