WordPress comes with a lot of amazing features and Post Revisions is one of them. This started with WordPress 2.6, even though this is a handy feature, it can bring in some unwanted issues. One of them is that it increases the size of your database. Depending on how long it takes you to writing a post, you might have hundreds of post revisions. You can simply use a plugin such as wp-optimize or manually delete them, for which you’ll have to run a simple query which we will discuss in this post and get rid of all the unwanted revisions.
Manually Delete Batches of Post Revisions
You’ll have to log into your phpMyAdmin from your hosting cPanel. After that, select your WordPress database, be sure to select the correct one!
Click on the SQL button and type this query:
DELETE FROM wp_posts WHERE post_type = "revision";
Basically, we looked up for a table ‘wp_posts’ and removed all the posts that had a ‘post_type’ of revision associated with them. Depending on the size of your database, this may save you a good lot of space and thus help you speed up your WordPress website.