# Consulta de Discourse sobre el tiempo total de lectura

**URL:** <https://meta.discourse.org/t/discourse-query-for-total-read-time/279717>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [21 Septiembre, 2023 18:37 UTC](https://meta.discourse.org/t/discourse-query-for-total-read-time/279717 "2023-09-21T18:37:15Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![codergautam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codergautam/32/261083_2.png) [@codergautam](https://meta.discourse.org/u/codergautam)\
**Post date:** [21 Septiembre, 2023 22:22 UTC](https://meta.discourse.org/t/discourse-query-for-total-read-time/279717/5 "2023-09-21T22:22:50Z")

</div>

Lo descubrí, esta consulta obtiene el tiempo total dedicado por día:

```plaintext
SELECT visited_at, SUM(time_read * 60) AS total_user_secs
FROM user_visits
GROUP BY visited_at
ORDER BY visited_at

```

Ejemplo en mi foro:

 ![image](https://global.discourse-cdn.com/meta/original/4X/5/2/2/522e966d27b3112c3f9277b45c133a9e47163ebf.png)

---

_[View the full topic](https://meta.discourse.org/t/discourse-query-for-total-read-time/279717)._