Problème de performance sur dashboard avec beaucoup de graphiques

[pierre-gilles]

C’est ici:

Help! Problème avec l'agrégation?

@lmilcent Hop c’est cadeau: SELECT COUNT(t_device_feature_state.id), device_feature_id, t_device_feature.name as feature_name, t_device.name as device_name FROM t_device_feature_state JOIN t_device_feature ON t_device_feature.id = device_feature_id JOIN t_device ON t_device.id = t_device_feature.device_id GROUP BY device_feature_id ORDER BY COUNT(t_device_feature_state.id) DESC;

Ensuite pour supprimer les états d’une feature:

DELETE FROM t_device_feature_state WHERE device_feature_id = 'cca32009-8d8f-4965-b658-bdb28eb31300';
DELETE FROM t_device_feature_state_aggregate WHERE device_feature_id = 'cca32009-8d8f-4965-b658-bdb28eb31300';

Ne pas oublier à la fin:

VACUUM;