Table Statistics

The table_stats system table includes information about the partitions in your Apache Iceberg tables.

From a worksheet within Upsolver, run the following query:

SELECT * 
FROM system.monitoring.table_stats;

The system.monitoring.table_stats table includes the following columns:

Column	Type	Description
avg_files_per_partition	bigint	The average number of files in each partition.
avg_partition_size	bigint	The average size of a partition in the table.
catalog	string	The name of the data catalog.
id	string	The unique identifier for the table.
partition_count	bigint	The number of partitions comprising the table.
schema	string	The name of the schema the table belongs to.
table_name	string	The name of the Iceberg table.
total_files_count	bigint	The total number of files comprising the table.
total_table_size	bigint	The size of the table across all files.