top | item 28775160 Show HN: Most active bots commenting on GitHub in the past 30 days 25 points| seiflotfy | 4 years ago |play.axiom.co | reply 8 comments order hn newest [+] [-] seiflotfy|4 years ago|reply You can run the same query with a query builder here https://play.axiom.co/axiom-play-qf1k/datasets/github-issues...I changed it to 90 days :D [+] [-] ucirello|4 years ago|reply that reminds of that presentation about Google's monorepo, in which a graph makes the distinction of the commits made by humans versus done by bots. The bots there were really active. load replies (1) [+] [-] abahlo|4 years ago|reply Wow, dependabot opened 2.7 Million PRs in the last 30 days https://play.axiom.co/axiom-play-qf1k/explorer?qid=blX8pIiTb... [+] [-] tolatemitope|4 years ago|reply [deleted] [+] [-] elesbao|4 years ago|reply how big is the dataset ? I am wondering that if this is a month worth of bots comment that's a lot of data and the interface feels snappy. [+] [-] seiflotfy|4 years ago|reply the query is faster is written is follows``` ['github-issue-comment-event'] | where actor contains "-bot" or actor contains "[bot]" | summarize count() by bin_auto(_time), actor | take 20 ``` [+] [-] seiflotfy|4 years ago|reply 90 days only we will backfill at some point but we need to test a bit more [+] [-] r0dms|4 years ago|reply Very cool, thanks for sharing!
[+] [-] seiflotfy|4 years ago|reply You can run the same query with a query builder here https://play.axiom.co/axiom-play-qf1k/datasets/github-issues...I changed it to 90 days :D [+] [-] ucirello|4 years ago|reply that reminds of that presentation about Google's monorepo, in which a graph makes the distinction of the commits made by humans versus done by bots. The bots there were really active. load replies (1)
[+] [-] ucirello|4 years ago|reply that reminds of that presentation about Google's monorepo, in which a graph makes the distinction of the commits made by humans versus done by bots. The bots there were really active. load replies (1)
[+] [-] abahlo|4 years ago|reply Wow, dependabot opened 2.7 Million PRs in the last 30 days https://play.axiom.co/axiom-play-qf1k/explorer?qid=blX8pIiTb... [+] [-] tolatemitope|4 years ago|reply [deleted]
[+] [-] elesbao|4 years ago|reply how big is the dataset ? I am wondering that if this is a month worth of bots comment that's a lot of data and the interface feels snappy. [+] [-] seiflotfy|4 years ago|reply the query is faster is written is follows``` ['github-issue-comment-event'] | where actor contains "-bot" or actor contains "[bot]" | summarize count() by bin_auto(_time), actor | take 20 ``` [+] [-] seiflotfy|4 years ago|reply 90 days only we will backfill at some point but we need to test a bit more
[+] [-] seiflotfy|4 years ago|reply the query is faster is written is follows``` ['github-issue-comment-event'] | where actor contains "-bot" or actor contains "[bot]" | summarize count() by bin_auto(_time), actor | take 20 ```
[+] [-] seiflotfy|4 years ago|reply 90 days only we will backfill at some point but we need to test a bit more
[+] [-] seiflotfy|4 years ago|reply
I changed it to 90 days :D
[+] [-] ucirello|4 years ago|reply
[+] [-] abahlo|4 years ago|reply
[+] [-] tolatemitope|4 years ago|reply
[deleted]
[+] [-] elesbao|4 years ago|reply
[+] [-] seiflotfy|4 years ago|reply
``` ['github-issue-comment-event'] | where actor contains "-bot" or actor contains "[bot]" | summarize count() by bin_auto(_time), actor | take 20 ```
[+] [-] seiflotfy|4 years ago|reply
[+] [-] r0dms|4 years ago|reply