In one of the buckets, we have 23K documents and in addition to that, there are 2.7 million _sync:rb documents.
For each document, there are around 138 _sync:rb documents.
Whenever a document is updated from a mobile device, the Account_xxxxxx document has correct data and the conflict resolution is working fine as we are not seeing any data loss.
Is there a way to remove these _sync:rb documents as it is slowing down all our queries?
We are getting timeout on most of our queries due to the high volume of _sync:rb documents.
mreiche,
Whenever we modify a document, a copy of it is created.
{
"meta": {
"id": "Account_0033efdf-7a3f-4191-96f2-e2da66577d29",
"rev": "142-171df75ef38600000000000002000006",
"expiration": 0,
"flags": 33554438,
"type": "json"
},
"xattrs": {
"_sync": {
"rev": "79-6af2daf50f405bd8d992fc6886bc08f6",
"flags": 24,
"sequence": 190660,
"recent_sequences": [
190654,
190655,
190656,
190657,
190658,
190659,
190660
],
"history": {
"revs": [
"69-8170696a0be28265799fb78fd248458b",
"34-a8ca41870265ad5bb88ed325f11c57bd",
"49-0a03b2ee3427ffc065148479e49feef7",
"51-6a38b1e56f94694d3b96dd3723619ae3",
"59-d88bd266eab40736dcb9dcafcb6606bc",
"72-1ded49de42674d134e07234b5836990c",
"19-daeec42daf942f37fa4b0a22cd61aa3b",
"1-e809869607c0beec00d869d3c5385d82",
"48-1f69642b99446e137e7c26cbbce14c88",
"20-525561dc7b21f4661480c8068b8a238c",
"2-6e8be76c67a51552faebd4a4ed9d887a",
"7-2fcc6bf52c76a77fcb4cd67de713f83a",
"50-164ef2a9ab02c7f9c65346473014ddbd",
"24-e46eb155652760f57b17789238652742",
"41-ed86a607591a16de2b3f31fc8b10cf09",
"57-98937229c5d98a9d2b8ab306ddee5b9f",
"21-6785a268fde260f701aad59ce2611838",
"23-4aea189c713a0d0f7e608605974c3c12",
"77-90e2cf02668a980e7d455a010d9dcba6",
"58-b1044e08237ee903e03e516204bc69b9",
"45-fe11967c1dad8c59f62673cec4672ebe",
"4-922106692b80e35aa1fe3000699db9cb",
"79-6af2daf50f405bd8d992fc6886bc08f6",
"33-0df81eb01ecff16cdbff762610c895ae",
"61-d55d0e135eaf7316720955043fe90bac",
"70-46d6a6d1aba98050587eed235321aa33",
"62-8fe5a636659092344724353c2c91eeb6",
"30-1278538323f77963dfb758f1e4034408",
"44-80b178e2543a7a9f5b819d76ac59bf5c",
"9-0b228c3db8103dfe30c017797125d5b4",
"17-c03a89cdf1cc7f9a9a1051b0b0185e87",
"60-1ad84d85c4fda775e0d90fb59e79a7d0",
"12-603b58acd317ba77996c1d40eb719ff6",
"39-e3cd7f92a70aaa1aa5144fa04fc2e07f",
"55-a738238019228ba31ca5d704e27757ee",
"6-59413b3e85dd805c48262d8a151820ee",
"13-07d0d3da509bc28a7bf5fd63bcc71885",
"14-8588f8ba4e107b30d152a8c147c7940a",
"76-822c7898fe7bb7c57738648a5fb3b056",
"74-1107fa433efe17cc751c0499b5306fca",
"40-b82082e65ae304e8b0c98bcc3e6f5937",
"11-382e481eb85b46e76eb544a60fadfdd1",
"78-94b892e7c47cc57d8be64b1b622226d2",
"63-e29a085a6d9fbdacbbb557210f5f4482",
"37-7eaf450d85c034e927d9e42b9a0431cb",
"56-0d24df7c25904ffa146f502c3c6b3b73",
"16-014f4b3e3c3dc92fc6d794b0b2598d95",
"39-01cb7b5efeb47d71fd3fcd96b5360ef4",
"31-b2a895054fbd05482c6ce72c96ec79e6",
"29-17ed810436ec54eddd4677f68d9dee10",
"10-f545fa3a36a80adfe7a1285b79313dea",
"42-ec2c0a859824ce82ff022ec89e76c842",
"36-92db186ea36b1eea5c18200a7ef4cf90",
"38-d21b0d42b93d19eef3c3997c4a79e5f6",
"46-16d1cab46b4f97753d35afac15db2937",
"73-4bbf44942be1344cd2a1b99afdd147c0",
"67-159a5e0217e13b24fe4aaf294cf5cfbc",
"18-4a7ee6ee7eb90c7e4ca5ea4f96924ed6",
"54-0518aa689bb6d237610b2b25ea086833",
"66-31ff00dbf155bcf931ceb33543fd00b4",
"8-82233e7811cd7f3a3a9988f2048c5b51",
"26-7e9a30a08a60adf92da223e193c611e6",
"52-4c9e0fd98201a06ab6038a63e16771e2",
"53-4fe62761d160b20cd5a118c9e9d8de50",
"15-ca7b583f17613ef26966276557a2b4f2",
"40-bd6b845264b8589171669e4b66b8672a",
"68-3d5c212e952ce363d01547718250e786",
"27-3029f8dc90255bea9c6e3d4b21c26e02",
"75-441ff402dc91af703ed35690f9f815df",
"38-95aa710b90ef41780f13e6fb88d2d49b",
"37-aecef6405b2c54138b71323b3bdcf3ac",
"65-f572f2adc9fa3259f693ac52b94b979c",
"32-26596614ee1ee1ab2f81a75504a07392",
"22-b2ba3dfd7e72becf4ad3075600f64eff",
"64-1407b87cdaaf6097e33e720dcc6afcf8",
"43-0050fe0b680ad8e9ae6f63e89feeee9e",
"5-056e9e4bf316a7691ef72bfbe572aa2e",
"25-5f9bac01c04e8028b5d9fc18fd201ca4",
"3-53f8e4fd03640dc220ab5a07fc7080bf",
"35-52bdf8c6fe5150eebc0cd0803091835c",
"43-acde99ded3b00378ad171634de27b6cf",
"47-16659f677ddc113238595b52d6381988",
"44-211c94c0c15c9dfa7950c5bc0d4686ea",
"71-2e04cc8d466cd97fd086084794b8c676",
"28-6cd183fa4f82e83fc0844cdf24829251"
],
"parents": [
66,
-1,
-1,
-1,
19,
83,
-1,
-1,
81,
-1,
-1,
-1,
2,
-1,
65,
-1,
-1,
-1,
38,
-1,
28,
-1,
42,
-1,
31,
0,
24,
-1,
80,
-1,
-1,
-1,
-1,
53,
-1,
-1,
-1,
-1,
68,
55,
33,
-1,
18,
26,
52,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
5,
59,
-1,
-1,
71,
-1,
-1,
-1,
-1,
-1,
-1,
56,
-1,
39,
70,
-1,
74,
48,
-1,
43,
-1,
-1,
-1,
-1,
1,
51,
-1,
-1,
25,
-1
],
"bodyKeyMap": {
"3": "_sync:rb:kt1YoB1oAXILioH61KHGZ1VAiJQ0DwhITHfQFakbHPQ=",
"4": "_sync:rb:QydGGBXYH/t1bhJVQPlNkiaC+wCL8Sw25KAinsLVW9Q=",
"6": "_sync:rb:Y2paafLVY7r27nLGELPnrOIq89rQyMq046V1RN5xFRk=",
"7": "_sync:rb:AonBN3fSQH0kRvtJHS2X/WMjiPjl2aKyeAkQsDffzKM=",
"8": "_sync:rb:x9T9B2hm6L611zY8T3YfXhNa6Cr6ImuQMhM57Tqh9gQ=",
"9": "_sync:rb:LJzyoMTmIbN06K1mdIYr1WJJb1Prber1nLGlqGkhlPA=",
"10": "_sync:rb:j/YENNuBP6+1RinPpXCGOpXF5mblg+OpZevBZo23YXE=",
"11": "_sync:rb:B8DL52p3hQIGt55tRUTVfC4dKOFbYWmC3nkJyPe2hUk=",
"12": "_sync:rb:iGQ9nus/f0JGmdAPfHq7OUtSK9kp4dxdRulGa7GLpWY=",
"13": "_sync:rb:yJM7P97BKw5hZXY0IVALFwyPL4LvcfcZDLu63RONB5k=",
"14": "_sync:rb:scJJcs1Hb8adlWidKB90Q1FrvgcU2mCBDkgM7DYHe0E=",
"15": "_sync:rb:iIlYhwc5kmmQpWTW95MaKnABRQQx1YgG4pKYeRe7354=",
"16": "_sync:rb:aZFBbDKNDr+85RKAjvkfhXyQT4nNpXMb8UgrX0VC7kU=",
"17": "_sync:rb:7dqNjygGVv7Lf9gblr/Q/rsc4Y4FZ8zqsiKIr6TTdWo=",
"20": "_sync:rb:4LbbYJpJ23wrUomV03DAc0yO5n/9vz1mUKNJClioPio=",
"21": "_sync:rb:OyClcp9SuNqKAxesHojJTr2EJEWiCFqosi+AUvwnzro=",
"23": "_sync:rb:WLh6iq66+xtWHH7HuRZFitzeBNrJkwxH/xtPK4II4tA=",
"27": "_sync:rb:kPeO+92c3kVc/ZTbNlJm+AxRTwLZKT2P7eV6apHnljE=",
"29": "_sync:rb:wpYPQFsOZ+mGV3Sc3O0ANKpW/H60BX7FIX5Ko5zcP4U=",
"30": "_sync:rb:G1yCf/RwmjQRK0YHWKWSygLNAC74S4UEoQ7kj8lONHs=",
"32": "_sync:rb:QeiwYagWs+7Lr/DGcyhGQkzrWnfhqyWdmZ2IFzOKqkc=",
"34": "_sync:rb:IFBE2mAUhLNSvnPgUmAXoD/qurHYrlmu/8VCJtn52IQ=",
"35": "_sync:rb:ENmetvbAKDIBbtvITFkOzB1ne/TE74rIb3S4vHWxLWo=",
"36": "_sync:rb:sJ4uAHsKNrmobrOdyJLv264VNaw+hQeXWGpKqskf3sA=",
"37": "_sync:rb:Trr5Ls8s6Mhxx6nb55U3VDQKjBSHLNg98QD+n8ei58U=",
"40": "_sync:rb:u1kNuugBZKwk9TrHtAkch0UOQ2X2EV1QZ0qvoMoys/c=",
"41": "_sync:rb:zirRejUML2gYjQ81rBVTzNyFY2QdtBYLD2MwI+tJCmQ=",
"44": "_sync:rb:tuY4Xh4Rmf+EQAxEsb//J54gLQJXlCkkFF9b/xmOHZI=",
"45": "_sync:rb:u5gBGTAz6EZaZ2BOFAUmsEPdSTnEFqTrJdtXM1sNfvg=",
"46": "_sync:rb:KhuKVlxlH0TEVYFl4GOPNfOvF0Dn4hYch6MDogoudgs=",
"47": "_sync:rb:qiNcfmedZcziqzoI5pYciQFfk2DNNYnQpDj0Hwg3OrY=",
"49": "_sync:rb:7sH7JTpk1g6ea0mljU1M0vZH6BEFhhsVSakIg11tLho=",
"50": "_sync:rb:RkmUvS2i7/i+juQSgeBeLv1HnbcJqUe+NYcGaeI+e2U=",
"54": "_sync:rb:M/QHIt+iQV0Uk4y9TglR0x8setjXNLIPYxMDpSzy4Kk=",
"57": "_sync:rb:01wdogtZgTxShTh6pazpJ+K41xKjq+D3KXK2KouBJTc=",
"58": "_sync:rb:CpllpYYMVQ7ipdixrDT6661AXoq4M7jZAImnf1uiC88=",
"60": "_sync:rb:sVB6bLCDpVTdwsAXsZN9EL7UQrWtmUBJ/RZv2WJ4/fs=",
"61": "_sync:rb:/5jv8WZ2xQKF4JM9lw9lDjphCiU2nQR7z+n2X2jhr9Y=",
"62": "_sync:rb:xn5frxieoHCcBnaWJGaOS1TTURRmtS+/jKHe/2Bning=",
"63": "_sync:rb:v2Fa/z5TvdshIMxKwcDl7QwmC+58FYK9V6RlXG0ULUM=",
"64": "_sync:rb:H14dRoG6AqilLzLeQ4NHDVoA2p/6xrw7WHEkfjTCDjs=",
"67": "_sync:rb:QxxqZmuf7Q5+q3F/touJm42kSc4rPgyMHJSofuV+vBk=",
"69": "_sync:rb:oK/fMW4Qe6NXQlSMu1UX8I00EDiMtVx6eJ2LKXMyYc8=",
"72": "_sync:rb:dr7v2Pp8oTW7WhyjNiWV/MUySdEx8F0Rra4Uc8XEqkM=",
"73": "_sync:rb:esFPjRAATBLRVpfmgrpZLZHOawSL6Pu4L7UdAj/4WDI=",
"75": "_sync:rb:XA/GGW0cMza6qVpI3Xdzs4EKCApUtdFnTLe2MVOaeLg=",
"76": "_sync:rb:DM97KH9PuZ/I0tXN2rcDDFzAjEB++NHVCBS1Wb8v7X0=",
"77": "_sync:rb:Vq5K0fHW9gJRabGSTQkTpj5AuVOJm7hKWF2UgjXdNRs=",
"78": "_sync:rb:8qkYEgO2qNn/gYVRIMZMnvN5pyGneuXrWQHAI8YgFpY=",
"79": "_sync:rb:EpN4glUP2QEHBc8vMSmanBZH8mWZuuKL71ymEDpy07U=",
"82": "_sync:rb:/fCbvnqyz+WCL+aXGGMz0cTXd5lP0NKn+CaaHbArRkU=",
"84": "_sync:rb:1YcMPgW3guks1Eks3VpbSrHVA1ieNSYowppgKdtqWTc="
},
"channels": [
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
],
[
"channel.site.783"
]
]
},
"channels": {
"channel.site.783": null
},
"cas": "0x000086f35ef71d17",
"value_crc32c": "0xb245c5db",
"time_saved": "2022-10-14T14:57:04.380739467Z"
}
}
}