en Copyright 2015 Java http://kernelsources.org:8080/source/history/linux/tools/perf/scripts/python/bin/export-to-postgresql-report#e5451c8f8330e03ad3cfa16048b4daf961af434f Merge remote-tracking branch 'linusw-gpio/for-next' into devm_gpiochipBase for demv_gpiochip_add_data() and devm_gpiochip_remove(). List of files: /linux/tools/perf/scripts/python/bin/export-to-postgresql-report Tue, 23 Feb 2016 15:07:08 +0100 Laxman Dewangan <ldewangan@nvidia.com> http://kernelsources.org:8080/source/history/linux/tools/perf/scripts/python/bin/export-to-postgresql-report#4ba24fef3eb3b142197135223b90ced2f319cd53 Merge branch 'next' into for-linusPrepare first round of input updates for 3.20. List of files: /linux/tools/perf/scripts/python/bin/export-to-postgresql-report Tue, 10 Feb 2015 20:35:36 +0100 Dmitry Torokhov <dmitry.torokhov@gmail.com> http://kernelsources.org:8080/source/history/linux/tools/perf/scripts/python/bin/export-to-postgresql-report#0c49cd295d42d0032af11d55e2140dbec11dc8d0 Merge tag 'v3.19-rc4' into nextMerge with mainline to bring in the latest thermal and other changes. List of files: /linux/tools/perf/scripts/python/bin/export-to-postgresql-report Thu, 15 Jan 2015 18:46:14 +0100 Dmitry Torokhov <dmitry.torokhov@gmail.com> http://kernelsources.org:8080/source/history/linux/tools/perf/scripts/python/bin/export-to-postgresql-report#0a87a2db485a1456b7427914969c0e8195a1bbda Merge tag 'topic/i915-hda-componentized-2015-01-12' into drm-intel-next-queuedConflicts: drivers/gpu/drm/i915/intel_runtime_pm.cSeparate branch so that Takashi can also pull just this refactoringinto sound-next.Signed-off-by: Daniel Vetter <daniel.vetter@intel.com> List of files: /linux/tools/perf/scripts/python/bin/export-to-postgresql-report Mon, 12 Jan 2015 23:07:46 +0100 Daniel Vetter <daniel.vetter@ffwll.ch> http://kernelsources.org:8080/source/history/linux/tools/perf/scripts/python/bin/export-to-postgresql-report#7ebdfaa52d15b947503f76474477f92854796d96 Merge tag 'mvebu-fixes-3.19' of git://git.infradead.org/linux-mvebu into fixesPull "Fixes for 3.19" from Andrew Lunn:Jason is taking a back seat this cycle and i'm doing all the patchwrangling for mvebu.* tag 'mvebu-fixes-3.19' of git://git.infradead.org/linux-mvebu: ARM: mvebu: Fix pinctrl configuration for Armada 370 DBAlso update to Linux 3.19-rc1, which this was based on.Signed-off-by: Arnd Bergmann <arnd@arndb.de> List of files: /linux/tools/perf/scripts/python/bin/export-to-postgresql-report Tue, 30 Dec 2014 11:17:07 +0100 Arnd Bergmann <arnd@arndb.de> http://kernelsources.org:8080/source/history/linux/tools/perf/scripts/python/bin/export-to-postgresql-report#8ab7913675726e5ae23b91221c0b5442d986d44a Merge branch 'x86/vt-d' of git://git.kernel.org/pub/scm/linux/kernel/git/joro/iommu into x86/apic-picksRequired to apply Jiangs x86 irq handling rework without creating anightmare of conflicts.Signed-off-by: Thomas Gleixner <tglx@linutronix.de> List of files: /linux/tools/perf/scripts/python/bin/export-to-postgresql-report Tue, 16 Dec 2014 12:25:38 +0100 Thomas Gleixner <tglx@linutronix.de> http://kernelsources.org:8080/source/history/linux/tools/perf/scripts/python/bin/export-to-postgresql-report#3459f0d78ffe27a1b341c22eb158b622eaaea3fc Merge branch 'linus' into perf/urgent, to pick up the upstream merged bitsSigned-off-by: Ingo Molnar <mingo@kernel.org> List of files: /linux/tools/perf/scripts/python/bin/export-to-postgresql-report Fri, 12 Dec 2014 09:09:03 +0100 Ingo Molnar <mingo@kernel.org> http://kernelsources.org:8080/source/history/linux/tools/perf/scripts/python/bin/export-to-postgresql-report#5706ffd045c3810912c4982357d7daa721af3464 Merge branch 'perf-core-for-linus' of git://git.kernel.org/pub/scm/linux/kernel/git/tip/tipPull perf events update from Ingo Molnar: "On the kernel side there's few changes, the one that stands out is PEBS machine state sampling support on x86, by Stephane Eranian. On the tooling side: User visible tooling changes: - Don't open the DWARF info multiple times, keeping instead a dwfl handle in struct dso, greatly speeding up 'perf report' on powerpc. (Sukadev Bhattiprolu) - Introduce PARSE_OPT_DISABLED option flag and use it to avoid showing undersired options in tools that provides frontends to 'perf record', like sched, kvm, etc (Namhyung Kim) - Fallback to kallsyms when using the minimal 'ELF' loader (Arnaldo Carvalho de Melo) - Fix annotation with kcore (Adrian Hunter) - Support source line numbers in annotate using a hotkey (Andi Kleen) - Callchain improvements including: * Enable printing the srcline in the history * Make get_srcline fall back to sym+offset (Andi Kleen) - TUI hist_entry browser fixes, including showing missing overhead value for first level callchain. Detected comparing the output of --stdio/--gui (that matched) with --tui, that had this problem. (Namhyung Kim) - Support handling complete branch stacks as histograms (Andi Kleen) Tooling infrastructure changes: - Prep work for supporting per-pkg and snapshot counters in 'perf stat' (Jiri Olsa) - 'perf stat' refactorings, moving stuff from it to evsel.c to use in per-pkg/snapshot format changes (Jiri Olsa) - Add per-pkg format file parsing (Matt Fleming) - Clean up libelf feature support code (Namhyung Kim) - Add gzip decompression support for kernel modules (Namhyung Kim) - More prep patches for Intel PT, including a a thread stack and more stuff made available via the database export mechanism (Adrian Hunter) - More Intel PT work, including a facility to export sample data (comms, threads, symbol names, etc) in a database friendly way, with an script to use this to create a postgresql database. (Adrian Hunter) - Make sure that thread->mg->machine points to the machine where the thread exists (it was being set only for the kmaps kernel modules case, do it as well for the mmaps) and use it to shorten function signatures (Arnaldo Carvalho de Melo) ... and lots of other fixes and smaller improvements"* 'perf-core-for-linus' of git://git.kernel.org/pub/scm/linux/kernel/git/tip/tip: (91 commits) perf report: In branch stack mode use address history sorting perf report: Add --branch-history option perf callchain: Support handling complete branch stacks as histograms perf stat: Add support for snapshot counters perf stat: Add support for per-pkg counters perf tools: Remove perf_evsel__read interface perf stat: Use read_counter in read_counter_aggr perf stat: Make read_counter work over the thread dimension perf stat: Use perf_evsel__read_cb in read_counter perf tools: Add snapshot format file parsing perf tools: Add per-pkg format file parsing perf evsel: Introduce perf_evsel__read_cb function perf evsel: Introduce perf_counts_values__scale function perf evsel: Introduce perf_evsel__compute_deltas function perf tools: Allow to force redirect pr_debug to stderr. perf tools: Fix segfault due to invalid kernel dso access perf callchain: Make get_srcline fall back to sym+offset perf symbols: Move bfd_demangle stubbing to its only user perf callchain: Enable printing the srcline in the history perf tools: Collapse first level callchain entry if it has sibling ... List of files: /linux/tools/perf/scripts/python/bin/export-to-postgresql-report Wed, 10 Dec 2014 05:55:37 +0100 Linus Torvalds <torvalds@linux-foundation.org> http://kernelsources.org:8080/source/history/linux/tools/perf/scripts/python/bin/export-to-postgresql-report#2a2662bf88e693d477ef08351d03934f7bc0b51c Merge branch 'perf/core-v3' of git://git.kernel.org/pub/scm/linux/kernel/git/frederic/linux-dynticks into perf/hw_breakpointsPull AMD range breakpoints support from Frederic Weisbecker:" - Extend breakpoint tools and core to support address range through perf event with initial backend support for AMD extended breakpoints. Syntax is: perf record -e mem:addr/len:type For example set write breakpoint from 0x1000 to 0x1200 (0x1000 + 512) perf record -e mem:0x1000/512:w - Clean up a bit breakpoint code validation It has been acked by Jiri and Oleg. "Signed-off-by: Ingo Molnar <mingo@kernel.org> List of files: /linux/tools/perf/scripts/python/bin/export-to-postgresql-report Mon, 08 Dec 2014 11:50:24 +0100 Ingo Molnar <mingo@kernel.org> http://kernelsources.org:8080/source/history/linux/tools/perf/scripts/python/bin/export-to-postgresql-report#322cd21fc196575d922e5e8bd8d5730a91c2b73d Merge tag 'perf-core-for-mingo' of git://git.kernel.org/pub/scm/linux/kernel/git/acme/linux into perf/corePull perf/core improvements and fixes from Arnaldo Carvalho de Melo:Infrastructure changes: - Add gzip decompression support for kernel modules (Namhyung Kim) - More prep patches for Intel PT, including a a thread stack and more stuff made available via the database export mechanism (Adrian Hunter) - Optimize checking that tracepoint events are defined in perf script perl/python (Jiri Olsa) - Do not free pevent when deleting tracepoint evsel (Jiri Olsa) - Fix build-id matching for vmlinux (Namhyung Kim)Signed-off-by: Arnaldo Carvalho de Melo <acme@redhat.com>Signed-off-by: Ingo Molnar <mingo@kernel.org> List of files: /linux/tools/perf/scripts/python/bin/export-to-postgresql-report Fri, 07 Nov 2014 06:21:46 +0100 Ingo Molnar <mingo@kernel.org> http://kernelsources.org:8080/source/history/linux/tools/perf/scripts/python/bin/export-to-postgresql-report#6a70307ddcd9999598c399d55dc44c07816a575f perf tools: Add call information to Python exportAdd the ability to export detailed information about paired calls andreturns to Python db export and the export-to-postgresql.py script.Signed-off-by: Adrian Hunter <adrian.hunter@intel.com>Cc: David Ahern <dsahern@gmail.com>Cc: Frederic Weisbecker <fweisbec@gmail.com>Cc: Jiri Olsa <jolsa@redhat.com>Cc: Namhyung Kim <namhyung@gmail.com>Cc: Paul Mackerras <paulus@samba.org>Cc: Peter Zijlstra <peterz@infradead.org>Cc: Stephane Eranian <eranian@google.com>Link: http://lkml.kernel.org/r/1414678188-14946-7-git-send-email-adrian.hunter@intel.comSigned-off-by: Arnaldo Carvalho de Melo <acme@redhat.com> List of files: /linux/tools/perf/scripts/python/bin/export-to-postgresql-report Thu, 30 Oct 2014 15:09:47 +0100 Adrian Hunter <adrian.hunter@intel.com> http://kernelsources.org:8080/source/history/linux/tools/perf/scripts/python/bin/export-to-postgresql-report#05b2537e8dc778bb00284f8fc86b83797b8f1d37 Merge tag 'perf-core-for-mingo' of git://git.kernel.org/pub/scm/linux/kernel/git/acme/linux into perf/corePull perf/core improvements from Arnaldo Carvalho de Melo:User visible changes: - Don't open the DWARF info multiple times, keeping instead a dwfl handle in struct dso, greatly speeding up 'perf report' on powerpc. (Sukadev Bhattiprolu) - Introduce PARSE_OPT_DISABLED option flag and use it to avoid showing undersired options in tools that provides frontends to 'perf record', like sched, kvm, etc (Namhyung Kim)Infrastructure changes: - More Intel PT work, including a facility to export sample data (comms, threads, symbol names, etc) in a database friendly way, with an script to use this to create a postgresql database. (Adrian Hunter) - Use make sure that thread->mg->machine points to the machine where the thread exists (it was being set only for the kmaps kernel modules case, do it as well for the mmaps) and use it to shorten function signatures (Arnaldo Carvalho de Melo)Signed-off-by: Arnaldo Carvalho de Melo <acme@redhat.com>Signed-off-by: Ingo Molnar <mingo@kernel.org> List of files: /linux/tools/perf/scripts/python/bin/export-to-postgresql-report Thu, 30 Oct 2014 07:34:32 +0100 Ingo Molnar <mingo@kernel.org> http://kernelsources.org:8080/source/history/linux/tools/perf/scripts/python/bin/export-to-postgresql-report#2987e32f75dcb40bce0f3ab1d5d48cc1c580fd8b perf script: Add Python script to export to postgresqlAdd a Python script to export to a postgresql database.The script requires the Python pyside module and the Qt PostgreSQLdriver. The packages needed are probably named "python-pyside" and"libqt4-sql-psql"The caller of the script must be able to create postgresql databases.The script takes the database name as a parameter. The database anddatabase tables are created. Data is written to flat files which arethen imported using SQL COPY FROM.Example: $ perf record ls ... $ perf script report export-to-postgresql lsdb 2014-02-14 10:55:38.631431 Creating database... 2014-02-14 10:55:39.291958 Writing to intermediate files... 2014-02-14 10:55:39.350280 Copying to database... 2014-02-14 10:55:39.358536 Removing intermediate files... 2014-02-14 10:55:39.358665 Adding primary keys 2014-02-14 10:55:39.658697 Adding foreign keys 2014-02-14 10:55:39.667412 Done $ psql lsdb lsdb-# \d List of relations Schema | Name | Type | Owner --------+-----------------+-------+------- public | comm_threads | table | acme public | comms | table | acme public | dsos | table | acme public | machines | table | acme public | samples | table | acme public | samples_view | view | acme public | selected_events | table | acme public | symbols | table | acme public | threads | table | acme (9 rows) lsdb-# \d samples Table "public.samples" Column | Type | Modifiers ---------------+---------+----------- id | bigint | not null evsel_id | bigint | machine_id | bigint | thread_id | bigint | comm_id | bigint | dso_id | bigint | symbol_id | bigint | sym_offset | bigint | ip | bigint | time | bigint | cpu | integer | to_dso_id | bigint | to_symbol_id | bigint | to_sym_offset | bigint | to_ip | bigint | period | bigint | weight | bigint | transaction | bigint | data_src | bigint | Indexes: "samples_pkey" PRIMARY KEY, btree (id) Foreign-key constraints: "commfk" FOREIGN KEY (comm_id) REFERENCES comms(id) "dsofk" FOREIGN KEY (dso_id) REFERENCES dsos(id) "evselfk" FOREIGN KEY (evsel_id) REFERENCES selected_events(id) "machinefk" FOREIGN KEY (machine_id) REFERENCES machines(id) "symbolfk" FOREIGN KEY (symbol_id) REFERENCES symbols(id) "threadfk" FOREIGN KEY (thread_id) REFERENCES threads(id) "todsofk" FOREIGN KEY (to_dso_id) REFERENCES dsos(id) "tosymbolfk" FOREIGN KEY (to_symbol_id) REFERENCES symbols(id) lsdb-# \d samples_view View "public.samples_view" Column | Type | Modifiers -------------------+-------------------------+----------- id | bigint | time | bigint | cpu | integer | pid | integer | tid | integer | command | character varying(16) | event | character varying(80) | ip_hex | text | symbol | character varying(2048) | sym_offset | bigint | dso_short_name | character varying(256) | to_ip_hex | text | to_symbol | character varying(2048) | to_sym_offset | bigint | to_dso_short_name | character varying(256) | lsdb=# select * from samples_view; id| time |cpu | pid | tid |command| event | ip_hex | symbol |sym_off| dso_name|to_ip_hex|to_symbol|to_sym_off|to_dso_name --+------------+----+------+------+-------+--------+---------------+---------------------+-------+---------+---------+---------+----------+---------- 1 |12202825015 | -1 | 7339 | 7339 |:17339 | cycles | fffff8104d24a |native_write_msr_safe| 10 | [kernel]| 0 | unknown | 0| unknown 2 |12203258804 | -1 | 7339 | 7339 |:17339 | cycles | fffff8104d24a |native_write_msr_safe| 10 | [kernel]| 0 | unknown | 0| unknown 3 |12203988119 | -1 | 7339 | 7339 |:17339 | cycles | fffff8104d24a |native_write_msr_safe| 10 | [kernel]| 0 | unknown | 0| unknownMy notes (which may be out-of-date) on setting up postgresql so you cancreate databases:fedora: $ sudo yum install postgresql postgresql-server python-pyside qt-postgresql $ sudo su - postgres -c initdb $ sudo service postgresql start $ sudo su - postgres $ createuser -s <your username>I used the the unix user name in createuser.If it fails, try createuser without -s and answer the following questionto allow your user to create tables: Shall the new role be a superuser? (y/n) yubuntu: $ sudo apt-get install postgresql $ sudo su - postgres $ createuser <your username> Shall the new role be a superuser? (y/n) yYou may want to disable automatic startup. One way is to edit/etc/postgresql/9.3/main/start.conf. Another is to disable the initscript e.g. sudo update-rc.d postgresql disableSigned-off-by: Adrian Hunter <adrian.hunter@intel.com>Cc: David Ahern <dsahern@gmail.com>Cc: Frederic Weisbecker <fweisbec@gmail.com>Cc: Jiri Olsa <jolsa@redhat.com>Cc: Namhyung Kim <namhyung@gmail.com>Cc: Paul Mackerras <paulus@samba.org>Cc: Peter Zijlstra <peterz@infradead.org>Cc: Stephane Eranian <eranian@google.com>Link: http://lkml.kernel.org/r/1414061124-26830-8-git-send-email-adrian.hunter@intel.comSigned-off-by: Arnaldo Carvalho de Melo <acme@redhat.com> List of files: /linux/tools/perf/scripts/python/bin/export-to-postgresql-report Thu, 23 Oct 2014 12:45:15 +0200 Adrian Hunter <adrian.hunter@intel.com>