Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

I can see that every StackOverflow question has its own id, but how can I see which question is the question #1,000,000? In general: How can I find out the serial number of a question?

Update: As I get it now, is "serial number" the wrong expression. I'm asking for the first question which will let the total question count climb the million number range.

share|improve this question

Yes, I don't think it is that easy either. There isn't any property of a question that would make it obvious. The question number is approaching 4 million right now. I assume that the question count is fairly heavily cached, far too expensive to calculate for every page refresh. So the storm of page refreshes when it gets close isn't going to show the winner. And it is very dynamic with questions getting deleted all the time, #1M can be (will be) #999,999 a second later.

Knowing the SO team, I bet they've programmed some kind of custom trigger that flashes a Unicorn page up for at least 5 minutes so the number is stable for at least that long. Looking forward to it, hope it's a good question. And have the honor to get the answer mark for it :)

share|improve this answer

Here's a data explorer query to find question number n. This doesn't include deleted questions.

share|improve this answer
Cool! Never know about this. – splash Oct 9 '10 at 21:39
Note that if deleted question are not counted, the answer will change in time. – dmckee Oct 10 '10 at 1:46

Wel if you're talking 1,000,000 for the database Id then you can see the question here

share|improve this answer
This is just the 1 millionth post (could be answer or tag-wiki). – kennytm Oct 9 '10 at 20:48
Well, it is the question number in this case, but it is an year old and counts other posts too. – Kobi Oct 9 '10 at 20:51
The database ID counts questions and answers alike. It is already above 3 million – Pëkka Oct 9 '10 at 21:00

You can probably see it in the blog.
I'm not how you can find it yourself. You can probably use the data dump to find the nth question, but it doesn't include deleted posts. Without deleted posts, you can't have a nth question.

share|improve this answer

You must log in to answer this question.

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