Qrulla Docs

Safety and administration

Monitor and performance

See who is connected, what is locked and which queries cost the most, and get index suggestions.

Max plan. Works with MySQL, MariaDB, PostgreSQL, SQL Server and Oracle.

Open the monitor

Right-click a connected connection → “Sessions and performance”, or “Monitor” in the toolbar. A tab opens with:

Sessions

Each session with its user, database, client, program, state, time, what it's waiting on, who blocks it and its SQL (running or the last one). On top:

  • a search box for user, database, program or SQL;
  • “Hide idle”, which never hides the ones that block or wait;
  • automatic refresh every few seconds while the tab is in view.

When you pick a session you can Cancel query (stops the statement; the session stays connected) or End session (disconnects it; if it had an open transaction, the server rolls it back). Both ask for confirmation. The monitor's own session is marked.

Locks

Which objects are locked, by whom, in what mode, and who is waiting. Sessions that block others stand out in “Sessions”.

Costly SQL

The statements that took the most time since the server started keeping statistics: executions, total and average time, CPU, reads and rows. Double-click opens one in the editor; in Oracle, “Show plan” shows the plan it used.

PostgreSQL needs the pg_stat_statements extension (in shared_preload_libraries and with CREATE EXTENSION pg_stat_statements). MySQL and MariaDB, performance_schema=ON. If they aren't on, Qrulla tells you how to turn them on.

Suggest indexes

Right-click a schema → “Suggest indexes…”. Qrulla checks:

  • foreign keys without an index, which slow down JOINs and every delete on the parent table;
  • where the server keeps statistics, slow queries that read whole tables;
  • in SQL Server, the indexes the server itself asked for, with how much they'd improve those queries.

It doesn't create anything: it gives you the scripts to review and run from the editor. On big tables, creating an index may block writes for a while.

In Oracle only foreign keys are checked, because its advisors need separate licenses (Tuning Pack).

The plan, in plain words

In the SQL editor, “Plan” explains in sentences what the server will do with your query and where an index would help.

Something missing or unclear? Write to support@qrulla.com.