# Leistungsproblem im Dashboard mit vielen Grafiken

**URL:** <https://community.gladysassistant.com/t/probleme-de-performance-sur-dashboard-avec-beaucoup-de-graphiques/7522>\
**Category:** Configuration\
**Created:** [11. September 2022 um 18:27 UTC](https://community.gladysassistant.com/t/probleme-de-performance-sur-dashboard-avec-beaucoup-de-graphiques/7522 "2022-09-11T18:27:48Z")\
**Posts on this page:** 1\
**Showing post:** 23

<div class="post-metadata">

**Author:** ![pierre-gilles](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/pierre-gilles/32/5886_2.png) [@pierre-gilles](https://community.gladysassistant.com/u/pierre-gilles)\
**Post date:** [15. September 2022 um 14:36 UTC](https://community.gladysassistant.com/t/probleme-de-performance-sur-dashboard-avec-beaucoup-de-graphiques/7522/23 "2022-09-15T14:36:12Z")

</div>

Hier ist es:

> [@Hilfe! Problem mit der Aggregation?](https://community.gladysassistant.com/t/help-probleme-avec-lagregation/6630/56?u=pierre-gilles):
>
> @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;

Danach, um die Zustände einer Funktion zu löschen:

```sql
DELETE FROM t_device_feature_state WHERE device_feature_id = 'cca3209-8d8f-4965-b658-bdb28eb31300';
DELETE FROM t_device_feature_state_aggregate WHERE device_feature_id = 'cca3209-8d8f-4965-b658-bdb28eb31300';

```

Am Ende nicht vergessen:

```auto
VACUUM;

```

---

_[View the full topic](https://community.gladysassistant.com/t/probleme-de-performance-sur-dashboard-avec-beaucoup-de-graphiques/7522)._