Get Started Free

Slow Query Analysis

Identify and analyze slow queries with detailed execution metrics. View queries grouped by collection with COLLSCAN warnings, execution plans, scan metrics, and duration highlighting. Search, filter by time range, operation type, and collection to pinpoint performance bottlenecks. Export results to CSV or JSON for further analysis.

Runs of a slow aggregation listed with their time, keys and documents read, documents returned and plan, above the full profile entry

Index Recommendations

Get intelligent index recommendations based on profiled queries. Automatically detects missing indexes causing collection scans, calculates performance impact with priority scoring, and provides ready-to-use index creation commands. View benefits, query patterns, and ESR (Equality, Sort, Range) ordered index suggestions for optimal performance.

Index advice ranking suggested indexes by priority and impact, each with Create index and Copy buttons

Visual Performance Insights

Monitor query performance with an interactive execution-time timeline you can zoom into. Filter by time range, operation type, minimum duration, and collection. View operations grouped by operation, query shape, or exact query with detailed metrics including mean time, total time, count, and quick access to query details.

Each operation plotted on a zoomable timeline, with the selected query highlighted and its suggested index alongside

The Same Profiler on SQL Databases

Connect to PostgreSQL, MySQL, MariaDB, SQL Server, Oracle or ClickHouse and the profiler charts each statement over time, with rows examined against rows returned, scans without an index, cache hit ratio and p95. Open a statement for its plan and index advice written in your database's own SQL. More on SQL profiling →

SQL Query Profiler charting PostgreSQL statements over time above a table of statements with their execution counts and timings
VisuaLeaf visual query builder assembling a MongoDB filter from dropdowns

Visual Query Builder

Identify slow queries in the Profiler, then optimize them using the Visual Query Builder. See which queries need indexes, then rebuild them visually with proper field selection and filtering. Close the loop between profiling and optimization.

VisuaLeaf visual schema diagram generated from existing MongoDB collections

Visual Schema

Use the Query Profiler to find performance bottlenecks, then view your schema to understand why. See which fields lack indexes, identify missing relationships, and plan schema improvements based on actual query patterns from the profiler.

VisuaLeaf SQL Query Profiler with a chart of statement time and the slowest statements

SQL Query Profiler

Tuning a SQL database too? The SQL Query Profiler works the same way for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle and ClickHouse: find the slowest statements, read their plans and get a CREATE INDEX suggestion.

Want to Learn More?

Check out the documentation to explore all the details about the Query Profiler and discover more VisuaLeaf features.

Read the Documentation

Ready to transform your MongoDB workflow?

Get started free with our Community Edition. Includes a 14-day trial of Pro features.

macOS Windows Linux