Skip to content

Instantly share code, notes, and snippets.

@pavel-paulau

pavel-paulau/gist:b222716934dfa3cb598e Secret

Created May 5, 2014 21:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pavel-paulau/b222716934dfa3cb598e to your computer and use it in GitHub Desktop.
Save pavel-paulau/b222716934dfa3cb598e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
14:48:04.718364 Enabling logging: [HTTP NETWORK PIPELINE CATALOG PLANNER SCAN OPTIMIZER PARSER]
14:48:04.718459 Developer Mode Enabled (default developer logging)
14:48:04.718465 Info line disabled false
14:48:04.718558 CATALOG: Created New Site http://127.0.0.1:8091
14:48:04.720906 tuqtng started...
14:48:04.720922 version: 0.0.0
14:48:04.720927 site: http://127.0.0.1:8091
14:48:05.942663 HTTP: request received
14:48:05.942734 HTTP: query string: SELECT name.f.f.f AS _name FROM bucket-1 WHERE coins.f > 224.210000 AND coins.f < 448.420000 LIMIT 20
14:48:05.942993 PARSER: SELECT_SELECT_HEAD
14:48:05.943145 PARSER: IDENTIFIER - name
14:48:05.943166 PARSER: SUFFIX_EXPR
14:48:05.943211 PARSER: EXPR DOT MEMBER
14:48:05.943274 PARSER: EXPR DOT MEMBER
14:48:05.943325 PARSER: EXPR DOT MEMBER
14:48:05.943384 PARSER: EXPRESSION
14:48:05.943453 PARSER: RESULT EXPR AS ID
14:48:05.943522 PARSER: SELECT SELECT TAIL - EXPR
14:48:05.943534 PARSER: SELECT_SELECT
14:48:05.943625 PARSER: PATH - bucket-1
14:48:05.943704 PARSER: FROM DATASOURCE
14:48:05.943718 PARSER: FROM DATASOURCE WITHOUT UNNEST
14:48:05.943730 PARSER: SELECT FROM - DATASOURCE
14:48:05.943812 PARSER: IDENTIFIER - coins
14:48:05.943828 PARSER: SUFFIX_EXPR
14:48:05.943859 PARSER: EXPR DOT MEMBER
14:48:05.944014 PARSER: NUMBER 224.210000
14:48:05.944032 PARSER: NUMBER
14:48:05.944054 PARSER: LITERAL
14:48:05.944065 PARSER: SUFFIX_EXPR
14:48:05.944125 PARSER: EXPR - GT
14:48:05.944212 PARSER: IDENTIFIER - coins
14:48:05.944226 PARSER: SUFFIX_EXPR
14:48:05.944257 PARSER: EXPR DOT MEMBER
14:48:05.944378 PARSER: NUMBER 448.420000
14:48:05.944392 PARSER: NUMBER
14:48:05.944403 PARSER: LITERAL
14:48:05.944413 PARSER: SUFFIX_EXPR
14:48:05.944480 PARSER: EXPR - LT
14:48:05.944500 PARSER: EXPR - AND
14:48:05.944518 PARSER: EXPRESSION
14:48:05.944529 PARSER: SELECT WHERE - EXPR
14:48:05.944547 PARSER: SELECT_CORE
14:48:05.944596 PARSER: LIMIT 20
14:48:05.944610 PARSER: SELECT_COMPOUND
14:48:05.944620 PARSER: SELECT_STMT
14:48:05.944632 PARSER: STMT - SELECT
14:48:05.944642 PARSER: INPUT
14:48:05.944990 CATALOG: Created New Pool default
14:48:05.959058 CATALOG: Created New Bucket bucket-1
14:48:05.981704 PLANNER: Indexes in bucket [name: #alldocs on: [META().id] using: view ddoc: { _all_docs } bucket: {0xc2001689a0 bucket-1 map[#alldocs:0xc200226000 by_achievement:0xc2002263c0 by_category:0xc200226460 by_coins:0xc200226500 by_year:0xc2002267d0] 0xc2001fa300} name: by_achievement on: [achievements] using: view ddoc: {ddl_by_achievement by_achievement
function (doc, meta) {
if (meta.type != "json") return;
var stringToUtf8Bytes = function (str) {
var utf8 = unescape(encodeURIComponent(str));
var bytes = [];
for (var i = 0; i < str.length; ++i) {
bytes.push(str.charCodeAt(i));
}
return bytes;
};
var indexFormattedValue = function (val) {
if (val === null) {
return [64];
} else if (typeof val == "boolean") {
return [96, val];
} else if (typeof val == "number") {
return [128, val];
} else if (typeof val == "string") {
return [160, stringToUtf8Bytes(val)];
} else if (typeof val == "object") {
if (val instanceof Array) {
return [192, val];
} else {
innerKeys = [];
for (var k in val) {
innerKeys.push(k);
}
innerKeys.sort()
innerVals = [];
for (var i in innerKeys) {
innerVals.push(indexFormattedValue(val[innerKeys[i]]));
}
return [224, [innerKeys, innerVals]];
}
} else {
return undefined;
}
};
var key1 = indexFormattedValue(doc.achievements);
var key = [key1];
var pos = key.indexOf(undefined);
if (pos == 0) {
return;
} else if (pos > 0) {
key.splice(pos)
}
emit(key, null);
}
// salt: 911902081
} bucket: {0xc2001689a0 bucket-1 map[#alldocs:0xc200226000 by_achievement:0xc2002263c0 by_category:0xc200226460 by_coins:0xc200226500 by_year:0xc2002267d0] 0xc2001fa300} name: by_category on: [category] using: view ddoc: {ddl_by_category by_category
function (doc, meta) {
if (meta.type != "json") return;
var stringToUtf8Bytes = function (str) {
var utf8 = unescape(encodeURIComponent(str));
var bytes = [];
for (var i = 0; i < str.length; ++i) {
bytes.push(str.charCodeAt(i));
}
return bytes;
};
var indexFormattedValue = function (val) {
if (val === null) {
return [64];
} else if (typeof val == "boolean") {
return [96, val];
} else if (typeof val == "number") {
return [128, val];
} else if (typeof val == "string") {
return [160, stringToUtf8Bytes(val)];
} else if (typeof val == "object") {
if (val instanceof Array) {
return [192, val];
} else {
innerKeys = [];
for (var k in val) {
innerKeys.push(k);
}
innerKeys.sort()
innerVals = [];
for (var i in innerKeys) {
innerVals.push(indexFormattedValue(val[innerKeys[i]]));
}
return [224, [innerKeys, innerVals]];
}
} else {
return undefined;
}
};
var key1 = indexFormattedValue(doc.category);
var key = [key1];
var pos = key.indexOf(undefined);
if (pos == 0) {
return;
} else if (pos > 0) {
key.splice(pos)
}
emit(key, null);
}
// salt: 208240456
} bucket: {0xc2001689a0 bucket-1 map[#alldocs:0xc200226000 by_achievement:0xc2002263c0 by_category:0xc200226460 by_coins:0xc200226500 by_year:0xc2002267d0] 0xc2001fa300} name: by_coins on: [coins.f] using: view ddoc: {ddl_by_coins by_coins
function (doc, meta) {
if (meta.type != "json") return;
var stringToUtf8Bytes = function (str) {
var utf8 = unescape(encodeURIComponent(str));
var bytes = [];
for (var i = 0; i < str.length; ++i) {
bytes.push(str.charCodeAt(i));
}
return bytes;
};
var indexFormattedValue = function (val) {
if (val === null) {
return [64];
} else if (typeof val == "boolean") {
return [96, val];
} else if (typeof val == "number") {
return [128, val];
} else if (typeof val == "string") {
return [160, stringToUtf8Bytes(val)];
} else if (typeof val == "object") {
if (val instanceof Array) {
return [192, val];
} else {
innerKeys = [];
for (var k in val) {
innerKeys.push(k);
}
innerKeys.sort()
innerVals = [];
for (var i in innerKeys) {
innerVals.push(indexFormattedValue(val[innerKeys[i]]));
}
return [224, [innerKeys, innerVals]];
}
} else {
return undefined;
}
};
var key1 = indexFormattedValue(doc.coins.f);
var key = [key1];
var pos = key.indexOf(undefined);
if (pos == 0) {
return;
} else if (pos > 0) {
key.splice(pos)
}
emit(key, null);
}
// salt: 1298498081
} bucket: {0xc2001689a0 bucket-1 map[#alldocs:0xc200226000 by_achievement:0xc2002263c0 by_category:0xc200226460 by_coins:0xc200226500 by_year:0xc2002267d0] 0xc2001fa300} name: by_year on: [year] using: view ddoc: {ddl_by_year by_year
function (doc, meta) {
if (meta.type != "json") return;
var stringToUtf8Bytes = function (str) {
var utf8 = unescape(encodeURIComponent(str));
var bytes = [];
for (var i = 0; i < str.length; ++i) {
bytes.push(str.charCodeAt(i));
}
return bytes;
};
var indexFormattedValue = function (val) {
if (val === null) {
return [64];
} else if (typeof val == "boolean") {
return [96, val];
} else if (typeof val == "number") {
return [128, val];
} else if (typeof val == "string") {
return [160, stringToUtf8Bytes(val)];
} else if (typeof val == "object") {
if (val instanceof Array) {
return [192, val];
} else {
innerKeys = [];
for (var k in val) {
innerKeys.push(k);
}
innerKeys.sort()
innerVals = [];
for (var i in innerKeys) {
innerVals.push(indexFormattedValue(val[innerKeys[i]]));
}
return [224, [innerKeys, innerVals]];
}
} else {
return undefined;
}
};
var key1 = indexFormattedValue(doc.year);
var key = [key1];
var pos = key.indexOf(undefined);
if (pos == 0) {
return;
} else if (pos > 0) {
key.splice(pos)
}
emit(key, null);
}
// salt: 683024728
} bucket: {0xc2001689a0 bucket-1 map[#alldocs:0xc200226000 by_achievement:0xc2002263c0 by_category:0xc200226460 by_coins:0xc200226500 by_year:0xc2002267d0] 0xc2001fa300} ]
14:48:05.981769 PLANNER: See primary index #alldocs
14:48:05.981795 PLANNER: See index by_achievement
14:48:05.981814 PLANNER: with Key [achievements]
14:48:05.981948 PLANNER: Can I use it1: false
14:48:05.981963 PLANNER: See index by_category
14:48:05.981980 PLANNER: with Key [category]
14:48:05.982084 PLANNER: Can I use it1: false
14:48:05.982100 PLANNER: See index by_coins
14:48:05.982120 PLANNER: with Key [coins.f]
14:48:05.982207 PLANNER: now ranges are: &plan.ScanRange{Low:catalog.LookupValue{(*dparval.Value)(0xc200252500)}, High:catalog.LookupValue(nil), Inclusion:2, Limit:0}
14:48:05.982263 PLANNER: now ranges are: &plan.ScanRange{Low:catalog.LookupValue{(*dparval.Value)(0xc200252500)}, High:catalog.LookupValue{(*dparval.Value)(0xc2002526c0)}, Inclusion:0, Limit:0}
14:48:05.982278 PLANNER: Can I use it1: true
14:48:05.982318 PLANNER: index deps are: [bucket-1.coins.f]
14:48:05.982343 PLANNER: See index by_year
14:48:05.982359 PLANNER: with Key [year]
14:48:05.982450 PLANNER: Can I use it1: false
14:48:05.982537 OPTIMIZER: See plan {0xc2001c0720}
14:48:05.982561 OPTIMIZER: See plan {0xc2001c07b0}
14:48:05.982581 OPTIMIZER: Choosing plan {0xc2001c07b0}
14:48:05.982639 PIPELINE: limit operator starting
14:48:05.982656 PIPELINE: project operator starting
14:48:05.982669 PIPELINE: filter operator starting
14:48:05.982681 PIPELINE: fetch operator starting
14:48:05.982692 PIPELINE: scan operator starting
14:48:05.982721 PIPELINE: scanning range &{[0xc200252500] [0xc2002526c0] 0 0}
14:48:05.982851 NETWORK: Request View: http://127.0.0.1:8092/bucket-1/_design/ddl_by_coins/_view/by_coins?endkey=%5B%5B128%2C448.42%5D%5D&endkey_docid=&limit=1001&startkey=%5B%5B128%2C224.21%5D%5D&startkey_docid=%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF%FF
14:48:06.022584 NETWORK: Request View: http://127.0.0.1:8092/bucket-1/_design/ddl_by_coins/_view/by_coins?endkey=%5B%5B128%2C448.42%5D%5D&endkey_docid=&limit=1001&startkey=%5B%5B128%2C288.48%5D%5D&startkey_docid=000000001468
14:48:06.094152 PIPELINE: limit operator finished
14:48:06.094259 PIPELINE: project operator finished
14:48:06.094354 HTTP: response complete
14:48:06.094383 PIPELINE: filter operator finished
14:48:06.099661 PIPELINE: fetch operator finished, fetched 1001
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment