DAO and DAO_DETAILS only record ResultSet execution time, which is good for checking slow queries but this doesn't give us the full DB picture. In particular, it doesn't measure the impact of the following calls:
GET/SET TRANSACTION ISOLATION LEVELSET AUTOCOMMITEXECUTE STATEMENTDEALLOCATE PREPARE STATEMENTCOMMIT
We don't have to go too low level (if needed, we can always enable the jdbc.audit logger), but it would be useful to at least measure the time taken to run full transactions.
DAOandDAO_DETAILSonly recordResultSetexecution time, which is good for checking slow queries but this doesn't give us the full DB picture. In particular, it doesn't measure the impact of the following calls:GET/SET TRANSACTION ISOLATION LEVELSET AUTOCOMMITEXECUTE STATEMENTDEALLOCATE PREPARE STATEMENTCOMMITWe don't have to go too low level (if needed, we can always enable the
jdbc.auditlogger), but it would be useful to at least measure the time taken to run full transactions.