Create list of links to all soft-deleted posts

Continuing the discussion from Introducing permanently delete post functionality:

Is it possible to create a list of links to all soft-deleted posts?

Also, I’d be interested to find out how much space they take up in the database.

I don’t think regular text posts take up much space in the database at all, though I don’t know how to measure that. :slight_smile:

You should be able to create a list of all the soft-deleted posts using something based on WHERE posts.deleted_at IS NOT NULL, though you may also want to pick out those posts which aren’t deleted themselves, but are attached to a deleted topic.

1 Like

Would exporting the result to a file with data explorer be a good approximation of the space they take?

But I think it should be negligible whether we’re talking about disk space, memory consumption, loading speed or anything else.

1 Like