Brad Parbs

Outputs some database query information on page load for logged in admins. Output is located as an html comment in the footer and also in the console.

Database Performance Monitor

Outputs some database query information on page load for logged in admins. Output is located as an html comment in the footer and also in the console.

Federal Communications Commission

Shortcode to count number of posts that match a given set of criteria; provides link to query to display list of matching posts.
Works with both built in post types (pages, posts) and taxonomies (tags, categories), as well as custom post types and custom taxonomies.
Example
You have a car custom post type and would like a count of all the red cars in your inventory, as well as a link to a listing of those cars.
Red Cars in Inventory: [count color=red]
Would return the number of cars, as well as a link to yoursite.com/?color=red (which may rewrite depending on your permalink structure)
Usage
Insert a shortcode in your post in the form of [count {taxonomy}={value}]. You can add as many or as fiew taxonomies as you would like.
You can also use the post_type argument to specify a post type (page, post, car, etc.)
List Usage
You can count all terms within a taxonomy, e.g., [list-counts taxonomy=”tags”] or across all taxonomies [list-counts].

Count Shortcode

Shortcode to count number of posts that match a given set of criteria; provides link to query to display list of matching posts

Database Performance Monitor vs Count Shortcode