Why my wp_posts data is so huge?

No, that isn’t normal for 23 posts.

Note that “posts” is pretty wide concept in modern WordPress. Many things are posts without being obvious as such, for example parts of navigation menus.

While 60k entries does sound excessive for a small site, there is no telling without examining actual data to determine which post types it belongs to and if those entries are valid for some purpose or merely broken leftovers.

Related Posts:

  1. Manually removing revision post types
  2. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  3. why there are so many posts whoes post_type is revision? will these records waste too much database space?
  4. Delete post revisions only for a single post
  5. Clean up customize_changeset in DB
  6. Can posts have parents?
  7. Where is the old post permalink slug stored?
  8. Separate Database Tables For Different Post Types
  9. SQL Query for getting all posts in their latest revised state
  10. How to Group Posts by the First Letter or Number?
  11. How are terms connected with posts in database?
  12. Moving WordPress to new server: no posts found
  13. how to enable different number of revisions for different blogs when using WPMU?
  14. Get the author of the latest revision
  15. database columns: post_title vs post_name
  16. Sanitizing `wp_editor();` Values for Database, Edit, and Display
  17. Exporting Data from WordPress into a flat table
  18. Insert posts in two tables
  19. Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?
  20. Adding a cancel button to edit post screen
  21. How do I batch create revisions of all posts?
  22. Are posts updated or built from revisions + autosaves?
  23. How much of my site can I recover from public_html?
  24. Reset/Reorder posts ID in the MySQL wp_posts table
  25. How to store an extra (surrogate) ID when creating a post with wp_insert_post?
  26. Enable post revisions for a specific post
  27. How do I find which articles are missing a featured image in The WordPress database?
  28. Split WP_POST table based on post types
  29. Most recent post from another database
  30. What structure should post_content have in the database?
  31. Multiples Empty Posts were created and cannot delete them
  32. Define a wordpress constant through plugin functions?
  33. Post revisions disappeared (for some posts)
  34. How to delete all the content of a wordpress site without deleting the Post and pages?
  35. Extracting post categories
  36. How to modify post content?
  37. How to hide html tags on revision comparison pages?
  38. After database migration, posts not showing up in dashboard
  39. Transferring WordPress Database – Serialised data
  40. Emojis replaced by ‘?’ automatically
  41. WordPress Local And Live Site
  42. Visual (non-HTML) display of post revisions [closed]
  43. Copy post to separate database with “add_action(….)”
  44. When open add new post or page WordPress add post with ID=0 continuously [closed]
  45. wp_posts table: safely remove unused columns to save database storage
  46. Anyone know why wordpress converts some html entities to their numeric equivalents?
  47. Remove a shortcode from all WordPress posts
  48. What do these phpMyAdmin errors mean on my WordPress databaes?
  49. Display post changelog in post
  50. Delete all drafts?
  51. Is it possible to use WP_Query to only pull posts with attachments?
  52. Get posts and include taxonomy term
  53. Add field to user meta table in database when link is clicked
  54. How safe is it to delete old posts edits to save database space?
  55. wp_posts table extremely large
  56. How to Assign / Move all Deleted post to a category
  57. Display post number by category
  58. Saving Post Data in Another Database
  59. Restore woocommerce orders
  60. How to select particular month post from table and update the post status using MySQL?
  61. Update field in database for users
  62. Import custom database into wp and keep the post id
  63. why the posts queried from sql is more than those showed on the page?
  64. Moved to a new server, backup was a day old and missing 3 posts, anyway to recover them from old host?
  65. Is there a function to get post info for any publish_status by post ID?
  66. Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”
  67. How Can I Always Display A Particular Post First Using WP_Query?
  68. Help on conditional statement to accompany wp_insert_post function please?
  69. How can I globally italicize list of texts in the UI database or Posts? [closed]
  70. Is it possible to modify posts table to only read for more recent ones?
  71. Menu Items disappearing/being empty on save or post edit
  72. How to setup default value of post_id
  73. Prevent a post with a specific ID from being created
  74. Bulk find & replace on WordPress posts/pages (minus image paths)
  75. Reusing old post IDs
  76. Trigger on DB make problem on wordpress?
  77. Comments are in database, don’t show up in WordPress backend or frontend
  78. Is there a way to save different data when USER interacts with the same POST?
  79. How can I stop ‘in use’ message from intermittently blocking my wp_posts table?
  80. More Than 50K Categories and WordPress Admin Panel Stop Showing Categories and Posts
  81. how i show manual data in a post
  82. Maximum number of posts per page before affecting performance?
  83. SQL trigger failes with post_content
  84. Surrogate ID for posts, is there an alternative field in the posts table?
  85. get backup file from wordpress database in x days
  86. Expired Post with More Recent Time Stamp?
  87. Converting Posts to Pages
  88. I moved my site to another server, wp admin works so does the front page, but posts don’t work
  89. How to change the publishing date of each posts?
  90. Can’t seem to replicate permalink structure for localhost development site
  91. Extra field in wp_post instead of postmeta
  92. Voting System, database connections?
  93. When I click edit on a post, all the content disappear. Does anyone know how to fix this?
  94. Given two custom post types: Automatically add meta fields from one custom post type to another
  95. Load posts from external source if not found in database
  96. Is there a maximum amount of pages for a multi-page post?
  97. How to make category for word post_content
  98. How can I merge a several related posts into one post?
  99. Restore posts, but only posts that exist in my database backup
  100. Change permalinks in posts via SQL