DBCC PDW_SHOWPARTITIONSTATS (Transact-SQL)
Applies to: 
Azure Synapse Analytics
Analytics Platform System (PDW)
Displays the size and number of rows for each partition of a table in a Azure Synapse Analytics or Analytics Platform System (PDW) database.
Transact-SQL syntax conventions
Syntax
--Show the partition stats for a table
DBCC PDW_SHOWPARTITIONSTATS ( "[ database_name . [ schema_name ] . ] | [ schema_name. ] table_name" )
[;]
Note
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
Arguments
"[ database_name . [ schema_name ] . | schema_name . ] table_name"
The one, two, or three-part name of the table to be displayed. For two or three-part table names, the name must be enclosed with double quotes (""). Using quotes around a one-part table name is optional.
Permissions
Requires VIEW SERVER STATE permission.
Result sets
This set is the results for the DBCC PDW_SHOWPARTITIONSTATS command.
| Column name | Data type | Description |
|---|---|---|
| partition_number | int | Partition number. |
| used_page_count | bigint | Number of pages used for the data. |
| reserved_page_count | bigint | Number of pages reserved for the partition. |
| row_count | bigint | Number of rows in the partition. |
| pdw_node_id | int | Compute node for the data. |
| distribution_id | int | Distribution identifier for the data. |
Examples: Azure Synapse Analytics and Analytics Platform System (PDW)
A. DBCC PDW_SHOWPARTITIONSTATS basic syntax examples
The following examples display the space used and number of rows by partition for the FactInternetSales table in the AdventureWorksPDW2022 database.
DBCC PDW_SHOWPARTITIONSTATS ("ssawPDW.dbo.FactInternetSales");
DBCC PDW_SHOWPARTITIONSTATS ("dbo.FactInternetSales");
DBCC PDW_SHOWPARTITIONSTATS (FactInternetSales);