profile-compile of rakudo build --target=parse sorted by exclusive_time (top 40)

gistfile1.txt

name|filename|line|entries|inclusive_time|exclusive_time
compile_mastop|gen/moar/stage2/QAST.nqp|1607|17871|842513|173065
term:sym<name>|src/Perl6/Grammar.nqp|3255|11044|3108746|192143
compile_node|gen/moar/stage2/QAST.nqp|5956|211632|2037757|192344
wanted|gen/moar/stage2/QASTNode.nqp|170|329632|257952|193630
method_def|src/Perl6/Grammar.nqp|2641|4170|31926835|198082
add_constant|src/Perl6/World.nqp|2570|30957|447171|200341
BUILDALL|gen/moar/stage2/NQPCORE.setting|517|61743|241487|208642
WANTED|gen/moar/Perl6-Actions.nqp|210|102066|1198749|213156
variable|gen/moar/Perl6-Actions.nqp|2325|53332|1002955|220565
finish_code_object|src/Perl6/World.nqp|2152|12578|483809|225452
MARKER|gen/moar/stage2/NQPHLL.nqp|1080|242250|282827|244733
name|blib/Perl6/Grammar.moarvm|-1|64757|1781575|244802
statementlist|src/Perl6/Grammar.nqp|1180|9565|53833991|255682
lower_signature|gen/moar/Perl6-Actions.nqp|7956|6519|726242|256814
longname|src/Perl6/Grammar.nqp|505|63083|3030194|257292
before|gen/moar/stage2/QRegex.nqp|1606|174523|945507|264280
set|gen/moar/stage2/QASTNode.nqp|124|413024|442168|313380
infixish|src/Perl6/Grammar.nqp|3866|75732|4657202|336564
unv|blib/Perl6/Grammar.moarvm|-1|138865|1027100|343532
new|gen/moar/stage2/QASTNode.nqp|565|392948|600539|353672
add_lexical|gen/moar/stage2/QAST.nqp|4627|179611|862718|392445
variable|src/Perl6/Grammar.nqp|2052|29755|3775660|413490
statement|src/Perl6/Grammar.nqp|1240|39212|53756575|440007
compile_var|gen/moar/stage2/QAST.nqp|5988|211632|1857559|477733
postfixish|src/Perl6/Grammar.nqp|3912|88445|12620777|487984
wanted|gen/moar/Perl6-Actions.nqp|56|138788|1061242|497051
compile_all_the_stmts|gen/moar/stage2/QAST.nqp|5810|10228|3885065|553240
compile_in_context|src/Perl6/World.nqp|2457|356|5035017|561869
ws|src/Perl6/Grammar.nqp|588|453843|5354330|567682
EXPR|gen/moar/stage2/NQPHLL.nqp|863|51538|53649276|571464
symbol|gen/moar/stage2/QASTNode.nqp|907|1558528|667339|663833
termish|src/Perl6/Grammar.nqp|3807|76052|53543049|728492
run|gen/moar/stage2/QRegex.nqp|681|526265|830916|830916
!cursor_start|gen/moar/stage2/QRegex.nqp|1203|2706601|925714|925714
!alt|gen/moar/stage2/QRegex.nqp|1414|1506871|3572718|1302863
!protoregex|gen/moar/stage2/QRegex.nqp|1354|526265|53410785|1346270
_ws|blib/Perl6/Grammar.moarvm|-1|233364|4142551|1365233
!reduce|gen/moar/stage2/QRegex.nqp|1338|1710317|21855445|1741246
find_symbol|src/Perl6/World.nqp|3749|461383|2671520|2105226
MATCH|gen/moar/stage2/QRegex.nqp|1940|3304821|6709947|6397484

query_used.sql

select
  case when r.name = "" then "<anon>" else r.name end,
  r.file,
  r.line,
  sum(entries) as en,
  sum(case when rec_depth = 0 then inclusive_time else 0 end) as inc,
  sum(exclusive_time) as ex
from
  callees c,
  routines r
where
  c.id = r.id
group by
  c.id
order by
  ex;