Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.kernel > #1702791 > unrolled thread

[PATCH 0/5] perf script: Add support for exporting to sqlite3

Back to article view | Back to linux.kernel

Contents

  [PATCH 0/5] perf script: Add support for exporting to sqlite3 Adrian Hunter <adrian.hunter@intel.com> - 2017-08-03 10:40 +0200
    [PATCH 1/5] perf script: Fix missing call_path_id in export-to-postgresql script Adrian Hunter <adrian.hunter@intel.com> - 2017-08-03 10:50 +0200

#1702791 — [PATCH 0/5] perf script: Add support for exporting to sqlite3

Hi

Here is a script for exporting to SQLite 3 the same data as the PostgreSQL
export.  The call-graph script is renamed and amended to work with both
PostgreSQL and SQLite.


Adrian Hunter (5):
      perf script: Fix missing call_path_id in export-to-postgresql script
      perf script: Fix query in call-graph-from-postgresql.py
      perf script: Add support for exporting to sqlite3
      perf script: Rename call-graph-from-postgresql.py to call-graph-from-sql.py
      perf script: Add support for sqlite3 to call-graph-from-sql.py

 tools/perf/Documentation/intel-pt.txt              |   6 +-
 .../scripts/python/bin/export-to-sqlite-record     |   8 +
 .../scripts/python/bin/export-to-sqlite-report     |  29 ++
 ...h-from-postgresql.py => call-graph-from-sql.py} |  70 ++--
 tools/perf/scripts/python/export-to-postgresql.py  |   5 +-
 tools/perf/scripts/python/export-to-sqlite.py      | 451 +++++++++++++++++++++
 6 files changed, 535 insertions(+), 34 deletions(-)
 create mode 100644 tools/perf/scripts/python/bin/export-to-sqlite-record
 create mode 100644 tools/perf/scripts/python/bin/export-to-sqlite-report
 rename tools/perf/scripts/python/{call-graph-from-postgresql.py => call-graph-from-sql.py} (87%)
 create mode 100644 tools/perf/scripts/python/export-to-sqlite.py


Regards
Adrian

[toc] | [next] | [standalone]

#1702796 — [PATCH 1/5] perf script: Fix missing call_path_id in export-to-postgresql script

The export does not work if only branches are exported because of a missing
column in the samples table.  Fix by adding the missing call_path_id.

Signed-off-by: Adrian Hunter <adrian.hunter@intel.com>
Fixes: 3521f3bc9dae ("perf script: Update export-to-postgresql to support callchain export")
---
 tools/perf/scripts/python/export-to-postgresql.py | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/tools/perf/scripts/python/export-to-postgresql.py b/tools/perf/scripts/python/export-to-postgresql.py
index 7656ff8aa066..f57811443beb 100644
--- a/tools/perf/scripts/python/export-to-postgresql.py
+++ b/tools/perf/scripts/python/export-to-postgresql.py
@@ -340,7 +340,8 @@ if branches:
 		'to_sym_offset	bigint,'
 		'to_ip		bigint,'
 		'branch_type	integer,'
-		'in_tx		boolean)')
+		'in_tx		boolean,'
+		'call_path_id	bigint)')
 else:
 	do_query(query, 'CREATE TABLE samples ('
 		'id		bigint		NOT NULL,'
-- 
1.9.1

[toc] | [prev] | [standalone]

Back to top | Article view | linux.kernel

csiph-web