Useful SQL
From Roaring Penguin
You can run the following SQL commands from the commend line by prefixing them with
psql -U spam spam -c "<actual command>"
PostgreSQL check a variable from command line:
SELECT * FROM settings WHERE variable = '<variable name>';
Delete domain whitelists:
DELETE FROM domain_action WHERE action = 'allow-always';
Delete sender whitelists:
DELETE FROM sender_action WHERE action = 'allow-always';
Find held message size for specific incidents
SELECT length(msg) FROM held_messages WHERE incident_id in (<incident id>, <incident id>, ...);
Find count of messages in incidents table
SELECT status, count(*) FROM incidents group BY status;
To see the last run and the run interval:
select abstime(last_run), period_in_minutes, task from ticker;