dbadmin=> select count(*) from cities;
count
--------
452376
(1 row)
dbadmin=> select * from cities limit 1 ;
city | state | zip | population
---------+-------+------+------------
0Boston | MA | 2108 | 694583
(1 row)
dbadmin=> delete from cities where city = '0Boston';
OUTPUT
--------
10
(1 row)
dbadmin=> select count(*) from cities;
count
--------
452366
(1 row)
dbadmin=> select node_name,projection_name, location_label, total_row_count , deleted_row_count , used_bytes, is_sorted from v_monitor.storage_containers;
node_name | projection_name | location_label | total_row_count | deleted_row_count | used_bytes | is_sorted
-----------------+-----------------+----------------+-----------------+-------------------+------------+-----------
v_vdb2_node0003 | msg_super | | 4 | 0 | 277 | t
v_vdb2_node0003 | msg_super | | 6 | 0 | 307 | t
v_vdb2_node0003 | cities_super | | 75241 | 10 | 23412682 | t
v_vdb2_node0003 | cities_super | | 75212 | 0 | 23387124 | t
v_vdb2_node0001 | msg_super | | 4 | 0 | 272 | t
v_vdb2_node0001 | cities_super | | 75595 | 0 | 23549329 | t
v_vdb2_node0001 | msg_super | | 6 | 0 | 292 | t
v_vdb2_node0001 | cities_super | | 75335 | 0 | 23448224 | t
v_vdb2_node0002 | msg_super | | 4 | 0 | 312 | t
v_vdb2_node0002 | cities_super | | 75405 | 0 | 23504398 | t
v_vdb2_node0002 | msg_super | | 1 | 0 | 241 | t
v_vdb2_node0002 | cities_super | | 75588 | 0 | 23510716 | t
(12 rows)