Partition count per projections and per table
How to get count of partitions are there per projections and also per table? Just wanted to have a track of partitions count as a maintanance activity.
0
How to get count of partitions are there per projections and also per table? Just wanted to have a track of partitions count as a maintanance activity.
Comments
Hi
You can use partitions table to get this info. Please see below query as an example which demonstrate the same:
rchoudhary=> select node_name,table_schema,projection_name,count(distinct(partition_key)) partitions from partitions group by 1,2,3 order by 3 desc;
node_name | table_schema | projection_name | partitions
------------------------+--------------+-----------------+------------
v_scrutinload_node0002 | public | p_test_b1 | 1
v_scrutinload_node0003 | public | p_test_b1 | 1
v_scrutinload_node0001 | public | p_test_b1 | 1
v_scrutinload_node0002 | public | p_test_b0 | 2
v_scrutinload_node0001 | public | p_test_b0 | 2
v_scrutinload_node0003 | public | p_test_b0 | 2
v_scrutinload_node0002 | public | p_b1 | 1
v_scrutinload_node0001 | public | p_b0 | 1
(8 rows)
I hope it helps!!
Regards
Rahul
it works. Thanks Rahul
Pleasure is all mine :-)
Enjoy your day!!
Regards
Rahul