Videos

Tables Summary view shows all tables involved in the query execution. We can use this view to quickly understand access patterns, see indexes, number of extracted rows, or how accurate our filters are.

Metis Metadata Collector (MMC) is a component that connects to your database and extracts data for the dashboard.

Metis Metadata Collector (MMC) Dashboard is a component in Metis that shows the observability dashboard, charts, metrics, and all the monitoring of your database server. MMC Dashboard is a must-have tool for every production database.

In this video we see how to integrate our JavaScript (or TypeScript) based application with Metis. We cover main flow, end-to-end tests, and connecting all of the pieces together.

Execution Plan tab shows us the raw execution plan extracted from the database. We can use this screen to get the plan and use it with other tools of our choice.

Query can be very complex and consist of multiple layers. The easiest way to understand how it works is to see it. Query Tale tab of the Performance Insights can visualize the query and show all operations it performed.

Performance Insights is crucial for understanding how the query will perform in production. In this video we explore insights, remediation plans, how to access the automated analysis performed by Metis, and how to reason whether the performance should be improved.

When we observe issues with a query, the first thing to check is what is the query text. With SQL tab of the Performance Insights we can see the query with parameters, see which tables it tries to access, and what was generated by the ORM.

Main Project Page is an entry point for all of the functionality for performance tracking. In this video we explore features it has and how it works.

We can integrate Metis with our CI/CD pipeline to automatically analyze schema migrations. We can use that to automatically find issues with tables, columns, indexes, partitions, and other DDL queries that we trigger when deploying the application. Featured playlist

We can integrate Metis with our CI/CD pipeline to automatically capture performance traces for every pull request we create. We can use that to automatically analyze performance of the code modified in a given pull request. This way we can find the performance degradation before going to production.

We can integrate Metis with our CI/CD pipeline to automatically capture performance traces every time we push a code to repository. We can use that to automatically analyze performance before going to production or even to staging environment.

Query Analyzer module is a tool for ad-hoc analysis of your queries. Just insert your SQL query + execution plan, and you get performance insights. Metis will analyze tables, indexes, functions, filters, I/O, buffers, and other performance metrics. You'll also get instruction how to fix the issues.

Like there are so many application tools available, Metis believes that database monitoring and observability fits the new era where developers are accountable for everything related to their database. From pre-deployment validation, monitoring, to the final troubleshooting. We believe developers deserve better tools to perform their database related activities.

Our SQL queries typically work well when we run them locally. There is no load, no concurrent transactions, not much data in the database. Problems pop up when we deploy to production and we realize the queries are just too slow. Let’s make sure this doesn’t happen and we can identify problems before deploying the code.

You can’t deploy blindly and let your application fail. You need to prevent the bad code from reaching production, monitor your databases, and automatically troubleshoot when something is wrong. You need database guardrails, and you need them now.

Today's topic is Extensions in PostgreSQL. Listen to learn why they are useful, how to use them, and which extensions are a must-have for our databases.

In this episode, we talk to Adam Furmanek (Head of DevRel at Metis) about what database developers can do to ensure their applications work and scale. Adam discusses monitoring, observability, and things to consider pre & post production.

One of the most common issues that cause production outages is the database, poor schema migrations, resource bottlenecks, and just plain misconfiguration can bring you to your knees. In the episode we explore the world of database observability. https://www.metisdata.io/

An interview with Adam Furmanek from Metis, about developers' relation to databases and a demo of Metis.

on't miss out! Join us at our upcoming event: KubeCon + CloudNativeCon Europe in Amsterdam, The Netherlands from 18 - 21 April, 2023.

CI/CD is now a well-known part of software development. We have tools for linting, unit testing, UI testing, database schema migration, infrastructure as code, and many others. We review our code and make sure it is safe to deploy to production. However, what about SQL queries? Do we check them on a regular basis? Do we make sure they will work in a production environment?