在Synapse Analytics中查询所有表的大小

SELECT 
    t.name AS TableName,
    SUM(pdw_node_id) AS NumberOfPartitions,
    SUM(total_pages) * 8 AS TotalSpaceKB, 
    SUM(used_pages) * 8 AS UsedSpaceKB, 
    (SUM(total_pages) - SUM(used_pages)) * 8 AS UnusedSpaceKB
FROM 
    sys.tables t
INNER JOIN      
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN 
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN 
    sys.dm_pdw_nodes_db_partition_stats db_partition_stats ON p.OBJECT_ID = db_partition_stats.OBJECT_ID AND p.index_id = db_partition布斯stats.index_id AND p.partition_number = db_partition_stats.partition_number AND db_partition_stats.distribution_id = pdw_node_id
GROUP BY 
    t.name
ORDER BY 
    TotalSpaceKB DESC;