To support T383895: If `tunnels.anonymous` no longer uses the NULL value, remove support for it, it would be nice if we could push a datapoint to grafana to see if we ever do fully stop using NULL in this property. It would happen as IPs time out and if new IPs coming in always have a value. I used this query to check on the status of the table:
[ipoid]> SELECT t.anonymous as isAnonymous, COUNT(ad.pkid) FROM actor_data ad INNER JOIN actor_data_tunnels adt ON ad.pkid = adt.actor_data_id INNER JOIN tunnels t ON t.pkid = adt.tunnel_id GROUP BY isAnonymous; +-------------+----------------+ | isAnonymous | COUNT(ad.pkid) | +-------------+----------------+ | NULL | 9379094 | | 0 | 143560 | | 1 | 369647 | +-------------+----------------+ 3 rows in set (23.228 sec)
so if this data could be emitted and graphed we could easily track the trend.