Identify unused documents in a bucket

Couchbase Server
1

Hi

Is there any option by which the unused documents / types in a bucket can be identified

Thanks

Haf

2

@haf no I don’t think so, partly as it would turn every read into a write in order to track access time.

3

Thanks for the details

4

Nb if you are specifically after the last time documents were modified (not just read), then yes you can get this. Have a look in the SDK for LookupInMacro.LAST_MODIFIED.

That is on a individual document basis though. To do this at scale could be tricky.. Perhaps @vsr1 knows if you can query (and perhaps index) on virtual attributes like this.

You may be best off maintaining your own last-modified field.

5

It is not possible. One can’t index on virtual attributes as they generated dynamically

1 Like