Skip to main content

Running Queries

After you build a query, you might want to run it. You might run a query to perform an action on your data (such as INSERT or DELETE), or you might test a query that you intend to save as a query worker.

Run a Query​

You can run a query in the Macrometa console, from the Macrometa CLI, or using an API endpoint.

Run a Query in the Console​

  1. Log in to your Macrometa account.
  2. Click Compute > Query Workers.
  3. In the Editor, select C8QL or SQL, depending on which language you want to write the query in.
  4. Write a SQL C8QL query.
  5. Enter any required bind parameter values.
  6. Click Run Query.

Macrometa runs the query and displays the Query Result for that query. Each query you run displays another Query Result unless you navigate away from the page or clear the results.

Run a Query with CLI​

  1. Install the CLI as described in Install gdnsl.
  2. Enter queries using gdnsl query. For more information and examples, refer to the CLI Queries documentation.

API Endpoint​

For more information, refer to API Endpoints.

Execution Plan​

note

Execution Plan is only available with C8QL queries.

After you write a query, click Execution Plan to see a detailed breakdown of the query compilation and execution pipeline. Basically, it shows you how Macrometa performs the query. The details given can be helpful when tuning or debugging complex queries.

Execution Plan

Query Result​

Query results vary based on the query. Queries that return information display that information. Queries that do not, perhaps because they are entering or deleting information, just display empty brackets []. The following screenshot shows a query with information returned when running it in the UI.

Query Result

The result of a query is an array of values. The individual values in the result array might have a homogeneous structure, depending on what is actually queried.

For example, when returning data from a collection with inhomogeneous documents (the individual documents in the collection have different attribute names) without modification, the result values will as well have an inhomogeneous structure. Each result value itself is a document:

FOR u IN users
    RETURN u
[ { "id": 1, "name": "John", "active": false }, 
  { "age": 32, "id": 2, "name": "Vanessa" }, 
  { "friends": [ "John", "Vanessa" ], "id": 3, "name": "Amy" } ]

However, if a fixed set of attributes from the collection is queried, then the query result values will have a homogeneous structure. Each result value is still a document:

FOR u IN users
    RETURN { "id": u.id, "name": u.name }
[ { "id": 1, "name": "John" }, 
  { "id": 2, "name": "Vanessa" }, 
  { "id": 3, "name": "Amy" } ]

It is also possible to query just scalar values. In this case, the result set is an array of scalars, and each result value is a scalar value:

FOR u IN users
    RETURN u.id
[ 1, 2, 3 ]

If a query does not produce any results because no matching data can be found, it will produce an empty result array:

[]

Query Profile​

Click Query Info to display detailed performance information about the query.

View options​

If your query returned results, then you can display them in Table or JSON format. Default is Table.

Clear results​

To clear a specific result, click Clear next to the result.

To clear all results, click Clear All under the Query Editor.

Running Queries tab​

Click the Running Queries tab to see information about any queries currently running, including the bind parameters, runtime, and when the query started.

Running Queries tab

Slow Query History tab​

Click the Slow Query History tab to see information about any queries currently running, including the bind parameters, runtime, and when the query started.

Slow Query History tab