scripts/python/export-to-postgresql.py

59 …perf script -s ~/libexec/perf-core/scripts/python/export-to-postgresql.py pt_example branches calls
88 #	calls
90 #		'calls' represents function calls and is related to 'samples' by 'call_id' and 'return_id'.
91 #		'calls' is only created when the 'calls' option to this script is specified.
96 #		'calls_paths' is only created when the 'calls' option to this script is specified.
145 #   Note that call information is only available if the script's 'calls' option has been used.
147 #	Top 10 function calls (not aggregated by symbol):
151 #	Top 10 function calls (aggregated by symbol):
165 #	Top 10 function calls for a specific symbol (e.g. whose symbol_id is 187):
169 #	Show function calls made by function in the same context (i.e. same call path) (e.g. one with cal…
280 …printerr("Usage is: export-to-postgresql.py <database name> [<columns>] [<calls>] [<callchains>] […
282 	printerr("        calls              'calls' => create calls and call_paths table");
303 	if (sys.argv[i] == "calls"):
439 	do_query(query, 'CREATE TABLE calls ('
565 			'calls.id,'
585 			'calls.parent_id'
586 		' FROM calls INNER JOIN call_paths ON call_paths.id = call_path_id')
841 		copy_output_file(call_file,		"calls")
885 		do_query(query, 'ALTER TABLE calls           ADD PRIMARY KEY (id)')
921 		do_query(query, 'ALTER TABLE calls '
928 		do_query(query, 'CREATE INDEX pcpid_idx ON calls (parent_call_path_id)')
929 		do_query(query, 'CREATE INDEX pid_idx ON calls (parent_id)')
931 …(query, 'UPDATE comms SET has_calls = TRUE WHERE comms.id IN (SELECT DISTINCT comm_id FROM calls)')