Skip to main content

Results Panel

Lets discuss this in detail
As a first example, let's execute this query:

select * from airport limit 120;

Toolbar Status​

This is the status of the query run. Result Chip: Either Success or Fatal Time: Time taken to run the query Docs: Number of documents returned Size: Server memory used to run the query

Toolbar Buttons​

Export Button: Exports the results either in json or csv depending on whether the current view is json or table Views Toggle Buttons: These are the different views:

  • JSON
  • Table
  • Chart
  • Plan
  • Index Advisor

JSON View​

workbench-results-json

Table View​

workbench-results-table

Note: Table is horizontally scrollable
When you hover on the column header, the sort arrow and a kebab menu are shown

Table Filters​

workbench-table-filter

Filter Example: Columns​

workbench-table-filter-column

Filter Example: Name​

Let's filter on airportname workbench-table-filter-post

info

For the remaining Views, we will use the Query:

SELECT city City, COUNT(DISTINCT name) LandmarkCount
   FROM landmark
   GROUP BY city
   ORDER BY LandmarkCount
   DESC LIMIT 10;

Chart View​

You can select from Bar,Pie or Line charts workbench-results-chart

Plan View​

This is the query Plan workbench-results-plan

Index Advisor View​

workbench-results-advisor

  • The Index Advisor is available automatically
  • Notice the Badge on Icon.
    • This will pop up if there are any recommendations
    • The Badge also shows the number of recommendations
  • Currently, the Build buttons are not available