gistfile1.sql

MySQL [piwik]> explain SELECT
    ->                                 log_visit.custom_var_k2 AS `custom_var_k2`, 
    ->                         log_visit.custom_var_v2 AS `custom_var_v2`, 
    ->                         count(distinct log_visit.idvisitor) AS `1`, 
    ->                         count(*) AS `2`, 
    ->                         sum(log_visit.visit_total_actions) AS `3`, 
    ->                         max(log_visit.visit_total_actions) AS `4`, 
    ->                         sum(log_visit.visit_total_time) AS `5`, 
    ->                         sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) AS `6`, 
    ->                         sum(case log_visit.visit_goal_converted when 1 then 1 else 0 end) AS `7`
    ->                         FROM
    ->                                 log_visit AS log_visit
    ->                         WHERE
    ->                                 log_visit.visit_last_action_time >= '2014-02-12 23:00:00'
    ->                                 AND log_visit.visit_last_action_time <= '2014-02-13 22:59:59'
    ->                                 AND log_visit.idsite = '14' AND log_visit.custom_var_k2 != ''
    ->                         GROUP BY
    ->                                 log_visit.custom_var_k2, log_visit.custom_var_v2;
+----+-------------+-----------+------+---------------------------------------------------------------------------+------------------------------+---------+-------+--------+-----------------------------+
| id | select_type | table     | type | possible_keys                                                             | key                          | key_len | ref   | rows   | Extra                       |
+----+-------------+-----------+------+---------------------------------------------------------------------------+------------------------------+---------+-------+--------+-----------------------------+
|  1 | SIMPLE      | log_visit | ref  | index_idsite_config_datetime,index_idsite_datetime,index_idsite_idvisitor | index_idsite_config_datetime | 4       | const | 268930 | Using where; Using filesort |
+----+-------------+-----------+------+---------------------------------------------------------------------------+------------------------------+---------+-------+--------+-----------------------------+