scripts/python/export-to-sqlite.py

1 # export-to-sqlite.py: export perf data to a sqlite3 database
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
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"):
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)