do
$$
    declare
        tenant    varchar;
        count_all int;
        count     int;
    begin
        for tenant in
            select tenantjson -> 'descriptor' ->> 'id'
            from public.tenants
            where tenantjson -> 'descriptor' ->> 'id' <> 'supertenant'
            --                 and tenantjson -> 'descriptor' ->> 'id' in (
--                     'college'
--                 )
            loop
                execute format($count$
                SELECT count(*)
                from %s_mod_inventory_storage.holdings_record
                   $count$, tenant)
                    into count_all;
                execute format($count$
                SELECT count(*)
                from %s_mod_inventory_storage.holdings_record
                WHERE jsonb ? 'permanentLocation'
                   OR jsonb ? 'illPolicy'
                   OR jsonb ? 'holdingsItems'
                   OR jsonb ? 'bareHoldingsItems'
                   OR jsonb ? 'holdingsInstance'
                   $count$, tenant)
                    into count;

                raise info 'tenant: % - % of %', tenant, count, count_all;

            end loop;
    end
$$ language plpgsql;