Tuesday, May 05, 2020

Who Contributed to PostgreSQL Development in 2019?

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.

 #  |       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)

Here are all of the committers of non-self-authored code.

 #  |     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)

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.

        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)

Thanks as always to all who contributed. Apologies that it took so long to get this post out.

6 comments:

  1. Are .po files considered as sources? :-)

    ReplyDelete
    Replies
    1. No. 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.

      Delete
  2. Thanks for these interesting stats!

    ReplyDelete
  3. Hello Robert
    is there any change to be one of the Contributor ?

    ReplyDelete
  4. The "80 posts" -- is that counting all replies? Or only top posts?

    ReplyDelete