Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Paste
P121
number of objects per archive
Active
Public
Actions
Authored by
zack
on Dec 15 2016, 2:32 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
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
;
Event Timeline
zack
created this paste.
Dec 15 2016, 2:32 PM
2016-12-15 14:32:43 (UTC+1)
Log In to Comment