System Functions

This page provides reference information for the system-related functions in Databend. These functions help you analyze and monitor the internal storage and performance aspects of your Databend deployment.

Table Metadata Functions

Function	Description	Example
CLUSTERING_INFORMATION	Returns clustering information of a table	CLUSTERING_INFORMATION('default', 'mytable')

Storage Layer Functions

Function	Description	Example
FUSE_SNAPSHOT	Returns snapshot information of a table	FUSE_SNAPSHOT('default', 'mytable')
FUSE_SEGMENT	Returns segment information of a table	FUSE_SEGMENT('default', 'mytable')
FUSE_BLOCK	Returns block information of a table	FUSE_BLOCK('default', 'mytable')
FUSE_COLUMN	Returns column information of a table	FUSE_COLUMN('default', 'mytable')
FUSE_TAG	Returns snapshot tag information of a table	FUSE_TAG('default', 'mytable')

Storage Optimization Functions

Function	Description	Example
FUSE_STATISTIC	Returns statistics information of a table	FUSE_STATISTIC('default', 'mytable')
FUSE_ENCODING	Returns encoding information of a table	FUSE_ENCODING('default', 'mytable')
FUSE_VIRTUAL_COLUMN	Returns virtual column information	FUSE_VIRTUAL_COLUMN('default', 'mytable')
FUSE_TIME_TRAVEL_SIZE	Returns time travel storage information	FUSE_TIME_TRAVEL_SIZE('default', 'mytable')