info
This is a preview feature. Preview features may be operationally incomplete and may offer limited backward compatibility.
Monitoring active server connections
The md_active_server_connections table function can be used to list all server-side connections that have active transactions.
Syntax
FROM md_active_server_connections();
This returns a list of active server connections, with the following information:
| column_name | column_type | description |
|---|---|---|
| client_duckdb_id | UUID | Unique identifier for the client DuckDB instance that initiated the connection |
| client_connection_id | UUID | Unique identifier for the client DuckDB connection that initiated the connection |
| client_transaction_id | UBIGINT | Identifier for the transaction within the current connection |
| server_transaction_stage | VARCHAR | Stage the server-side transaction is in |
| server_transaction_elapsed_time | INTERVAL | How long the server-side transaction has been in the current stage |
| client_query_id | UBIGINT | Identifier for the query within the current transaction |
| client_query | VARCHAR | Query string (possibly truncated) |
| server_query_elapsed_time | INTERVAL | How long the query has been running on the server-side |
| server_query_progress | DOUBLE | Progress information (value between 0.0 and 1.0) |
| server_interrupt_elapsed_time | INTERVAL | How long the connection has been interrupted |
| server_interrupt_reason | VARCHAR | Why the connection was interrupted |