Explain Query (mysql)
EXPLAIN SELECT
COUNT(transaction_id) AS nb_donations,
SUM(ABS(amount)) AS donation_amount
FROM
`transactions`
WHERE
type = 116 /*116*/ AND
DATE(created_time) BETWEEN SUBDATE(CURDATE(), INTERVAL 7 DAY) AND CURDATE()
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | transactions | ref | idx_type | idx_type | 1 | const | 290490 | 100.00 | Using where |