Skip to content

Instantly share code, notes, and snippets.

@tunix
Created March 24, 2017 15:17
Show Gist options
  • Save tunix/bbf1ae152e26492c978b5997a08a105d to your computer and use it in GitHub Desktop.
Save tunix/bbf1ae152e26492c978b5997a08a105d to your computer and use it in GitHub Desktop.
couchbase explain output
[
{
"plan": {
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan",
"covers": [
"cover ((`fooboo`.`appId`))",
"cover ((`fooboo`.`xid`))",
"cover ((`fooboo`.`yid`))",
"cover ((`fooboo`.`createdAt`))",
"cover ((meta(`fooboo`).`id`))"
],
"filter_covers": {
"cover ((`fooboo`.`_class`))": "com.foo.bar"
},
"index": "pid_appId_xid_yid_createdAt_idx",
"index_id": "9bca8d04ec6dbd2e",
"keyspace": "fooboo",
"namespace": "default",
"spans": [
{
"Range": {
"High": [
"\"app1\"",
"successor(\"03cad07a-3f55-4c72-bd83-c4caeda3db2a\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"03cad07a-3f55-4c72-bd83-c4caeda3db2a\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"05453355-8e57-4e35-a194-539e4eff29cb\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"05453355-8e57-4e35-a194-539e4eff29cb\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"0c442a20-5a3b-4ec8-a327-e251dffe7c5e\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"0c442a20-5a3b-4ec8-a327-e251dffe7c5e\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"1511a545-c7a8-4032-9134-d0fb32b58e31\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"1511a545-c7a8-4032-9134-d0fb32b58e31\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"1cde85a0-8055-4846-89b6-909eae43e9a9\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"1cde85a0-8055-4846-89b6-909eae43e9a9\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"1e06ad8d-d83c-4bab-acf4-a55af326d71f\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"1e06ad8d-d83c-4bab-acf4-a55af326d71f\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"2075c5bb-e4ec-442f-8269-c19e10b4852d\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"2075c5bb-e4ec-442f-8269-c19e10b4852d\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"27055919-8be9-4c82-8ac0-79a5cbfc0c2e\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"27055919-8be9-4c82-8ac0-79a5cbfc0c2e\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"28630ea9-c52e-4b76-a14f-37b79fb9a3b7\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"28630ea9-c52e-4b76-a14f-37b79fb9a3b7\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"2be93b20-4f0b-4bac-958f-7021f56679ee\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"2be93b20-4f0b-4bac-958f-7021f56679ee\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"2ca8819f-a6f5-4d17-9376-f204fb635399\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"2ca8819f-a6f5-4d17-9376-f204fb635399\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"316f7fb0-84f5-447b-9b41-292ec1064c69\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"316f7fb0-84f5-447b-9b41-292ec1064c69\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"353711cb-ba51-4bb8-ba05-b2b12b4f50d3\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"353711cb-ba51-4bb8-ba05-b2b12b4f50d3\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"35b94d23-e13e-4948-98bf-ffb69dc26f11\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"35b94d23-e13e-4948-98bf-ffb69dc26f11\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"35e08328-3a19-4333-9986-1689e76f8957\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"35e08328-3a19-4333-9986-1689e76f8957\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"36438f76-673d-4a6a-b0a3-3bdfeee4d5b8\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"36438f76-673d-4a6a-b0a3-3bdfeee4d5b8\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"373eabe2-545a-49cb-a4f3-88cfa0bb7a47\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"373eabe2-545a-49cb-a4f3-88cfa0bb7a47\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"3a592709-55e7-4726-b0d0-9b29659c0cdd\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"3a592709-55e7-4726-b0d0-9b29659c0cdd\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"3caac994-1459-47b8-a13b-87d454ddd01f\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"3caac994-1459-47b8-a13b-87d454ddd01f\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"442b6ae0-90af-4a75-854b-70936a7dde84\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"442b6ae0-90af-4a75-854b-70936a7dde84\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"453fc273-5ec1-47ed-8c17-46b4887adc22\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"453fc273-5ec1-47ed-8c17-46b4887adc22\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"46acee67-86aa-40c6-bad9-7ff2b080b364\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"46acee67-86aa-40c6-bad9-7ff2b080b364\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"4b0c8833-efd6-4e97-bdf6-a60cb26f8115\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"4b0c8833-efd6-4e97-bdf6-a60cb26f8115\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"4c1ce91e-9c8b-4a34-8b7c-17f4bee6e00a\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"4c1ce91e-9c8b-4a34-8b7c-17f4bee6e00a\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"4f937e41-dd53-49e6-b143-3bf0d07112ad\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"4f937e41-dd53-49e6-b143-3bf0d07112ad\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"505c544b-067d-4d50-b167-0d848934eea6\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"505c544b-067d-4d50-b167-0d848934eea6\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"52441caa-4990-4d57-a218-8b93ddfe34d6\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"52441caa-4990-4d57-a218-8b93ddfe34d6\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"52784ccb-d6b4-4281-956c-956fd3e3257d\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"52784ccb-d6b4-4281-956c-956fd3e3257d\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"5314f8bf-4d7a-4c47-b7fb-46753d8e26f4\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"5314f8bf-4d7a-4c47-b7fb-46753d8e26f4\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"5b167ac4-89ba-43b0-bcaf-ffd6cc7cfb0c\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"5b167ac4-89ba-43b0-bcaf-ffd6cc7cfb0c\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"5ff4d13f-3e6a-4c25-92c4-81e37ea65842\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"5ff4d13f-3e6a-4c25-92c4-81e37ea65842\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"614ff5fc-1836-4171-a959-fcf913ea8777\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"614ff5fc-1836-4171-a959-fcf913ea8777\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"63eb1175-695c-4803-8aa9-4972460ab906\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"63eb1175-695c-4803-8aa9-4972460ab906\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"6665a867-528d-4c15-afea-78c5c5049602\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"6665a867-528d-4c15-afea-78c5c5049602\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"671b20a5-a3fd-44f4-910d-64182f3895d2\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"671b20a5-a3fd-44f4-910d-64182f3895d2\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"6793f874-39bd-4fa3-9624-f8b5f95b71e4\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"6793f874-39bd-4fa3-9624-f8b5f95b71e4\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"6ac13b13-9801-4904-a63e-c67236332535\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"6ac13b13-9801-4904-a63e-c67236332535\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"6bde897c-d19f-4c4a-a7b1-5c20be1bedfa\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"6bde897c-d19f-4c4a-a7b1-5c20be1bedfa\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"6be5b9ed-4598-4913-bcef-d4c06ba4a139\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"6be5b9ed-4598-4913-bcef-d4c06ba4a139\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"6e336e35-9789-404a-bc11-6e4f507bf7d7\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"6e336e35-9789-404a-bc11-6e4f507bf7d7\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"6e73f171-cbbb-43e1-a8d6-f9da5c8e8000\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"6e73f171-cbbb-43e1-a8d6-f9da5c8e8000\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"6f1e030d-a3f2-47dc-b63e-cc041a765e67\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"6f1e030d-a3f2-47dc-b63e-cc041a765e67\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"74d8b24e-29c0-4c19-9fed-7087c996f4ab\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"74d8b24e-29c0-4c19-9fed-7087c996f4ab\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"785b8cc2-4746-465a-9514-7557dc216e0a\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"785b8cc2-4746-465a-9514-7557dc216e0a\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"790d1adb-6f0f-4089-9cde-0387c4c69151\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"790d1adb-6f0f-4089-9cde-0387c4c69151\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"824ad3bc-ed90-4058-b1fb-121dfe127dcf\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"824ad3bc-ed90-4058-b1fb-121dfe127dcf\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"8a50122c-e79f-4232-bc11-345266704bd6\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"8a50122c-e79f-4232-bc11-345266704bd6\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"8f8f3fea-9444-46ea-b443-9fb62631a785\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"8f8f3fea-9444-46ea-b443-9fb62631a785\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"8f925844-6c93-428b-b199-df72c776f397\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"8f925844-6c93-428b-b199-df72c776f397\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"900d58b3-ca31-4cb8-8afe-183df986a49a\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"900d58b3-ca31-4cb8-8afe-183df986a49a\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"99cc04f0-a6b8-4cb9-8ec4-564d67cc07b8\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"99cc04f0-a6b8-4cb9-8ec4-564d67cc07b8\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"9a90315f-32ab-49e0-a68b-22751fc698e5\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"9a90315f-32ab-49e0-a68b-22751fc698e5\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"9cfa0dc9-bcbc-4bc3-9325-f71abc09046d\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"9cfa0dc9-bcbc-4bc3-9325-f71abc09046d\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"a0b0d8f8-7027-44e1-95a2-e3e3cc06e851\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"a0b0d8f8-7027-44e1-95a2-e3e3cc06e851\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"a23388f2-188c-4aa6-996e-77149492a1d6\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"a23388f2-188c-4aa6-996e-77149492a1d6\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"a3f183fb-4581-4c63-ab62-389c02804b53\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"a3f183fb-4581-4c63-ab62-389c02804b53\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"a4aaa116-5c10-49eb-8801-7fb0b5e98955\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"a4aaa116-5c10-49eb-8801-7fb0b5e98955\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"a5ee42ea-f517-416c-87e6-b28709f767fc\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"a5ee42ea-f517-416c-87e6-b28709f767fc\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"a84984c5-1b42-489e-ab8c-08e2332e3e00\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"a84984c5-1b42-489e-ab8c-08e2332e3e00\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"a9cb8744-30f5-4449-8104-0b5410ab2b5b\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"a9cb8744-30f5-4449-8104-0b5410ab2b5b\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"a9f519e3-1573-4f36-af14-3e0a7b132ebb\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"a9f519e3-1573-4f36-af14-3e0a7b132ebb\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"aa344a8c-51cc-450b-b7f5-ded14c45867e\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"aa344a8c-51cc-450b-b7f5-ded14c45867e\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"ad410706-fb3f-44fe-b33c-3a3f059c801f\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"ad410706-fb3f-44fe-b33c-3a3f059c801f\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"ad906562-3ce4-464a-b885-0ecb1dc1a484\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"ad906562-3ce4-464a-b885-0ecb1dc1a484\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"ae536edb-4543-4dd5-8933-7223e1d95417\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"ae536edb-4543-4dd5-8933-7223e1d95417\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"aedfae22-48b2-4ca0-bf80-3d6c7beb4ccc\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"aedfae22-48b2-4ca0-bf80-3d6c7beb4ccc\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"b16d8545-1943-452c-aa74-ed57687036ff\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"b16d8545-1943-452c-aa74-ed57687036ff\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"b3bb7695-555f-4b6a-a622-2fd84c92401b\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"b3bb7695-555f-4b6a-a622-2fd84c92401b\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"b56ad96a-873c-4df9-aa70-afd3fbf0c118\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"b56ad96a-873c-4df9-aa70-afd3fbf0c118\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"b5b8b85f-6257-40f4-8b51-bdafc1570eeb\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"b5b8b85f-6257-40f4-8b51-bdafc1570eeb\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"b8092bb0-33e0-42bc-acac-f5855ee08b29\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"b8092bb0-33e0-42bc-acac-f5855ee08b29\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"b9df5727-e246-4197-ad73-e6748b8acc2b\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"b9df5727-e246-4197-ad73-e6748b8acc2b\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"be966d49-a323-46be-9c1e-1a182bbd9be7\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"be966d49-a323-46be-9c1e-1a182bbd9be7\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"beae20e8-4aac-4b1e-9520-e15e619c9b97\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"beae20e8-4aac-4b1e-9520-e15e619c9b97\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"c0b16e53-c8e6-4261-952b-f972c319b58e\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"c0b16e53-c8e6-4261-952b-f972c319b58e\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"c1db22db-f39f-42a2-8990-8a78e1308e77\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"c1db22db-f39f-42a2-8990-8a78e1308e77\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"c34a0ead-fb3b-4e18-af3c-ce6391923d23\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"c34a0ead-fb3b-4e18-af3c-ce6391923d23\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"c94b9c7e-d03b-4b54-8dbf-508e327187e3\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"c94b9c7e-d03b-4b54-8dbf-508e327187e3\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"caf6a079-eb93-4035-99f8-f212327d901e\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"caf6a079-eb93-4035-99f8-f212327d901e\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"cfddfe1f-e5c0-436f-ab96-969a29d4e41d\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"cfddfe1f-e5c0-436f-ab96-969a29d4e41d\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"d38f5081-eafd-48ba-8563-a65a135c2a2b\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"d38f5081-eafd-48ba-8563-a65a135c2a2b\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"d3af6999-dd04-41af-a4b7-8d74dd83dfbd\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"d3af6999-dd04-41af-a4b7-8d74dd83dfbd\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"d6556f65-2b41-4f50-83c6-ad32f06ee970\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"d6556f65-2b41-4f50-83c6-ad32f06ee970\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"d7b141d7-3480-40bc-822a-4f1433c48a26\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"d7b141d7-3480-40bc-822a-4f1433c48a26\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"d84a8840-2810-4d56-85b8-917e78c97385\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"d84a8840-2810-4d56-85b8-917e78c97385\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"d9e5bd21-4df0-440d-b873-f95e42a080c6\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"d9e5bd21-4df0-440d-b873-f95e42a080c6\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"da2327c6-bce7-405a-b783-80d43083b06a\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"da2327c6-bce7-405a-b783-80d43083b06a\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"defcf542-91ef-4e93-895c-ceaba36f09d0\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"defcf542-91ef-4e93-895c-ceaba36f09d0\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"dfac2a5d-338b-45a9-b8a0-69cf002bc74c\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"dfac2a5d-338b-45a9-b8a0-69cf002bc74c\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"e2d63419-2d49-4c3b-a8c8-c0b2b4e27ba9\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"e2d63419-2d49-4c3b-a8c8-c0b2b4e27ba9\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"e3d814b9-13d3-4577-b653-9d46d500e401\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"e3d814b9-13d3-4577-b653-9d46d500e401\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"eb7f85b7-d270-41f4-93de-426ab6fb05da\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"eb7f85b7-d270-41f4-93de-426ab6fb05da\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"f3597ca3-e085-44c2-a4b1-085f3ec65fcb\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"f3597ca3-e085-44c2-a4b1-085f3ec65fcb\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"f42969de-8ff4-4a8b-b742-e0d5c0ae5acb\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"f42969de-8ff4-4a8b-b742-e0d5c0ae5acb\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"f5157c27-7b33-4ed5-9ebd-ee02230fe6c6\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"f5157c27-7b33-4ed5-9ebd-ee02230fe6c6\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"f5396da7-c5df-4abf-b5ac-b43ae99dac34\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"f5396da7-c5df-4abf-b5ac-b43ae99dac34\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"f6ca7672-8b02-4a8f-acfa-e73d297f8571\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"f6ca7672-8b02-4a8f-acfa-e73d297f8571\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"f8f01639-a5a6-489f-879a-e4c8e3546f5c\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"f8f01639-a5a6-489f-879a-e4c8e3546f5c\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"fba0a67e-aa20-4333-8404-4fb382f20c9c\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"fba0a67e-aa20-4333-8404-4fb382f20c9c\""
]
}
},
{
"Range": {
"High": [
"\"app1\"",
"successor(\"fe9be53a-68e6-4168-8a47-c7ae1d78f702\")"
],
"Inclusion": 1,
"Low": [
"\"app1\"",
"\"fe9be53a-68e6-4168-8a47-c7ae1d78f702\""
]
}
}
],
"using": "gsi"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "Filter",
"condition": "((((cover ((`fooboo`.`_class`)) = \"com.foo.bar\") and (cover ((`fooboo`.`appId`)) = \"app1\")) and (\"2017-02-22\" < millis_to_str(str_to_millis(cover ((`fooboo`.`createdAt`))), \"2006-01-02\"))) and (cover ((`fooboo`.`xid`)) in [\"fba0a67e-aa20-4333-8404-4fb382f20c9c\", \"beae20e8-4aac-4b1e-9520-e15e619c9b97\", \"5ff4d13f-3e6a-4c25-92c4-81e37ea65842\", \"ae536edb-4543-4dd5-8933-7223e1d95417\", \"6793f874-39bd-4fa3-9624-f8b5f95b71e4\", \"6bde897c-d19f-4c4a-a7b1-5c20be1bedfa\", \"3caac994-1459-47b8-a13b-87d454ddd01f\", \"b16d8545-1943-452c-aa74-ed57687036ff\", \"c1db22db-f39f-42a2-8990-8a78e1308e77\", \"63eb1175-695c-4803-8aa9-4972460ab906\", \"d6556f65-2b41-4f50-83c6-ad32f06ee970\", \"f8f01639-a5a6-489f-879a-e4c8e3546f5c\", \"0c442a20-5a3b-4ec8-a327-e251dffe7c5e\", \"6e336e35-9789-404a-bc11-6e4f507bf7d7\", \"6665a867-528d-4c15-afea-78c5c5049602\", \"505c544b-067d-4d50-b167-0d848934eea6\", \"9a90315f-32ab-49e0-a68b-22751fc698e5\", \"671b20a5-a3fd-44f4-910d-64182f3895d2\", \"b3bb7695-555f-4b6a-a622-2fd84c92401b\", \"52441caa-4990-4d57-a218-8b93ddfe34d6\", \"8f925844-6c93-428b-b199-df72c776f397\", \"6be5b9ed-4598-4913-bcef-d4c06ba4a139\", \"a0b0d8f8-7027-44e1-95a2-e3e3cc06e851\", \"9cfa0dc9-bcbc-4bc3-9325-f71abc09046d\", \"824ad3bc-ed90-4058-b1fb-121dfe127dcf\", \"3a592709-55e7-4726-b0d0-9b29659c0cdd\", \"6ac13b13-9801-4904-a63e-c67236332535\", \"27055919-8be9-4c82-8ac0-79a5cbfc0c2e\", \"05453355-8e57-4e35-a194-539e4eff29cb\", \"ad410706-fb3f-44fe-b33c-3a3f059c801f\", \"fe9be53a-68e6-4168-8a47-c7ae1d78f702\", \"36438f76-673d-4a6a-b0a3-3bdfeee4d5b8\", \"a23388f2-188c-4aa6-996e-77149492a1d6\", \"b5b8b85f-6257-40f4-8b51-bdafc1570eeb\", \"defcf542-91ef-4e93-895c-ceaba36f09d0\", \"c94b9c7e-d03b-4b54-8dbf-508e327187e3\", \"4b0c8833-efd6-4e97-bdf6-a60cb26f8115\", \"614ff5fc-1836-4171-a959-fcf913ea8777\", \"d9e5bd21-4df0-440d-b873-f95e42a080c6\", \"caf6a079-eb93-4035-99f8-f212327d901e\", \"5b167ac4-89ba-43b0-bcaf-ffd6cc7cfb0c\", \"03cad07a-3f55-4c72-bd83-c4caeda3db2a\", \"1e06ad8d-d83c-4bab-acf4-a55af326d71f\", \"2be93b20-4f0b-4bac-958f-7021f56679ee\", \"353711cb-ba51-4bb8-ba05-b2b12b4f50d3\", \"da2327c6-bce7-405a-b783-80d43083b06a\", \"373eabe2-545a-49cb-a4f3-88cfa0bb7a47\", \"d38f5081-eafd-48ba-8563-a65a135c2a2b\", \"5314f8bf-4d7a-4c47-b7fb-46753d8e26f4\", \"eb7f85b7-d270-41f4-93de-426ab6fb05da\", \"b8092bb0-33e0-42bc-acac-f5855ee08b29\", \"900d58b3-ca31-4cb8-8afe-183df986a49a\", \"790d1adb-6f0f-4089-9cde-0387c4c69151\", \"f3597ca3-e085-44c2-a4b1-085f3ec65fcb\", \"99cc04f0-a6b8-4cb9-8ec4-564d67cc07b8\", \"28630ea9-c52e-4b76-a14f-37b79fb9a3b7\", \"a4aaa116-5c10-49eb-8801-7fb0b5e98955\", \"74d8b24e-29c0-4c19-9fed-7087c996f4ab\", \"4c1ce91e-9c8b-4a34-8b7c-17f4bee6e00a\", \"aa344a8c-51cc-450b-b7f5-ded14c45867e\", \"8f8f3fea-9444-46ea-b443-9fb62631a785\", \"d84a8840-2810-4d56-85b8-917e78c97385\", \"b56ad96a-873c-4df9-aa70-afd3fbf0c118\", \"35b94d23-e13e-4948-98bf-ffb69dc26f11\", \"dfac2a5d-338b-45a9-b8a0-69cf002bc74c\", \"785b8cc2-4746-465a-9514-7557dc216e0a\", \"2075c5bb-e4ec-442f-8269-c19e10b4852d\", \"e2d63419-2d49-4c3b-a8c8-c0b2b4e27ba9\", \"52784ccb-d6b4-4281-956c-956fd3e3257d\", \"1cde85a0-8055-4846-89b6-909eae43e9a9\", \"be966d49-a323-46be-9c1e-1a182bbd9be7\", \"cfddfe1f-e5c0-436f-ab96-969a29d4e41d\", \"35e08328-3a19-4333-9986-1689e76f8957\", \"2ca8819f-a6f5-4d17-9376-f204fb635399\", \"4f937e41-dd53-49e6-b143-3bf0d07112ad\", \"c0b16e53-c8e6-4261-952b-f972c319b58e\", \"d3af6999-dd04-41af-a4b7-8d74dd83dfbd\", \"442b6ae0-90af-4a75-854b-70936a7dde84\", \"f42969de-8ff4-4a8b-b742-e0d5c0ae5acb\", \"e3d814b9-13d3-4577-b653-9d46d500e401\", \"6e73f171-cbbb-43e1-a8d6-f9da5c8e8000\", \"f6ca7672-8b02-4a8f-acfa-e73d297f8571\", \"a3f183fb-4581-4c63-ab62-389c02804b53\", \"1511a545-c7a8-4032-9134-d0fb32b58e31\", \"aedfae22-48b2-4ca0-bf80-3d6c7beb4ccc\", \"f5396da7-c5df-4abf-b5ac-b43ae99dac34\", \"c34a0ead-fb3b-4e18-af3c-ce6391923d23\", \"316f7fb0-84f5-447b-9b41-292ec1064c69\", \"a9f519e3-1573-4f36-af14-3e0a7b132ebb\", \"a84984c5-1b42-489e-ab8c-08e2332e3e00\", \"a5ee42ea-f517-416c-87e6-b28709f767fc\", \"8a50122c-e79f-4232-bc11-345266704bd6\", \"453fc273-5ec1-47ed-8c17-46b4887adc22\", \"f5157c27-7b33-4ed5-9ebd-ee02230fe6c6\", \"46acee67-86aa-40c6-bad9-7ff2b080b364\", \"6f1e030d-a3f2-47dc-b63e-cc041a765e67\", \"b9df5727-e246-4197-ad73-e6748b8acc2b\", \"ad906562-3ce4-464a-b885-0ecb1dc1a484\", \"a9cb8744-30f5-4449-8104-0b5410ab2b5b\", \"d7b141d7-3480-40bc-822a-4f1433c48a26\"]))"
},
{
"#operator": "InitialGroup",
"aggregates": [
"count(distinct cover ((`fooboo`.`yid`)))"
],
"group_keys": [
"cover ((`fooboo`.`xid`))"
]
}
]
}
},
{
"#operator": "IntermediateGroup",
"aggregates": [
"count(distinct cover ((`fooboo`.`yid`)))"
],
"group_keys": [
"cover ((`fooboo`.`xid`))"
]
},
{
"#operator": "FinalGroup",
"aggregates": [
"count(distinct cover ((`fooboo`.`yid`)))"
],
"group_keys": [
"cover ((`fooboo`.`xid`))"
]
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "InitialProject",
"result_terms": [
{
"expr": "cover ((`fooboo`.`xid`))"
},
{
"as": "count",
"expr": "count(distinct cover ((`fooboo`.`yid`)))"
}
]
},
{
"#operator": "FinalProject"
}
]
}
}
]
},
"text": "\nSELECT xid, COUNT(DISTINCT yid) AS count\nFROM fooboo\nWHERE _class = \"com.foo.bar\"\n AND appId = \"app1\"\n AND MILLIS_TO_STR(MILLIS(createdAt), \"2006-01-02\") > \"2017-02-22\"\n AND xid IN [\"fba0a67e-aa20-4333-8404-4fb382f20c9c\",\"beae20e8-4aac-4b1e-9520-e15e619c9b97\",\"5ff4d13f-3e6a-4c25-92c4-81e37ea65842\",\"ae536edb-4543-4dd5-8933-7223e1d95417\",\"6793f874-39bd-4fa3-9624-f8b5f95b71e4\",\"6bde897c-d19f-4c4a-a7b1-5c20be1bedfa\",\"3caac994-1459-47b8-a13b-87d454ddd01f\",\"b16d8545-1943-452c-aa74-ed57687036ff\",\"c1db22db-f39f-42a2-8990-8a78e1308e77\",\"63eb1175-695c-4803-8aa9-4972460ab906\",\"d6556f65-2b41-4f50-83c6-ad32f06ee970\",\"f8f01639-a5a6-489f-879a-e4c8e3546f5c\",\"0c442a20-5a3b-4ec8-a327-e251dffe7c5e\",\"6e336e35-9789-404a-bc11-6e4f507bf7d7\",\"6665a867-528d-4c15-afea-78c5c5049602\",\"505c544b-067d-4d50-b167-0d848934eea6\",\"9a90315f-32ab-49e0-a68b-22751fc698e5\",\"671b20a5-a3fd-44f4-910d-64182f3895d2\",\"b3bb7695-555f-4b6a-a622-2fd84c92401b\",\"52441caa-4990-4d57-a218-8b93ddfe34d6\",\"8f925844-6c93-428b-b199-df72c776f397\",\"6be5b9ed-4598-4913-bcef-d4c06ba4a139\",\"a0b0d8f8-7027-44e1-95a2-e3e3cc06e851\",\"9cfa0dc9-bcbc-4bc3-9325-f71abc09046d\",\"824ad3bc-ed90-4058-b1fb-121dfe127dcf\",\"3a592709-55e7-4726-b0d0-9b29659c0cdd\",\"6ac13b13-9801-4904-a63e-c67236332535\",\"27055919-8be9-4c82-8ac0-79a5cbfc0c2e\",\"05453355-8e57-4e35-a194-539e4eff29cb\",\"ad410706-fb3f-44fe-b33c-3a3f059c801f\",\"fe9be53a-68e6-4168-8a47-c7ae1d78f702\",\"36438f76-673d-4a6a-b0a3-3bdfeee4d5b8\",\"a23388f2-188c-4aa6-996e-77149492a1d6\",\"b5b8b85f-6257-40f4-8b51-bdafc1570eeb\",\"defcf542-91ef-4e93-895c-ceaba36f09d0\",\"c94b9c7e-d03b-4b54-8dbf-508e327187e3\",\"4b0c8833-efd6-4e97-bdf6-a60cb26f8115\",\"614ff5fc-1836-4171-a959-fcf913ea8777\",\"d9e5bd21-4df0-440d-b873-f95e42a080c6\",\"caf6a079-eb93-4035-99f8-f212327d901e\",\"5b167ac4-89ba-43b0-bcaf-ffd6cc7cfb0c\",\"03cad07a-3f55-4c72-bd83-c4caeda3db2a\",\"1e06ad8d-d83c-4bab-acf4-a55af326d71f\",\"2be93b20-4f0b-4bac-958f-7021f56679ee\",\"353711cb-ba51-4bb8-ba05-b2b12b4f50d3\",\"da2327c6-bce7-405a-b783-80d43083b06a\",\"373eabe2-545a-49cb-a4f3-88cfa0bb7a47\",\"d38f5081-eafd-48ba-8563-a65a135c2a2b\",\"5314f8bf-4d7a-4c47-b7fb-46753d8e26f4\",\"eb7f85b7-d270-41f4-93de-426ab6fb05da\",\"b8092bb0-33e0-42bc-acac-f5855ee08b29\",\"900d58b3-ca31-4cb8-8afe-183df986a49a\",\"790d1adb-6f0f-4089-9cde-0387c4c69151\",\"f3597ca3-e085-44c2-a4b1-085f3ec65fcb\",\"99cc04f0-a6b8-4cb9-8ec4-564d67cc07b8\",\"28630ea9-c52e-4b76-a14f-37b79fb9a3b7\",\"a4aaa116-5c10-49eb-8801-7fb0b5e98955\",\"74d8b24e-29c0-4c19-9fed-7087c996f4ab\",\"4c1ce91e-9c8b-4a34-8b7c-17f4bee6e00a\",\"aa344a8c-51cc-450b-b7f5-ded14c45867e\",\"8f8f3fea-9444-46ea-b443-9fb62631a785\",\"d84a8840-2810-4d56-85b8-917e78c97385\",\"b56ad96a-873c-4df9-aa70-afd3fbf0c118\",\"35b94d23-e13e-4948-98bf-ffb69dc26f11\",\"dfac2a5d-338b-45a9-b8a0-69cf002bc74c\",\"785b8cc2-4746-465a-9514-7557dc216e0a\",\"2075c5bb-e4ec-442f-8269-c19e10b4852d\",\"e2d63419-2d49-4c3b-a8c8-c0b2b4e27ba9\",\"52784ccb-d6b4-4281-956c-956fd3e3257d\",\"1cde85a0-8055-4846-89b6-909eae43e9a9\",\"be966d49-a323-46be-9c1e-1a182bbd9be7\",\"cfddfe1f-e5c0-436f-ab96-969a29d4e41d\",\"35e08328-3a19-4333-9986-1689e76f8957\",\"2ca8819f-a6f5-4d17-9376-f204fb635399\",\"4f937e41-dd53-49e6-b143-3bf0d07112ad\",\"c0b16e53-c8e6-4261-952b-f972c319b58e\",\"d3af6999-dd04-41af-a4b7-8d74dd83dfbd\",\"442b6ae0-90af-4a75-854b-70936a7dde84\",\"f42969de-8ff4-4a8b-b742-e0d5c0ae5acb\",\"e3d814b9-13d3-4577-b653-9d46d500e401\",\"6e73f171-cbbb-43e1-a8d6-f9da5c8e8000\",\"f6ca7672-8b02-4a8f-acfa-e73d297f8571\",\"a3f183fb-4581-4c63-ab62-389c02804b53\",\"1511a545-c7a8-4032-9134-d0fb32b58e31\",\"aedfae22-48b2-4ca0-bf80-3d6c7beb4ccc\",\"f5396da7-c5df-4abf-b5ac-b43ae99dac34\",\"c34a0ead-fb3b-4e18-af3c-ce6391923d23\",\"316f7fb0-84f5-447b-9b41-292ec1064c69\",\"a9f519e3-1573-4f36-af14-3e0a7b132ebb\",\"a84984c5-1b42-489e-ab8c-08e2332e3e00\",\"a5ee42ea-f517-416c-87e6-b28709f767fc\",\"8a50122c-e79f-4232-bc11-345266704bd6\",\"453fc273-5ec1-47ed-8c17-46b4887adc22\",\"f5157c27-7b33-4ed5-9ebd-ee02230fe6c6\",\"46acee67-86aa-40c6-bad9-7ff2b080b364\",\"6f1e030d-a3f2-47dc-b63e-cc041a765e67\",\"b9df5727-e246-4197-ad73-e6748b8acc2b\",\"ad906562-3ce4-464a-b885-0ecb1dc1a484\",\"a9cb8744-30f5-4449-8104-0b5410ab2b5b\",\"d7b141d7-3480-40bc-822a-4f1433c48a26\"]\nGROUP BY xid"
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment