Filter, sort and inspect results

The results grid can be filtered, sorted and paged without running the query again. Type in Filter results… to keep only rows that contain the text, click a column header to sort, and double-click a row to open it in the Row inspector.

All of this works on the rows already fetched by the query, which is at most 500.

The editor with a MySQL query and the results grid below it, showing the Filter results box, sortable column headers, row numbers and the 1–12 of 12 rows footer.

Filter

Type into Filter results… above the grid. A row stays visible if any of its cells contains the text, ignoring case. Objects and arrays (MongoDB documents, Kubernetes objects) are searched as JSON, so filtering for CrashLoopBackOff or an email domain works.

The filter resets when you run the query again. If nothing matches, the grid says “No rows match your filter.”

Sort

Click a column header to sort ascending; click it again to sort descending. Sorting compares the displayed values with numeric awareness, so 9 comes before 10. It sorts only the fetched rows. For a sort across the whole table, use ORDER BY (SQL) or sort (MongoDB) in the query.

Page through rows

The grid shows 50 rows per page. The footer shows the range, for example 1–50 of 230 rows, with previous and next page buttons. The footer also says Up to 500 rows and Read-only, and notes when the result was cut short.

Inspect a row

Double-click a row to open the Row inspector. It lists each column with its full value, and pretty-prints objects as JSON. Copy JSON copies the row as a JSON object keyed by column name.

For Kubernetes results, double-clicking a row opens the resource inspector instead. See Inspect a Kubernetes resource.

How values are shown

NULL values appear as NULL.
MySQL 64-bit integers are passed as text, so large IDs keep every digit instead of being rounded by JavaScript.
Date and time values are shown in UTC, in RFC 3339 format.
MongoDB values keep their BSON types as canonical Extended JSON. See MongoDB Extended JSON.

Export the result with Export query results to CSV. The export includes all fetched rows, not only the filtered ones.
Why a result stops early: Why results stop at 500 rows.

Frequently asked questions

Does Filter results run a new query?

No. It searches only the rows already fetched, up to 500. To search the whole table, add a WHERE clause or a filter to the query and run it again.