Help Center/Admin Operations/Run a read-only SQL query and read its plan
Admin Operations•Last updated: 2026-10-20•4 min read

Run a read-only SQL query and read its plan

The "SQL Editor" tab runs SQL in Read-only mode by default. "Explain" shows the query plan without running the statement.

Have questions or need step-by-step guidance on this topic?

Ask AI Copilot

Step-by-Step Procedure

1

Open the editor

In the Database Explorer click "SQL Editor" (or press Alt+3). The box starts with SELECT now() AS server_time;. Clicking a table in the left list inserts its name at the cursor.

2

Check the mode

The "Mode" switch should read "Read-only" (green).

3

Run

Click "Run" (Ctrl/Cmd+Enter) to run the selection or the whole script, or "Run statement" (Ctrl/Cmd+Shift+Enter) for the statement at the cursor.

4

Read the results

A header shows the statement count, time and audit ID; a tab per statement lets you switch; "Export CSV" saves the grid. Results beyond the limit show "truncated".

5

Explain

Click "Explain" (Ctrl/Cmd+E) to see "Query plan (not executed)". "Format" tidies the SQL.

Expected Operational Outcome

The query results or plan appear below the editor. Every statement is written to the audit ledger before it runs.

Was this guide helpful?

Help us refine our platform documentation