Skip to content

Instantly share code, notes, and snippets.

@pscollins
Created June 1, 2015 23:11
Show Gist options
  • Save pscollins/950d423f14094a7f460e to your computer and use it in GitHub Desktop.
Save pscollins/950d423f14094a7f460e to your computer and use it in GitHub Desktop.
➜ p3 git:(master) ✗ ./chidb 1table-1index-1pageeach.cdb
chidb> explain select code from numbers where altcode > 5;
addr opcode p1 p2 p3 p4
---------- ---------- ---------- ---------- ---------- ----------
0 Integer 2 0 0
1 OpenRead 0 0 3
2 Integer 5 1 0
3 Integer 3 2 0
4 OpenRead 1 2 2
5 SeekGt 1 11 1
6 IdxPKey 1 3 0
7 Seek 0 0 3
8 Key 0 4 0
9 ResultRow 4 1 32585
10 Next 1 6 0
11 Close 1 0 0
12 Close 0 0 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment