dzhuryn
This file contains hidden or 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
| db.threads | |
| //.explain("executionStats") | |
| .aggregate([ | |
| { | |
| "$match": { | |
| "ci": { | |
| "$in": [ | |
| ObjectId("60fefc1f535ed8596d08c151"), | |
| ObjectId("6102e3c4535ed8596d3723da"), | |
| ObjectId("612163ca535ed8596dd57732"), |
dzhuryn
/ gist:aa1cdc8805501b79c011d13698ff3e2b
Created
May 23, 2023 19:16
This file contains hidden or 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
| db.threads.aggregate([ | |
| { | |
| "$match": { | |
| "ci": { | |
| "$in": [ObjectId("60fefc1f535ed8596d08c151"), ObjectId("6102e3c4535ed8596d3723da"), ObjectId("612163ca535ed8596dd57732"), ObjectId("61216d9a535ed8596dd5d3a0"), ObjectId("6121762d535ed8596dd61f13"), ObjectId("6121d19d535ed8596dd8c7e8"), ObjectId("6121f226535ed8596dd9b0da"), ObjectId("6121f282535ed8596dd9b386"), ObjectId("61227509535ed8596dde2d40"), ObjectId("61227a35535ed8596dde637d"), ObjectId("61227ed2535ed8596ddea2d1"), ObjectId("6122b672535ed8596d0bda85"), ObjectId("612385b8535ed8596d56e6a9"), ObjectId("6124099c535ed8596d5bd76a"), ObjectId("61311e2a535ed8596dc35295"), ObjectId("61312b78535ed8596dc4a781"), ObjectId("61312e75535ed8596dc4eb72"), ObjectId("61313c49535ed8596dc6c06b"), ObjectId("61313d82535ed8596dc6eb85"), ObjectId("6131420c535ed8596dc77e46"), ObjectId("6132851f535ed8596deabc01"), ObjectId("6133e0fe535ed8596d1800a1"), ObjectId("6133e4f6535ed8596d185541"), ObjectId("6133e5c8535ed8596d1867fa"), ObjectId("6133e948535ed8596d18bd9c"), O |
dzhuryn
/ gist:52b0c44e3789c52b31f92358661336f6
Last active
June 10, 2023 07:52
This file contains hidden or 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
| db.threads.aggregate([ | |
| { | |
| "$match": { | |
| "$text": { | |
| "$search": "modx" | |
| } | |
| } | |
| }, | |
| { | |
| "$facet":{ |
This file contains hidden or 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
| -- DROP function test2; | |
| CREATE OR REPLACE FUNCTION test2() RETURNS void AS $$ | |
| DECLARE | |
| siteId integer; | |
| attributeId int; | |
| enumId int; | |
| BEGIN | |
| FOR siteId IN select id from site LOOP |
OlderNewer