What’s New In SelectStar in September: Expanded Query Plans, Improvements to MongoDB, Full-Stack Relationship Maps and More
We’ve been sprinting so hard this September, we’re completely out of breath. Check out the latest functionality we’ve just recently pushed live while we cool off with an ice-cold LaCroix. Unfortunately for us, we don’t have this kind of service in our office.
Enhanced and Expanded Query Plans
Our Postgres Query Plans have been an extremely popular since we rolled them out in July. We continue to add this feature to other DBMS platforms. Most recently, we’ve added a Query Plan tree feature for MySQL that gives you a logical, visual representation of your query plan with the ability to easily drill down into execution details. Look for us to continue to expand this feature to other platforms in future releases. In fact, we’re working on adding it to Oracle in our current sprint.
We’ve also enhanced the PostgreSQL Query Plan trees, also view additional execution details and cumulative cost for actions in your Query Plan trees. We’ve also provided more guidance and controls around Query Plans in general.
Improvements to the MongoDB Dashboard
If you’re running MongoDB, you’ve probably already noticed the changes we’ve made to your dashboard. We’ve re-styled the single cards into a consolidated, more easy-to-read view of your database performance. Look for a more cohesive view, particularly in larger environments. We’ve also made it a little easier to navigate the heatmap, by visually highlighting your selection as you mouse over it.
Figure 2: The improved MongoDB overview dashboard.
A Smarter Universal Time Series Selector
Look for stronger visual cues like those we made to the MongoDB heatmap to make their way into other parts of the platform. In fact, we’ve added some functionality to our Universal Time Series Selector to reflect the way you’re actually using this feature. Now, when you click on a past alert from the Database Activity tab to investigate further, the Universal Time Selector will automatically update to the time range when it occurred, allowing you to see what was happening in the environment when it was triggered. In addition, when you update to a new time range, you’ll see a brief flash, indicating the graphs and activity has been updated to reflect your selection.
Full-Stack Relationships and Clearer Infrastructure Metrics
One of the features that sets SelectStar apart from other database performance monitoring platforms is the ability to see your underlying infrastructure metrics. We’ve upped the ante here by adding detailed relationship mapping on the Relationships Map. It’s a feature we’ve been recognized for at Blue Medora for a number of years. Now we’ve brought that functionality to SelectStar. The next time you visit the the Database Relationships Map, you’ll see it has been expanded to give you greater visibility into your entire database stack. This map should be your go-to for root cause analysis. It’s a fast way to find infrastructure issues, like CPU, network or disk limitations that are dragging your database down.
Figure 3: Full-Stack visibility now included on the Relationships Map
And to make it easier for you to quickly separate your infrastructure metrics from your database metrics, we’ve added new labels and links to the Database Advanced tab, so you can easily drill down on your VMware, AWS, Microsoft Azure or Google Cloud environment. As you drill down, you may notice we’ve refined the prefix-naming of your infrastructure-related metric graphs to be more meaningful and concise–another way to help you find what you need more quickly and easily.
Stronger Query Search and More
We know a lot of you are spending time troubleshooting slow queries, so we always are looking for ways to improve the Query Overview and Query Deep Dive views. To that point, you’ll notice you can now search for and copy specific query text from the Query table itself. In addition, you can now click on a query from the Query table to hop directly into the Query Deep Dive view.
Another time saver, we’ve refined the Amazon RDS alerts to clear out some of the noise. You should see fewer notification-level events from your RDS instance status alerts. With that, it’s time to set down this LaCroix and head back to work.
Stay on top of the latest updates by subscribing to our blog newsletter below. In the meantime, try out a free trial of SelectStar to see our new features in action.