Huge gateway_stats table : can we safely purge it?

Hi all,

Our loraserver database is very huge (nearly 80 gigabytes) and I investigated why it uses so much space and discovered the gateway_stats has more than 331 millions records.
This table seems to have only stats about gateway traffic so I suppose it can be purged safely and easily.

But before break all our production network server, I would like to have confirmation I can run a such query : DELETE FROM gateway_stats WHERE timestamp < date_trunc('day', NOW() - interval '1 month') or totally truncate the table (we need to migrate the database server) ?

Many thanks

1 Like

Yes, it is safe to purge :slight_smile: Either all or partly up now - some interval.

2 Likes