github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/log/query_cu.result (about) 1 set @stats="[3,7528422223,573384797164.000,0,1,247109,2]"; 2 set @duration=309319808921; 3 select json_extract(@stats, '$[1]') val; 4 val 5 7528422223 6 select json_extract(@stats, '$[2]') val; 7 val 8 573384797164 9 select json_extract(@stats, '$[3]') val; 10 val 11 0 12 select json_extract(@stats, '$[4]') val; 13 val 14 1 15 select json_extract(@stats, '$[5]') val; 16 val 17 247109 18 select json_extract(@stats, '$[6]') val; 19 val 20 2 21 select CAST(mo_cu(@stats, @duration) AS DECIMAL(32,6)) as cu, CAST(mo_cu(@stats, @duration, "total") AS DECIMAL(32,6)) cu_total, CAST(mo_cu(@stats, @duration, "cpu") AS DECIMAL(32,6)) cu_cpu, CAST(mo_cu(@stats, @duration, "mem") AS DECIMAL(32,6)) cu_mem, CAST(mo_cu(@stats, @duration, "ioin") AS DECIMAL(32,6)) cu_ioin, CAST(mo_cu(@stats, @duration, "ioout") AS DECIMAL(32,6)) cu_ioout, CAST(mo_cu(@stats, @duration, "network") AS DECIMAL(32,6)) cu_network; 22 cu cu_total cu_cpu cu_mem cu_ioin cu_ioout cu_network 23 807058.4751 807058.4750 259.0369 806598.2280 0.0000 6.7619 194.4483 24 select CAST(JSON_UNQUOTE(JSON_EXTRACT(@stats, '$[1]')) * 3.45e-14 / 1.002678e-06 AS DECIMAL(32,6)) - CAST(mo_cu(@stats, @duration, "cpu") AS DECIMAL(32,6)) val; 25 val 26 0 27 select CAST(JSON_UNQUOTE(JSON_EXTRACT(@stats, '$[2]')) * 4.56e-24 * @duration / 1.002678e-06 AS DECIMAL(32,6)) - CAST(mo_cu(@stats, @duration, "mem") AS DECIMAL(32,6)) val; 28 val 29 0 30 select mo_cu('[1,1,2,3,4,5,0,0]', 0) val; 31 val 32 44.0121 33 select mo_cu('[3,1,2,3,4,5,0,0]', 0) val; 34 val 35 44.0161