Created
September 14, 2020 17:21
-
-
Save sridevi-15/68d0a39af775ca9c7b97c2dceb67a41c to your computer and use it in GitHub Desktop.
select *, meta().plan from system:prepareds
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "plan": { | |
| "#operator": "Authorize", | |
| "privileges": { | |
| "List": [ | |
| { | |
| "Priv": 7, | |
| "Props": 0, | |
| "Target": "default:data-bucket" | |
| } | |
| ] | |
| }, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "IndexScan3", | |
| "index": "sg_allDocs_x1", | |
| "index_id": "d8f11c4d8bd4507e", | |
| "index_projection": { | |
| "primary_key": true | |
| }, | |
| "keyspace": "data-bucket", | |
| "namespace": "default", | |
| "spans": [ | |
| { | |
| "exact": true, | |
| "range": [ | |
| { | |
| "inclusion": 0, | |
| "low": "0" | |
| }, | |
| { | |
| "inclusion": 0 | |
| }, | |
| { | |
| "high": "null", | |
| "inclusion": 0 | |
| } | |
| ] | |
| }, | |
| { | |
| "range": [ | |
| { | |
| "inclusion": 0, | |
| "low": "0" | |
| }, | |
| { | |
| "inclusion": 0 | |
| }, | |
| { | |
| "inclusion": 0, | |
| "low": "null" | |
| } | |
| ] | |
| } | |
| ], | |
| "using": "gsi" | |
| }, | |
| { | |
| "#operator": "Fetch", | |
| "keyspace": "data-bucket", | |
| "namespace": "default", | |
| "subpaths": [ | |
| "_sync" | |
| ] | |
| }, | |
| { | |
| "#operator": "Parallel", | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Filter", | |
| "condition": "((0 < (((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`)) and (not ((meta(`data-bucket`).`id`) like \"\\\\_sync:%\")) and (((meta(`data-bucket`).`xattrs`).`_sync`) is not missing) and (((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`) is missing) or (bittest((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`), 1) = false)))" | |
| }, | |
| { | |
| "#operator": "InitialProject", | |
| "result_terms": [ | |
| { | |
| "as": "id", | |
| "expr": "(meta(`data-bucket`).`id`)" | |
| }, | |
| { | |
| "as": "r", | |
| "expr": "(((meta(`data-bucket`).`xattrs`).`_sync`).`rev`)" | |
| }, | |
| { | |
| "as": "s", | |
| "expr": "(((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`)" | |
| }, | |
| { | |
| "as": "c", | |
| "expr": "(((meta(`data-bucket`).`xattrs`).`_sync`).`channels`)" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Order", | |
| "sort_terms": [ | |
| { | |
| "expr": "(meta(`data-bucket`).`id`)" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Stream" | |
| } | |
| ] | |
| } | |
| }, | |
| "prepareds": { | |
| "avgElapsedTime": "278.98766ms", | |
| "avgServiceTime": "278.828743ms", | |
| "encoded_plan": "H4sIAAAAAAAA/7RVbW8qNxP9K9Y8enRBMhHckLeV+oF7s2lRk4BY+qaCwNjD4hvj3Wt7U2i0/e2VvSFAXlRuqn6bXZ9zZvbMzPoBUPNMoJjkimmIACjMkbnC4OdMO5MpC1HrIwWpBa46ufwZjZWZhqhNQbMlQgTsnF0cn10cNy7mc944+dieN9jpqWigOGmzU5yd4UULKrTNGfcUgXNWKAcUshwNc5mB6AH+t32ATuEWmZF/IlDIjbyXClO0HnUtrYPo9wcYMpOi26pFgjnWmBX8Dr1y38h7iM58kOUWomY5Lin8xRdSiefZEvxaoOY+WQUwqEOO/wbU9WYmnOljeHQWIrDphCl1mXE7WbU27ydS+A88n7davC3OZ6J90jzDp9PcZF+Qu9CQB+/Tkpn15A7XEDlTYEnhDtdPpu/Z83o7bM60DfXiinFXyVAwTKcYXkvNVVFNQJOCyv6ACJpQ0v0T/7yQ6QIi0IVSod6d07E/f4/ma8iQoByXYwqFlTqFCFIrA33X8yt0fAHfbkgxy5lbeE9gYteaw/i5cp8ZphQq+FfTdSWVQwMUeKaFrFoKtVqTjIpm85iTWq22RMdq052qp/Wj6Yo5Z6yPQnk+sI/5pvU6YVqQms4ceYMuxbROlLxDMoLRaDQKItH/R7DhHpqWSEt8nqW0vgtP7MPLniuW2kroSSQzpDaTzqF175CipFUn35E5Uxbr9fqLmehq6SRT/WqLgIJBWyg3cWiW1RYwCxFIARRwlXvK2y4G9YA3O/DDazZ4vyti3yWybf1Wib9LiS+Y1qisVxqX47J8Mfc9I8LA2szsWnaAUeOXYokzyJb+qKTwtUCz9vcPrlx1J1mZ6nAr+d3iEMEXm2n/WxHb2GxDuwlLCo8i/UHc7wxiksTX8echuYmHnefVSUGYJVJQ8lrtlUdHwaAjg/ceaw6Ablri8fYA/MZ4j+fkatC7IXtw8lMSk+7tZfwrqe3dGXXyyw/xIP6GisKvBUmTdG4v33Lktjck190fY/Jh5/fwITD+KRHpJoF+002S7u33gfPqWOxVF3bXUze03oB86g6HcTI8kEx3tp70BpfxgHz67Y3vg/LvAAAA//8WOomIAwkAAA==", | |
| "featuresControl": 12, | |
| "indexApiVersion": 4, | |
| "lastUse": "2020-09-14 08:35:39.717961806 -0700 PDT m=+32457.591181045", | |
| "maxElapsedTime": "1.786076979s", | |
| "maxServiceTime": "1.786011094s", | |
| "minElapsedTime": "7.22483ms", | |
| "minServiceTime": "7.145002ms", | |
| "name": "a8a93793-9ffc-524f-a66d-ed54a6eb7e91", | |
| "namespace": "default", | |
| "node": "172.23.106.102:8091", | |
| "statement": "PREPARE SELECT META(`data-bucket`).id as id, meta(`data-bucket`).xattrs._sync.rev as r, meta(`data-bucket`).xattrs._sync.sequence as s, meta(`data-bucket`).xattrs._sync.channels as c FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE meta(`data-bucket`).xattrs._sync.sequence > 0 AND META(`data-bucket`).id NOT LIKE '\\\\_sync:%' AND meta(`data-bucket`).xattrs._sync IS NOT MISSING AND (meta(`data-bucket`).xattrs._sync.flags IS MISSING OR BITTEST(meta(`data-bucket`).xattrs._sync.flags,1) = false) ORDER BY META(`data-bucket`).id", | |
| "uses": 123 | |
| } | |
| }, | |
| { | |
| "plan": { | |
| "#operator": "Authorize", | |
| "privileges": { | |
| "List": [ | |
| { | |
| "Priv": 7, | |
| "Props": 0, | |
| "Target": "default:data-bucket" | |
| } | |
| ] | |
| }, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "IndexScan3", | |
| "covers": [ | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`rev`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`deleted`))", | |
| "cover ((meta(`data-bucket`).`id`))" | |
| ], | |
| "filter": "(($startSeq <= cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`))) and (cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`)) < $endSeq) and cover ((not ((meta(`data-bucket`).`id`) like \"\\\\_sync:%\"))))", | |
| "filter_covers": { | |
| "cover ((not ((meta(`data-bucket`).`id`) like \"\\\\_sync:%\")))": true | |
| }, | |
| "index": "sg_allDocs_x1", | |
| "index_id": "c2248a1b5e10aeb8", | |
| "index_projection": { | |
| "entry_keys": [ | |
| 0, | |
| 1, | |
| 2 | |
| ], | |
| "primary_key": true | |
| }, | |
| "keyspace": "data-bucket", | |
| "limit": "5000", | |
| "namespace": "default", | |
| "spans": [ | |
| { | |
| "exact": true, | |
| "range": [ | |
| { | |
| "high": "$endSeq", | |
| "inclusion": 1, | |
| "low": "$startSeq" | |
| } | |
| ] | |
| } | |
| ], | |
| "using": "gsi" | |
| }, | |
| { | |
| "#operator": "Parallel", | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "InitialProject", | |
| "result_terms": [ | |
| { | |
| "as": "seq", | |
| "expr": "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`))" | |
| }, | |
| { | |
| "as": "rev", | |
| "expr": "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`rev`))" | |
| }, | |
| { | |
| "as": "flags", | |
| "expr": "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`))" | |
| }, | |
| { | |
| "as": "id", | |
| "expr": "cover ((meta(`data-bucket`).`id`))" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Limit", | |
| "expr": "5000" | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Stream" | |
| } | |
| ] | |
| } | |
| }, | |
| "prepareds": { | |
| "avgElapsedTime": "30.184252ms", | |
| "avgServiceTime": "30.068297ms", | |
| "encoded_plan": "H4sIAAAAAAAA/7RVbW8iNxD+K9b0qlskEy0hXFJL9wFdtioqyaFAX6QDEbMeNr4Y72J7KWm0/e2VvbA57q7XJqjfxvY8jz1vjx8BdZoLFPNCcQ0MgMISuSsNvsu1M7mywDqnFKQWuO0X8lc0VuYa2BkFzVcIDHp82bvAxZv2Wfc8bvf4QrR/eCPO212BF9jriOVZN4ba2xY89RCBS14qBxTyAg13uQH2CN89LaBfurvcyD8RKBRGbqTCDK33GkrrgH14hAk3GbonNia44+1Fmd6jZx4ZuQF27o28sMDialZR+Cu9k0p8ftsY1yXq1F9WOxjU4Y7/x2ngkzlOue4ChTTfoLHAPtQWiaIoWqHj0e0n8dy2Tm633DljvTW3Dzr1ht3ddttq7ZmehTe4eSl0qXhmXwoWqNChOIR/FSyD04zCUiqHPnlR9Mo6btwY12RaxnE3fUuOylyLcC1IdBTH7iXkFWoxxnVNuWfUuftWeETJeyRTmE6n08DNvp9CqxVyU0c93/fIIxzJCcyZEqvdPAMDm825Upd5aufbDuz251IAg/T09OyCdxY97MQcFxfNaWHyj5i6IANeQJx5mN/jg+/hmHbo6SyM7IrX282V3mU//weTquRK+jnuxfE/C4UtuLZhknDLU1ezUjBcZxi272R2Bwx2FQiPTVVZi1WHgsr/8Kf71oFqVs0olFbqDBhkVkJFD6d0xA1XChUcpRoDLZ3kalTnDCgYtKVyc4dmVcfDra9DeDJuC485Tgh8HIHT4OYYzp04NHRh4o8hbCSjoZTiS75vyICvWeVl/DDFw9A/DVFooy+9xs4gX/mDisK6RPPgfzjcuvrXszLT4d/zVa5DZfDR5tp3kniyfVKbha/ablFR2JGNbpJR/yYh42SYvJuQr8VTJ+ckZOZkXzvSHxOLa/rvCIMb72xw8x+cQyzePRiUXCWT/ucAKbyDFOTHm/dX5OCQ/DJOyOD6MvmdRAdi0SK//ZTcJM+IL2gkviVP+t2/vnwuvtHYAA7BhPdfv5+Q4eDnhLz+RPNeEzIcXA0mpO6JvwMAAP//xkMq0O4IAAA=", | |
| "featuresControl": 12, | |
| "indexApiVersion": 4, | |
| "lastUse": "2020-09-14 05:46:34.213003681 -0700 PDT m=+22312.086222626", | |
| "maxElapsedTime": "120.325753ms", | |
| "maxServiceTime": "120.251499ms", | |
| "minElapsedTime": "1.889081ms", | |
| "minServiceTime": "1.810667ms", | |
| "name": "5af58eb6-4370-5abd-96d7-3de8e51df430", | |
| "namespace": "default", | |
| "node": "172.23.106.102:8091", | |
| "statement": "PREPARE SELECT meta(`data-bucket`).xattrs._sync.sequence AS seq, meta(`data-bucket`).xattrs._sync.rev AS rev, meta(`data-bucket`).xattrs._sync.flags AS flags, META(`data-bucket`).id AS id FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE meta(`data-bucket`).xattrs._sync.sequence >= $startSeq AND meta(`data-bucket`).xattrs._sync.sequence < $endSeq AND META().id NOT LIKE '\\\\_sync:%' LIMIT 5000", | |
| "uses": 5 | |
| } | |
| }, | |
| { | |
| "plan": { | |
| "#operator": "Authorize", | |
| "privileges": { | |
| "List": [ | |
| { | |
| "Priv": 7, | |
| "Props": 0, | |
| "Target": "default:data-bucket" | |
| } | |
| ] | |
| }, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "IndexScan3", | |
| "covers": [ | |
| "cover ((meta(`data-bucket`).`id`))", | |
| "cover ((meta(`data-bucket`).`id`))" | |
| ], | |
| "filter": "(cover (((meta(`data-bucket`).`id`) like \"\\\\_sync:%\")) and ((cover ((meta(`data-bucket`).`id`)) like \"\\\\_sync:user:%\") or (cover ((meta(`data-bucket`).`id`)) like \"\\\\_sync:role:%\")))", | |
| "filter_covers": { | |
| "cover (((meta(`data-bucket`).`id`) like \"\\\\_sync:%\"))": true | |
| }, | |
| "index": "sg_syncDocs_x1", | |
| "index_id": "ac81d66703361538", | |
| "index_projection": { | |
| "primary_key": true | |
| }, | |
| "keyspace": "data-bucket", | |
| "namespace": "default", | |
| "spans": [ | |
| { | |
| "range": [ | |
| { | |
| "high": "\"_sync:user;\"", | |
| "inclusion": 1, | |
| "low": "\"_sync:user:\"" | |
| } | |
| ] | |
| }, | |
| { | |
| "range": [ | |
| { | |
| "high": "\"_sync:role;\"", | |
| "inclusion": 1, | |
| "low": "\"_sync:role:\"" | |
| } | |
| ] | |
| } | |
| ], | |
| "using": "gsi" | |
| }, | |
| { | |
| "#operator": "Parallel", | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "InitialProject", | |
| "result_terms": [ | |
| { | |
| "expr": "cover ((meta(`data-bucket`).`id`))" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Stream" | |
| } | |
| ] | |
| } | |
| }, | |
| "prepareds": { | |
| "avgElapsedTime": "10.413669ms", | |
| "avgServiceTime": "10.349598ms", | |
| "encoded_plan": "H4sIAAAAAAAA/6SUe2/aPBTGv4p1Xr0iSOFVKQX6en+hNtPQekHQXaSmAsc5BBdjp7bTwRD77JOT3ujWy7r/DH78nOMnv+M1oOI6xXScS6aAAoQwReYKgwdaOaOlBdrcDUGoFJe9XHxGY4VWQPdCUGyBQIF1Ozzh7aSRIGs32kkraSTN6U4Dd7sJ3/uftTvTJlRqmzPuj6Q4ZYV0EILO0TCnDdA1/HP/A3qFm2kjviOEkBtxLSRmaL3qSFgH9HwNZ8xk6O7daMocayQFn6N3HhhxDbTrFzq3QHc2F5sQfvCZkOnjaiO8KlBxX6wSGFRljT8W9X1OI85UC0Lg+hqNBXperUgQLNCxYPKg0Un9v4lIJ/X6rfx50UUIUyEd+lLBrf7pA0SKOZIY4jiOx3alOP03hnqdMJWSIHi53q/nC4umNCHakDc5GC2xasPfubrN+DapNbz5UkCdKXBzgypQsFm5e6i5HS89geXGWKSeWb7fTDud7k6r1Wm2W/t3u7nRl8hdifjak7dgZjWe4+rOfo6rO4y3gPs94DZnypaYGKYyLFczkc2AQgz3mb6LoeyBy6Kar2YIUn97pKIxgMf4GTMf78tm5UeozC5CKKxQGVDIrABv/hDoATNMSpTwV7PTV8IJJgdVuhCCQVtIN3ZoFlU6uMy98BUz4HveVCls9eEMsoXf3YRwVaBZ+RcMl6561azIVPmu+f5LBi6tVrAJ4UYzGEaD3jAio+goOjgjx9FZ73EDIiXvh6fHZOtv8mkUkf7JYfQ12CauTr58iIbRU05H/Y8RqT2AuEZ6J4ckeKW8GsQaOR2+tkA1eLU6bH4GAAD//8ZvDa32BQAA", | |
| "featuresControl": 12, | |
| "indexApiVersion": 4, | |
| "lastUse": "2020-09-14 07:04:26.29974293 -0700 PDT m=+26984.172961966", | |
| "maxElapsedTime": "22.849142ms", | |
| "maxServiceTime": "22.760305ms", | |
| "minElapsedTime": "1.624103ms", | |
| "minServiceTime": "1.584194ms", | |
| "name": "a76cbc5b-bea5-5b3b-b1f0-e27bc49a56f1", | |
| "namespace": "default", | |
| "node": "172.23.106.102:8091", | |
| "statement": "PREPARE SELECT META(`data-bucket`).id FROM `data-bucket` USE INDEX(sg_syncDocs_x1) WHERE META(`data-bucket`).id LIKE '\\\\_sync:%' AND (META(`data-bucket`).id LIKE '\\\\_sync:user:%' OR META(`data-bucket`).id LIKE '\\\\_sync:role:%')", | |
| "uses": 12 | |
| } | |
| }, | |
| { | |
| "plan": { | |
| "#operator": "Authorize", | |
| "privileges": { | |
| "List": [ | |
| { | |
| "Priv": 7, | |
| "Props": 0, | |
| "Target": "default:data-bucket" | |
| } | |
| ] | |
| }, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "IndexScan3", | |
| "covers": [ | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`rev`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`deleted`))", | |
| "cover ((meta(`data-bucket`).`id`))" | |
| ], | |
| "filter": "(cover ((not ((meta(`data-bucket`).`id`) like \"\\\\_sync:%\"))) and (0 < cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`))))", | |
| "filter_covers": { | |
| "cover ((not ((meta(`data-bucket`).`id`) like \"\\\\_sync:%\")))": true | |
| }, | |
| "index": "sg_allDocs_x1", | |
| "index_id": "ae8fb19c97979a06", | |
| "index_projection": { | |
| "entry_keys": [ | |
| 0 | |
| ], | |
| "primary_key": true | |
| }, | |
| "keyspace": "data-bucket", | |
| "namespace": "default", | |
| "spans": [ | |
| { | |
| "exact": true, | |
| "range": [ | |
| { | |
| "inclusion": 0, | |
| "low": "0" | |
| } | |
| ] | |
| } | |
| ], | |
| "using": "gsi" | |
| }, | |
| { | |
| "#operator": "Parallel", | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "InitialProject", | |
| "result_terms": [ | |
| { | |
| "expr": "cover ((meta(`data-bucket`).`id`))" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Stream" | |
| } | |
| ] | |
| } | |
| }, | |
| "prepareds": { | |
| "avgElapsedTime": "3.716326ms", | |
| "avgServiceTime": "3.648569ms", | |
| "encoded_plan": "H4sIAAAAAAAA/6RU7W7qOBB9FWtWqwYpVKFdCvgfarNatP1AwH5IBQXXHlK3xklth4VF2WdfOYG2VL1Xt+2/YXxm5jA5Z7aAmmcCRZIrpoEChLBA5gqD55l2JlMWaOskBKkFrvu5/BONlZkG+ksImi0RKJz1OO+xDjaxLbDZbketZg/FXVOciLN2V4iuOOlCjbY5475E4IIVykEIWY6GucwA3cJPLz+gX7j7zMh/EULIjVxJhSlaj7qU1gG93cKEmRTdSzcqmGPNu4I/ou88NHIFtOODLLdAo3JWhvAfv5dKvJ02xqcCNffDaoBBXc34MGjg9zTmTJ9CCDxbobFAb+uIBEEQLNGxYP6K6rxxPF8z54z1UWI3mvvA7qbNG419pw/VG1x9tnShWGo/WyxQoUNxWP5usaxAsxAWUjn0ywv2eJ2571URJR+RTGE6nU6rwfTnKTQaDcK0IEFEpkUUnXLypaVX/Gtmyf47buGLBIE6U2C5sxNQsGnClLrIuE3WLdjlEymAAsPu4q7V471Or9Nj0dnza26yB+SucqH3rzOb5BE3XmfRrHLLktWp53H+eW+9A5O8b0qbM20raeOacVe3CcEwnWKVlpqror4DUQgq+wcoRFDOylkIhZU6BQqplVCGh+4YMsOUQgVfMuJASyeZGtZ7gBAM2kK5xKFZ7mnnHvgD8vOcS38Z3vBwBtnSv5YhPBVoNv4c4trVJ9LKVFdH0vOvvtaDzTSUIewww1E87I9iMo4v4/MJuYon/bcEpCC/jm6uyEGa/DGOyeD6Iv6bBAfaaJC/fotH8bc6Xd9MyOXg95gcvZLcEelfX5D3/nwt/eMKd7wXfW0bJBGU/wcAAP//q41zAxcGAAA=", | |
| "featuresControl": 12, | |
| "indexApiVersion": 4, | |
| "lastUse": "2020-09-14 05:53:59.407137496 -0700 PDT m=+22757.280356602", | |
| "maxElapsedTime": "3.716326ms", | |
| "maxServiceTime": "3.648569ms", | |
| "minElapsedTime": "3.716326ms", | |
| "minServiceTime": "3.648569ms", | |
| "name": "69cc9a7e-e5de-5501-9edb-d2d658dd8d28", | |
| "namespace": "default", | |
| "node": "172.23.106.102:8091", | |
| "statement": "PREPARE SELECT META(`data-bucket`).id FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE META(`data-bucket`).id NOT LIKE '\\\\_sync:%' AND meta(`data-bucket`).xattrs._sync.sequence > 0", | |
| "uses": 1 | |
| } | |
| }, | |
| { | |
| "plan": { | |
| "#operator": "Authorize", | |
| "privileges": { | |
| "List": [ | |
| { | |
| "Priv": 7, | |
| "Props": 0, | |
| "Target": "default:data-bucket" | |
| } | |
| ] | |
| }, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "IndexScan3", | |
| "covers": [ | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`rev`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`deleted`))", | |
| "cover ((meta(`data-bucket`).`id`))" | |
| ], | |
| "filter": "(($startSeq <= cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`))) and (cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`)) < $endSeq) and cover ((not ((meta(`data-bucket`).`id`) like \"\\\\_sync:%\"))) and ((cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`)) is missing) or (bittest(cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`)), 1) = false)))", | |
| "filter_covers": { | |
| "cover ((not ((meta(`data-bucket`).`id`) like \"\\\\_sync:%\")))": true | |
| }, | |
| "index": "sg_allDocs_x1", | |
| "index_id": "61ea35b945350d6f", | |
| "index_projection": { | |
| "entry_keys": [ | |
| 0, | |
| 1, | |
| 2 | |
| ], | |
| "primary_key": true | |
| }, | |
| "keyspace": "data-bucket", | |
| "namespace": "default", | |
| "spans": [ | |
| { | |
| "exact": true, | |
| "range": [ | |
| { | |
| "high": "$endSeq", | |
| "inclusion": 1, | |
| "low": "$startSeq" | |
| }, | |
| { | |
| "inclusion": 0 | |
| }, | |
| { | |
| "high": "null", | |
| "inclusion": 0 | |
| } | |
| ] | |
| }, | |
| { | |
| "range": [ | |
| { | |
| "high": "$endSeq", | |
| "inclusion": 1, | |
| "low": "$startSeq" | |
| }, | |
| { | |
| "inclusion": 0 | |
| }, | |
| { | |
| "inclusion": 0, | |
| "low": "null" | |
| } | |
| ] | |
| } | |
| ], | |
| "using": "gsi" | |
| }, | |
| { | |
| "#operator": "Parallel", | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "InitialProject", | |
| "result_terms": [ | |
| { | |
| "as": "seq", | |
| "expr": "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`))" | |
| }, | |
| { | |
| "as": "rev", | |
| "expr": "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`rev`))" | |
| }, | |
| { | |
| "as": "flags", | |
| "expr": "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`))" | |
| }, | |
| { | |
| "as": "id", | |
| "expr": "cover ((meta(`data-bucket`).`id`))" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Limit", | |
| "expr": "5000" | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Stream" | |
| } | |
| ] | |
| } | |
| }, | |
| "prepareds": { | |
| "avgElapsedTime": "2.125336ms", | |
| "avgServiceTime": "2.059342ms", | |
| "encoded_plan": "H4sIAAAAAAAA/7RWa2/bNhT9K8Rdh8oAHchx3KAC8sFrtE2YkxiW9wBqw2Gka4cNTckk5TkztN8+kJJfrdE18faNlM45l/ehQ60BZZKlmE5ywSQEABSmyEyh8EMmjcqEhqB1ToHLFFfdnP+GSvNMQnBBQbI5QgB46fv+ectvdi4Qmx3mY/M9u0yarHPeTlh60fEvO1Chdc4SS0lxygphgEKWo2ImUxCs4bvdBrqFecwU/wuBQq74kgucobaoHtcGgo9rGDI1Q7NTC1JmWPOhSJ7QKvcVX0JwaRdZriHwy3FJ4e/kkYv082gxLgqUiQ1WARRKF+P/AUW2mHHCZBsoJNkSlYbgY7Uinud5czTMu9/L575xdr9ixihtVxP9LBO70HW0+0Zjo/QivsLla6lTwWb6teQUBRpMD+lHydyBxhSmXBi0xfO8N9owZWJckFHh++3kipxUuQZhMiXeSRr1ScgblGmMi0pyoygz87X0iOBPSEYwGo1GTjv4fgTbY73iXJvWEK7JnGvN5axBMkW8B24ManOCJCWtBrkiUyY0Nlz3qr5MNlO8hhOzhsCoAsvacSAAPZswIa6zRE9WLaifT3gKAbxrIWt3Ht5fdNodP3033b7NVfYJE+OMylqcUc+TJ3y2X5lPW/R87ExlzqrH25AWsnGoAy857l06Z1K7jxtXLDGVDAXF5Azd40c+e4QA6qFwp0tEUflni4LI/rRvN9MMJV3vI3y7ryVkIcQh39nZ+r8Ntr/fMFzkclyOKRR2kiCAmeaOvm9pfaaYECjgJIuNJDeciX7VPqCgUBfCTAyqeVVppu1IuPxwlVvOaa5p83CaCpenaNZOupVzH8wpglt/3Ury9Eu9r3im7VlZDcl+iXt8zs1OqOP7PnyJio1CNrcvSgqLAtWz/R3Alal+ETSfSfeTYLtcpRrAJ51JO3bpbm2Lut3YrtWbkkIt1h+E/e4gJHHYCz8MybF8quKcucqcbXpHujHRuKD/zlC4tGCFy28Au1ws3C0ouQmH3c8JPLUAnpIfB3c35OAl+TUOSXR7Hf5BvAPfapDffw4H4QvycxcKXpHdZde9vX4pf3shObJLxp3/9m5IetEvIXm7Z79vHejoSB2pURSTmyiOo9ufyN2A/BANh2E8/EYy3btECOlFN9GQVIP4TwAAAP//sO/ygZAKAAA=", | |
| "featuresControl": 12, | |
| "indexApiVersion": 4, | |
| "lastUse": "2020-09-14 00:06:22.030811794 -0700 PDT m=+1899.904030902", | |
| "maxElapsedTime": "2.657502ms", | |
| "maxServiceTime": "2.574117ms", | |
| "minElapsedTime": "1.593171ms", | |
| "minServiceTime": "1.544568ms", | |
| "name": "e7000210-54ee-5a0e-9a7c-a523cad45075", | |
| "namespace": "default", | |
| "node": "172.23.106.102:8091", | |
| "statement": "PREPARE SELECT meta(`data-bucket`).xattrs._sync.sequence AS seq, meta(`data-bucket`).xattrs._sync.rev AS rev, meta(`data-bucket`).xattrs._sync.flags AS flags, META(`data-bucket`).id AS id FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE meta(`data-bucket`).xattrs._sync.sequence >= $startSeq AND meta(`data-bucket`).xattrs._sync.sequence < $endSeq AND META().id NOT LIKE '\\\\_sync:%' AND (meta(`data-bucket`).xattrs._sync.flags IS MISSING OR BITTEST(meta(`data-bucket`).xattrs._sync.flags,1) = false) LIMIT 5000", | |
| "uses": 2 | |
| } | |
| }, | |
| { | |
| "plan": { | |
| "#operator": "Authorize", | |
| "privileges": { | |
| "List": [ | |
| { | |
| "Priv": 7, | |
| "Props": 0, | |
| "Target": "default:data-bucket" | |
| } | |
| ] | |
| }, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "IndexScan3", | |
| "covers": [ | |
| "cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`rev`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`))", | |
| "cover ((meta(`data-bucket`).`id`))" | |
| ], | |
| "filter": "(cover (([] <= object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`)))) and cover ((object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`)) < {})))", | |
| "filter_covers": { | |
| "cover (([] <= object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`))))": true, | |
| "cover ((object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`)) < {}))": true, | |
| "cover (is_array(object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`))))": true | |
| }, | |
| "index": "sg_channels_x1", | |
| "index_id": "eba038cebf491d89", | |
| "index_order": [ | |
| { | |
| "keypos": 0 | |
| } | |
| ], | |
| "keyspace": "data-bucket", | |
| "limit": "5000", | |
| "namespace": "default", | |
| "spans": [ | |
| { | |
| "exact": true, | |
| "range": [ | |
| { | |
| "high": "[$channelName, $endSeq]", | |
| "inclusion": 3, | |
| "low": "[$channelName, $startSeq]" | |
| } | |
| ] | |
| } | |
| ], | |
| "using": "gsi" | |
| }, | |
| { | |
| "#operator": "Parallel", | |
| "maxParallelism": 1, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Filter", | |
| "condition": "(cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)]) between [$channelName, $startSeq] and [$channelName, $endSeq])" | |
| }, | |
| { | |
| "#operator": "InitialProject", | |
| "result_terms": [ | |
| { | |
| "as": "seq", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[1])" | |
| }, | |
| { | |
| "as": "rRev", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[2])" | |
| }, | |
| { | |
| "as": "rDel", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[3])" | |
| }, | |
| { | |
| "as": "rev", | |
| "expr": "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`rev`))" | |
| }, | |
| { | |
| "as": "flags", | |
| "expr": "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`))" | |
| }, | |
| { | |
| "as": "id", | |
| "expr": "cover ((meta(`data-bucket`).`id`))" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Limit", | |
| "expr": "5000" | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Stream" | |
| } | |
| ] | |
| } | |
| }, | |
| "prepareds": { | |
| "avgElapsedTime": "333.167µs", | |
| "avgServiceTime": "257.235µs", | |
| "encoded_plan": "H4sIAAAAAAAA/9xWXW/iOBf+K9Z55yKRXASl7dBI7wVt011WLUWE2dkVi8BNDtQzxklth6GL2N++shOg9FPT6ajq3tnxcz6ek3MeewEo4zTBZJgJJiEAoDBGZnKFx6k0KhUagtouBS4TnDcz/jsqzVMJwR4FyaYIAdSxsR/Xa42d3d34cGc/OWjsNMZ7H3eqB416FQ+SMTtoQIHWGYutSYJjlgsDFNIMFTOpgmAB/9tsoJmbq1TxvxEoZIrPuMAJaos649pA0F9Aj6kJmo23IGGG7Vzm8Ve0njuKzyD4aBdppiGoLgdLCv/EV1wkd6NFeJ2jjG2wAqBQuhg/B9SyxYxiJutAIU5nqDQE/WJFvL43SrNRZWQLNvIpEci08TzPm6Jh3ugWy5FfGc2ZMUrb1VDfyNgudJmDNfZKZzMmyqOR71PCx1OuNZcT7w5A4cyayVyIp2AJijVs4K9YkO/J0kV6memG4Mvsx4JN9Lbxg6Y8saABhTEXBu2f81b4/oD8lVer9fj/JL38grEZZowr/T1ZxFdMShQ2Ed8nTCZk5fwVPJbZkcXSdzwLBsNVsy3gZxGBwKgcN4V9ZS533HM9ZEqxm9cIs3K+LNUOAtCT4QownNegPBjyBALAS1atN2K8HO8d1pLG4fo0VYntlf4CvuJNlhbSQ+1mLX9bQiX4lFsZ269Wq4/qpM6Y1M4pzllsVmVQTE7Qfb7ikysIoP+hTLjNpkjJB5RJhNcDl1ws8kK76xRE+u0BtDZMGYdfDmzOuZ19CGCiOSzptoh1mGJCoAAKUzZf7bieQlD7IZ09LYbN/mOZcOMyXg/e+xNHconmG6Ikjxbbzf4jP86/V/eW5IYz0VGp7XigoFDnwgwNqmnRIUzb1sVroIDzTL3r6vVrZQkcKdXF2X+C1e4WqxM3Re+fVX2L1e1f9eLnwdqdu7N/xOH60l+75Ml9f0+8A6wkLu0jcnsez5x8rx05Fb+PioxCNrUHSwrXOaob+77GuSne3JpPpHt1W8UsqAbwRafSCneyWbtW2ezsOGx2tzd2/MvNkkIZqNMNO81uSKLwLDzukX6aVaRTm7OwGfUe5F4UsuKqWFl1FCVpVpkxYT/4tHV63oqiVvsXr/yqcEaLzrl3lKAojgb92oA0I6Lxmr5xIrsuEVvLt86kXmRygoKSZyMrnDm0TftZsGspC3cLSs7DXvOuAU8sgCfktHtxTrYOyacoJK32SfgH8bbfRD751G6HUY9cHP0WHveGnWarGz1ftpUH34ZMM/L517AbEu9Ny0/IUdj7HIZt8sRV3WyfPHpVk4vuSdglR3++bRuRs9Z5q0cKIfo3AAD//yLHuvDhDwAA", | |
| "featuresControl": 12, | |
| "indexApiVersion": 4, | |
| "lastUse": "2020-09-14 09:02:30.51102292 -0700 PDT m=+34068.384242035", | |
| "maxElapsedTime": "148.97518ms", | |
| "maxServiceTime": "148.912987ms", | |
| "minElapsedTime": "126.92µs", | |
| "minServiceTime": "107.219µs", | |
| "name": "3e85c318-22c9-5d68-8f47-06830e6dfa68", | |
| "namespace": "default", | |
| "node": "172.23.106.102:8091", | |
| "statement": "PREPARE SELECT [op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][1] AS seq, [op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][2] AS rRev, [op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][3] AS rDel, meta(`data-bucket`).xattrs._sync.rev AS rev, meta(`data-bucket`).xattrs._sync.flags AS flags, META(`data-bucket`).id AS id FROM `data-bucket` USE INDEX (sg_channels_x1) UNNEST OBJECT_PAIRS(meta(`data-bucket`).xattrs._sync.channels) AS op WHERE ([op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)] BETWEEN [$channelName, $startSeq] AND [$channelName, $endSeq]) ORDER BY [op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)] LIMIT 5000", | |
| "uses": 100650 | |
| } | |
| }, | |
| { | |
| "plan": { | |
| "#operator": "Authorize", | |
| "privileges": { | |
| "List": [ | |
| { | |
| "Priv": 7, | |
| "Props": 0, | |
| "Target": "default:data-bucket" | |
| } | |
| ] | |
| }, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "IndexScan3", | |
| "index": "sg_syncDocs_x1", | |
| "index_id": "542f1d5f337dd541", | |
| "index_projection": { | |
| "primary_key": true | |
| }, | |
| "keyspace": "data-bucket", | |
| "namespace": "default", | |
| "spans": [ | |
| { | |
| "range": [ | |
| { | |
| "high": "\"_sync:session;\"", | |
| "inclusion": 1, | |
| "low": "\"_sync:session:\"" | |
| } | |
| ] | |
| } | |
| ], | |
| "using": "gsi" | |
| }, | |
| { | |
| "#operator": "Fetch", | |
| "keyspace": "data-bucket", | |
| "namespace": "default" | |
| }, | |
| { | |
| "#operator": "Parallel", | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Filter", | |
| "condition": "(((meta(`data-bucket`).`id`) like \"\\\\_sync:%\") and ((meta(`data-bucket`).`id`) like \"\\\\_sync:session:%\") and ((`data-bucket`.`username`) = $userName))" | |
| }, | |
| { | |
| "#operator": "InitialProject", | |
| "result_terms": [ | |
| { | |
| "expr": "(meta(`data-bucket`).`id`)" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Stream" | |
| } | |
| ] | |
| } | |
| }, | |
| "prepareds": { | |
| "avgElapsedTime": "3.450613ms", | |
| "avgServiceTime": "3.396384ms", | |
| "encoded_plan": "H4sIAAAAAAAA/6SUa2/aPBTHv4p1nmcqkUxVCqzF016gNtXQ2g5Bd5GWCkx8CC7GSW2ng6Hss09OegG6Sqv2Lo7/5+Lf3z5rQB2nAsUoU1wDA6AwRe5ygyepdiZVFljjkILUApfdTH5BY2WqgbUoaL5AYICddqclDng9PmqKevvw+Lg+OeaTeqP1FjsH2OAT7EClthmPfYjAKc+VAwpphoa71ABbw39PC+jmbpYa+ROBQmbknVSYoPWqc2kdsO9ruOImQfeUjQnueH2Sx3P0mftG3gE78h9pZoEdFNcFhV/xTCqxW22Itznq2BerBAZ1WePVop7nNIy5bsI9NGBgk5Fd6fg0je1o2XjYGEkBDNqtw2lDtKfN5pEQ7dbTbmbSG4xdCXvtGSy4WY3muALmTI4FhTmuHoFuHf3PqG3GtS0bNlwnWH7NZDIDBhGUDTKL1rv7LoKyjVjlldkNCir98VzIIoDiurimkFupE2CQWAkF3WZyhi6ewSv73U3S54YrhQr+ycMzqRwaoBCnWsgKLtRqtQU6XhtvdDUO9sdSjAOi5BxJBFEURdXR30QQEK4FeVXUA7CN6K3A/XFu0XgQ44C8J//71SVfYBA8I9HT0kmu+tX9AAoGba7cyKFZVP7iMvPCl/srTSv8g9hh6Azyhd8tKNzmaFZ+CuDSVZPBykSXs8GzL2/vjU01FBTuNf1B2O8OQjIMz8OTK3IRXnV360tBzgafLsjWb/J5GJLe5Wn4rbb9VgLy9UM4CF/KdN77GJK9DW/2SPfy9G/Vj55UUQ8GbOKH4ncAAAD//9fQ4qkiBQAA", | |
| "featuresControl": 12, | |
| "indexApiVersion": 4, | |
| "lastUse": "2020-09-14 02:06:03.369469228 -0700 PDT m=+9081.242688181", | |
| "maxElapsedTime": "3.450613ms", | |
| "maxServiceTime": "3.396384ms", | |
| "minElapsedTime": "3.450613ms", | |
| "minServiceTime": "3.396384ms", | |
| "name": "e9594d0a-c73d-5288-b8ab-146e90e1abe9", | |
| "namespace": "default", | |
| "node": "172.23.106.102:8091", | |
| "statement": "PREPARE SELECT META(`data-bucket`).id FROM `data-bucket` USE INDEX(sg_syncDocs_x1) WHERE META(`data-bucket`).id LIKE '\\\\_sync:%' AND META(`data-bucket`).id LIKE '\\\\_sync:session:%' AND username = $userName", | |
| "uses": 1 | |
| } | |
| }, | |
| { | |
| "plan": { | |
| "#operator": "Authorize", | |
| "privileges": { | |
| "List": [ | |
| { | |
| "Priv": 7, | |
| "Props": 0, | |
| "Target": "default:data-bucket-2" | |
| } | |
| ] | |
| }, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "IndexScan3", | |
| "covers": [ | |
| "cover ([(`op`.`name`), least((((meta(`data-bucket-2`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])", | |
| "cover ((((meta(`data-bucket-2`).`xattrs`).`_sync`).`rev`))", | |
| "cover ((((meta(`data-bucket-2`).`xattrs`).`_sync`).`sequence`))", | |
| "cover ((((meta(`data-bucket-2`).`xattrs`).`_sync`).`flags`))", | |
| "cover ((meta(`data-bucket-2`).`id`))" | |
| ], | |
| "filter": "(cover (([] <= object_pairs((((meta(`data-bucket-2`).`xattrs`).`_sync`).`channels`)))) and cover ((object_pairs((((meta(`data-bucket-2`).`xattrs`).`_sync`).`channels`)) < {})))", | |
| "filter_covers": { | |
| "cover (([] <= object_pairs((((meta(`data-bucket-2`).`xattrs`).`_sync`).`channels`))))": true, | |
| "cover ((object_pairs((((meta(`data-bucket-2`).`xattrs`).`_sync`).`channels`)) < {}))": true, | |
| "cover (is_array(object_pairs((((meta(`data-bucket-2`).`xattrs`).`_sync`).`channels`))))": true | |
| }, | |
| "index": "sg_channels_x1", | |
| "index_id": "78c0db70a9f5137d", | |
| "index_order": [ | |
| { | |
| "keypos": 0 | |
| } | |
| ], | |
| "keyspace": "data-bucket-2", | |
| "limit": "5000", | |
| "namespace": "default", | |
| "spans": [ | |
| { | |
| "exact": true, | |
| "range": [ | |
| { | |
| "high": "[$channelName, $endSeq]", | |
| "inclusion": 3, | |
| "low": "[$channelName, $startSeq]" | |
| } | |
| ] | |
| } | |
| ], | |
| "using": "gsi" | |
| }, | |
| { | |
| "#operator": "Parallel", | |
| "maxParallelism": 1, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Filter", | |
| "condition": "(cover ([(`op`.`name`), least((((meta(`data-bucket-2`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)]) between [$channelName, $startSeq] and [$channelName, $endSeq])" | |
| }, | |
| { | |
| "#operator": "InitialProject", | |
| "result_terms": [ | |
| { | |
| "as": "seq", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket-2`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[1])" | |
| }, | |
| { | |
| "as": "rRev", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket-2`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[2])" | |
| }, | |
| { | |
| "as": "rDel", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket-2`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[3])" | |
| }, | |
| { | |
| "as": "rev", | |
| "expr": "cover ((((meta(`data-bucket-2`).`xattrs`).`_sync`).`rev`))" | |
| }, | |
| { | |
| "as": "flags", | |
| "expr": "cover ((((meta(`data-bucket-2`).`xattrs`).`_sync`).`flags`))" | |
| }, | |
| { | |
| "as": "id", | |
| "expr": "cover ((meta(`data-bucket-2`).`id`))" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Limit", | |
| "expr": "5000" | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Stream" | |
| } | |
| ] | |
| } | |
| }, | |
| "prepareds": { | |
| "avgElapsedTime": "128.2709ms", | |
| "avgServiceTime": "128.180031ms", | |
| "encoded_plan": "H4sIAAAAAAAA/9xWXW/bNhf+K8R5eyEBtCFHTZMKeC/cRNk8JI5huesGz7AZ8dhhS1MKSbnODO+3D5T8USdzkDYpgvaOFJ/z8RwePjoLQJVmHPkwl0xBBEBhjMwWGk8yZXUmDUSNAwpCcZw3c/E7aiMyBdFrCopNESIYh2M8Dl6HtSDEw9phePi6dsyCsJaGwRv+lr/hx8EBVGiTs9SZcByzQlqgkOWomc00RAv433YDzcJeZ1r8jUAh12ImJE7QONS5MBai/gJ6TE/Qbr1FnFlWuyrST2hrLmJHixlER26R5QaiYDlYUvgnvRaS342X4E2BKnXhKoBGVUb5PqCWK2eSMhUChTSboTYQ9asV8freKMtH9ZEr2cinRCIz1vM8b4qWeaMdniO/Ppoza7Vxq6G5ValbmFUWztxbuZsxuToa+T4lYjwVxgg18e4ANM6cmSqkfAjGUW5gA3/Ng3xdnmWsbzXekvxWD2PJJmbXfI+x4A42oDAW0qK7Q29t0R+Qv4ogCNP/k+zqI6Z2mDOhzddlkl4zpVC6ZHyfMMXJ2v2z+FxlSBZLv2RbsRiuW28B348MRFYXuC3ws/O5E0CYIdOa3T5PoLX75UoDIQIzGa4Bw3kDVgdDwSGCo+M04FdHAXs7PmyER3xzmmnuuqa/gE94m2eVHFG32YjiHfmSYiqcvB0GQbBXP03OlCnd4pyldl0KzdQEy8/XYnINEfRfrVJusylS8goVT/BmUKaXyqLS9JCCzD7/B9pYpm2JXw5c1oXTA4hgYgQs6a60dZhmUqIEClM2X++EmULUeJL6nlUPz92z4sKWGW8e4Y8omeQK7WdERfaWu9SBPVfn36t8SwkrmOzozPU9UNBoCmmHFvW06hFmXPviDVDAea5/8Pr1G6silLR0F2c/Ca+DHV6n5Vv6GXiFO7y+vK4njA4bh+W//GkuN+PAxqng9z0+OCE4gVy6QXP3bZ6XYr5xVWr6fVRiNbKpO1hSuClQ37opHOe2msyNmKhyNnf6WdGN4KPJlJNxvl2XLbPduYex3X25cVKw2iwprAJ1unGn2Y1JEp/HJz3Sz/K6KpXnPG4mvT3sq2LWy0rW151FSZbXZ0y6Dz5tnV20kqTV/sVbfdU4o1UH3TviKKujQb8xIM2EGLyhL57KQZmKq+fL5xJWuZyipOQRsTXOSrxL/RHwsrmcQbmg5CLuNe+bCO4ggpOz7uUFuXNM3icxabVP4z+Itzsx+eR9ux0nPXL57rf4pDfsNFvd5DEFXPvwXdgsJx9+jbsx8V74Kgh5F/c+xHGbPPAjb7ZP9/7IyWX3NO6Sd3++dFOR89ZFq0cqcfo3AAD//1mdkiYbEAAA", | |
| "featuresControl": 12, | |
| "indexApiVersion": 4, | |
| "lastUse": "2020-09-14 05:01:14.537371279 -0700 PDT m=+19592.410590679", | |
| "maxElapsedTime": "176.414181ms", | |
| "maxServiceTime": "176.353267ms", | |
| "minElapsedTime": "5.11992ms", | |
| "minServiceTime": "5.080409ms", | |
| "name": "f3fe8043-03e5-5354-8a03-c306d9d6d802", | |
| "namespace": "default", | |
| "node": "172.23.106.102:8091", | |
| "statement": "PREPARE SELECT [op.name, LEAST(meta(`data-bucket-2`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][1] AS seq, [op.name, LEAST(meta(`data-bucket-2`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][2] AS rRev, [op.name, LEAST(meta(`data-bucket-2`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][3] AS rDel, meta(`data-bucket-2`).xattrs._sync.rev AS rev, meta(`data-bucket-2`).xattrs._sync.flags AS flags, META(`data-bucket-2`).id AS id FROM `data-bucket-2` USE INDEX (sg_channels_x1) UNNEST OBJECT_PAIRS(meta(`data-bucket-2`).xattrs._sync.channels) AS op WHERE ([op.name, LEAST(meta(`data-bucket-2`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)] BETWEEN [$channelName, $startSeq] AND [$channelName, $endSeq]) ORDER BY [op.name, LEAST(meta(`data-bucket-2`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)] LIMIT 5000", | |
| "uses": 11 | |
| } | |
| }, | |
| { | |
| "plan": { | |
| "#operator": "Authorize", | |
| "privileges": { | |
| "List": [ | |
| { | |
| "Priv": 7, | |
| "Props": 0, | |
| "Target": "default:data-bucket" | |
| } | |
| ] | |
| }, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "IndexScan3", | |
| "covers": [ | |
| "cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`rev`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`))", | |
| "cover ((meta(`data-bucket`).`id`))" | |
| ], | |
| "filter": "(cover (([] <= object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`)))) and cover ((object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`)) < {})))", | |
| "filter_covers": { | |
| "cover (([] <= object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`))))": true, | |
| "cover ((object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`)) < {}))": true, | |
| "cover (is_array(object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`))))": true | |
| }, | |
| "index": "sg_channels_x1", | |
| "index_id": "ad8c086379375a48", | |
| "index_order": [ | |
| { | |
| "keypos": 0 | |
| } | |
| ], | |
| "keyspace": "data-bucket", | |
| "limit": "20", | |
| "namespace": "default", | |
| "spans": [ | |
| { | |
| "exact": true, | |
| "range": [ | |
| { | |
| "high": "[$channelName, $endSeq]", | |
| "inclusion": 3, | |
| "low": "[$channelName, $startSeq]" | |
| } | |
| ] | |
| } | |
| ], | |
| "using": "gsi" | |
| }, | |
| { | |
| "#operator": "Parallel", | |
| "maxParallelism": 1, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Filter", | |
| "condition": "(cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)]) between [$channelName, $startSeq] and [$channelName, $endSeq])" | |
| }, | |
| { | |
| "#operator": "InitialProject", | |
| "result_terms": [ | |
| { | |
| "as": "seq", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[1])" | |
| }, | |
| { | |
| "as": "rRev", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[2])" | |
| }, | |
| { | |
| "as": "rDel", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[3])" | |
| }, | |
| { | |
| "as": "rev", | |
| "expr": "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`rev`))" | |
| }, | |
| { | |
| "as": "flags", | |
| "expr": "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`))" | |
| }, | |
| { | |
| "as": "id", | |
| "expr": "cover ((meta(`data-bucket`).`id`))" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Limit", | |
| "expr": "20" | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Stream" | |
| } | |
| ] | |
| } | |
| }, | |
| "prepareds": { | |
| "avgElapsedTime": "5.127806ms", | |
| "avgServiceTime": "5.073159ms", | |
| "encoded_plan": "H4sIAAAAAAAA/9xWW2/bNhT+K8RZHySAMXxpGkfAHpxE2TwkjmG56wbPsGnp2GFLUwpJuc4M77cPpHyJc0XTFEH6RorfuXxH53zkAlDGaYLJIBNMQgBAYYzM5AqPU2lUKjQElSoFLhOcNzL+JyrNUwnBewqSTRECwP3a/mGtcrgXfxiX9/ZH+2yvXklqe/VKvVrF2sFoNKpAgdYZi61JgmOWCwMU0gwVM6mCYAG/bDfQyM1lqvi/CBQyxWdc4AS1RZ1xbSDoLaDL1ATN1luQMMP2Rnn8Ba3ntuIzCA7sIs00BOVlf0nhv/iSi+R2tAivcpSxDVYAFEoX48eAmraYUcxkDSjE6QyVhqBXrIjX84ZpNiwNbcGGPiUCmTae53lTNMwb3mA59EvDOTNGabsa6GsZ24Ve5WCNvZWzGROro6HvU8LHU641lxPvFkDhzJrJXIjHYAmKDazvr1mQb8nSRXqe6Zbg8+zHgk30rvG9pjyxoD6FMRcG7Z/z1vhen/yTl8u1+FeSjj5jbAYZ40p/SxbxJZMShU3E9wmTCVk7fwGPq+zIYuk7ngWDwbrZFvCjiEBgVI7bwr4wl1vuuR4wpdj1S4RZO1+u1A4C0JPBGjCYWxFzBwOeQAAsqcfl+ofawWHtYJ+9r29OU5XYXukt4AteZ2khPdRuNvK3I1SCT7mVsWr5QZXUGZPaucQ5i826CIrJCbrPl3xyCQH03q3SbbEpUvIOZRLhVd+lFou8UO4aBZF+vQetDVPG4Zd9m3FuJx8CmGgOS7orYW2mmBAogMKUzdc7rqcQVL5LZU+LUbN/WCbcuIw3Y/f2pJGM0HxFlOTBYrvJf+DH+Xfq3pTccCbaKrX9DhQU6lyYgUE1LTqEadu4eAUUcJ6pN129XmVVAkdKdXD2U7Cq7rA6cVP09lnVdljd/FXPfhxs3Lkb+3scbq78jUue3PX3yCvASuLSPiF35/HMiffGUbUMdzGRUcim9mBJ4SpHdW3f1jg3xXtb84l0L26rlwXRAD7rVFrZTrZr1yjbnR2G7e7mxg7/arOksArU7oTtRickUXgWHndJL81K0mnNWdiIuvcyL8pYcjUsrfuJkjQrzZiwH3zaPD1vRlGz9Zu3+qpwRou+uXOUoCiO+r1KnzQiovGKvnIiVZeIreVrZ1IrMjlBQcmTkRXOHNqm/STYtZSFuwUl52G3cduAJxbAE3LauTgnO4fkYxSSZusk/It4u+8hn3xstcKoSy6O/giPu4N2o9mJni7b2oNvQ6YZ+fR72AmJ96rlJ+Qo7H4KwxZ55KJutE4evKjJReck7JCjv1+3jchZ87zZJVaG/g8AAP//tRQFN9sPAAA=", | |
| "featuresControl": 12, | |
| "indexApiVersion": 4, | |
| "lastUse": "2020-09-14 00:32:23.56418133 -0700 PDT m=+3461.437400288", | |
| "maxElapsedTime": "17.504706ms", | |
| "maxServiceTime": "17.42139ms", | |
| "minElapsedTime": "1.946144ms", | |
| "minServiceTime": "1.898741ms", | |
| "name": "e5359319-c6f0-5b5a-81d3-81822e37bbb1", | |
| "namespace": "default", | |
| "node": "172.23.106.102:8091", | |
| "statement": "PREPARE SELECT [op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][1] AS seq, [op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][2] AS rRev, [op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][3] AS rDel, meta(`data-bucket`).xattrs._sync.rev AS rev, meta(`data-bucket`).xattrs._sync.flags AS flags, META(`data-bucket`).id AS id FROM `data-bucket` USE INDEX (sg_channels_x1) UNNEST OBJECT_PAIRS(meta(`data-bucket`).xattrs._sync.channels) AS op WHERE ([op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)] BETWEEN [$channelName, $startSeq] AND [$channelName, $endSeq]) ORDER BY [op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)] LIMIT 20", | |
| "uses": 18 | |
| } | |
| }, | |
| { | |
| "plan": { | |
| "#operator": "Authorize", | |
| "privileges": { | |
| "List": [ | |
| { | |
| "Priv": 7, | |
| "Props": 0, | |
| "Target": "default:data-bucket" | |
| } | |
| ] | |
| }, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "IndexScan3", | |
| "covers": [ | |
| "cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`rev`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`))", | |
| "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`))", | |
| "cover ((meta(`data-bucket`).`id`))" | |
| ], | |
| "filter": "(cover (([] <= object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`)))) and cover ((object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`)) < {})))", | |
| "filter_covers": { | |
| "cover (([] <= object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`))))": true, | |
| "cover ((object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`)) < {}))": true, | |
| "cover (is_array(object_pairs((((meta(`data-bucket`).`xattrs`).`_sync`).`channels`))))": true | |
| }, | |
| "index": "sg_channels_x1", | |
| "index_id": "d6d2888a3f0977e1", | |
| "index_order": [ | |
| { | |
| "keypos": 0 | |
| } | |
| ], | |
| "keyspace": "data-bucket", | |
| "limit": "50", | |
| "namespace": "default", | |
| "spans": [ | |
| { | |
| "exact": true, | |
| "range": [ | |
| { | |
| "high": "[$channelName, $endSeq]", | |
| "inclusion": 3, | |
| "low": "[$channelName, $startSeq]" | |
| } | |
| ] | |
| } | |
| ], | |
| "using": "gsi" | |
| }, | |
| { | |
| "#operator": "Parallel", | |
| "maxParallelism": 1, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Filter", | |
| "condition": "(cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)]) between [$channelName, $startSeq] and [$channelName, $endSeq])" | |
| }, | |
| { | |
| "#operator": "InitialProject", | |
| "result_terms": [ | |
| { | |
| "as": "seq", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[1])" | |
| }, | |
| { | |
| "as": "rRev", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[2])" | |
| }, | |
| { | |
| "as": "rDel", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[3])" | |
| }, | |
| { | |
| "as": "rev", | |
| "expr": "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`rev`))" | |
| }, | |
| { | |
| "as": "flags", | |
| "expr": "cover ((((meta(`data-bucket`).`xattrs`).`_sync`).`flags`))" | |
| }, | |
| { | |
| "as": "id", | |
| "expr": "cover ((meta(`data-bucket`).`id`))" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Limit", | |
| "expr": "50" | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Stream" | |
| } | |
| ] | |
| } | |
| }, | |
| "prepareds": { | |
| "avgElapsedTime": "11.584505ms", | |
| "avgServiceTime": "11.477528ms", | |
| "encoded_plan": "H4sIAAAAAAAA/9xWXW/iOBf+K9Z55yKRXARl+hXpvaBtusuqpYgwO7tiEZjkQD1jnNR2GLqI/e0rOwFKPzWdjqrunR0/5+M5OeexF4AyThNMBplgEgIACmNkJld4kkqjUqEhqO1S4DLBeSPjv6PSPJUQfKQg2RQhgH02Gu/v7e7v1PZH45292t7Rzogd1Xfq9aN4XMMD/IgHUKB1xmJrkuCY5cIAhTRDxUyqIFjA/zYbaOTmKlX8bwQKmeIzLnCC2qLOuTYQ9BbQZWqCZuMtSJhhO6M8/orWc1vxGQQHdpFmGoLqsr+k8E98xUVyN1qE1znK2AYrAAqli/FzQE1bzChmsg4U4nSGSkPQK1bE63nDNBtWhrZgQ58SgUwbz/O8KRrmDW+xHPqV4ZwZo7RdDfSNjO1ClzlYY690NmOiPBr6PiV8POVacznx7gAUzqyZzIV4CpagWMP6/ooF+Z4sXaSXmW4Ivsx+LNhEbxs/aMoTC+pTGHNh0P45b4Xv9clfebVaj/9P0tEXjM0gY1zp78kivmJSorCJ+D5hMiEr56/gscyOLJa+41kwGKyabQE/iwgERuW4Kewrc7njnusBU4rdvEaYlfNlqXYQgJ4MVoDBvAblwYAnVnX2k93Dw0NWH1ePDg5wc5qqxPZKbwFf8SZLC+mhdrOWvy2hEnzKrYztVR9VSZ0xqZ1LnLPYrIqgmJyg+3zFJ1cQQO9DmW6LTZGSDyiTCK/7LrVY5IVy1ymI9NsDaG2YMg6/7NuMczv5EMBEc1jSbQlrM8WEQAEUpmy+2nE9haD2Qyp7Voya/cMy4cZlvB679yeNZITmG6IkjxbbTf4jP86/V/em5IYz0Vap7XegoFDnwgwMqmnRIUzbxsVroIDzTL3r6vVqZQkcKdXB2X+C1e4Wq1M3Re+fVX2L1e1f9eLHwdqdu7F/xOH6yl+75Ml9f0+8AqwkLu0Tcnsez514rx3tVeE+JjIK2dQeLClc56hu7Nsa56Z4b2s+ke7FbfWyIBrAF51KK9vJZu0aZbOzw7DZ3d7Y4S83SwploHYnbDc6IYnC8/CkS3ppVpFOa87DRtR9kHlRxoqrYWXVT5SkWWXGhP3g0+bZRTOKmq1fvPKrwhkt+ubeUYKiOOr3an3SiIjGa/rGiey6RGwt3zqTepHJKQpKno2scObQNu1nwa6lLNwtKLkIu427BjyxAJ6Qs87lBdk6JJ+ikDRbp+EfxNt+D/nkU6sVRl1yefxbeNIdtBvNTvR82VYefBsyzcjnX8NOSLw3LT8hx2H3cxi2yBMXdaN1+uhFTS47p2GHHP/5tm1EzpsXzS6xMvRvAAAA///kHmrH2w8AAA==", | |
| "featuresControl": 12, | |
| "indexApiVersion": 4, | |
| "lastUse": "2020-09-14 05:52:10.668303323 -0700 PDT m=+22648.541522263", | |
| "maxElapsedTime": "45.968891ms", | |
| "maxServiceTime": "45.919877ms", | |
| "minElapsedTime": "2.471641ms", | |
| "minServiceTime": "2.429527ms", | |
| "name": "6abf6526-16bf-5159-ba93-339cf1e7e4e7", | |
| "namespace": "default", | |
| "node": "172.23.106.102:8091", | |
| "statement": "PREPARE SELECT [op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][1] AS seq, [op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][2] AS rRev, [op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][3] AS rDel, meta(`data-bucket`).xattrs._sync.rev AS rev, meta(`data-bucket`).xattrs._sync.flags AS flags, META(`data-bucket`).id AS id FROM `data-bucket` USE INDEX (sg_channels_x1) UNNEST OBJECT_PAIRS(meta(`data-bucket`).xattrs._sync.channels) AS op WHERE ([op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)] BETWEEN [$channelName, $startSeq] AND [$channelName, $endSeq]) ORDER BY [op.name, LEAST(meta(`data-bucket`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)] LIMIT 50", | |
| "uses": 4001 | |
| } | |
| }, | |
| { | |
| "plan": { | |
| "#operator": "Authorize", | |
| "privileges": { | |
| "List": [ | |
| { | |
| "Priv": 7, | |
| "Props": 0, | |
| "Target": "default:data-bucket-1" | |
| } | |
| ] | |
| }, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "IndexScan3", | |
| "covers": [ | |
| "cover ([(`op`.`name`), least((((meta(`data-bucket-1`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])", | |
| "cover ((((meta(`data-bucket-1`).`xattrs`).`_sync`).`rev`))", | |
| "cover ((((meta(`data-bucket-1`).`xattrs`).`_sync`).`sequence`))", | |
| "cover ((((meta(`data-bucket-1`).`xattrs`).`_sync`).`flags`))", | |
| "cover ((meta(`data-bucket-1`).`id`))" | |
| ], | |
| "filter": "(cover (([] <= object_pairs((((meta(`data-bucket-1`).`xattrs`).`_sync`).`channels`)))) and cover ((object_pairs((((meta(`data-bucket-1`).`xattrs`).`_sync`).`channels`)) < {})))", | |
| "filter_covers": { | |
| "cover (([] <= object_pairs((((meta(`data-bucket-1`).`xattrs`).`_sync`).`channels`))))": true, | |
| "cover ((object_pairs((((meta(`data-bucket-1`).`xattrs`).`_sync`).`channels`)) < {}))": true, | |
| "cover (is_array(object_pairs((((meta(`data-bucket-1`).`xattrs`).`_sync`).`channels`))))": true | |
| }, | |
| "index": "sg_channels_x1", | |
| "index_id": "4619046190e64d0e", | |
| "index_order": [ | |
| { | |
| "keypos": 0 | |
| } | |
| ], | |
| "keyspace": "data-bucket-1", | |
| "limit": "5000", | |
| "namespace": "default", | |
| "spans": [ | |
| { | |
| "exact": true, | |
| "range": [ | |
| { | |
| "high": "[$channelName, $endSeq]", | |
| "inclusion": 3, | |
| "low": "[$channelName, $startSeq]" | |
| } | |
| ] | |
| } | |
| ], | |
| "using": "gsi" | |
| }, | |
| { | |
| "#operator": "Parallel", | |
| "maxParallelism": 1, | |
| "~child": { | |
| "#operator": "Sequence", | |
| "~children": [ | |
| { | |
| "#operator": "Filter", | |
| "condition": "(cover ([(`op`.`name`), least((((meta(`data-bucket-1`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)]) between [$channelName, $startSeq] and [$channelName, $endSeq])" | |
| }, | |
| { | |
| "#operator": "InitialProject", | |
| "result_terms": [ | |
| { | |
| "as": "seq", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket-1`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[1])" | |
| }, | |
| { | |
| "as": "rRev", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket-1`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[2])" | |
| }, | |
| { | |
| "as": "rDel", | |
| "expr": "(cover ([(`op`.`name`), least((((meta(`data-bucket-1`).`xattrs`).`_sync`).`sequence`), ((`op`.`val`).`seq`)), ifmissing(((`op`.`val`).`rev`), null), ifmissing(((`op`.`val`).`del`), null)])[3])" | |
| }, | |
| { | |
| "as": "rev", | |
| "expr": "cover ((((meta(`data-bucket-1`).`xattrs`).`_sync`).`rev`))" | |
| }, | |
| { | |
| "as": "flags", | |
| "expr": "cover ((((meta(`data-bucket-1`).`xattrs`).`_sync`).`flags`))" | |
| }, | |
| { | |
| "as": "id", | |
| "expr": "cover ((meta(`data-bucket-1`).`id`))" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Limit", | |
| "expr": "5000" | |
| } | |
| ] | |
| }, | |
| { | |
| "#operator": "Stream" | |
| } | |
| ] | |
| } | |
| }, | |
| "prepareds": { | |
| "avgElapsedTime": "130.843614ms", | |
| "avgServiceTime": "130.748243ms", | |
| "encoded_plan": "H4sIAAAAAAAA/9xWXW8aORf+K9Z5ezEjGQQhbZKR3guSTHZZJQQxdLsrFoEzPiFujWdieyhZxP72lT18lGSJ0iZV1N4gGz/n4zk+fubMAVWaceTDXDIFEQCFa2S20HiSKaszaSCq71EQiuOsmYvfURuRKYj2KSg2QYiAHTUOD/f3jyqH/Oig8pYdHFbY1cFBJb1iadqoNdI95FCiTc5SZ8LxmhXSAoUsR81spiGaw/82G2gW9ibT4m8ECrkWUyFxjMahzoWxEPXn0GN6jHbjLeLMsspVkX5CW6kDhY4WU4gO3CLLDUS1xWBB4Z/0Rkh+P16CtwWq1IUrARqVj/J9QC1XziRlqgEU0myK2kDUL1ck6AejLB9VR65ko5ASiczYIAiCCVoWjLZ4jsLqaMas1cathuZOpW5hllk482Dpbsrk8mgUhpSI64kwRqhxcA+gcerMVCHlYzCOcg0bhCse5Ovy9LG+1XhD8ls9XEs2NtvmO4wFd7ABhWshLbo7DFYW/QH5q6jVGun/SXb1EVM7zJnQ5usySW+YUihdMmFImOJk5f5FfC4zJPNF6NmWLIar1pvD9yMDkdUFbgr84nzuBRBmyLRmdy8TaOV+sdRAiMCMhyvAcOaExh8MBYcI9t/Vj2r+B9/t8xquTzPNXdf05/AJ7/KslCPqNmtRvCdfUkyEk7e3tVptp36anCnj3eKMpXZVCs3UGP3fN2J8AxH03yxTbrMJUvIGFU/wduDTS2VRanqDgsw+/wfaWKatxy8GLuvC6QFEMDYCFnRb2jpMMylRAoUJm612wkwgqj9Lfc/Kh+fuWXFhfcbrR/gjSia5QvsZUZGd5fY6sOPqwgeVbylhBZMdnbm+BwoaTSHt0KKelD3CjGtfvAUKOMv1D16/fn1ZBE9Ld3H6k/Da2+J16t/Sz8CrscXry+t6xuiwdui/5c9zuR4H1k4Ff+jx0QnBCeTCDZrbb/Pci/naldf0h6jEamQTd7CgcFugvnNTOM5sOZkbMVZ+Nnf6WdKN4KPJlJNxvln7ltns3MPY7L7cOClYbhYUloE63bjT7MYkic/jkx7pZ3lVeeU5j5tJbwf7sphVX8nqqrMoyfLqlEn3R0hbZxetJGm1fwmW/2qc0rKDHhxxlOXRoF8fkGZCDN7SV09lz6fi6vn6uTTKXE5RUvKE2BqnHu9SfwLcN5cz8AtKLuJe86GJ4A4iODnrXl6Qe8fkfRKTVvs0/oME2xNTSN6323HSI5fHv8UnvWGn2eomTyngykfowmY5+fBr3I1J8MpXQchx3PsQx23yyIe82T7d+SEnl93TuEuO/3ztpiLnrYtWj5Ti9G8AAAD//+mc8o4bEAAA", | |
| "featuresControl": 12, | |
| "indexApiVersion": 4, | |
| "lastUse": "2020-09-14 05:01:09.320133688 -0700 PDT m=+19587.193352640", | |
| "maxElapsedTime": "158.783903ms", | |
| "maxServiceTime": "158.690687ms", | |
| "minElapsedTime": "2.126795ms", | |
| "minServiceTime": "2.080384ms", | |
| "name": "a9388449-8d97-5a78-ab77-cbacc303c2ed", | |
| "namespace": "default", | |
| "node": "172.23.106.102:8091", | |
| "statement": "PREPARE SELECT [op.name, LEAST(meta(`data-bucket-1`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][1] AS seq, [op.name, LEAST(meta(`data-bucket-1`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][2] AS rRev, [op.name, LEAST(meta(`data-bucket-1`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)][3] AS rDel, meta(`data-bucket-1`).xattrs._sync.rev AS rev, meta(`data-bucket-1`).xattrs._sync.flags AS flags, META(`data-bucket-1`).id AS id FROM `data-bucket-1` USE INDEX (sg_channels_x1) UNNEST OBJECT_PAIRS(meta(`data-bucket-1`).xattrs._sync.channels) AS op WHERE ([op.name, LEAST(meta(`data-bucket-1`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)] BETWEEN [$channelName, $startSeq] AND [$channelName, $endSeq]) ORDER BY [op.name, LEAST(meta(`data-bucket-1`).xattrs._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null),IFMISSING(op.val.del,null)] LIMIT 5000", | |
| "uses": 11 | |
| } | |
| } | |
| ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment