Developer Queries

This page documents useful queries to perform to look at recent developer activity:

git Queries

Committers from Date

xdev2 funtoo-overlay # git log --stat --after '04-01-2013' | grep Author: | sort -u
Author: Alexander Reitzel <shiin@funtoo.org>
Author: Daniel Robbins <drobbins@funtoo.org>
Author: Jean-Francis Roy <jeanfrancisroy@gmail.com>
Author: Oleg Vinichenko <oleg@funtoo.org>

JIRA PostgreSQL Queries

Top Commenters

jiradb=# SELECT author, count(author) as comments FROM jiraaction j WHERE UPDATED > now() - interval '30 days' group by author ORDER BY comments DESC limit 10;   
author    | comments -------------+---------- 
oleg        |       55 
drobbins    |       29 
golodhrim   |       14 
arithmos    |       12 
jeanfrancis |       11 
fearedbliss |       10 
overkill    |        8 
janzhou     |        7 
anak1n      |        6 
sputnik     |        5
(10 rows)