# How much post editing/revision are my users doing?

**URL:** <https://meta.discourse.org/t/how-much-post-editing-revision-are-my-users-doing/75499>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [6 Diciembre, 2017 04:43 UTC](https://meta.discourse.org/t/how-much-post-editing-revision-are-my-users-doing/75499 "2017-12-06T04:43:08Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![simon](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/simon/32/339122_2.png) [@simon](https://meta.discourse.org/u/simon)\
**Post date:** [6 Diciembre, 2017 08:09 UTC](https://meta.discourse.org/t/how-much-post-editing-revision-are-my-users-doing/75499/3 "2017-12-06T08:09:32Z")

</div>

There is information about revisions in the `post_revisions` table. You can run these as [Data Explorer](https://meta.discourse.org/t/32566?silent=true) queries The first will give the number of revisions per post, the second gives the number of unique users who have edited a post.

```sql
SELECT
pr.post_id,
count(pr.post_id) AS revisions
FROM post_revisions pr
GROUP BY pr.post_id
ORDER BY revisions DESC
LIMIT 50

```

```sql
SELECT
pr.post_id,
COUNT(DISTINCT pr.user_id) AS reviser_count
FROM post_revisions pr
GROUP BY pr.post_id
ORDER BY reviser_count DESC
LIMIT 50

```

There is a lot more that could be done with this.

---

_[View the full topic](https://meta.discourse.org/t/how-much-post-editing-revision-are-my-users-doing/75499)._