How big is your Discourse backup?

Support
16

On one instance my backups are 9.6GB+, another 7.8GB+ compressed, my email_logs table is not an issue at less than 60MB and less than 15MB each uncompressed - both running Discourse well over 1 year.

I haven’t seen any issues with email_logs table growing unexpectedly so far.

What are the results of the following queries for your instance?

Get the count of items and date range of email log table contents:

SELECT count(*), MAX(created_at), MIN(created_at) FROM email_logs;

Get size of top 20 relations:

SELECT nspname || '.' || relname AS "relation",
    pg_size_pretty(pg_relation_size(C.oid)) AS "size"
  FROM pg_class C
  LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
  WHERE nspname NOT IN ('pg_catalog', 'information_schema')
  ORDER BY pg_relation_size(C.oid) DESC
  LIMIT 20;

Get count of rows by email_type:

SELECT count(email_type) as count,email_type FROM email_logs GROUP BY email_type;