psql -h localhost -U listmonk -d listmonk -c 'SELECT count(*) FROM subscribers;'

Category: Listmonk & Newsletters

psql -h localhost -U listmonk -d listmonk -c 'SELECT count(*) FROM subscribers;'

Count total subscribers in the database

Returns the number of rows in the subscribers table, the ground truth for audience size regardless of dashboard caching. Filter by status by adding WHERE status = 'enabled' to exclude blocklisted or disabled addresses.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.