Skip to content

Instantly share code, notes, and snippets.

Michał Janaszek Everettss

Block or report user

Report or block Everettss

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
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.