Monitoring Deletes and Updates

The frequency of delete and update submissions to the database should be sustainable and not negatively impact performance. While you develop your application, make sure to monitor the delete and update operations in the database. To do so, monitor the DELETE_VECTORS system table. This table provides a view of the number of deleted records and their corresponding delete vectors that are still physically stored in the system:

VMart=> SELECT node_name, schema_name, projection_name, 
           deleted_row_count, used_bytes FROM delete_vectors;
-[ RECORD 1 ]-----+--------------------------
node_name         | v_vmart_node0001
schema_name       | public
projection_name   | product_dimension_super
deleted_row_count | 32345
used_bytes        | 524288
-[ RECORD 2 ]-----+--------------------------
node_name         | v_vmart_node0001
schema_name       | public
projection_name   | employee_dimension_super
deleted_row_count | 943
used_bytes        | 54788
-[ RECORD 3 ]-----+--------------------------
node_name         | v_vmart_node0001
schema_name       | public
projection_name   | warehouse_dimension_super
deleted_row_count | 20
used_bytes        | 16384