Skip to main content
Version: 0.9

Administration

This document addresses strategies and practices used in the operation of GreptimeDB systems and deployments.

Database/Cluster management

Runtime information

For example, find all the region id of a table:

SELECT greptime_partition_id FROM PARTITIONS WHERE table_name = 'monitor'

Find the distribution of all regions in a table:

SELECT b.peer_id as datanode_id,
a.greptime_partition_id as region_id
FROM information_schema.partitions a LEFT JOIN information_schema.region_peers b
ON a.greptime_partition_id = b.region_id
WHERE a.table_name='monitor'
ORDER BY datanode_id ASC

The INFORMATION_SCHEMA database provides access to system metadata, such as the name of a database or table, the data type of a column, etc. Please read the reference.

Data management

Best Practices