Sessions
Use Sessions to investigate SQL queries that are still running in a warehouse. You can review query execution details and terminate a query that is causing problems or running longer than expected.
Open Sessions
- Log in to the VeloDB Cloud console.
- In the upper-left corner, select the warehouse to inspect.
- In the left navigation pane, under OBSERVABILITY, click Sessions.
Find active sessions
Use the filters to focus on the sessions you need to investigate:
- Active: Filter sessions by their current state.
- Cluster: Filter sessions by the cluster they are running on.
- Database: Show sessions that run against a selected database.
- User: Show sessions submitted by a selected warehouse user.
- Host: Show sessions from a client host.
- FE Host: Show sessions accepted by a selected frontend node.
To update the list automatically while you investigate, select an interval from Refresh Interval. Leave it set to off when you do not need automatic refreshes.
Review session information
Each row represents an active session. The default table shows the following information:
| Field | Description |
|---|---|
| Connection ID | Identifier for the client connection. |
| Query ID | Identifier for the running query. |
| SQL | The SQL statement being executed. |
| Database | The database used by the session. |
| User | The warehouse user that submitted the query. |
| Host | The client host and port. |
| FE Host | The frontend node that accepted the query. |
| Query Time (browser time zone) | Time when the query started. The console displays the time in your browser's time zone. |
| Execution Duration | How long the query has been running. |
Use the column chooser to show additional fields when you need more context.
View session details
Click a Query ID to inspect the running query. Use the details to confirm the SQL statement, executing user, and frontend node before you decide whether to terminate it. Open the query profile when it is available to investigate execution behavior.
Terminate a session
Select the session to terminate, then click Terminate Session. Terminate a session only when you have confirmed that stopping its query will not interrupt a required workload.
See also
- Query Audit: investigate completed queries and review available query profiles.
- Metrics: investigate resource pressure and query performance across the warehouse and clusters.
- Alerts: get notified when resource or performance metrics cross a threshold.