Administration Commands

This page provides reference information for the system administration commands in Databend.

System Monitoring

Command	Description
SHOW PROCESSLIST	Display active queries and connections
SHOW METRICS	View system performance metrics
KILL	Terminate running queries or connections
RUST BACKTRACE	Debug Rust stack traces

Configuration Management

Command	Description
SET	Set global configuration parameters
UNSET	Remove configuration settings
SET VARIABLE	Manage user-defined variables
SHOW SETTINGS	Display current system settings

Function Management

Command	Description
SHOW FUNCTIONS	List built-in functions
SHOW USER FUNCTIONS	List user-defined functions
SHOW TABLE FUNCTIONS	List table-valued functions

Storage Maintenance

Command	Description
VACUUM TABLE	Reclaim storage space from tables
VACUUM DROP TABLE	Clean up dropped table data
VACUUM TEMP FILES	Remove temporary files
SHOW INDEXES	Display table indexes

Dynamic Execution

Command	Description
EXECUTE IMMEDIATE	Execute dynamically constructed SQL statements