Postgres table annotation very large


Our annotation table is very large, at 11G right now. Any idea what makes it grow so much?

grafana=> select count(*) from annotation;



I guess it’s alerting. Ech alert change state creates annotation (vertical green, yellow , red line in the panel).

Thanks for the reply. Some of these alerts must be set up in a very bad way then. Would it be safe to truncate the table you think?

I would say better is to configure Grafana - see max_annotation configs:

Thanks a lot for the quick help. That did indeed do the trick.