Pinger Benchmarks: Queries

pinger_benchmarks_queries.sql

\timing on
\o /dev/null

select count(*) from pinger.event_tmp1;
select count(*) from pinger.event_tmp1;
select count(*) from pinger.event_tmp1;
select count(*) from pinger.event_tmp1;
select count(*) from pinger.event_tmp1;

select looker_instance_slug, count(*) from pinger.event_tmp1 group by 1;
select looker_instance_slug, count(*) from pinger.event_tmp1 group by 1;
select looker_instance_slug, count(*) from pinger.event_tmp1 group by 1;
select looker_instance_slug, count(*) from pinger.event_tmp1 group by 1;
select looker_instance_slug, count(*) from pinger.event_tmp1 group by 1;

select count(*) from pinger.event_tmp1 where created_at >= current_date - interval '90 day';
select count(*) from pinger.event_tmp1 where created_at >= current_date - interval '90 day';
select count(*) from pinger.event_tmp1 where created_at >= current_date - interval '90 day';
select count(*) from pinger.event_tmp1 where created_at >= current_date - interval '90 day';
select count(*) from pinger.event_tmp1 where created_at >= current_date - interval '90 day';

select count(*) from pinger.event_tmp1 left join license.looker_instance on event_tmp1.looker_instance_slug = looker_instance.slug;
select count(*) from pinger.event_tmp1 left join license.looker_instance on event_tmp1.looker_instance_slug = looker_instance.slug;
select count(*) from pinger.event_tmp1 left join license.looker_instance on event_tmp1.looker_instance_slug = looker_instance.slug;
select count(*) from pinger.event_tmp1 left join license.looker_instance on event_tmp1.looker_instance_slug = looker_instance.slug;
select count(*) from pinger.event_tmp1 left join license.looker_instance on event_tmp1.looker_instance_slug = looker_instance.slug;

select count(*) from pinger.event_tmp1 left join license.license on event_tmp1.license_slug = license.slug;
select count(*) from pinger.event_tmp1 left join license.license on event_tmp1.license_slug = license.slug;
select count(*) from pinger.event_tmp1 left join license.license on event_tmp1.license_slug = license.slug;
select count(*) from pinger.event_tmp1 left join license.license on event_tmp1.license_slug = license.slug;
select count(*) from pinger.event_tmp1 left join license.license on event_tmp1.license_slug = license.slug;