show processlist

show processlist

| 3398201 | helios      | 10.180.148.162:35374                     | device_hub | Query       |        5 | Copying to tmp table                   
                               | SELECT `devices`.`id` AS `id`, `serial_numbers`.`serial` AS `serial_number`, `mac_address`, CAST(group_concat(CAS
E WHEN lookup_metrics.ui_metric_name = 'version_firmware_dsp' THEN inverter_properties.property_value ELSE null END) AS decimal(30,2)) AS `version
_firmware_dsp`, CAST(group_concat(CASE WHEN lookup_metrics.ui_metric_name = 'version_firmware_pvm' THEN inverter_properties.property_value ELSE nu
ll END) AS decimal(30,2)) AS `version_firmware_pvm`, CAST(group_concat(CASE WHEN lookup_metrics.ui_metric_name = 'pvm_status' THEN inverter_proper
ties.property_value ELSE null END) AS decimal(30,2)) AS `pvm_status`, `model_name`, `inverter_connection_history`.`state` AS `location_state`, `fi
rst_reported`, `last_reported`, group_concat(DISTINCT inverter_lookup_status.name ORDER BY inverter_lookup_status.type SEPARATOR ',') AS `status`,
 `inverter_monitor_polls`.`total_kwh`, `inverter_monitor_polls`.`power_ac`, `inverter_monitor_polls`.`power_dc`, `inverter_tripped_fault_list`.`fa
ult_name_list` AS `current_faults` FROM `devices` LEFT JOIN `serial_numbers` ON (`devices`.`id` = `serial_numbers`.`device_id`) LEFT JOIN `inverte
r_properties` ON ((`devices`.`id` = `inverter_properties`.`inverter_id`) AND (`inverter_properties`.`active` = 1)) LEFT JOIN `lookup_metrics` ON (
`lookup_metrics`.`id` = `inverter_properties`.`inverter_property_name_id`) LEFT JOIN `lookup_models` ON (`devices`.`model_id` = `lookup_models`.`id`) LEFT JOIN `inverter_connection_history` ON ((`devices`.`id` = `inverter_connection_history`.`inverter_id`) AND (`inverter_connection_history`.`active` = 1)) LEFT JOIN inverter_status_history FORCE INDEX (active) ON devices.id = inverter_status_history.inverter_id AND inverter_status_history.active = 1 LEFT JOIN `inverter_lookup_status` ON (`inverter_status_history`.`status_id` = `inverter_lookup_status`.`id`) LEFT JOIN `inverter_monitor_polls` ON (`devices`.`last_poll_id` = `inverter_monitor_polls`.`id`) LEFT JOIN `inverter_tripped_fault_list` ON ((`inverter_monitor_polls`.`fault_asserted` = 1) AND (`devices`.`last_poll_id` = `inverter_tripped_fault_list`.`inverter_poll_id`)) WHERE ((`devices`.`device_type_id` IN (1)) AND (`last_reported` IS NOT NULL)) GROUP BY `devices`.`id` ORDER BY `last_reported` DESC |         0 |             0 |      9073 |
| 3398246 | pvpower_db  | 10.180.75.108:39529                      | device_hub | Sleep       |        0 |                                                                       | NULL