Database Monitoring Widgets

There are eight database-related monitor dashboard widgets for the eight new resource types. These are found in the Widget Type Selection Panel's Widget Type, Monitor category:

Buffer Cache Size – The size of the database buffer cache, in bytes.



Deletes – The number of DELETE statements issued to the database (MySQL, Oracle, SQL Server), or the number of rows deleted from the current catalog (PostgreSQL).



Disk Sorts – The number of sorts that required creating a temporary table on the disk. This metric is not supported when monitoring PostgreSQL. The Disk Sorts widget does a simple count. When the count is zero, the Y-axis lists 1, 2, 3, 4.



Full Table Scans – The number of full table scans across all queries.



Index Scans – The number of index scans across all queries.



Inserts – The number of INSERT statements issued to the database (MySQL, Oracle, SQL Server), or the number of rows inserted into the current catalog (PostgreSQL).



Selects – The number of SELECT statements issued to the database (MySQL, Oracle, SQL Server), or to the current catalog (PostgreSQL).



Updates – The number of UPDATE statements issued to the database (MySQL, Oracle, SQL Server), or the number of rows updated in the current catalog (PostgreSQL).