記事数をカウント

post_type 毎

SELECT post_type,count(*) FROM wp_posts GROUP BY post_type;

wp-cli

https://developer.wordpress.org/cli/commands/post/list/

wp post list --format=count
wp post list --post_type=page --format=count

wp cli - WordPress API - count posts - WordPress Development Stack Exchange

wp post list --format=count
6554
wp post list --post_type=post --format=count
6554
wp post list --post_type=revision --format=count
45373

post_typeは省略すると--post_type=post （合計にはならない）

マルチサイトの場合は --url を指定

wp post list --format=count --url=<url>

post_type 確認

wp post-type list --capability_type=post --fields=name,public

https://developer.wordpress.org/cli/commands/post-type/list/