Execution Plan Insights - Easily analyze SQL queries and their execution plans using built-in insights.
Simple and Intuitive visualization of the EXPLAIN output. We used PEV2, the best open source UI component for Execution Plan visualization. Instead of manually copy-pasting the plan into their site, explain.dalibo.com, the visualization is integrated with the VS Code.
Analysis of the table’s schema to see which indexes were not used. Quickly detect table scans and WHY none of the existing indexes was used
Get deep insights, enriched by the metadata from the production.
General analysis of the tables and indexes, not in the context of a specific query.
App Logs Instrumentation
Log and link the calling REST API to its related SQL commands
Analyze batch of log records
Easy integration with the development lifecycle. For example Analyzing all the SQL commands generated by a specific Pull Request
Easy instrumentation, just 2 lines of code. Starting with Python SQLAlchemy .
Built-in integration with other ORM Log Collectors such as Django Silk. Silk logs the SQL Commands to the DB. Simply configure Metis to use that DB, we are familiar with the tables created by Silk and how to use them.
CI/CD integration
Automated analysis. Still in private beta.
SQL Library
Useful commands we cherry picked to help you get a deeper understanding of the DB. These are the queries we use to build our Insights Engine.
Versions History
V0.1.46 (Apr 7th 2022)
PG Query Analysis
Table Analysis
Index Analysis
Static Schema Analysis (SSA) of the tables and indexes
V0.1.47 (Apr 19th 2022)
SQL LIB Related Command
SQL LIB Command Parameters
V0.1.48 (May 03th 2022)
Run Postgres Functions
V0.1.49 (May 16th 2022)
Welcome page
Insight new UI
V0.1.50(Jun 14th 2022)
Add error handler on query analyze
Credit
We love open source and use great libraries and UI components to give you a better dev tool .
The Execution Plan UI component is the best open source created for this task. Built by Dalibo.