Show Partitions
SHOW PARTITIONS [storage_name]
SHOW PARTITION id

List partitions using JSON.

Examples #

SHOW PARTITIONS

[{
  "min": 0,
  "max": 2999999,
  "events": 3000000,
  "events_heap": 0,
  "regions": 2677,
  "size": 13967985,
  "size_uncompressed": 351203582,
  "size_heap": 0,
  "created": 1712235856124572,
  "refreshed": 1712235856993813,
  "refreshes": 1,
  "on_storage": false,
  "on_cloud": true,
  "storage": "main"
}, {
  "min": 3000000,
  "max": 5999999,
  "events": 3000000,
  "events_heap": 0,
  "regions": 2677,
  "size": 13967294,
  "size_uncompressed": 351203582,
  "size_heap": 0,
  "created": 1712235856993615,
  "refreshed": 1712235857869257,
  "refreshes": 1,
  "on_storage": false,
  "on_cloud": true,
  "storage": "main"
}, {
  "min": 6000000,
  "max": 8999999,
  "events": 634200,
  "events_heap": 634200,
  "regions": 0,
  "size": 0,
  "size_uncompressed": 0,
  "size_heap": 77594624,
  "created": 1712235857869048,
  "refreshed": 0,
  "refreshes": 0,
  "on_storage": false,
  "on_cloud": false,
  "storage": "main"
}]
SHOW PARTITION 6000000

{
  "min": 6000000,
  "max": 8999999,
  "events": 634200,
  "events_heap": 634200,
  "regions": 0,
  "size": 0,
  "size_uncompressed": 0,
  "size_heap": 77594624,
  "created": 1712235857869048,
  "refreshed": 0,
  "refreshes": 0,
  "on_storage": false,
  "on_cloud": false,
  "storage": "main"
}

See also CREATE STORAGE, CREATE PARTITIONS