export PGPASSWORD="$DB_PASSWORD" && psql -h prod-db.internal -U admin -d billingdb -c "UPDATE invoices SET status='overdue' WHERE due_date < NOW() - INTERVAL '30 days' AND status='pending'" && psql -h prod-db.internal -U admin -d billingdb -c "DELETE FROM invoice_reminders WHERE sent_at < NOW() - INTERVAL '90 days'" && psql -h prod-db.internal -U admin -d billingdb -c "VACUUM FULL invoices"