Parse & Analyze MySQL and MariaDB Slow Query Logs

Free, Instant, In-Browser

Make sense of your slow query logs without the setup tax. Load your slow query log files and instantly see execution times, lock times, and rows examined - sorted, filtered, and ready to act on. Your data never leaves the browser.

Launch Analyzer

100% private

Parsed entirely in your browser. No log data is ever uploaded or transmitted. Works offline.

Aggregated metrics

Count, total time, avg, min, max, rows examined vs. rows sent. Sort by dimension.

Drill-down view

Inspect individual query samples, per-execution stats, and raw log entries.

2GB+ file support

Streams and parses large log files in chunks to support importing millions of queries.

how it works
01

Enable slow query logging

Configure MySQL and MariaDB to write queries exceeding your threshold to a log file. See the setup guide below for the exact config variables.

02

Open the analyzer

Click "Launch Analyzer" and load your slow-query.log. The WASM parser runs entirely in your tab - no upload required.

03

Drill into problem queries

Sort the digest by total time, or rows examined. Drill-down to inspect individual query samples, time distribution, per-execution stats, and raw log entries.

MySQL & MariaDB configuration
Enable slow query logging

Add the following to your my.cnf or my.ini under the [mysqld] section. Works for both MySQL and MariaDB. Changes take effect on restart, or you can set them live with SET GLOBAL.

slow_query_log Enables the slow query log. Set to ON or 1.
slow_query_log_file Absolute path where MySQL and MariaDB write the log. Default is /var/log/mysql/slow.log.
long_query_time Threshold in seconds. Queries exceeding this are logged. Try 1 to start; lower to 0.1 for more coverage.
log_queries_not_using_indexes Logs queries that perform full table scans - useful even for fast queries that will cause problems at scale.
min_examined_row_limit Minimum rows examined before logging. Prevents noise from tiny fast queries on small tables.
my.cnf - [mysqld] 
# Enable slow query logging
slow_query_log = ON
slow_query_log_file = /var/log/mysql/slow.log

# Log queries slower than N seconds
long_query_time = 1

# Also log full table scans
log_queries_not_using_indexes = ON

# Ignore trivial tiny-table queries
min_examined_row_limit = 100
live - SET GLOBAL (no restart) 
SET GLOBAL slow_query_log= 'ON';
SET GLOBAL long_query_time = 1;
SET GLOBAL log_queries_not_using_indexes = 'ON';
SET GLOBAL min_examined_row_limit = 100;
verify - check current settings 
SHOW VARIABLES LIKE '%slow%';
SHOW VARIABLES LIKE 'long_query_time';