Skip to main content

v26.02: Database Monitoring: Queries Monitor

The Queries Monitor is a new administration tool accessible from the Explore pane under Admin Central > Queries Monitor (positioned below Settings, with fa-server icon). Access is restricted to users with Workspace Owner or Workspace Admin roles. The ellipsis icon beside Queries Monitor provides a "New Tab" option to open it in a separate browser tab.

The monitor displays a grid of active database queries exceeding a configurable time threshold (default: 2 minutes). The time interval textbox accepts positive integers only — decimal values, negative numbers, and special characters display a validation error "Please enter a positive number." Values exceeding 50,000 display "Maximum row limit is 50,000."

If the textbox is cleared, the system reverts to the default value of 2 on refresh. Grid columns include: PID, User, Database, Started, Elapsed Time, Query, State, Event Type (Lock/IO/NULL), and Event. When no queries exceed the threshold, the grid displays an empty state.

Terminate Long-Running Queries

  1. Review the grid to identify queries causing performance issues.

  2. Select one or more queries using the row checkboxes (a header checkbox provides select all/deselect all).

  3. Click the Terminate button in the L2 header (enabled only when rows are selected).

  4. In the confirmation dialog, click Confirm to proceed or Cancel to abort.

  5. The system terminates the selected queries. The grid auto-refreshes, checkboxes clear, and the Terminate button returns to disabled state.

A manual Refresh button re-executes the query and updates the grid, displaying a timestamp of the last refresh (for example, "Just now" or "2m ago").

Was this article helpful?

We're sorry to hear that.