I have around 140 post in database but wordpress admin page shows just 50 post. How could I let wordpress shows all the posts in database?


  • 1
    3x the posts in the DB could mean that you also got trashed posts, attachments, etc.
    – kaiser
    May 30, 2011 at 18:26

2 Answers 2


Are you sure those aren't pages, drafts, trashed, revisions or attachments? To make sure that those aren't such, run the following in

  • phpMyAdmin (Query tab - field "SQL query on database [database name]:")
  • Adminer
  • In the terminal

and see how many results you get:

select * from wp_posts where post_status='publish'
  • 1
    Thanks Alex you are right. How could I manage those hidden posts?
    – Feras Odeh
    May 30, 2011 at 19:09
  • You can install Wp Optimize, a plugin that deletes everything you don't need anymore and optimizes your database. May 30, 2011 at 20:12

The post row in database is much more broad than what post is in admin interface. Extra posts are not something hidden, there are merely instances of things that aren't of post post type and are not displayed as such (or at all in some cases).

You don't really need to manage those, WP does that nicely on its own. The one exclusion would probably be post revisions.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.