# Any api to purge old deleted posts / uploads

**URL:** https://meta.discourse.org/t/any-api-to-purge-old-deleted-posts-uploads/73495
**Category:** Support
**Created:** [November 6, 2017, 8:59am UTC](https://meta.discourse.org/t/any-api-to-purge-old-deleted-posts-uploads/73495 "2017-11-06T08:59:10Z")
**Posts on this page:** 1
**Showing post:** 7

<div class="post-metadata">

### Author: ![nathank](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/nathank/32/290039_2.png) [@nathank](https://meta.discourse.org/u/nathank)
#### Post date: [August 27, 2021, 11:52pm UTC](https://meta.discourse.org/t/any-api-to-purge-old-deleted-posts-uploads/73495/7 "2021-08-27T23:52:02Z")

</div>

## Call for Help!

Can a clever person walk me through combining:

> [@adopilot](#):
>
> ```plaintext
> SELECT 
> post_uploads.id
> -- ,uploads.filesize
> -- ,posts.id
> --,topics.id
> FROM 
> public.topics
> inner join public.posts on topics.id=posts.topic_id
> inner join public.post_uploads on posts.id=post_uploads.post_id
> inner join public.uploads on post_uploads.upload_id=uploads.id
> WHERE 
> topics.deleted_by_id is not null
> )
> 
> ```

### AND

> [@zogstrip](#):
>
> ```plaintext
> ./launcher enter app
> rails db
> DELETE FROM post_uploads WHERE post_id IN (SELECT id FROM posts WHERE deleted_at IS NOT NULL)
> 
> ```

to make an awesome orphaned uploads purger run from the console?

I note that when I use `rails db`, I’m asked for `Password for user discourse:`. What do I do with that?

---

_[View the full topic](https://meta.discourse.org/t/any-api-to-purge-old-deleted-posts-uploads/73495)._