WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question
3x the posts in the DB could mean that you also got trashed posts, attachments, etc. – kaiser May 30 '11 at 18:26
up vote 3 down vote accepted

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'
share|improve this answer
Thanks Alex you are right. How could I manage those hidden posts? – Feras Odeh May 30 '11 at 19:09
You can install Wp Optimize, a plugin that deletes everything you don't need anymore and optimizes your database. – Alex Dumitru May 30 '11 at 20:12
@Feras please pick this as an accepted answer if it helped you. – Alex Dumitru May 31 '11 at 3:49

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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