How do I display database query statistics on WordPress site?

I’ve noticed that a few WordPress blogs have query statistics present in their footer that simply state the number of queries and the total time required to process them for the particular page, reading something like:

23 queries. 0.448 seconds

Read More

I was wondering how this is accomplished. Is it through the use of a particular WordPress plug-in or perhaps from using some particular php function in the page’s code?

Related posts

Leave a Reply

3 comments

  1. Try adding this to the bottom of the footer in your template:

    <?php echo $wpdb->num_queries; ?> <?php _e('queries'); ?>. <?php timer_stop(1); ?> <?php _e('seconds'); ?>
    
  2. wordpress has a easy solution now

    There is a function called get_num_queries() and as specified in other answers timer_stop().

    <?php echo get_num_queries(); _e(' queries'); ?> in <?php timer_stop(1); _e(' seconds'); ?></p>
    

    get_num_queries() – returns the number of database queries during the WordPress execution and accepts no parameters