Skip to content

Instantly share code, notes, and snippets.

@pavel-paulau

pavel-paulau/gist:a7245ab7254c1b4fb53e Secret

Created May 16, 2014 17:07
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/a7245ab7254c1b4fb53e to your computer and use it in GitHub Desktop.
Save pavel-paulau/a7245ab7254c1b4fb53e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
10:03:16.771773 Enabling logging: [HTTP NETWORK PIPELINE CATALOG PLANNER SCAN OPTIMIZER PARSER]
10:03:16.771990 Developer Mode Enabled (default developer logging)
10:03:16.772000 Info line disabled false
10:03:16.772226 CATALOG: Created New Site http://127.0.0.1:8091
10:03:16.775158 tuqtng started...
10:03:16.775217 version: 0.0.0
10:03:16.775228 site: http://127.0.0.1:8091
10:03:19.263303 HTTP: request received
10:03:19.263435 HTTP: query string: SELECT DISTINCT year FROM bucket-1 LIMIT 20
10:03:19.263822 PARSER: SELECT_SELECT_HEAD
10:03:19.263926 PARSER: SELECT_SELECT_QUALIFIER DISTINCT
10:03:19.264068 PARSER: IDENTIFIER - year
10:03:19.264087 PARSER: SUFFIX_EXPR
10:03:19.264112 PARSER: EXPRESSION
10:03:19.264126 PARSER: RESULT EXPR
10:03:19.264146 PARSER: SELECT SELECT TAIL - EXPR
10:03:19.264158 PARSER: SELECT_SELECT
10:03:19.264258 PARSER: PATH - bucket-1
10:03:19.264348 PARSER: FROM DATASOURCE
10:03:19.264390 PARSER: FROM DATASOURCE WITHOUT UNNEST
10:03:19.264404 PARSER: SELECT FROM - DATASOURCE
10:03:19.264417 PARSER: SELECT WHERE - EMPTY
10:03:19.264434 PARSER: SELECT_CORE
10:03:19.264493 PARSER: LIMIT 20
10:03:19.264507 PARSER: SELECT_COMPOUND
10:03:19.264518 PARSER: SELECT_STMT
10:03:19.264528 PARSER: STMT - SELECT
10:03:19.264538 PARSER: INPUT
10:03:19.264747 CATALOG: Created New Pool default
10:03:19.279566 CATALOG: Created New Bucket bucket-1
10:03:19.300397 PLANNER: Indexes in bucket [name: #alldocs on: [META().id] using: view ddoc: { _all_docs } bucket: {0xc200242000 bucket-1 map[#alldocs:0xc20021fc80 by_full_state:0xc20021feb0 by_state:0xc200140b40 by_year:0xc20021f410] 0xc200241300} name: by_full_state on: [full_state.f] using: view ddoc: {ddl_by_full_state by_full_state
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.full_state.f);
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: {0xc200242000 bucket-1 map[#alldocs:0xc20021fc80 by_full_state:0xc20021feb0 by_state:0xc200140b40 by_year:0xc20021f410] 0xc200241300} name: by_state on: [state.f] using: view ddoc: {ddl_by_state by_state
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.state.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: {0xc200242000 bucket-1 map[#alldocs:0xc20021fc80 by_full_state:0xc20021feb0 by_state:0xc200140b40 by_year:0xc20021f410] 0xc200241300} 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: 911902081
} bucket: {0xc200242000 bucket-1 map[#alldocs:0xc20021fc80 by_full_state:0xc20021feb0 by_state:0xc200140b40 by_year:0xc20021f410] 0xc200241300} ]
10:03:19.300477 PLANNER: See primary index #alldocs
10:03:19.300506 PLANNER: See index by_full_state
10:03:19.300529 PLANNER: with Key [full_state.f]
10:03:19.300544 PLANNER: See index by_state
10:03:19.300561 PLANNER: with Key [state.f]
10:03:19.300572 PLANNER: See index by_year
10:03:19.300596 PLANNER: with Key [year]
10:03:19.300645 OPTIMIZER: See plan {0xc2002a9090}
10:03:19.300664 OPTIMIZER: Choosing plan {0xc2002a9090}
10:03:19.300763 PIPELINE: limit operator starting
10:03:19.300782 PIPELINE: eliminate duplicates operator starting
10:03:19.300803 PIPELINE: project operator starting
10:03:19.300825 PIPELINE: fetch operator starting
10:03:19.300838 PIPELINE: scan operator starting
10:03:19.300852 PIPELINE: scanning range <nil>
10:03:19.300998 NETWORK: Request View: http://127.0.0.1:8092/bucket-1/_all_docs?limit=1001
10:03:19.969863 NETWORK: Request View: http://127.0.0.1:8092/bucket-1/_all_docs?limit=1001&startkey=%22000000001001%22&startkey_docid=000000001001
10:03:20.617914 NETWORK: Request View: http://127.0.0.1:8092/bucket-1/_all_docs?limit=1001&startkey=%22000000002001%22&startkey_docid=000000002001
10:03:21.293120 NETWORK: Request View: http://127.0.0.1:8092/bucket-1/_all_docs?limit=1001&startkey=%22000000003001%22&startkey_docid=000000003001
10:03:21.976329 NETWORK: Request View: http://127.0.0.1:8092/bucket-1/_all_docs?limit=1001&startkey=%22000000004001%22&startkey_docid=000000004001
10:03:22.710272 NETWORK: Request View: http://127.0.0.1:8092/bucket-1/_all_docs?limit=1001&startkey=%22000000005001%22&startkey_docid=000000005001
10:03:23.366056 NETWORK: Request View: http://127.0.0.1:8092/bucket-1/_all_docs?limit=1001&startkey=%22000000006001%22&startkey_docid=000000006001
10:03:24.037542 NETWORK: Request View: http://127.0.0.1:8092/bucket-1/_all_docs?limit=1001&startkey=%22000000007001%22&startkey_docid=000000007001
10:03:24.732408 NETWORK: Request View: http://127.0.0.1:8092/bucket-1/_all_docs?limit=1001&startkey=%22000000008001%22&startkey_docid=000000008001
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment