MariaDB [enwiki_p]> SELECT * FROM logging_userindex JOIN actor_logging ON actor_id = log_actor WHERE actor_name = 'DGG' ORDER BY log_timestamp DESC LIMIT 1\G
*************************** 1. row ***************************
        log_id: 144862893
      log_type: patrol
    log_action: patrol
 log_timestamp: 20230329153142
     log_actor: 9406
 log_namespace: 118
     log_title: Weizenbaum_Institute_for_the_Networked_Society_-_The_German_Internet_Institute
log_comment_id: 10
    log_params: a:3:{s:8:"4::curid";s:10:"1147057086";s:9:"5::previd";s:1:"0";s:7:"6::auto";i:0;}
   log_deleted: 0
      log_page: 73412827
      actor_id: 9406
    actor_user: 2157954
    actor_name: DGG
1 row in set (1 min 5.702 sec)

MariaDB [enwiki_p]> SHOW EXPLAIN FOR 49146868\G
*************************** 1. row ***************************
           id: 1
  select_type: PRIMARY
        table: actor
         type: const
possible_keys: PRIMARY,actor_name
          key: actor_name
      key_len: 257
          ref: const
         rows: 1
        Extra:
*************************** 2. row ***************************
           id: 1
  select_type: PRIMARY
        table: logging
         type: index
possible_keys: log_actor_type_time,log_type_action,log_type_time,log_actor_time,log_actor_deleted
          key: log_times
      key_len: 14
          ref: NULL
         rows: 112457196
        Extra: Using where
*************************** 3. row ***************************
           id: 4
  select_type: SUBQUERY
        table: logging
         type: range
possible_keys: log_actor_type_time,log_type_action,log_type_time,log_actor_time,log_actor_deleted
          key: log_actor_type_time
      key_len: 42
          ref: NULL
         rows: 165187
        Extra: Using index condition; Using where
3 rows in set, 1 warning (0.002 sec)

SELECT  log_id,log_type,log_action,log_timestamp,log_deleted  FROM `logging` JOIN `actor` ON ((actor_id=log_actor))   WHERE (log_type NOT IN ('spamblacklist','titleblacklist','urlshortener','abusefilterprivatedetails','abusefilterblockeddomainhit','abusefilter-protected-vars','oath','checkuser-temporary-account','checkuser-private-event','ipinfo','suppress')) AND actor_name = 'DGG' AND ((log_deleted & 4) != 4)  ORDER BY log_timestamp DESC,log_id DESC LIMIT 2

cumin2024@db1169.eqiad.wmnet[enwiki]> show explain for 2640969;
+------+-------------+---------+-------+------------------------------------------------------------------+------------+---------+-------+-----------+-------------+
| id   | select_type | table   | type  | possible_keys                                                    | key        | key_len | ref   | rows      | Extra       |
+------+-------------+---------+-------+------------------------------------------------------------------+------------+---------+-------+-----------+-------------+
|    1 | SIMPLE      | actor   | const | PRIMARY,actor_name                                               | actor_name | 257     | const |         1 | Using index |
|    1 | SIMPLE      | logging | index | log_actor_type_time,log_type_action,log_type_time,log_actor_time | log_times  | 14      | NULL  | 112332602 | Using where |
+------+-------------+---------+-------+------------------------------------------------------------------+------------+---------+-------+-----------+-------------+
2 rows in set, 1 warning (0.001 sec)

cumin2024@db1169.eqiad.wmnet[enwiki]> explain SELECT  log_id,log_type,log_action,log_timestamp,log_deleted  FROM `logging` JOIN `actor` ON ((actor_id=log_actor))   WHERE (log_type NOT IN ('spamblacklist','titleblacklist','urlshortener','abusefilterprivatedetails','abusefilterblockeddomainhit','abusefilter-protected-vars','oath','checkuser-temporary-account','checkuser-private-event','ipinfo','suppress')) AND actor_name = 'DGG' AND ((log_deleted & 4) != 4)  ORDER BY log_timestamp DESC,log_id DESC LIMIT 2;
+------+-------------+---------+-------+------------------------------------------------------------------+------------+---------+-------+------+-------------+
| id   | select_type | table   | type  | possible_keys                                                    | key        | key_len | ref   | rows | Extra       |
+------+-------------+---------+-------+------------------------------------------------------------------+------------+---------+-------+------+-------------+
|    1 | SIMPLE      | actor   | const | PRIMARY,actor_name                                               | actor_name | 257     | const | 1    | Using index |
|    1 | SIMPLE      | logging | index | log_actor_type_time,log_type_action,log_type_time,log_actor_time | log_times  | 14      | NULL  | 1281 | Using where |
+------+-------------+---------+-------+------------------------------------------------------------------+------------+---------+-------+------+-------------+
2 rows in set (0.003 sec)

cumin2024@db1169.eqiad.wmnet[enwiki]> SELECT  log_id,log_type,log_action,log_timestamp,log_deleted  FROM `logging` ignore index (log_times) JOIN `actor` ON ((actor_id=log_actor))   WHERE (log_type NOT IN ('spamblacklist','titleblacklist','urlshortener','abusefilterprivatedetails','abusefilterblockeddomainhit','abusefilter-protected-vars','oath','checkuser-temporary-account','checkuser-private-event','ipinfo','suppress')) AND actor_name = 'DGG' AND ((log_deleted & 4) != 4)  ORDER BY log_timestamp DESC,log_id DESC LIMIT 2
    -> ;
+-----------+----------+------------+----------------+-------------+
| log_id    | log_type | log_action | log_timestamp  | log_deleted |
+-----------+----------+------------+----------------+-------------+
| 144862893 | patrol   | patrol     | 20230329153142 |           0 |
| 144862891 | move     | move       | 20230329153140 |           0 |
+-----------+----------+------------+----------------+-------------+
2 rows in set (0.002 sec)

+---------------+------------+------------+---------------------+--------------+------------+-------------+-----------------------------------+
| database_name | table_name | index_name | last_update         | stat_name    | stat_value | sample_size | stat_description                  |
+---------------+------------+------------+---------------------+--------------+------------+-------------+-----------------------------------+
| enwiki        | logging    | log_times  | 2022-05-26 17:07:07 | n_diff_pfx01 |   87385704 |          20 | log_timestamp                     |
| enwiki        | logging    | log_times  | 2022-05-26 17:07:07 | n_diff_pfx02 |  112955046 |          20 | log_timestamp,log_id              |
| enwiki        | logging    | log_times  | 2022-05-26 17:07:07 | n_leaf_pages |     167888 |        NULL | Number of leaf pages in the index |
| enwiki        | logging    | log_times  | 2022-05-26 17:07:07 | size         |     192064 |        NULL | Number of pages in the index      |
+---------------+------------+------------+---------------------+--------------+------------+-------------+-----------------------------------+
4 rows in set (0.003 sec)