How to see the query of Deleted Row Count ?

Forum|Forum|11 years ago
June 14, 2015
5 replies
14 views

+2

UJJWAL_RANA
Participating Frequently

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 :-

+1

Adrian_Oprea_1
Participating Frequently
Forum|Forum|11 years ago
June 14, 2015

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.

Like

Rahul_Choudhary
Participating Frequently
Forum|Forum|11 years ago
June 15, 2015

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

Like

+2

UJJWAL_RANA
Author
Participating Frequently
Forum|Forum|11 years ago
June 15, 2015

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 ?