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;
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;