Skip to main content

Log Explorer

Log Explorer is an interactive query tool for log analytics. It lets you search, filter, and aggregate logs directly from the console, with an interface designed for high-volume log retrieval at scale. To open Log Explorer:

  1. Go to the VeloDB Cloud console.
  2. In the left navigation pane, click Log Explorer.

Interface layout​

Log Explorer is divided into four areas:

Top input area: Select the cluster, table, time field, and query time range. The main input box supports two modes: keyword search and SQL. Click Query to run the search.

Left field panel: Lists every field in the current table, grouped into Selected fields and Available fields. Pick which fields appear in the detail panel. You can also filter by field values directly from this panel.

Middle trend chart: Shows the number of matching log entries over time as a bar chart. Hover over any bar to see the exact count and timestamp for that interval.

Bottom detail panel: Displays the matching log rows. Click a row to open its full detail. Both table and JSON formats are supported; the table format also lets you build filters interactively.

To get started, select a table. For example, select internal_schema > audit_log. Log Explorer queries its fields and selects the first time field automatically.

Keyword search mode​

  1. Click the mode dropdown in the top input area (it defaults to SQL).
  2. Select Search.
  3. Type your keyword in the input box.
  4. Click Query.

Keyword search mode requires an inverted index on the target table. If the table does not have one, the Search option is disabled and a tooltip appears: "Please create an inverted index for this table first."

Matches are highlighted in the detail panel, and the trend chart updates to show how many entries match over time.

Note:

Search uses MATCH_ANY under the hood to match keywords across every field in the log. Highlighting will try to cover all search keywords, but because of special characters the highlight may not be character-exact. To match a phrase, wrap it in double quotes, for example, "GET /api/v1/user". Phrase search uses MATCH_PHRASE under the hood.

SQL mode​

When you need a more precise match, switch the input box to SQL mode:

  1. Click the mode dropdown in the top input area.
  2. Select SQL.
  3. Type a filter condition, for example state = 'EOF'.
  4. Click Query.

As you type, a dropdown suggests available fields from the selected table.

Row details and context​

Click any row in the detail panel to expand its full contents.

Detail tabs​

  • Table: Displays fields as rows. Next to each value are three buttons:
    • +: Add an equivalent filter (field = value).
    • -: Add a non-equivalent filter (field != value).
    • folder icon: Add this field as a column to the detail table.
  • JSON: Displays the raw log entry as JSON.

Click Contextual Search on the right side of a row to open the search panel. It shows the log entries before and after the selected row.

  • Click Load 5 items to fetch older or newer records.
  • Click Filter to open the filter builder. Select a field, operator, and value, then click Confirm to apply it.