Explore
Explore
The query console: editor, results, chart and the field rail.
Explore is the console's query surface. It is the same LSQL and the same engine the API uses — nothing you can do here is unavailable to a script.
The layout
| Area | What it does |
|---|---|
| Editor | LSQL with completion over the dataset's real fields. ⌘↵ runs |
| Chart | Drawn automatically when the result has a time column and a number |
| Results | The table. Click any cell to add it as a filter |
| Datasets rail | Switch dataset; the editor's completion follows |
| Fields rail | Every field with its type. Click to project it, ⌥-click to where on it |
Shortcuts
| Key | Does |
|---|---|
⌘↵ | Run |
⌘K | Command palette — datasets, saved queries, dashboards |
⌘S | Save the query |
⌘/ | Comment the selected lines |
⌥↑ / ⌥↓ | Move a pipe stage up or down |
⎋ | Cancel a running query |
Move a stage instead of retyping it
⌥↑ reorders pipe stages. Pulling a where above an extend is the most common query optimisation, and it is one keystroke.Reading the cost line
Under every result: rows examined, rows matched, blocks scanned and elapsed time. Blocks scanned is the number that matters — it is what a tighter time filter reduces, and it is proportional to what the query costs.