数据仓库服务 GAUSSDB(DWS)-GaussDB(DWS)列存表的常用信息查询:查询分区边界

时间:2024-04-24 17:49:36

查询分区边界

1
2
3
4
5
6
7
8
9
SELECT relname, partstrategy, boundaries FROM pg_partition where parentid=(select parentid from pg_partition where relname='my_table');
   relname   | partstrategy | boundaries
-------------+--------------+------------
 my_table    | r            |
 my_table_p1 | r            | {600}
 my_table_p2 | r            | {800}
 my_table_p3 | r            | {950}
 my_table_p4 | r            | {1000}
(5 rows)
support.huaweicloud.com/dws_faq/dws_03_2104.html