count_many_users_posts( int[] $users, string|string[] $post_type = 'post', bool $public_only = false ): array<int,

Compatibility

Present in every tracked release (6.7.7 to 7.1.0), and compiles on PHP 7.4 through 8.6-dev.

Parameters

$usersint[]

Array of user IDs.

$post_typestring|string[]optional

Single post type or array of post types to check. Defaults to 'post'.Default: 'post'

$public_onlybooloptional

Only return counts for public posts. Defaults to false.Default: false

Return value

array<int,

string> Amount of posts each user has written, as strings, keyed by user ID.

Performance profile

How much work a call to count_many_users_posts() does, and what it touches: the algorithmic scaling, the Zend instruction count per call across PHP versions, the hooks it hands control to, and the core code that calls it. Measured from the compiled opcodes, not a stopwatch, so every number is identical on any machine running the same PHP version, and every function in core is ranked by cost.

Cost class

Heavy

Reaches the database via ->get_results().

Scaling

Scales with input

The body loops, so the work grows with what you pass in.

Instructions

7–100

Executed per call on PHP 8.5, depending on the branch taken. The body compiles to 107.

Plugin surface

1 hook

Third-party callbacks on 'pre_count_many_users_posts' run inside this call, and their cost is not bounded by anything here.

Called by

1

1 place in core call this, so the cost is paid more often than your own code shows.

What it touches

• hookthird-party callbacksapply_filters()called directly
• cacheobject cachewp_cache_get_last_changed()called directly
• sqldatabase query->get_results()called directly

Further down the call graph this can also reach query, option, serialize and transient. Those are the worst case, several calls deep and usually down an error path, not what a normal call pays.

What one call costs · 4 distinct outcomes

One number would be a lie: the work depends on which branch runs. These are every distinct cost count_many_users_posts() can have, taken from its control-flow graph on PHP 8.5.

Hooks and filters fired · 1

One hook fires while count_many_users_posts() runs, in this order:

1. 1
   apply_filters( pre_count_many_users_posts )filterline 681 (+20 into the body)

   Filters whether to short-circuit performing the post counts.

Uses · 5

• apply_filters()Calls the callback functions that have been added to a filter hook.
• get_posts_by_author_sql()Retrieves the post SQL based on capability, author, and type.
• wp_cache_get_last_changed()Gets last changed date for the specified cache group.
• wp_cache_get_salted()Retrieves cached data if valid and unchanged.
• wp_cache_set_salted()Stores salted data in the cache.

Used by · 1

• WP_Users_List_Table::display_rows()Generates the list table rows.

Source code

View on Trac ↗View on GitHub ↗

661function count_many_users_posts( $users, $post_type = 'post', $public_only = false ) {662	global $wpdb;663 664	if ( empty( $users ) || ! is_array( $users ) ) {665		return array();666	}667 668	/**669	 * Filters whether to short-circuit performing the post counts.670	 *671	 * When filtering, return an array of posts counts as strings, keyed672	 * by the user ID.673	 *674	 * @since 6.8.0675	 *676	 * @param string[]|null   $count       The post counts. Return a non-null value to short-circuit.677	 * @param int[]           $users       Array of user IDs.678	 * @param string|string[] $post_type   Single post type or array of post types to check.679	 * @param bool            $public_only Whether to only return counts for public posts.680	 */681	$pre = apply_filters( 'pre_count_many_users_posts', null, $users, $post_type, $public_only );682	if ( null !== $pre ) {683		return $pre;684	}685 686	// Cleanup the users array. Remove duplicates and sort for consistent ordering.687	$users = array_unique( array_filter( array_map( 'intval', $users ) ) );688	sort( $users );689 690	// Cleanup the post type argument. Remove duplicates and sort for consistent ordering.691	$post_type = array_unique( (array) $post_type );692	sort( $post_type );693 694	$userlist    = implode( ',', $users );695	$where       = get_posts_by_author_sql( $post_type, true, null, $public_only );696	$query       = "SELECT post_author, COUNT(*) FROM $wpdb->posts $where AND post_author IN ($userlist) GROUP BY post_author";697	$cache_key   = 'count_many_users_posts:' . md5( $query );698	$cache_salts = array( wp_cache_get_last_changed( 'posts' ), wp_cache_get_last_changed( 'users' ) );699	$count       = wp_cache_get_salted( $cache_key, 'post-queries', $cache_salts );700 701	if ( false === $count ) {702		$result = $wpdb->get_results( $query, ARRAY_N );703 704		$count = array_fill_keys( $users, 0 );705		foreach ( $result as $row ) {706			$count[ $row[0] ] = $row[1];707		}708 709		wp_cache_set_salted( $cache_key, $count, 'post-queries', $cache_salts, HOUR_IN_SECONDS );710	}711 712	return $count;713}

Changelog

Introduced in 3.0.0. One change between 6.7.7 and 7.1.0.

1. 6.7.7
2. 6.8.8
3. 6.9.7
4. 7.0.4
5. 7.1.0

Signature, return type and hooks compared across 5 parsed releases.

About this page

Parsed data

Generated from the wordpress-develop 7.0.4 tag, from src/wp-includes/user.php, and regenerated for each WordPress release so it tracks the code rather than a snapshot of it.

Corrections

Something wrong on this page? Report it and it gets fixed in the next regeneration.