number of objects per archive
ActivePublic
Actions

Authored by zack on Dec 15 2016, 2:32 PM.

Tags

None

Subscribers

None

	select copies.key as archive, count(content_id)
	from content_archive, jsonb_each(copies) as copies
	where copies.value->>'status' = 'present'
	group by copies.key;

number of objects per archiveActivePublicActions