Hi
How can we Identify the size of an individual document in a bucket
can we group it based on type of the documents in a bucket
Is there any N1QL query to identify the information
Note : Using Couchbase EE 5.5.3
Thanks
Hi
How can we Identify the size of an individual document in a bucket
can we group it based on type of the documents in a bucket
Is there any N1QL query to identify the information
Note : Using Couchbase EE 5.5.3
Thanks
SELECT META().xattrs.`$document`.value_bytes
FROM default USE KEYS "k01";
OR
k01 CAS=0x164a5af2c2060000
0. Size=236, RC=LCB_SUCCESS (0x00)
{"CAS":"0x164a5af2c2060000","datatype":["json"],"deleted":false,"exptime":0,"flags":0,"last_modified":"1606196215","revid":"1","seqno":"0x0000000000000003","value_bytes":7,"value_crc32c":"0xcff7d56a","vbucket_uuid":"0x000060b97aed55a8"}
1. Size=7, RC=LCB_SUCCESS (0x00)
{"a":1}
Thanks for the details