Checking for the PostHistory entries in the SEDE for deleted Posts, I get some results, but only a very few.

For example, there is only 33 such records for the whole SO. All of them are from 2018.

I looked for them with this query.

Is surely everything with your SEDE publisher script okay?

I am really hoping, you didn't forbid this very important feature.

1 Answer 1


Nope, there's nothing wrong, just a timing issue.

Take a look at the timeline of this question. It has been deleted on February 10th, 16:04 and later, on February 11th, 5:19, it was undeleted. The last SEDE update, according to the homepage is February 11th, 7:22. What I expect to have happened is the following: when the PostsWithDeleted table was populated, the question was still deleted. It was not deleted anymore when the PostHistory table was populated.

Another example is this answer.

In general, the PostHistory table does not include (and has never included) entries for deleted posts.

  • I am not sure you understood the question well. A little bit of inconsistency of the db could be explained if the SEDE upload doesn't happen in a single transaction, but it still leaves the question open, what is happened to the PostHistory records of the deleted posts.
    – peterh
    Feb 16, 2018 at 10:33
  • @peterh they're not included in the dump.
    – Glorfindel Mod
    Feb 16, 2018 at 10:35
  • Are you sure they never was? As I can remember, I could collect some stat including deleted posts, but I am not sure.
    – peterh
    Feb 16, 2018 at 10:36
  • @peterh some information (like spam flags) is stored, e.g. data.stackexchange.com/stackoverflow/query/646101/…
    – Glorfindel Mod
    Feb 16, 2018 at 10:38
  • I know that, but this query is not coming from the PostHistory table. As I can remember, sometimes I could collect info for deleted posts from the PostHistory, but I am not sure.
    – peterh
    Feb 16, 2018 at 11:03

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .