Useful SQL
From Roaring Penguin
PostgreSQL check a variable from command line:
psql -U spam spam -c "SELECT * FROM settings WHERE variable = 'BayesDBFormat';"
Delete domain whitelists:
psql -U spam -c "DELETE FROM domain_action WHERE action = 'allow-always'"
Delete sender whitelists:
psql -U spam -c "DELETE FROM sender_action WHERE action = 'allow-always'"
Find held message size for specific incidents
psql -U postgres spam SELECT length(msg) FROM held_messages WHERE incident_id in (518210, 518197, 519116);
Find count of messages in incidents table
psql -U postgres spam SELECT status, count(*) FROM incidents group BY status;