This is my fourth annual post on who contributes to PostgreSQL development. See previous posts in this series for methodology. I calculate that this year, 189 people were primary authors of at least one PostgreSQL commit. 37 of those people accounted for 90% of the new lines, and 12 people accounted for 66% of the new lines. In total, there were 2127 commits by 26 committers. The work of committing patches written by someone other than the committer was principally shared by 5 committers who committed 66% of the lines of non-self-authored code; 10 committers accounted for 90% of the lines of non-self-authored code.
Here are the top 37 contributors by lines added to PostgreSQL in 2019.
Here are all of the committers of non-self-authored code.
Here is a list of everyone who wrote at least 80 emails to pgsql-hackers this year, along with the number of posts. This covers about 79% of the total posts. This list was prepared by me, using a Perl script to parse the mbox files. I apologize for any inaccuracies.
Thanks as always to all who contributed. Apologies that it took so long to get this post out.
Here are the top 37 contributors by lines added to PostgreSQL in 2019.
# | author | lines | pct_lines | commits
----+--------------------+-------+-----------+---------
1 | Tom Lane | 34496 | 17.10 | 379
2 | Andres Freund | 21320 | 10.57 | 137
3 | Peter Eisentraut | 20749 | 10.29 | 274
4 | Nikita Glukhov | 13211 | 6.55 | 21
5 | Alvaro Herrera | 7291 | 3.61 | 95
6 | Andrew Gierth | 7000 | 3.47 | 20
7 | Tomas Vondra | 6536 | 3.24 | 48
8 | Michael Paquier | 6483 | 3.21 | 126
9 | David Rowley | 5513 | 2.73 | 36
10 | Amit Langote | 5453 | 2.70 | 47
11 | Peter Geoghegan | 4700 | 2.33 | 65
12 | Bruce Momjian | 4381 | 2.17 | 74
13 | John Naylor | 4359 | 2.16 | 20
14 | Noah Misch | 4107 | 2.04 | 49
15 | Alexander Korotkov | 3383 | 1.68 | 36
16 | Heikki Linnakangas | 2846 | 1.41 | 23
17 | Fabien Coelho | 2671 | 1.32 | 26
18 | Robbie Harwood | 2569 | 1.27 | 1
19 | Robert Haas | 2565 | 1.27 | 30
20 | Ideriha Takeshi | 2332 | 1.16 | 1
21 | Matsumura Ryo | 2149 | 1.07 | 3
22 | Haribabu Kommi | 1900 | 0.94 | 10
23 | Thomas Munro | 1762 | 0.87 | 53
24 | Etsuro Fujita | 1390 | 0.69 | 28
25 | Masahiko Sawada | 1318 | 0.65 | 16
26 | Andrey Borodin | 1136 | 0.56 | 5
27 | Julien Rouhaud | 1125 | 0.56 | 14
28 | Dmitry Dolgov | 1119 | 0.55 | 4
29 | Dean Rasheed | 1108 | 0.55 | 7
30 | Craig Ringer | 1032 | 0.51 | 5
31 | Shawn Debnath | 960 | 0.48 | 2
32 | Vignesh C | 863 | 0.43 | 9
33 | Alexander Lakhin | 824 | 0.41 | 24
34 | Chapman Flack | 809 | 0.40 | 4
35 | Jürgen Purtz | 802 | 0.40 | 2
36 | Li Japin | 693 | 0.34 | 1
37 | Brandur Leach | 689 | 0.34 | 1
(37 rows)
# | committer | lines | pct_lines | commits
----+--------------------+-------+-----------+---------
1 | Tom Lane | 14299 | 19.68 | 115
2 | Alexander Korotkov | 14275 | 19.65 | 28
3 | Alvaro Herrera | 9982 | 13.74 | 68
4 | Michael Paquier | 7349 | 10.11 | 175
5 | Michael Meskes | 4789 | 6.59 | 9
6 | Peter Eisentraut | 4185 | 5.76 | 31
7 | Amit Kapila | 3863 | 5.32 | 36
8 | Stephen Frost | 2633 | 3.62 | 2
9 | Andres Freund | 2608 | 3.59 | 27
10 | Thomas Munro | 1453 | 2.00 | 18
11 | Robert Haas | 1403 | 1.93 | 18
12 | Tomas Vondra | 1252 | 1.72 | 11
13 | Heikki Linnakangas | 1085 | 1.49 | 7
14 | Andrew Dunstan | 766 | 1.05 | 10
15 | Peter Geoghegan | 756 | 1.04 | 4
16 | Etsuro Fujita | 500 | 0.69 | 7
17 | Fujii Masao | 450 | 0.62 | 11
18 | Dean Rasheed | 413 | 0.57 | 2
19 | Magnus Hagander | 284 | 0.39 | 11
20 | Joe Conway | 192 | 0.26 | 4
21 | David Rowley | 64 | 0.09 | 3
22 | Jeff Davis | 31 | 0.04 | 2
23 | Andrew Gierth | 11 | 0.02 | 1
24 | Noah Misch | 10 | 0.01 | 3
25 | Bruce Momjian | 8 | 0.01 | 5
(25 rows)
name | count
---------------------+-------
Tom Lane | 2687
Michael Paquier | 1878
Andres Freund | 1566
Alvaro Herrera | 1329
Robert Haas | 1053
Kyotaro Horiguchi | 846
Peter Eisentraut | 810
Tomas Vondra | 804
Thomas Munro | 707
Amit Kapila | 641
Amit Langote | 575
David Rowley | 513
Peter Geoghegan | 463
Fabien Coelho | 445
Stephen Frost | 409
Bruce Momjian | 406
Pavel Stehule | 372
Masahiko Sawada | 354
Justin Pryzby | 343
Andrew Dunstan | 276
Julien Rouhaud | 254
Alexander Korotkov | 253
David Fetter | 229
Etsuro Fujita | 227
Dilip Kumar | 202
Konstantin Knizhnik | 196
Antonin Houska | 183
Takayuki Tsunakawa | 182
Heikki Linnakangas | 177
Magnus Hagander | 168
Andrew Gierth | 165
Chapman Flack | 164
David Steele | 150
Nikita Glukhov | 150
Daniel Gustafsson | 146
John Naylor | 140
Noah Misch | 134
Fujii Masao | 128
Andrey Borodin | 122
Dmitry Dolgov | 120
Sergei Kornilov | 119
Haribabu Kommi | 113
Vignesh C | 110
Mark Dilger | 103
Amit Khandekar | 95
Joe Conway | 94
Ashwin Agrawal | 89
Ibrar Ahmed | 89
Jonathan S. Katz | 87
Surafel Temesgen | 83
Laurenz Albe | 83
Dave Cramer | 80
Christoph Berg | 80
(53 rows)
Are .po files considered as sources? :-)
ReplyDeleteNo. Translation updates and some other large mechanical commits are excluded. It would be great to have other statistics that capture the contributions of translators, as well as other roles: conference organizers, bloggers, bug reporters, maintainers of drivers and other software that is part of the PostgreSQL ecosystem, etc. This is my contribution to what would ideally be a larger effort to measure and recognize contributions.
DeleteThanks for these interesting stats!
ReplyDeleteHello Robert
ReplyDeleteis there any change to be one of the Contributor ?
The "80 posts" -- is that counting all replies? Or only top posts?
ReplyDeleteAll emails.
Delete