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