Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
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)