| title | DBCC PDW_SHOWPARTITIONSTATS (Transact-SQL) | |
|---|---|---|
| description | DBCC PDW_SHOWPARTITIONSTATS displays the size and number of rows for each partition of a table in Azure Synapse Analytics or the Analytics Platform System (PDW). | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.date | 06/14/2022 | |
| ms.prod | sql | |
| ms.technology | data-warehouse | |
| ms.topic | language-reference | |
| dev_langs |
|
|
| monikerRange | >= aps-pdw-2016 || = azure-sqldw-latest |
[!INCLUDEapplies-to-version/asa-pdw]
Displays the size and number of rows for each partition of a table in a [!INCLUDEssSDW] or [!INCLUDEssPDW] database.
Transact-SQL Syntax Conventions (Transact-SQL)
--Show the partition stats for a table
DBCC PDW_SHOWPARTITIONSTATS ( " [ database_name . [ schema_name ] . ] | [ schema_name.] table_name ")
[;]
Note
[!INCLUDEsynapse-analytics-od-unsupported-syntax]
[ 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.
Requires VIEW SERVER STATE permission.
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. |
The following examples display the space used and number of rows by partition for the FactInternetSales table in the [!INCLUDEssawPDW] database.
DBCC PDW_SHOWPARTITIONSTATS ("ssawPDW.dbo.FactInternetSales");
DBCC PDW_SHOWPARTITIONSTATS ("dbo.FactInternetSales");
DBCC PDW_SHOWPARTITIONSTATS (FactInternetSales);