Improved Key Visualizer and Slow Queries

[dveeden]

Feature Request

The current "Key Visualizer" looks like this:

And the "Slow Queries" page looks like this:

The key visualizer page is great for use by DBA's that focus on the complete system, but isn't great for developers that only focus on a specific database that is used for the (part of) the application that they are working on.

The slow query page has a dropdown to select one or more databases, the key visualizer page doesn't have this. The key visualizer allows you select a focus area with the "Select & Zoom" button.

As a developer I would want to focus on the schema I'm interested in without seeing data from other schemas that might be from other applications that I don't have influence over.

Improvement 1

Add a dropdown for database schema on the "Key Visualizer" page.

Improvement 2

Make the schema and table names on the "Key Visualizer" page clickable.

Improvement 3

Combine the key visualizer and slow query pages

This is a mock-up:

This is similar to what "Top SQL" shows:

But "Top SQL" shows CPU time, not hotspots etc. Note that "Top SQL" also doesn't let you focus on a single schema.

[baurine]

/cc @lilyjazz

[lilyjazz]

@dveeden Thank you for your suggestion. I think it's reasonable, we will design this scenario soon.