Math.Stackexchange.com welcomes its $100\,000^{\text{th}}$ user. I don't think you'll get cookies, but even better you'll get your questions answered.

  • 2
    $\begingroup$ welcome!! @GolovachLena $\endgroup$
    – what'sup
    Commented Oct 10, 2013 at 22:05
  • 4
    $\begingroup$ Seems to me like a good addition to the milestones page. $\endgroup$
    – Dan Rust
    Commented Oct 10, 2013 at 22:23
  • 11
    $\begingroup$ Well, if there is a user with number 100000, this does not exactly mean that MSE has 100000 users. Merged accounts, deleted users, probably other things,.... (But it definitely is a close approximation.) $\endgroup$ Commented Oct 11, 2013 at 6:09
  • 2
    $\begingroup$ @Martin: Also the user number includes unregistered accounts. $\endgroup$
    – Asaf Karagila Mod
    Commented Oct 15, 2013 at 22:30
  • 1
    $\begingroup$ Over 100000 as of January 22, 2014; added to the history thread. $\endgroup$
    – user127096
    Commented Feb 25, 2014 at 3:16

3 Answers 3


Looking at the UserId is a serious overestimate. The query

SELECT COUNT(Id) AS NumberOfUsers FROM Users

returns 82335, based on the data from October 13. (This includes both registered and unregistered accounts.)

Since September 1, new users are joining at the rate of about 180/day, see new users per day. If this continues, the user base will reach 100000 in about 3 months.

The most up-to-date available count of users (also including unregistered) is in the list of SE sites (link pointed out by Martin Sleziak). Mouse over the number of users to get a more precise figure.

The older version of this post used

SELECT COUNT(*) AS NumberOfUsers FROM Users

which undercounts table rows by a thousand or so, for reasons that transcend my limited knowledge of SQL.

  • 5
    $\begingroup$ And as I type this it’s down to $81117$. $\endgroup$ Commented Oct 13, 2013 at 22:34
  • $\begingroup$ BTW number of the users is shown in the list of sites in SE network, too. (I am not sure how often it is updated.) This number says 82848 at the moment. $\endgroup$ Commented Oct 15, 2013 at 18:17
  • $\begingroup$ @MartinSleziak The site list at stackexchange.com is updated at least daily, so it may be the best approximation to the current number of users. It's at 82904 now. $\endgroup$
    – user98130
    Commented Oct 16, 2013 at 0:06
  • $\begingroup$ @BrianM.Scott Thanks for pointing out the drop; this was certainly an SQL artifact rather than an actual drop in the number of users. I modified the query to obtain a hopefully correct count. $\endgroup$
    – user98130
    Commented Oct 16, 2013 at 0:37
  • $\begingroup$ 98766 users as of my writing this. $\endgroup$ Commented Jan 13, 2014 at 12:48

... and closes her* post as off-topic.

This question is missing context or other details

  • assuming the name is real, which I doubt.

Golovach Lena => Головач Лена => "голова члена" => "head of the penis". An old old joke.

  • 3
    $\begingroup$ seems like reason to celebrate..... $\endgroup$ Commented Oct 11, 2013 at 1:40
  • 11
    $\begingroup$ Classic. ${}{} $ $\endgroup$ Commented Oct 11, 2013 at 2:29
  • 5
    $\begingroup$ Very ironic.... $\endgroup$
    – Prism
    Commented Oct 11, 2013 at 2:36
  • 7
    $\begingroup$ And every comment ends with " Golovach Lena is Love!!!"... $\endgroup$
    – user61527
    Commented Oct 11, 2013 at 3:59
  • $\begingroup$ @T.Bongers Hmm, is seems that the comments have been edited to remove the phrase. $\endgroup$
    – JRN
    Commented Oct 16, 2013 at 6:17

As others have pointed out, these kind of ID numbers (usually surrogate database keys) should not be used to count table rows, even disregarding deleted/merged accounts. Databases often produce "holes" in the sequence, (and that's considered ok) because of the need to deal with concurrency and transactions.




You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .