SQLlyQuery Insights
✓ functionalBounded top-query statistics from Query Store, pg_stat_statements, or Performance Schema.
The top 50 queries for the database, sourced from whatever store the
engine keeps: SQL Server Query Store, PostgreSQL
pg_stat_statements, or MySQL / MariaDB Performance Schema.
Each row shows the query text with its average duration, execution count, and a
reads-shaped column named for what the engine really measures - logical reads on SQL
Server, buffer accesses on PostgreSQL, rows examined on MySQL.
- Rank cycles the ordering: average duration, executions, or reads.
- Time window - last hour, 24 hours, 7 days, or all time - on SQL Server, whose Query Store keeps time intervals; the other engines are cumulative since their last reset, and the button says so instead of pretending.
- Open Selected Query puts the row's SQL in an editor tab - it never re-runs anything by itself.
Needs the store enabled. The pane probes the collector when it opens. If it is off, it says so - and where a statement can fix it, offers to script one for review:
ALTER DATABASE … SET QUERY_STORE = ON for SQL Server, CREATE EXTENSION pg_stat_statements for PostgreSQL. MySQL's Performance Schema is a server-configuration switch, and the pane is honest about that too.