Postgres table annotation very large

Grafana Alerting
1

Hi,

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

grafana=> select count(*) from annotation;
  count
----------
 34422532

Regards,

Tobias

2

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

3

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?

4

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

5

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