Ñò
•˜¦_c @ sÉ d d k Z d d k Z d d k Z d d k Z d d k Td d k Te d ƒ Z e i Z e e _
e i Z e i Z e i
Z
e e
_
e i Z e i Z e e e g e _ e i Z e e g e _ e i i e i d d ƒ e Z e Z d „ Z e e i ƒ d j o e ƒ n e i d Z e e i ƒ d j o e i d Z n d
Z e dF j o e ƒ n e d j Z e e i ƒ d j o) e i d d
j o
e Z q°e ƒ n e i ƒ d e d Z! e i" e! ƒ d „ Z# e i i$ ƒ Gd GHe% i& d ƒ Z' e( e' ƒ Z) e' i* d ƒ e' i+ ƒ y e# e) d e ƒ Wn e i, e! ƒ ‚ n Xe) i- ƒ e) i. ƒ e' i/ ƒ e' i* e ƒ e' i+ ƒ e( e' ƒ Z) e# e) d ƒ e# e) d ƒ e# e) d ƒ e# e) d ƒ e# e) d ƒ e# e) d ƒ e# e) d ƒ e# e) d ƒ e# e) d ƒ e o e# e) d ƒ n e# e) d ƒ e o e# e) d ƒ e# e) d! ƒ n e# e) d" ƒ e i0 d# d$ d% d% ƒ Z1 d& Z2 d' „ Z3 d( „ Z4 d) „ Z5 d* „ Z6 d+ „ Z7 e3 d, ƒ Z8 e3 d- ƒ Z9 e3 d. ƒ Z: e3 d/ ƒ Z; e3 d0 ƒ Z< e3 d1 ƒ Z= e3 d2 ƒ Z> e3 d3 ƒ Z? e3 d4 ƒ Z@ e o e3 d5 ƒ ZA e3 d6 ƒ ZB n d7 „ ZC d% aD d8 „ ZE d9 „ ZF d: „ ZG d; „ ZH d< „ ZI d= „ ZJ d> „ ZK d? „ ZL d@ „ ZM dA „ ZN dB „ ZO dC „ ZP dD „ ZQ dE „ ZR d S(G iÿÿÿÿN( t *s
libpq.so.5t PERF_EXEC_PATHs. /scripts/python/Perf-Trace-Util/lib/Perf/Tracec C s7 t i d IJt i d IJt i d IJt d ƒ ‚ d S( NsG Usage is: export-to-postgresql.py [] []s# where: columns 'all' or 'branches's& calls 'calls' => create calls tables Too few arguments( t syst stderrt Exception( ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt usage- s
i i i t allt branchesi t callst /s
-perf-datac C s5 | i | ƒ o d St d | i ƒ i ƒ ƒ ‚ d S( Ns Query failed: ( t exec_R t lastErrort text( t qt s( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt do_queryK s s Creating database...t QPSQLt postgress CREATE DATABASE s" SET client_min_messages TO WARNINGsE CREATE TABLE selected_events (id bigint NOT NULL,name varchar(80))sQ CREATE TABLE machines (id bigint NOT NULL,pid integer,root_dir varchar(4096))si CREATE TABLE threads (id bigint NOT NULL,machine_id bigint,process_id bigint,pid integer,tid integer)s; CREATE TABLE comms (id bigint NOT NULL,comm varchar(16))sP CREATE TABLE comm_threads (id bigint NOT NULL,comm_id bigint,thread_id bigint)s CREATE TABLE dsos (id bigint NOT NULL,machine_id bigint,short_name varchar(256),long_name varchar(4096),build_id varchar(64))s~ CREATE TABLE symbols (id bigint NOT NULL,dso_id bigint,sym_start bigint,sym_end bigint,binding integer,name varchar(2048))sC CREATE TABLE branch_types (id integer NOT NULL,name varchar(80))s/ CREATE TABLE samples (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,branch_type integer,in_tx boolean)sp CREATE TABLE samples (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,branch_type integer,in_tx boolean)s[ CREATE TABLE call_paths (id bigint NOT NULL,parent_id bigint,symbol_id bigint,ip bigint)sß CREATE TABLE calls (id bigint NOT NULL,thread_id bigint,comm_id bigint,call_path_id bigint,call_time bigint,return_time bigint,branch_count bigint,call_id bigint,return_id bigint,parent_call_path_id bigint,flags integer)s¼ CREATE VIEW samples_view AS SELECT id,time,cpu,(SELECT pid FROM threads WHERE id = thread_id) AS pid,(SELECT tid FROM threads WHERE id = thread_id) AS tid,(SELECT comm FROM comms WHERE id = comm_id) AS command,(SELECT name FROM selected_events WHERE id = evsel_id) AS event,to_hex(ip) AS ip_hex,(SELECT name FROM symbols WHERE id = symbol_id) AS symbol,sym_offset,(SELECT short_name FROM dsos WHERE id = dso_id) AS dso_short_name,to_hex(to_ip) AS to_ip_hex,(SELECT name FROM symbols WHERE id = to_symbol_id) AS to_symbol,to_sym_offset,(SELECT short_name FROM dsos WHERE id = to_dso_id) AS to_dso_short_name,(SELECT name FROM branch_types WHERE id = branch_type) AS branch_type_name,in_tx FROM sampless !11siis PGCOPY
ÿ
i s ÿÿc C s. t d | } t | d ƒ } | i t ƒ | S( NR s w+( t output_dir_namet opent writet file_header( t file_namet path_namet file( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt open_output_fileá s
c C s | i t ƒ | i ƒ d S( N( R t file_trailert close( R ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt close_output_fileç s
c C s4 t | ƒ d | d | i d } t t | ƒ d S( Ns COPY s FROM 's ' (FORMAT 'binary')( R t nameR t query( R t
table_namet sql( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt copy_output_file_directë s
c C s= t d t ƒ } t | ƒ o t d ƒ ‚ n | i t ƒ | i d ƒ d | d } t | | ƒ } t | ƒ d j o t d ƒ ‚ n | i d ƒ } x` t
| ƒ oR t | | t
| ƒ ƒ } | d j o t d
t | ƒ ƒ ‚ n | i d ƒ } q™ Wt
| d ƒ } | d j o t d t | ƒ ƒ ‚ n t | ƒ d S( Ns dbname = s" COPY FROM STDIN PQconnectdb failedi s COPY s FROM STDIN (FORMAT 'binary')i s COPY FROM STDIN PQexec failedi i s, COPY FROM STDIN PQputCopyData failed, error s+ COPY FROM STDIN PQputCopyEnd failed, error ( t PQconnectdbt dbnamet PQstatusR R R t seekt PQexect PQresultStatust readt lent
PQputCopyDatat strt PQputCopyEndt Nonet PQfinish( R R t connR t rest datat ret( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt copy_output_fileñ s(
c C s$ | i } | i ƒ t i | ƒ d S( N( R R t ost unlink( R R ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt remove_output_file s
s evsel_table.bins machine_table.bins thread_table.bins comm_table.bins comm_thread_table.bins
dso_table.bins symbol_table.bins branch_type_table.bins sample_table.bins call_path_table.bins call_table.binc C sé t i i ƒ Gd GHt d d ƒ t d d d ƒ t d d d d d ƒ t d d ƒ t d d d d d ƒ t d d d d d d ƒ t d d d d d d d d d d d d d d d d d d d d d ƒ t o t
d d d d ƒ n d S( Ns Writing to intermediate files...i t unknowniÿÿÿÿt ( t datetimet todayt evsel_tablet
machine_tablet thread_tablet
comm_tablet dso_tablet symbol_tablet sample_tablet perf_db_export_callst call_path_table( ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt trace_begin s
Fc C s° t i i ƒ Gd GHt t d ƒ t t d ƒ t t d ƒ t t d ƒ t t d ƒ t t d ƒ t t d ƒ t t
d ƒ t t d
ƒ t o t t
d ƒ t t d ƒ n t i i ƒ Gd
GHt t ƒ t t ƒ t t ƒ t t ƒ t t ƒ t t ƒ t t ƒ t t
ƒ t t ƒ t o t t
ƒ t t ƒ n t i t ƒ t i i ƒ Gd GHt t d ƒ t t d ƒ t t d ƒ t t d ƒ t t d ƒ t t d ƒ t t d ƒ t t d ƒ t t d ƒ t o t t d ƒ t t d ƒ n t i i ƒ Gd GHt t d ƒ t t d ƒ t t d ƒ t t d ƒ t t d ƒ t o+ t t d ƒ t t d! ƒ t t d" ƒ n t o t i i ƒ Gd# Gt Gd$ GHn t i i ƒ Gd% GHd S(& Ns Copying to database...t selected_eventst machinest threadst commst comm_threadst dsost symbolst branch_typest samplest
call_pathsR s Removing intermediate files...s Adding primary keyss0 ALTER TABLE selected_events ADD PRIMARY KEY (id)s0 ALTER TABLE machines ADD PRIMARY KEY (id)s0 ALTER TABLE threads ADD PRIMARY KEY (id)s0 ALTER TABLE comms ADD PRIMARY KEY (id)s0 ALTER TABLE comm_threads ADD PRIMARY KEY (id)s0 ALTER TABLE dsos ADD PRIMARY KEY (id)s0 ALTER TABLE symbols ADD PRIMARY KEY (id)s0 ALTER TABLE branch_types ADD PRIMARY KEY (id)s0 ALTER TABLE samples ADD PRIMARY KEY (id)s0 ALTER TABLE call_paths ADD PRIMARY KEY (id)s0 ALTER TABLE calls ADD PRIMARY KEY (id)s Adding foreign keyss³ ALTER TABLE threads ADD CONSTRAINT machinefk FOREIGN KEY (machine_id) REFERENCES machines (id),ADD CONSTRAINT processfk FOREIGN KEY (process_id) REFERENCES threads (id)s¸ ALTER TABLE comm_threads ADD CONSTRAINT commfk FOREIGN KEY (comm_id) REFERENCES comms (id),ADD CONSTRAINT threadfk FOREIGN KEY (thread_id) REFERENCES threads (id)s` ALTER TABLE dsos ADD CONSTRAINT machinefk FOREIGN KEY (machine_id) REFERENCES machines (id)sc ALTER TABLE symbols ADD CONSTRAINT dsofk FOREIGN KEY (dso_id) REFERENCES dsos (id)s˜ ALTER TABLE samples ADD CONSTRAINT evselfk FOREIGN KEY (evsel_id) REFERENCES selected_events (id),ADD CONSTRAINT machinefk FOREIGN KEY (machine_id) REFERENCES machines (id),ADD CONSTRAINT threadfk FOREIGN KEY (thread_id) REFERENCES threads (id),ADD CONSTRAINT commfk FOREIGN KEY (comm_id) REFERENCES comms (id),ADD CONSTRAINT dsofk FOREIGN KEY (dso_id) REFERENCES dsos (id),ADD CONSTRAINT symbolfk FOREIGN KEY (symbol_id) REFERENCES symbols (id),ADD CONSTRAINT todsofk FOREIGN KEY (to_dso_id) REFERENCES dsos (id),ADD CONSTRAINT tosymbolfk FOREIGN KEY (to_symbol_id) REFERENCES symbols (id)s¸ ALTER TABLE call_paths ADD CONSTRAINT parentfk FOREIGN KEY (parent_id) REFERENCES call_paths (id),ADD CONSTRAINT symbolfk FOREIGN KEY (symbol_id) REFERENCES symbols (id)s ALTER TABLE calls ADD CONSTRAINT threadfk FOREIGN KEY (thread_id) REFERENCES threads (id),ADD CONSTRAINT commfk FOREIGN KEY (comm_id) REFERENCES comms (id),ADD CONSTRAINT call_pathfk FOREIGN KEY (call_path_id) REFERENCES call_paths (id),ADD CONSTRAINT callfk FOREIGN KEY (call_id) REFERENCES samples (id),ADD CONSTRAINT returnfk FOREIGN KEY (return_id) REFERENCES samples (id),ADD CONSTRAINT parent_call_pathfk FOREIGN KEY (parent_call_path_id) REFERENCES call_paths (id)s5 CREATE INDEX pcpid_idx ON calls (parent_call_path_id)s Warning: s unhandled eventst Done( R9 R: R3 t
evsel_filet machine_filet thread_filet comm_filet comm_thread_filet dso_filet symbol_filet branch_type_filet sample_fileRB t call_path_filet call_fileR6 R4 t rmdirR R R t unhandled_count( ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt trace_end' sj
c C s t d 7a d S( Ni ( R\ ( t
event_namet contextt event_fields_dict( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt trace_unhandledw s c G s d S( N( ( t x( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt sched__sched_switch{ s c G sO t | ƒ } d t | ƒ d } t i | d d | | | ƒ } t i | ƒ d S( Ns !hiqiR i i ( R) R+ t structt packRP R ( t evsel_idt
evsel_nameRb t nt fmtt value( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyR; ~ s c G sU t | ƒ } d t | ƒ d } t i | d d | d | | | ƒ } t i | ƒ d S( Ns !hiqiiiR i i i ( R) R+ Rd Re RQ R ( t
machine_idt pidt root_dirRb Rh Ri Rj ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyR< „ s $c
G sA t i d d d | d | d | d | d | ƒ } t i | ƒ d S( Ns !hiqiqiqiiiii i i ( Rd Re RR R ( t thread_idRk t
process_idRl t tidRb Rj ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyR= Š s 0c G sO t | ƒ } d t | ƒ d } t i | d d | | | ƒ } t i | ƒ d S( Ns !hiqiR i i ( R) R+ Rd Re RS R ( t comm_idt comm_strRb Rh Ri Rj ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyR> Ž s c G s; d } t i | d d | d | d | ƒ } t i | ƒ d S( Ns !hiqiqiqi i ( Rd Re RT R ( t comm_thread_idRq Rn Rb Ri Rj ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt comm_thread_table” s $c
G s• t | ƒ } t | ƒ } t | ƒ } d t | ƒ d t | ƒ d t | ƒ d } t i | d d | d | | | | | | | ƒ }
t i |
ƒ d S( Ns !hiqiqit siR i i ( R) R+ Rd Re RU R ( t dso_idRk t
short_namet long_namet build_idRb t n1t n2t n3Ri Rj ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyR? ™ s 00c
G sg t | ƒ } d t | ƒ d } t i | d d | d | d | d | d | | | ƒ } t i | ƒ d S( Ns
!hiqiqiqiqiiiR i i i ( R) R+ Rd Re RV R (
t symbol_idRv t sym_startt sym_endt bindingt symbol_nameRb Rh Ri Rj ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyR@ ¡ s 6c G sO t | ƒ } d t | ƒ d } t i | d d | | | ƒ } t i | ƒ d S( Ns !hiiiR i i ( R) R+ Rd Re RW R ( t branch_typeR Rb Rh Ri Rj ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt branch_type_table§ s c - G s$ t o| t i d d d | d | d | d | d | d | d | d | d | d | d |
d | d | d |
d | d | d | ƒ$ } n‘ t i d d d | d | d | d | d | d | d | d | d | d | d |
d | d | d |
d | d | d | d | d | d | d | ƒ, } t i | ƒ d S( Ns$ !hiqiqiqiqiqiqiqiqiqiqiiiqiqiqiqiiiBi i i i s, !hiqiqiqiqiqiqiqiqiqiqiiiqiqiqiqiqiqiqiqiiiBi ( R Rd Re RX R ( t sample_idRf Rk Rn Rq Rv R} t
sym_offsett ipt timet cput to_dso_idt to_symbol_idt
to_sym_offsett to_ipt periodt weightt transactiont data_srcR‚ t in_txRb Rj ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyRA s |c G sA d } t i | d d | d | d | d | ƒ
} t i | ƒ d S( Ns
!hiqiqiqiqi i ( Rd Re RY R ( t cp_idt parent_idR} R† Rb Ri Rj ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyRC ´ s *c G sk d } t i | d d | d | d | d | d | d | d | d | d | d | d |
ƒ }
t i |
ƒ d S( Ns !hiqiqiqiqiqiqiqiqiqiqiii i i ( Rd Re RZ R ( t cr_idRn Rq t call_path_idt call_timet return_timet branch_countt call_idt return_idt parent_call_path_idt flagsRb Ri Rj ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt call_return_table¹ s T( s alls branches(S R4 R Rd R9 t PySide.QtSqlt ctypest CDLLt libpqR" t c_void_pt restypeR. R$ R& R' R* t c_intt argtypesR, t patht appendt environt Truet perf_db_export_modet FalseRB R R) t argvR# t columnsR t getcwdR t mkdirR R: t QSqlDatabaset addDatabaset dbt QSqlQueryR t setDatabaseNameR R[ t finisht clearR Re R R R R R! R3 R6 RP RQ RR RS RT RU RV RW RX RY RZ RD R\ R] Ra Rc R; R< R= R> Rt R? R@ Rƒ RA RC R ( ( ( s= /usr/libexec/perf-core/scripts/python/export-to-postgresql.pyt
sÒ
P