Explain of WP_Queries

gistfile1.txt

mysql> EXPLAIN SELECT COUNT( 1 ) FROM sjwd_posts WHERE post_type = 'page' AND post_status NOT IN ( 'trash','auto-draft','inherit' ) AND post_author = 1;
+----+-------------+------------+------------+-------+------------------------------+------------------+---------+------+------+----------+------------------------------------+
| id | select_type | table      | partitions | type  | possible_keys                | key              | key_len | ref  | rows | filtered | Extra                              |
+----+-------------+------------+------------+-------+------------------------------+------------------+---------+------+------+----------+------------------------------------+
|  1 | SIMPLE      | sjwd_posts | NULL       | range | type_status_date,post_author | type_status_date | 164     | NULL |   24 |    36.87 | Using index condition; Using where |
+----+-------------+------------+------------+-------+------------------------------+------------------+---------+------+------+----------+------------------------------------+
1 row in set, 1 warning (0.00 sec)