Use these views to track the performance of every build across all of your Yext-owned sites.

Builds

pages.builds

This view contains a log of your YextCI builds.

Sample Queries

Calculate the average build time for a given site, excluding failed builds.

select round(avg(build_duration_seconds), 2)
from prod_pages.public.builds
where status = 'SUCCESS'
and site_id = 12345
and build_duration_seconds is not null;

Get a log of all builds in the past year.

select 
    build_id,
    site_id,
    status,
    artifact_size,
    queued_at_timestamp, 
    started_at_timestamp,
    completion_timestamp,
    build_duration_seconds
from prod_sharing.pages.builds

Generations

pages.generations

This view contains a log of generations through one of the Pages producers.

Sample Query

Get the count of successful generations for a given site's production version in the past 90 days.

select 
    site_id, 
    count(*) as generations
from prod_sharing.pages.generations
where completed_timestamp > dateadd(day, -90, current_date)
and generation_type = 'UPDATE'
and is_production
and status = 'SUCCESS'
group by 1 order by 2 desc;

Generation Function Invocations

pages.generation_function_invocations

This view contains a log of function invocations for a given activity in the Pages system.

Sample Query

Get the count of generation function invocations by event type.

select 
    distinct event_type_name, 
    count(*) as function_invocations
from prod_sharing.pages.generation_function_invocations
group by 1 order by 2 desc;

Sites

pages.sites

This view contains information about a specific page generated and hosted by the Pages system.

Sample Query

Get metadata for each site created in the past six months.

select 
    sites.creation_timestamp, 
    site_name,
    concat('https://yext.com/s/', businesses.business_id, '/yextsites/', site_id) as site_link,
    businesses.business_id, 
    name as account_name, 
    site_id, 
    sites.repo_uuid, 
    hostname, 
    published_deploy_id
from prod_pages.public.sites
join prod_platform.public.businesses using (business_id)
where creation_timestamp > dateadd(month, -6, current_date)
order by 1 desc;

Pages Errors

pages.pages_errors

This view contains a log of errors that occurred during a publish in the Pages system.

Sample Query

Get the count of all errors from today.

select count(*)
from prod_sharing.pages.pages_errors 
join prod_pages.public.sites using (site_id)
where date(pages_errors.timestamp) = current_date();