psql -h localhost -U listmonk -d listmonk -c "SELECT count(*) FROM campaigns WHERE status = 'running';"

Queries the campaigns table for rows whose status is 'running'; the full status enum is draft, scheduled, running, paused, cancelled, finished. Useful to confirm a stuck campaign before restarting the app. The outer double quotes keep the single quotes for SQL intact.