thanksfully from nv-u I could find the sqlite document.
based on the information, COMPOSITE_EVENTS table contains
Table name COMPOSITE_EVENTS
Column Name Column Type Column Description
start INT NOT NULL Event start timestamp in nanoseconds.
cpu INT NOT NULL ID of CPU this thread was running on.
threadState INT NOT NULL Thread state at the moment of sampling.
globalTid INT NOT NULL Serialized GlobalId.
cpuCycles INT NOT NULL The value of Performance Monitoring Unit (PMU) counter.
and there are several sql examples also,
-- Thread summary calculated using CPU cycles (when available)
SELECT
globalTid / 0x1000000 % 0x1000000 AS PID,
globalTid % 0x1000000 AS TID,
ROUND(100.0 * SUM(cpuCycles) /
(
SELECT SUM(cpuCycles) FROM COMPOSITE_EVENTS
GROUP BY globalTid / 0x1000000000000 % 0x100
),
2
) as CPU_utilization,
(SELECT value FROM StringIds WHERE id =
(
SELECT nameId FROM ThreadNames
WHERE ThreadNames.globalTid = COMPOSITE_EVENTS.globalTid
)
) as thread_name
FROM COMPOSITE_EVENTS
GROUP BY globalTid
ORDER BY CPU_utilization DESC
LIMIT 10;
results
PID TID CPU_utilization thread_name
---------- ---------- --------------- ---------------
19163 19163 98.4 radixSortThrust
19163 19168 1.35 CUPTI worker th
19163 19166 0.25 [NS]
These are from the documentation. Take a look.