# SHOW PARTITIONS Shows partitions and relevant information about them. ## Syntax ```sql SHOW PARTITIONS [EXTENDED] [ON ]; ``` ## Remarks * Shows partition information for the current database, or for the database in the optional ON clause. * This command must be run on the master aggregator or a child aggregator node (see [Node Requirements for SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md)). * The `SHOW PARTITIONS` command includes a `Locked` column that indicates whether a partition is locked. Any query that accesses a locked partition will wait until the partition is unlocked before proceeding. * The `EXTENDED` option will display additional partition information including replication status, last command run, last error, and last message. ## Example ```sql SHOW PARTITIONS ON memsql_demo; +---------+------------+------+--------+--------+ | Ordinal | Host | Port | Role | Locked | +---------+------------+------+--------+--------+ | 0 | 10.0.3.2 | 3306 | Master | 0 | | 1 | 10.0.15.33 | 3306 | Master | 0 | | 2 | 10.0.3.2 | 3306 | Master | 0 | | 3 | 10.0.15.33 | 3306 | Master | 0 | | 4 | 10.0.3.2 | 3306 | Master | 0 | | 5 | 10.0.15.33 | 3306 | Master | 0 | | 6 | 10.0.3.2 | 3306 | Master | 0 | | 7 | 10.0.15.33 | 3306 | Master | 0 | | 8 | 10.0.3.2 | 3306 | Master | 0 | | 9 | 10.0.15.33 | 3306 | Master | 0 | | 10 | 10.0.3.2 | 3306 | Master | 0 | | 11 | 10.0.15.33 | 3306 | Master | 0 | | 12 | 10.0.3.2 | 3306 | Master | 0 | | 13 | 10.0.15.33 | 3306 | Master | 0 | | 14 | 10.0.3.2 | 3306 | Master | 0 | | 15 | 10.0.15.33 | 3306 | Master | 0 | +---------+------------+------+--------+--------+ 16 rows in set (0.00 sec) ``` *** Modified at: June 22, 2022 Source: [/db/v9.1/reference/sql-reference/show-commands/show-partitions/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-partitions/) (An index of the documentation is available at /llms.txt)