Mick McGuinness
Mick McGuinness DBmarlin Co-founder & Product Manager

DBmarlin 3.3 released - with CockroachDB improvements

DBmarlin 3.3 released - with CockroachDB improvements

We are pleased to announce version 3.3 of DBmarlin where we have added some new features for CockroachDB users as well as some other improvements and fixes.

CockroachDB improvements

With this release we have added a number of new features for CockroachDB users. In v3.3 we have improved the way we collect Execution Plans for CockroachDB. Previously we attempted to do an EXPLAIN PLAN for the top statements, but now we collect the cached plan stored within the crdb_internal schema. These plans are in JSON format rather than text, so we can now apply our tree-table formatting with master/detail split screen like we do for other databases already. This includes a button linking to the knowledge-base for each execution plan operation which has also been updated for CockroachDB, so you can find out more about what it means.

DBmarlin CockroachDB Execution Plan screen

We have changed our automatic schema change detection algorithm for CockroachDB too, so it can now pick up more changes than previously.

We have also combined the many waits showing as ‘Executing (xxx.xx%)’ (where xxx.xx could be many different values), to simply show as ‘Executing (xxx.xx%)’ which should be less confusing for users. CockroachDB doesn’t yet have a wide range of wait events like other DB engines so you will still only see ‘Executing’, ‘Executing (xxx.xx%)’ and ‘Preparing’ as the 3 states that a SQL statement spends its time.

DBmarlin CockroachDB Wait events

Other improvements

We also packed in a number of minor enhancements and bug fixes. For example the new Blocking Sessions screen for Oracle and SQL Server now has blocked and blocking time in separate columns and the alignment of the tree is now better. We fixed some bugs that arose due to the changes to granularity, such as the Copy URL button and Filters not working as they should and half-width bars on the chart in some circumstances. We also added an Agent field to the instance and host settings screens which will be used in an upcoming release to support remote agents.

Ready to try DBmarlin?

If you would like to find out more about DBmarlin and why we think it is special, try one of the links below.

dbmarlin-g2-review