Partition Statistics

The partition_stats system table includes information about the partitions that comprise your Apache Iceberg tables.

From a worksheet within Upsolver, run the following query:

SELECT * 
FROM system.monitoring.partition_stats;

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

Column	Type	Description
catalog	string	The name of the data catalog.
compacted_files_count	bigint	The number of the files following compaction.
compacted_size	bigint	The size of the files after compaction.
id	string	The unique identifier for the partition.
partition	string	The unique name for the partition.
schema	string	The name of the schema that the table belongs to.
table_name	string	The name of the table that the partition belongs to.
uncompacted_files_count	bigint	The number of files within the partition that have not been compacted.
uncompacted_size	bigint	The size of uncompacted files within the partition.