Summarizer

HN Thread Summary
1 Fetch Pages
→
2 Extract Text
→
3 Analyze Content
→
4 Tag Comments
→
5 Summarize Topics

Total monthly number of StackOverflow questions over time

947 comments · 65,980 words

Complete Created: Jan 5, 12:13 PM (00:11:59)

Models: Claude Opus 4.5 (analyze) · Gemini 3 Flash (tag) · Gemini 3 Flash (summarize)

Article URL: https://data.stackexchange.com/stackoverflow/query/1926661#graph

Article Summary

The article appears to be missing or empty, but the discussion centers around a dramatic decline in Stack Overflow question volume, as shown by data visualization. The graph reveals that Stack Overflow questions have dropped from peaks of around 160,000+ monthly questions in the mid-2010s to approximately 300-4,000 questions per month in 2025, representing a near-complete collapse of the platform's activity.

Comment Summary

The discussion reveals a complex debate about Stack Overflow's decline, with commenters split between blaming toxic moderation culture and LLMs as the primary causes. Many users share personal experiences of hostile moderators, questions being incorrectly closed as duplicates, and a bureaucratic culture that prioritized rule enforcement over helping users. Former SO employees and moderators defend the site's mission as a knowledge repository rather than a help desk, while critics argue this distinction drove users away. The consensus suggests moderation issues preceded LLMs but that ChatGPT's 2022 release accelerated the decline dramatically. Commenters express concern about the loss of human-generated technical knowledge and worry about what LLMs will train on in the future.

Topics

Raw Files

HN HTML HN Text

Execution Log

[2026-01-05T20:13:20.288Z] Starting step: fetch_pages (attempt 1)
[2026-01-05T20:13:20.338Z] Fetching HN page: https://news.ycombinator.com/item?id=46482345
[2026-01-05T20:13:20.561Z] Fetched HN page: 1593130 bytes
[2026-01-05T20:13:20.816Z] Extracted title: Total monthly number of StackOverflow questions over time
[2026-01-05T20:13:20.873Z] Extracted linked URL: https://data.stackexchange.com/stackoverflow/query/1926661#graph
[2026-01-05T20:13:20.908Z] Fetching linked article: https://data.stackexchange.com/stackoverflow/query/1926661#graph
[2026-01-05T20:13:20.986Z] Warning: Failed to fetch linked article: Failed to fetch https://data.stackexchange.com/stackoverflow/query/1926661#graph: 403 Forbidden
[2026-01-05T20:13:21.049Z] Completed step: fetch_pages in 729ms
[2026-01-05T20:13:21.306Z] Starting step: extract_text (attempt 1)
[2026-01-05T20:13:21.489Z] Extracted HN text: 439292 chars
[2026-01-05T20:13:21.687Z] Extracted 947 comments
[2026-01-05T20:13:21.904Z] Comment word count: 65980
[2026-01-05T20:13:21.994Z] Completed step: extract_text in 650ms
[2026-01-05T20:13:22.154Z] Starting step: analyze_content (attempt 1)
[2026-01-05T20:13:22.333Z] Calling Claude Opus 4.5 (article: 0 chars, 800 comments (sampled 800 of 947))
[2026-01-05T20:13:36.786Z] Claude analysis complete: 20 topics, 78882 input tokens, 386 output tokens
[2026-01-05T20:13:36.854Z] Completed step: analyze_content in 14669ms
[2026-01-05T20:13:36.998Z] Starting step: tag_comments (attempt 1)
[2026-01-05T20:13:37.079Z] Tagging 947 comments with 20 topics (batch size: 50)
[2026-01-05T20:13:37.106Z] Processing batch 1/19 (50 comments)
[2026-01-05T20:14:16.180Z] Batch 1 complete: 72 tags assigned
[2026-01-05T20:14:16.210Z] Processing batch 2/19 (50 comments)
[2026-01-05T20:14:38.432Z] Batch 2 complete: 91 tags assigned
[2026-01-05T20:14:38.460Z] Processing batch 3/19 (50 comments)
[2026-01-05T20:15:01.534Z] Batch 3 complete: 90 tags assigned
[2026-01-05T20:15:01.593Z] Processing batch 4/19 (50 comments)
[2026-01-05T20:15:30.108Z] Batch 4 complete: 82 tags assigned
[2026-01-05T20:15:30.143Z] Processing batch 5/19 (50 comments)
[2026-01-05T20:15:58.252Z] Batch 5 complete: 95 tags assigned
[2026-01-05T20:15:58.283Z] Processing batch 6/19 (50 comments)
[2026-01-05T20:16:33.092Z] Batch 6 complete: 89 tags assigned
[2026-01-05T20:16:33.126Z] Processing batch 7/19 (50 comments)
[2026-01-05T20:16:59.266Z] Batch 7 complete: 78 tags assigned
[2026-01-05T20:16:59.302Z] Processing batch 8/19 (50 comments)
[2026-01-05T20:17:25.414Z] Batch 8 complete: 79 tags assigned
[2026-01-05T20:17:25.448Z] Processing batch 9/19 (50 comments)
[2026-01-05T20:17:51.471Z] Batch 9 complete: 85 tags assigned
[2026-01-05T20:17:51.499Z] Processing batch 10/19 (50 comments)
[2026-01-05T20:18:14.026Z] Batch 10 complete: 86 tags assigned
[2026-01-05T20:18:14.061Z] Processing batch 11/19 (50 comments)
[2026-01-05T20:18:32.207Z] Batch 11 complete: 84 tags assigned
[2026-01-05T20:18:32.239Z] Processing batch 12/19 (50 comments)
[2026-01-05T20:19:01.105Z] Batch 12 complete: 78 tags assigned
[2026-01-05T20:19:01.140Z] Processing batch 13/19 (50 comments)
[2026-01-05T20:19:26.306Z] Batch 13 complete: 52 tags assigned
[2026-01-05T20:19:26.338Z] Processing batch 14/19 (50 comments)
[2026-01-05T20:19:57.631Z] Batch 14 complete: 103 tags assigned
[2026-01-05T20:19:57.662Z] Processing batch 15/19 (50 comments)
[2026-01-05T20:20:28.383Z] Batch 15 complete: 92 tags assigned
[2026-01-05T20:20:28.413Z] Processing batch 16/19 (50 comments)
[2026-01-05T20:20:54.676Z] Batch 16 complete: 82 tags assigned
[2026-01-05T20:20:54.705Z] Processing batch 17/19 (50 comments)
[2026-01-05T20:21:37.125Z] Batch 17 complete: 80 tags assigned
[2026-01-05T20:21:37.157Z] Processing batch 18/19 (50 comments)
[2026-01-05T20:22:04.678Z] Batch 18 complete: 73 tags assigned
[2026-01-05T20:22:04.731Z] Processing batch 19/19 (47 comments)
[2026-01-05T20:22:34.733Z] Batch 19 complete: 78 tags assigned
[2026-01-05T20:22:34.767Z] Tagging complete: 1569 total tags, 120661 input tokens, 23723 output tokens
[2026-01-05T20:22:34.797Z] Completed step: tag_comments in 537770ms
[2026-01-05T20:22:34.941Z] Starting step: summarize_topics (attempt 1)
[2026-01-05T20:22:34.988Z] Summarizing 20 topics
[2026-01-05T20:22:35.074Z] Summarizing topic 1/20: "Toxic moderation culture" (227 comments)
[2026-01-05T20:22:43.277Z] Topic 1 summarized (25815 in, 165 out)
[2026-01-05T20:22:43.333Z] Summarizing topic 2/20: "LLMs replacing Stack Overflow" (222 comments)
[2026-01-05T20:22:51.305Z] Topic 2 summarized (23004 in, 145 out)
[2026-01-05T20:22:51.356Z] Summarizing topic 3/20: "Duplicate question closures" (96 comments)
[2026-01-05T20:22:59.303Z] Topic 3 summarized (15921 in, 179 out)
[2026-01-05T20:22:59.371Z] Summarizing topic 4/20: "Knowledge repository vs help desk debate" (87 comments)
[2026-01-05T20:23:07.312Z] Topic 4 summarized (16600 in, 155 out)
[2026-01-05T20:23:07.380Z] Summarizing topic 5/20: "Community decline timeline" (141 comments)
[2026-01-05T20:23:15.529Z] Topic 5 summarized (11341 in, 159 out)
[2026-01-05T20:23:15.577Z] Summarizing topic 6/20: "Discord as alternative platform" (19 comments)
[2026-01-05T20:23:25.006Z] Topic 6 summarized (1990 in, 149 out)
[2026-01-05T20:23:25.065Z] Summarizing topic 7/20: "Future of LLM training data" (88 comments)
[2026-01-05T20:23:32.311Z] Topic 7 summarized (7527 in, 189 out)
[2026-01-05T20:23:32.362Z] Summarizing topic 8/20: "Gamification and reputation systems" (74 comments)
[2026-01-05T20:23:40.542Z] Topic 8 summarized (9863 in, 177 out)
[2026-01-05T20:23:40.593Z] Summarizing topic 9/20: "Expert knowledge preservation" (71 comments)
[2026-01-05T20:23:47.885Z] Topic 9 summarized (7578 in, 170 out)
[2026-01-05T20:23:47.933Z] Summarizing topic 10/20: "Reddit as alternative" (25 comments)
[2026-01-05T20:23:55.914Z] Topic 10 summarized (2704 in, 131 out)
[2026-01-05T20:23:55.987Z] Summarizing topic 11/20: "Question quality standards" (85 comments)
[2026-01-05T20:24:08.996Z] Topic 11 summarized (11200 in, 151 out)
[2026-01-05T20:24:09.044Z] Summarizing topic 12/20: "Moderator power dynamics" (89 comments)
[2026-01-05T20:24:17.745Z] Topic 12 summarized (12866 in, 166 out)
[2026-01-05T20:24:17.792Z] Summarizing topic 13/20: "Google search integration decline" (42 comments)
[2026-01-05T20:24:25.970Z] Topic 13 summarized (4685 in, 177 out)
[2026-01-05T20:24:26.021Z] Summarizing topic 14/20: "Stack Exchange expansion problems" (14 comments)
[2026-01-05T20:24:33.288Z] Topic 14 summarized (1637 in, 160 out)
[2026-01-05T20:24:33.343Z] Summarizing topic 15/20: "Human interaction loss" (64 comments)
[2026-01-05T20:24:40.499Z] Topic 15 summarized (7396 in, 166 out)
[2026-01-05T20:24:40.548Z] Summarizing topic 16/20: "Documentation vs community answers" (32 comments)
[2026-01-05T20:24:47.196Z] Topic 16 summarized (2977 in, 135 out)
[2026-01-05T20:24:47.260Z] Summarizing topic 17/20: "Site mission misalignment" (59 comments)
[2026-01-05T20:24:55.929Z] Topic 17 summarized (10638 in, 172 out)
[2026-01-05T20:24:55.985Z] Summarizing topic 18/20: "New user experience" (66 comments)
[2026-01-05T20:25:02.711Z] Topic 18 summarized (7252 in, 156 out)
[2026-01-05T20:25:02.763Z] Summarizing topic 19/20: "GitHub Discussions alternative" (17 comments)
[2026-01-05T20:25:10.418Z] Topic 19 summarized (1754 in, 150 out)
[2026-01-05T20:25:10.469Z] Summarizing topic 20/20: "Corporate ownership changes" (51 comments)
[2026-01-05T20:25:19.081Z] Topic 20 summarized (6292 in, 162 out)
[2026-01-05T20:25:19.110Z] Summarization complete: 20 topics, 189040 input tokens, 3214 output tokens
[2026-01-05T20:25:19.140Z] Completed step: summarize_topics in 164171ms
[2026-01-05T20:25:19.216Z] Job completed successfully

LLM Invocations

Time Purpose Model Duration Outcome Input Output Cost
12:13 PM Generate summaries claude-opus-4-5-20251101 14.1s Success Input (78,882) Output (386) -
12:14 PM Tag comments gemini-3-flash-preview 38.7s Success Input (7,098) Output (1,172) -
12:14 PM Tag comments gemini-3-flash-preview 21.9s Success Input (9,286) Output (1,616) -
12:15 PM Tag comments gemini-3-flash-preview 22.6s Success Input (7,956) Output (1,206) -
12:15 PM Tag comments gemini-3-flash-preview 27.9s Success Input (7,270) Output (1,582) -
12:15 PM Tag comments gemini-3-flash-preview 27.7s Success Input (9,099) Output (1,223) -
12:16 PM Tag comments gemini-3-flash-preview 34.4s Success Input (7,021) Output (1,198) -
12:16 PM Tag comments gemini-3-flash-preview 25.8s Success Input (4,733) Output (1,180) -
12:17 PM Tag comments gemini-3-flash-preview 25.7s Success Input (7,099) Output (1,195) -
12:17 PM Tag comments gemini-3-flash-preview 25.2s Success Input (4,516) Output (1,189) -
12:18 PM Tag comments gemini-3-flash-preview 22.1s Success Input (5,431) Output (1,194) -
12:18 PM Tag comments gemini-3-flash-preview 17.8s Success Input (5,671) Output (1,196) -
12:19 PM Tag comments gemini-3-flash-preview 28.5s Success Input (6,107) Output (1,178) -
12:19 PM Tag comments gemini-3-flash-preview 24.8s Success Input (6,964) Output (1,117) -
12:19 PM Tag comments gemini-3-flash-preview 30.9s Success Input (8,015) Output (1,627) -
12:20 PM Tag comments gemini-3-flash-preview 30.3s Success Input (5,901) Output (1,201) -
12:20 PM Tag comments gemini-3-flash-preview 25.8s Success Input (5,180) Output (1,183) -
12:21 PM Tag comments gemini-3-flash-preview 42.1s Success Input (4,677) Output (1,179) -
12:22 PM Tag comments gemini-3-flash-preview 27.1s Success Input (3,785) Output (1,164) -
12:22 PM Tag comments gemini-3-flash-preview 29.6s Success Input (4,852) Output (1,123) -
12:22 PM Summarize topic gemini-3-flash-preview 7.8s Success Input (25,815) Output (165) -
12:22 PM Summarize topic gemini-3-flash-preview 7.6s Success Input (23,004) Output (145) -
12:22 PM Summarize topic gemini-3-flash-preview 7.5s Success Input (15,921) Output (179) -
12:23 PM Summarize topic gemini-3-flash-preview 7.6s Success Input (16,600) Output (155) -
12:23 PM Summarize topic gemini-3-flash-preview 7.8s Success Input (11,341) Output (159) -
12:23 PM Summarize topic gemini-3-flash-preview 7.6s Success Input (1,990) Output (149) -
12:23 PM Summarize topic gemini-3-flash-preview 6.9s Success Input (7,527) Output (189) -
12:23 PM Summarize topic gemini-3-flash-preview 7.8s Success Input (9,863) Output (177) -
12:23 PM Summarize topic gemini-3-flash-preview 6.9s Success Input (7,578) Output (170) -
12:23 PM Summarize topic gemini-3-flash-preview 7.6s Success Input (2,704) Output (131) -
12:24 PM Summarize topic gemini-3-flash-preview 12.6s Success Input (11,200) Output (151) -
12:24 PM Summarize topic gemini-3-flash-preview 8.3s Success Input (12,866) Output (166) -
12:24 PM Summarize topic gemini-3-flash-preview 7.7s Success Input (4,685) Output (177) -
12:24 PM Summarize topic gemini-3-flash-preview 6.9s Success Input (1,637) Output (160) -
12:24 PM Summarize topic gemini-3-flash-preview 6.8s Success Input (7,396) Output (166) -
12:24 PM Summarize topic gemini-3-flash-preview 6.3s Success Input (2,977) Output (135) -
12:24 PM Summarize topic gemini-3-flash-preview 8.3s Success Input (10,638) Output (172) -
12:25 PM Summarize topic gemini-3-flash-preview 6.2s Success Input (7,252) Output (156) -
12:25 PM Summarize topic gemini-3-flash-preview 7.2s Success Input (1,754) Output (150) -
12:25 PM Summarize topic gemini-3-flash-preview 8.2s Success Input (6,292) Output (162) -

← Back to all jobs