"Show all children" feature

[dchanman]

In the trace viewing panel, whenever I post a "sticky note" for the function in the bottom right corner, I'd like this box to contain a link "Summarize all children". By clicking on this link, I'd like to see a pop-up box where all children for this function are ordered by duration. The SQL query that will produce this output follows. Assume that the parent function has id=4096 and tid=18:

WITH lowerboundtime AS (SELECT time FROM trace WHERE id=4096 AND dir=0), upperboundtime AS (SELECT time FROM trace WHERE id=4096 and dir=1) SELECT func, id, time, duration FROM trace WHERE time>= (SELECT * FROM lowerboundtime) AND time <= (SELECT * FROM upperboundtime) AND tid=18 ORDER BY duration DESC;