How to see the query of Deleted Row Count ?

Hi,

I wanted  to see all the 100 queries under deleted_row_count when I ran select * from delete_vectors in vsql and it displays as following. How can i see all the 100 queries that falls under deleted_row_count. Please suggest  :-

 

node_name         | nodeC3
schema_name       | test_vmart
projection_name   | example_dimension
storage_type      | APPROS
dv_oid            | 7897897897801
storage_oid       | 09097897643421
deleted_row_count | 100
used_bytes        | 90
start_epoch       | 5656567
end_epoch         | 4248763
is_sorted         | t

Comments

  • The value you see under deleted_row_count is not referencig some queries ! it is the number of delete rows ! or better the number of rows marked for deletion. 

     

  • Hi 

     

    This suggests the count of rows that are marked for deletion related to that particular projection.So here in  your case (example_dimension) projection has 100 rows that are marked for deletion & should be purged.

     

     

    Regards

    Rahul Choudhary

  • Thanks for the response. So isn't there any way where I can see the deleted rows ? I mean like what if like i wanted to see all those 100 rows which been deleted ? Is it possible to see the deleted rows ?

     

     

  • Hi Ujjawal

     

    Nope there is no functionality or views which can help you achieve what you asked for.

     

    Regards

    Rahul Choudhary

  • Thanks Rahul

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.