Lines Matching full:as
6 # version 2, as published by the Free Software Foundation.
153 # SELECT symbol_id,(SELECT name FROM symbols WHERE id = symbol_id) AS symbol,
154 # SUM(elapsed_time) AS tot_elapsed_time,SUM(branch_count) AS tot_branch_count
498 do_query(query, 'CREATE VIEW machines_view AS '
503 'CASE WHEN id=0 THEN \'unknown\' WHEN pid=-1 THEN \'host\' ELSE \'guest\' END AS host_or_guest'
506 do_query(query, 'CREATE VIEW dsos_view AS '
510 '(SELECT host_or_guest FROM machines_view WHERE id = machine_id) AS host_or_guest,'
516 do_query(query, 'CREATE VIEW symbols_view AS '
520 '(SELECT short_name FROM dsos WHERE id=dso_id) AS dso,'
524 'CASE WHEN binding=0 THEN \'local\' WHEN binding=1 THEN \'global\' ELSE \'weak\' END AS binding'
527 do_query(query, 'CREATE VIEW threads_view AS '
531 '(SELECT host_or_guest FROM machines_view WHERE id = machine_id) AS host_or_guest,'
537 do_query(query, 'CREATE VIEW comm_threads_view AS '
540 '(SELECT comm FROM comms WHERE id = comm_id) AS command,'
542 '(SELECT pid FROM threads WHERE id = thread_id) AS pid,'
543 '(SELECT tid FROM threads WHERE id = thread_id) AS tid'
547 do_query(query, 'CREATE VIEW call_paths_view AS '
550 'to_hex(c.ip) AS ip,'
552 '(SELECT name FROM symbols WHERE id = c.symbol_id) AS symbol,'
553 '(SELECT dso_id FROM symbols WHERE id = c.symbol_id) AS dso_id,'
554 '(SELECT dso FROM symbols_view WHERE id = c.symbol_id) AS dso_short_name,'
556 'to_hex(p.ip) AS parent_ip,'
557 'p.symbol_id AS parent_symbol_id,'
558 '(SELECT name FROM symbols WHERE id = p.symbol_id) AS parent_symbol,'
559 '(SELECT dso_id FROM symbols WHERE id = p.symbol_id) AS parent_dso_id,'
560 '(SELECT dso FROM symbols_view WHERE id = p.symbol_id) AS parent_dso_short_name'
563 do_query(query, 'CREATE VIEW calls_view AS '
567 '(SELECT pid FROM threads WHERE id = thread_id) AS pid,'
568 '(SELECT tid FROM threads WHERE id = thread_id) AS tid,'
569 '(SELECT comm FROM comms WHERE id = comm_id) AS command,'
571 'to_hex(ip) AS ip,'
573 '(SELECT name FROM symbols WHERE id = symbol_id) AS symbol,'
576 'return_time - call_time AS elapsed_time,'
580 …WHEN cyc_count=0 THEN CAST(0 AS NUMERIC(20, 2)) ELSE CAST((CAST(insn_count AS FLOAT) / cyc_count) …
583 …THEN \'no call/return\' WHEN flags=6 THEN \'jump\' ELSE CAST ( flags AS VARCHAR(6) ) END AS flags,'
588 do_query(query, 'CREATE VIEW samples_view AS '
593 '(SELECT pid FROM threads WHERE id = thread_id) AS pid,'
594 '(SELECT tid FROM threads WHERE id = thread_id) AS tid,'
595 '(SELECT comm FROM comms WHERE id = comm_id) AS command,'
596 '(SELECT name FROM selected_events WHERE id = evsel_id) AS event,'
597 'to_hex(ip) AS ip_hex,'
598 '(SELECT name FROM symbols WHERE id = symbol_id) AS symbol,'
600 '(SELECT short_name FROM dsos WHERE id = dso_id) AS dso_short_name,'
601 'to_hex(to_ip) AS to_ip_hex,'
602 '(SELECT name FROM symbols WHERE id = to_symbol_id) AS to_symbol,'
604 '(SELECT short_name FROM dsos WHERE id = to_dso_id) AS to_dso_short_name,'
605 '(SELECT name FROM branch_types WHERE id = branch_type) AS branch_type_name,'
609 …WHEN cyc_count=0 THEN CAST(0 AS NUMERIC(20, 2)) ELSE CAST((CAST(insn_count AS FLOAT) / cyc_count) …
613 do_query(query, 'CREATE VIEW ptwrite_view AS '
618 'to_hex(payload) AS payload_hex,'
619 'CASE WHEN exact_ip=FALSE THEN \'False\' ELSE \'True\' END AS exact_ip'
623 do_query(query, 'CREATE VIEW cbr_view AS '
634 do_query(query, 'CREATE VIEW mwait_view AS '
639 'to_hex(hints) AS hints_hex,'
640 'to_hex(extensions) AS extensions_hex'
644 do_query(query, 'CREATE VIEW pwre_view AS '
651 'CASE WHEN hw=FALSE THEN \'False\' ELSE \'True\' END AS hw'
655 do_query(query, 'CREATE VIEW exstop_view AS '
660 'CASE WHEN exact_ip=FALSE THEN \'False\' ELSE \'True\' END AS exact_ip'
664 do_query(query, 'CREATE VIEW pwrx_view AS '
675 ' ELSE CAST ( wake_reason AS VARCHAR(2) )'
676 'END AS wake_reason'
680 do_query(query, 'CREATE VIEW power_events_view AS '
685 'selected_events.name AS event,'
686 'FORMAT(\'%6s\', cbr.cbr) AS cbr,'
687 'FORMAT(\'%6s\', cbr.mhz) AS MHz,'
688 'FORMAT(\'%5s\', cbr.percent) AS percent,'
689 'to_hex(mwait.hints) AS hints_hex,'
690 'to_hex(mwait.extensions) AS extensions_hex,'
691 'FORMAT(\'%3s\', pwre.cstate) AS cstate,'
692 'FORMAT(\'%3s\', pwre.subcstate) AS subcstate,'
693 'CASE WHEN pwre.hw=FALSE THEN \'False\' WHEN pwre.hw=TRUE THEN \'True\' ELSE NULL END AS hw,'
694 …p.exact_ip=FALSE THEN \'False\' WHEN exstop.exact_ip=TRUE THEN \'True\' ELSE NULL END AS exact_ip,'
695 'FORMAT(\'%3s\', pwrx.deepest_cstate) AS deepest_cstate,'
696 'FORMAT(\'%3s\', pwrx.last_cstate) AS last_cstate,'
702 'END AS wake_reason'
712 do_query(query, 'CREATE VIEW context_switches_view AS '
718 'th_out.pid AS pid_out,'
719 'th_out.tid AS tid_out,'
720 'comm_out.comm AS comm_out,'
721 'th_in.pid AS pid_in,'
722 'th_in.tid AS tid_in,'
723 'comm_in.comm AS comm_in,'
727 ' ELSE CAST ( context_switches.flags AS VARCHAR(11) )'
728 'END AS flags'
730 ' INNER JOIN threads AS th_out ON th_out.id = context_switches.thread_out_id'
731 ' INNER JOIN threads AS th_in ON th_in.id = context_switches.thread_in_id'
732 ' INNER JOIN comms AS comm_out ON comm_out.id = context_switches.comm_out_id'
733 ' INNER JOIN comms AS comm_in ON comm_in.id = context_switches.comm_in_id')