This will give you a list of all the subscriptions, how they're send, how frequently and to whom.
There's other information in those tables if you need it:
SELECT p.id, p.name, pc.channel_type, pc.schedule_type, cu.email FROM public.pulse p
inner join pulse_channel pc on p.id = pc.pulse_id
inner join public.pulse_channel_recipient pcr on pc.id = pcr.pulse_channel_id
inner join core_user cu on cu.id = pcr.user_id
where p.archived = false