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_user_agent	VARCHAR	User agent for the client
client_duckdb_version	USMALLINT[3]	DuckDB version from the client
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_execution_elapsed_time	INTERVAL	How long the connection has been interrupted
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
query_total_upload_size	UBIGINT	Data uploaded in Bytes
query_total_download_size	UBIGINT	Data downloaded in Bytes