permaryService Registration Patterns
    Updated 2024-11-10
    select
    date_trunc('month', block_timestamp) as month,
    count(distinct service_id) as new_services,
    count(distinct owner_address) as unique_owners,
    avg(array_size(agent_ids)) as avg_agents_per_service,
    count(case when multisig_address is not null then 1 end) as multisig_services
    from crosschain.olas.ez_service_registrations
    group by 1
    order by 1 DESC;
    QueryRunArchived: QueryRun has been archived