Hi everyone, Is it possible to create a data explorer query which can list the “top X” topics by “estimated read time” ? I’d love to know which topics on our Discourse are the most time consuming to read :smiley: (And off topic, further to this post by @simon , I can’t seem to add a data-explorer…

[Bild] Richie: (And off topic, further to this post by @simon , I can’t seem to add a data-explorer tag to this post?) I think the approach I suggested in that topic needs to be improved. One problem with it is that only TL3 and above users can tag posts on Meta. That means that the majority…

[Bild] Richie: Is it possible to create a data explorer query which can list the “top X” topics by “estimated read time” ? Sorry for the late answer. I got caught up in the question about how to organize Data Explorer queries on the site. Using the data-explorer tag seems like the ideal solut…

Hi @simon Is that formula correct? If I pick four or five at random, and compare the estimated read time column result in this query, to the estimated read time in the topic itself, I’m getting two very different numbers? :thinking:

It looks like that query gives you the Topics that have been read for the most time, rather than the Topics that take the longest to read?

Ah, that could explain the issue. I’m guessing total_msecs_viewed is the wrong column to use here?

You can use the average time that the users take to read the topic. In that case, you can just change the SUM function to AVG, it would look like this: SELECT topic_id, category_id, AVG(total_msecs_viewed) / 60000 AS estimated_minutes_read FROM topic_users tu JOIN topics t ON t.id = t…

Thanks for the suggestion @michebs but I’m afraid that one is way off the mark too. A few examples: What the query says What the topic says 438 61 353 58 335 40 196 24

But that would mean, on average, a person takes 438 minutes to read that top topic? That seems unlikely. This may sound silly, but did you have enough 0s in 60,000? Edit: Or maybe the AVG includes all the re-readings of a topic too? So once through would be 61 minutes, but actually users spend on a…

[Bild] JammyDodger: I’m quite interested to know how the Estimated Read Time is worked out for the Summary, as ideally you’d want those to match Yes, exactly :blush:

I had a little search, and found this "There are 84 replies with an estimated read time of 0 minutes." - #9 by nbianca . I struggle with deciphering these things, but it seems it’s uses a word count x time figure (plus a minimum time to cover posts with no words, like images). There was also this o…

Data Explorer-Abfrage, um die Themen mit der längsten "geschätzten Lesezeit" aufzulisten?

Gemeinschaft Daten & Berichterstattung

simon 13. August 2021 um 21:22 3

[quote=“Richie, post:1, topic:196761”]
Ist es möglich, eine Data-Explorer-Abfrage zu erstellen, die die „Top X

Thema		Antworten	Aufrufe
Showing read time in the top categories pane in summary Feature	1	550	2. August 2018
Discourse query for total read time Data & reporting sql-query	5	589	21. September 2023
Get total list of topics and their view counts from Discourse API Development	4	1846	4. Dezember 2024
Is there any way to show approximate reading time in the topics list? Feature	11	1681	11. Mai 2021
Discourse Data Explorer Plugin official , data-explorer , included-in-core	31	82443	22. Oktober 2025

Data Explorer-Abfrage, um die Themen mit der längsten "geschätzten Lesezeit" aufzulisten?

Verwandte Themen