scripts/python/export-to-postgresql.py

1 # export-to-postgresql.py: export perf data to a postgresql 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-psql for Qt postgresql support.
30 #	$ sudo yum install postgresql postgresql-server qt-postgresql
31 #	$ sudo su - postgres -c initdb
33 #	$ sudo su - postgres
34 #	$ createuser -s <your user id here>    # Older versions may not support -s, in which case answer …
36 #	$ sudo yum install python-pyside
39 #		$ sudo yum install python3-pyside
40 #		$ pip install --user PySide2
41 #		$ pip3 install --user PySide2
45 #	$ sudo apt-get install postgresql
46 #	$ sudo su - postgres
47 #	$ createuser -s <your user id here>
48 #	$ sudo apt-get install python-pyside.qtsql libqt4-sql-psql
52 #		$ sudo apt-get install python3-pyside.qtsql libqt4-sql-psql
53 #		$ sudo apt-get install python-pyside2.qtsql libqt5sql5-psql
54 #		$ sudo apt-get install python3-pyside2.qtsql libqt5sql5-psql
58 #	$ perf record -e intel_pt//u ls
59 #	$ perf script -s ~/libexec/perf-core/scripts/python/export-to-postgresql.py pt_example branches c…
60 #	2015-05-29 12:49:23.464364 Creating database...
61 #	2015-05-29 12:49:26.281717 Writing to intermediate files...
62 #	2015-05-29 12:49:27.190383 Copying to database...
63 #	2015-05-29 12:49:28.140451 Removing intermediate files...
64 #	2015-05-29 12:49:28.147451 Adding primary keys
65 #	2015-05-29 12:49:28.655683 Adding foreign keys
66 #	2015-05-29 12:49:29.365350 Done
77 # exported-sql-viewer.py.  Refer to that script for details.
81 #	The tables largely correspond to perf tools' data structures.  They are largely self-explanatory.
108 #		'comms' contains a record for each 'comm' - the name given to the executable that is running.
216 if not "pyside-version-1" in sys.argv:
232 	# Assume UTF-8 server_encoding and client_encoding
263 	'/scripts/python/Perf-Trace-Util/lib/Perf/Trace')
280 …printerr("Usage is: export-to-postgresql.py <database name> [<columns>] [<calls>] [<callchains>] […
284 	printerr("        pyside-version-1   'pyside-version-1' => use pyside version 1");
307 	elif (sys.argv[i] == "pyside-version-1"):
312 output_dir_name = os.getcwd() + "/" + dbname + "-perf-data"
503 		'CASE WHEN id=0 THEN \'unknown\' WHEN pid=-1 THEN \'host\' ELSE \'guest\' END AS host_or_guest'
576 			'return_time - call_time AS elapsed_time,'
806 	thread_table(0, 0, 0, -1, -1)