CREATE FUNCTION MON_FORMAT_XML_TIMES_BY_ROW_TREE(DETAILS BLOB(100M))
RETURNS TABLE(
  LVL                  INT
, COUNT                BIGINT
, TOTAL_TIME_VALUE     BIGINT
, TOTAL_TIME_VALUE_PST INT
, METRIC_NAME          VARCHAR(128)
, CHAIN                VARCHAR(256)
)
READS SQL DATA
DETERMINISTIC
NO EXTERNAL ACTION
RETURN
with w as (
select
  metric_name
, total_time_value
, count
, parent_metric_name
from TABLE(MON_FORMAT_XML_TIMES_BY_ROW(DETAILS)) AS F
)
, t (metric_name, total_time_value, count, total_time_value_pst, lvl, chain) as (
select 
  metric_name
, total_time_value, count, 100
, 0, cast(metric_name as varchar(256))
from w a
where not exists (select 1 from w b where b.metric_name=a.parent_metric_name)
  union all
select 
  w.metric_name
, w.total_time_value, w.count
, 100*w.total_time_value/nullif(t.total_time_value, 0) total_time_value_pst
, t.lvl+1, t.chain||'|'||w.metric_name
from w, t
where w.parent_metric_name=t.metric_name
)
select 
  lvl, count, total_time_value, total_time_value_pst
, repeat('  ', lvl)||metric_name metric_name, chain
from t