📊 Monitor & troubleshoot your databases

Monitor & troubleshoot - AFTER deployment

At the end of this section you will be able to:

• Analyze your database host metrics;
• Analyze your database metrics;
• Get insights for the schema configuration;
• See the extensions and runtime configuration insights;
• See insights for queries executed in your database;
• Find unused indexes.

How it works

Metis integrates with your database and extracts metrics, logs, and runtime configuration. All that is done by the Metis Agent. It’s a tiny Docker container that you can run alongside your database to get all the benefits. You can run it locally (on-premise) or in the cloud.

Metis Agent is open-source and you can verify how it works. It spins up periodic tasks (CRON-like) that connect to your database, extract logs, statistics, metrics, and then posts them to the Metis platform. No confidential information is extracted.

Integrate Metis Agent

To run Metis agent, follow the 🤖 Deploy Metis Agent guide. Once you do that, you should see the list of the servers monitored by the Metis Agent:

Once you click on the server, you get the Server Observability Dashboard.

Server Observability Dashboard

The dashboard shows multiple charts: CPU (1), memory (2), throughput (3), active sessions (4), and connections (5). You can also see insights about Configurations (6), and details for a specific database (7).

You can zoom in each chart by clicking on it. You can also modify the time range by dragging the slider:

Once you click on the extensions, you get this:

You can see the list of installed extensions and insights for each one of them requiring attention. When you click on the extension, you get:

You can see the list of insights (1), the impact of each insight (2), and the instruction how to fix that (3).

When you go to configuration, you get a very similar list of configuration keys and insights:

Each insight is presented in a similar manner:

When you go to a database view, you get the database-oriented dashboard:

You can see the transactions (1), rows (2), temporary files (3), cache hits (4). You can also examine table sizes (5), schema insights (6), indexes (7),queries (8) and Extensions (9).

After clicking on the Table Sizes, you can see the details of each table:

Similarly, you can check your schemas:

Each schema has insights. Once you click on it, you go to a screen that shows the details of the impact and how to fix it:

When you go to indexes, you can see the following:

You can see the index name and other details (1), automated insights (2), and the history of the usage (3). You can click on the insights to get more details:

You can go to the Queries:

The screen shows the query texts (1), number of calls (2), average duration (3), and the insights for each query. Once you click on a query, you get details:

You can see the query text (1), the average duration over time (2), and the number of hourly calls (3). You can also click on Insights to get automated recommendations:

You can also go to the Extensions:

You can see the list of installed extensions and insights for each one of them requiring attention. When you click on the extension, you get: