As in previous years, I've pulled together a few statistics on code contributions to PostgreSQL. See previous posts in this series for methodology and caveats. I calculate that, in 2022, there were 192 people who were the principal author of at least one PostgreSQL commit. 66% of the new lines of code were contributed by one of 14 people, and 90% of the new lines of code were contributed by one of 40 people. Here they are. Asterisks indicate non-committers.
# | author | lines | pct_lines | commits
----+-----------------------+-------+-----------+---------
1 | Tom Lane | 36623 | 14.94 | 356
2 | Andres Freund | 34140 | 13.93 | 207
3 | Peter Eisentraut | 18697 | 7.63 | 263
4 | Bruce Momjian | 9677 | 3.95 | 61
5 | Tomas Vondra | 9438 | 3.85 | 23
6 | Pavan Deolasee [*] | 8842 | 3.61 | 3
7 | Heikki Linnakangas | 8826 | 3.60 | 15
8 | Robert Haas | 7093 | 2.89 | 73
9 | Mark Dilger [*] | 6406 | 2.61 | 7
10 | Thomas Munro | 5609 | 2.29 | 132
11 | Kyotaro Horiguchi [*] | 5512 | 2.25 | 25
12 | Michael Paquier | 5361 | 2.19 | 121
13 | David Rowley | 4926 | 2.01 | 59
14 | Peter Geoghegan | 4865 | 1.99 | 61
15 | Amit Langote [*] | 4066 | 1.66 | 18
16 | Hou Zhijie [*] | 4001 | 1.63 | 20
17 | Nathan Bossart [*] | 3851 | 1.57 | 55
18 | Dilip Kumar [*] | 3299 | 1.35 | 18
19 | Alexander Korotkov | 3272 | 1.34 | 10
20 | Bharath Rupireddy [*] | 2891 | 1.18 | 36
21 | Alvaro Herrera | 2752 | 1.12 | 87
22 | Masahiko Sawada [*] | 2736 | 1.12 | 26
23 | Julien Rouhaud [*] | 2228 | 0.91 | 22
24 | Andrew Dunstan | 2137 | 0.87 | 61
25 | Peter Smith [*] | 2075 | 0.85 | 28
26 | Yugo Nagata [*] | 2034 | 0.83 | 12
27 | Justin Pryzby [*] | 1947 | 0.79 | 54
28 | Melanie Plageman [*] | 1909 | 0.78 | 15
29 | John Naylor | 1599 | 0.65 | 42
30 | Dmitry Dolgov [*] | 1574 | 0.64 | 1
31 | Joe Koshakow [*] | 1550 | 0.63 | 2
32 | Jeevan Ladhe [*] | 1481 | 0.60 | 7
33 | Daniel Gustafsson | 1457 | 0.59 | 42
34 | Jacob Champion [*] | 1437 | 0.59 | 8
35 | Christoph Heiss [*] | 1237 | 0.50 | 1
36 | Samay Sharma [*] | 1178 | 0.48 | 2
37 | Etsuro Fujita | 1079 | 0.44 | 24
38 | Richard Guo [*] | 1071 | 0.44 | 24
39 | Dipesh Pandit [*] | 1068 | 0.44 | 2
40 | Dave Page [*] | 1039 | 0.42 | 4
As usual, I'm also interested in which committers did the most work to commit patches for which they themselves were not the principal author. Here's how that looked in 2022.
# | committer | lines | pct_lines | commits
----+--------------------+-------+-----------+---------
1 | Alvaro Herrera | 14625 | 16.53 | 51
2 | Tom Lane | 12222 | 13.82 | 129
3 | Michael Paquier | 10468 | 11.83 | 205
4 | Robert Haas | 10156 | 11.48 | 52
5 | Amit Kapila | 9487 | 10.72 | 70
6 | Andres Freund | 7257 | 8.20 | 46
7 | Peter Eisentraut | 5406 | 6.11 | 60
8 | Andrew Dunstan | 3442 | 3.89 | 23
9 | Jeff Davis | 2856 | 3.23 | 9
10 | David Rowley | 2852 | 3.22 | 33
11 | Tomas Vondra | 1854 | 2.10 | 8
12 | Tatsuo Ishii | 1608 | 1.82 | 5
13 | Dean Rasheed | 1319 | 1.49 | 2
14 | Etsuro Fujita | 975 | 1.10 | 5
15 | John Naylor | 806 | 0.91 | 25
16 | Thomas Munro | 648 | 0.73 | 13
17 | Noah Misch | 641 | 0.72 | 4
18 | Alexander Korotkov | 422 | 0.48 | 7
19 | Daniel Gustafsson | 413 | 0.47 | 23
20 | Bruce Momjian | 391 | 0.44 | 13
21 | Fujii Masao | 261 | 0.30 | 12
22 | Stephen Frost | 221 | 0.25 | 1
23 | Joe Conway | 68 | 0.08 | 1
24 | Peter Geoghegan | 37 | 0.04 | 3
25 | Heikki Linnakangas | 23 | 0.03 | 2
26 | Magnus Hagander | 7 | 0.01 | 2
Finally, here are people who sent at least 100 emails to pgsql-hackers in 2022.
count | name
-------+---------------------------
2657 | Tom Lane
2403 | Andres Freund
1406 | Robert Haas
1362 | Michael Paquier
1280 | Justin Pryzby
1036 | Nathan Bossart
1008 | Amit Kapila
844 | Kyotaro Horiguchi
798 | Alvaro Herrera
786 | Peter Eisentraut
695 | Thomas Munro
635 | Bharath Rupireddy
625 | Julien Rouhaud
545 | Peter Geoghegan
532 | Andrew Dunstan
439 | Masahiko Sawada
439 | David Rowley
431 | Peter Smith
336 | David G. Johnston
325 | Tomas Vondra
325 | John Naylor
317 | Jacob Champion
301 | Bruce Momjian
299 | Daniel Gustafsson
282 | Dilip Kumar
266 | Pavel Stehule
254 | Vignesh C
244 | Aleksander Alekseev
238 | Amit Langote
229 | Simon Riggs
227 | Zhijie Hou
189 | Zhihong Yu
187 | Bertrand Drouvot
176 | Stephen Frost
173 | Ranier Vilela
169 | Greg Stark
164 | Jonathan S. Katz
162 | Japin Li
157 | Noah Misch
146 | Richard Guo
145 | Matthias Van De Meent
144 | Hayato Kuroda
134 | Mark Dilger
133 | Jeff Davis
125 | Wei Wang
113 | Fujii Masao
110 | Dagfinn Ilmari Mannsåker
108 | Osumi Takamichi
107 | Pavel Borisov
106 | Yugo Nagata
As always, it's important to keep in mind that there are many important contributions to the PostgreSQL project other than development, and that these statistics don't even fully or entirely accurately capture the work that goes into development. I present this just as an aid to understanding some of what goes on in the development community, not in any way the last word. Thanks this year to Sarah Conway for help with some of the data compilation.
No comments:
Post a Comment