# 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:** [2017年十二月6日 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:** 7
**Page:** 1
### Author:  [@bombledmonk](https://meta.discourse.org/u/bombledmonk)
#### Post date: [2017年十二月6日 04:43 UTC](https://meta.discourse.org/t/how-much-post-editing-revision-are-my-users-doing/75499/1 "2017-12-06T04:43:08Z")
This is probably an edge case, but I’m curious to understand how much Editing/Revision is going on on my site. There are stats for Topics Viewed, Posts Viewed, Read Time, etc, but I’m looking also for how many edits a person has done. Is there any way to extract this somehow?
The reason why i’m curious is that there’s people publishing and editing content on the website and there may be multiple people revising the same Topical post, but there’s not really a good way to metric when multiple people have contributed, nor their level of contribution. The people primarily revising content are essentially invisible.
---
### Author:  [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [2017年十二月6日 06:00 UTC](https://meta.discourse.org/t/how-much-post-editing-revision-are-my-users-doing/75499/2 "2017-12-06T06:00:34Z")
You could probably formulate a [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query to get this data out of the raw database.
---
### Author:  [@simon](https://meta.discourse.org/u/simon)
#### Post date: [2017年十二月6日 08:09 UTC](https://meta.discourse.org/t/how-much-post-editing-revision-are-my-users-doing/75499/3 "2017-12-06T08:09:32Z")
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.
---
### Author:  [@bombledmonk](https://meta.discourse.org/u/bombledmonk)
#### Post date: [2017年十二月6日 15:50 UTC](https://meta.discourse.org/t/how-much-post-editing-revision-are-my-users-doing/75499/4 "2017-12-06T15:50:59Z")
Kind of a silly question, but I can’t seem to find the [data explorer](https://meta.discourse.org/t/32566?silent=true) anymore. I could swear it was enabled on our instance previously, but for the life of me I can’t find it.
---
### Author:  [@simon](https://meta.discourse.org/u/simon)
#### Post date: [2017年十二月6日 16:12 UTC](https://meta.discourse.org/t/how-much-post-editing-revision-are-my-users-doing/75499/5 "2017-12-06T16:12:02Z")
I checked for it on your forum and it’s not installed. We can add it.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [2020年二月8日 21:56 UTC](https://meta.discourse.org/t/how-much-post-editing-revision-are-my-users-doing/75499/6 "2020-02-08T21:56:36Z")
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [2020年三月9日 22:03 UTC](https://meta.discourse.org/t/how-much-post-editing-revision-are-my-users-doing/75499/7 "2020-03-09T22:03:46Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.