Skip to content

Instantly share code, notes, and snippets.

@alonho
Created June 9, 2012 09:18
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 alonho/2900231 to your computer and use it in GitHub Desktop.
Save alonho/2900231 to your computer and use it in GitHub Desktop.
traces from sqlite
{Alons-MacBook-Pro-2:cpytrace} % sqlite3 -header -column ./db.sqlite "select traces.id, time, tid, type, depth, modules.value, funcs.name, types.value, arg_values.value, arg_names.value from traces join funcs on (traces.func_id=funcs.id) join modules on (funcs.module_id=modules.id) join association on (traces.id=association.trace_id) join args on (association.arg_id=args.id) join arg_names on (args.name_id=arg_names.id) join arg_values on (args.value_id=arg_values.id) join types on (args.type_id=types.id);"
id time tid type depth value name value value value
---------- ---------------- ---------- ---------- ---------- ------------------------------------------------- ---------- ------------ ---------- ----------
1 1339232492.47153 2015967584 call 18 build/lib.macosx-10.4-x86_64-2.7/cpytrace/test.py fib <type 'int'> 3 n
2 1339232492.47154 2015967584 call 19 build/lib.macosx-10.4-x86_64-2.7/cpytrace/test.py fib <type 'int'> 2 n
3 1339232492.47154 2015967584 return 18 build/lib.macosx-10.4-x86_64-2.7/cpytrace/test.py fib <type 'int'> 1 return_val
4 1339232492.47154 2015967584 call 19 build/lib.macosx-10.4-x86_64-2.7/cpytrace/test.py fib <type 'int'> 1 n
5 1339232492.47154 2015967584 return 18 build/lib.macosx-10.4-x86_64-2.7/cpytrace/test.py fib <type 'int'> 1 return_val
6 1339232492.47154 2015967584 return 17 build/lib.macosx-10.4-x86_64-2.7/cpytrace/test.py fib <type 'int'> 2 return_val
7 1339232492.47154 2015967584 return 16 build/lib.macosx-10.4-x86_64-2.7/cpytrace/test.py fib <type 'int'> 5 return_val
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment