Lines Matching +full:can +full:- +full:primary
1 # export-to-sqlite.py: export perf data to a sqlite3 database
4 # This program is free software; you can redistribute it and/or modify it
20 # To use this script you will need to have installed package python-pyside which
21 # provides LGPL-licensed Python bindings for Qt. You will also need the package
22 # libqt4-sql-sqlite for Qt sqlite3 support.
28 # $ sudo apt-get install python-pyside.qtsql libqt4-sql-psql
32 # $ sudo apt-get install python3-pyside.qtsql libqt4-sql-psql
33 # $ sudo apt-get install python-pyside2.qtsql libqt5sql5-psql
34 # $ sudo apt-get install python3-pyside2.qtsql libqt5sql5-psql
37 # $ sudo yum install python-pyside
40 # $ sudo yum install python3-pyside
41 # $ pip install --user PySide2
42 # $ pip3 install --user PySide2
46 # $ perf record -e intel_pt//u ls
47 # $ perf script -s ~/libexec/perf-core/scripts/python/export-to-sqlite.py pt_example branches calls
48 # 2017-07-31 14:26:07.326913 Creating database...
49 # 2017-07-31 14:26:07.538097 Writing records...
50 # 2017-07-31 14:26:09.889292 Adding indexes
51 # 2017-07-31 14:26:09.958746 Done
53 # To browse the database, sqlite3 can be used e.g.
65 # exported-sql-viewer.py. Refer to that script for details.
68 # export-to-postgresql.py. Refer to that script for details. A notable
73 if not "pyside-version-1" in sys.argv:
84 '/scripts/python/Perf-Trace-Util/lib/Perf/Trace')
101 …printerr("Usage is: export-to-sqlite.py <database name> [<columns>] [<calls>] [<callchains>] [<pys…
105 printerr(" pyside-version-1 'pyside-version-1' => use pyside version 1");
128 elif (sys.argv[i] == "pyside-version-1"):
166 'id integer NOT NULL PRIMARY KEY,'
169 'id integer NOT NULL PRIMARY KEY,'
173 'id integer NOT NULL PRIMARY KEY,'
179 'id integer NOT NULL PRIMARY KEY,'
185 'id integer NOT NULL PRIMARY KEY,'
189 'id integer NOT NULL PRIMARY KEY,'
195 'id integer NOT NULL PRIMARY KEY,'
202 'id integer NOT NULL PRIMARY KEY,'
207 'id integer NOT NULL PRIMARY KEY,'
230 'id integer NOT NULL PRIMARY KEY,'
258 'id integer NOT NULL PRIMARY KEY,'
264 'id integer NOT NULL PRIMARY KEY,'
280 'id integer NOT NULL PRIMARY KEY,'
285 'id integer NOT NULL PRIMARY KEY,'
291 'id integer NOT NULL PRIMARY KEY,'
296 'id integer NOT NULL PRIMARY KEY,'
302 'id integer NOT NULL PRIMARY KEY,'
306 'id integer NOT NULL PRIMARY KEY,'
312 'id integer NOT NULL PRIMARY KEY,'
341 'CASE WHEN id=0 THEN \'unknown\' WHEN pid=-1 THEN \'host\' ELSE \'guest\' END AS host_or_guest'
414 'return_time - call_time AS elapsed_time,'
620 thread_table(0, 0, 0, -1, -1)