Skip to content

Instantly share code, notes, and snippets.

View trace.json
{"traceEvents":[{"pid":37053,"tid":15363,"ts":29055802932,"ph":"X","cat":"toplevel","name":"MessagePumpLibevent::OnLibeventNotification","args":{"src_file":"../../mojo/edk/system/channel_posix.cc","src_func":"StartOnIOThread"},"dur":196,"tdur":86,"tts":3786},
{"pid":37053,"tid":15363,"ts":29055803176,"ph":"X","cat":"toplevel","name":"MessagePumpLibevent::OnLibeventNotification","args":{"src_file":"../../mojo/edk/system/channel_posix.cc","src_func":"StartOnIOThread"},"dur":39,"tdur":36,"tts":3888},
{"pid":37053,"tid":15363,"ts":29056719406,"ph":"X","cat":"toplevel","name":"MessagePumpLibevent::OnLibeventNotification","args":{"src_file":"../../mojo/edk/system/channel_posix.cc","src_func":"StartOnIOThread"},"dur":55,"tdur":52,"tts":3948},
{"pid":37053,"tid":775,"ts":29055803102,"ph":"X","cat":"toplevel","name":"TaskQueueManager::ProcessTaskFromWorkQueue","args":{"src_file":"../../base/trace_event/trace_log.cc","src_func":"SetEnabled"},"dur":28,"tdur":27,"tts":60182},
{"pid":37053,"tid":775,"ts":29055803136,"ph":
View dev-vs-start.sql
SELECT dev.taskType as taskType, dev.percent as dev, start.percent as start, dev.type as type
FROM (
SELECT scripts.taskType as taskType, scripts.percent as percent, types.group as type
FROM (
SELECT taskType, (count(distinct projectID) / 15868 * 100) as percent
FROM
(SELECT *, 'nodemon' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bnodemon\b)')),
(SELECT *, 'pm2' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bpm2\b)')),
(SELECT *, 'istanbul' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bistanbul\b)')),
(SELECT *, 'jsdoc' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bjsdoc\b)')),
View start-vs-build.sql
SELECT build.taskType as taskType, build.percent as build, start.percent as start, build.type as type
FROM (
SELECT scripts.taskType as taskType, scripts.percent as percent, types.group as type
FROM (
SELECT taskType, (count(distinct projectID) / 65794 * 100) as percent
FROM
(SELECT *, 'nodemon' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bnodemon\b)')),
(SELECT *, 'pm2' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bpm2\b)')),
(SELECT *, 'istanbul' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bistanbul\b)')),
(SELECT *, 'jsdoc' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bjsdoc\b)')),
View technologies-build.sql
SELECT scripts.taskType as taskType, scripts.percent as percent, types.group as type
FROM (
SELECT taskType, (count(distinct projectID) / 65794 * 100) as percent
FROM
(SELECT *, 'nodemon' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bnodemon\b)')),
(SELECT *, 'pm2' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bpm2\b)')),
(SELECT *, 'istanbul' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bistanbul\b)')),
(SELECT *, 'jsdoc' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bjsdoc\b)')),
(SELECT *, 'documentation' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bdocumentation\b)')),
(SELECT *, 'make' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bmake\b)')),
View build-tasks.sql
SELECT task, (count(distinct projectID) / 65794 * 100) as percent
FROM [scripts]
WHERE taskName = 'build'
GROUP BY task
ORDER BY percent DESC
View technologies-start.sql
SELECT scripts.taskType as taskType, scripts.percent as percent, types.group as type
FROM (
SELECT taskType, (count(distinct projectID) / 107646 * 100) as percent
FROM
(SELECT *, 'nodemon' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bnodemon\b)')),
(SELECT *, 'pm2' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bpm2\b)')),
(SELECT *, 'istanbul' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bistanbul\b)')),
(SELECT *, 'jsdoc' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bjsdoc\b)')),
(SELECT *, 'documentation' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bdocumentation\b)')),
(SELECT *, 'make' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bmake\b)')),
View start-tasks.sql
SELECT task, (count(distinct projectID) / 107646 * 100) as percent
FROM [scripts]
WHERE taskName = 'start'
GROUP BY task
ORDER BY percent DESC
View test-tasks.sql
SELECT task, (count(distinct projectID) / 202808 * 100) as percent
FROM [scripts]
WHERE taskName = 'test'
GROUP BY task
ORDER BY percent DESC
You can’t perform that action at this time.