SQL snippet to get an overview of the types of content in your `wp_posts` table.

wp_posts-snippet.sql

SELECT post_type, COUNT(*) AS total 
FROM wp_posts GROUP BY post_type;