We are pleased to announce the release of DBmarlin 5.6. This month we have been busy adding a brand new Object Browser screen where you can see table and index statistics.

🔍 New Object Browser for Tables, Indexes & Columns

We’ve introduced a brand new Object Browser screen where you can view details for tables, indexes, and columns—including key statistics such as:

• Row counts
• Distinct column values
• Object sizes

The Insights tab also provides information on things like:

• Unused indexes
• Tables with missing Primary key
• Foreign key columns without indexes

We have also included navigation directly from elements in execution plans to the Object Browser, making it much easier to investigate performance.

To enable the collection of object statistics, head to Settings -> Instances -> Advanced Mode, there’s now a toggle to control whether Object Statistics are collected.

Available now for both PostgreSQL and MySQL.

🛠 Many other enhancements

As usual we’ve also crammed in several other updates and fixes into this release.

• MySQL JDBC driver has been updated for better compatibility and performance.
• Data retention for recommendations has been optimised to reduce storage use.
• SQL literal detection has been added to catch excessive use, as another recommendation.
• CockroachDB SQL stats aggregation has been refined for accuracy.
• Event History granularity is now consistent across the product—most events are collected once per minute.

See the release notes for a full list of changes. https://docs.dbmarlin.com/docs/Release-notes/v5.6.0