Skip to content

Instantly share code, notes, and snippets.

@githoov

githoov/pinger_benchmarks_queries.sql

Last active April 23, 2016 00:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save githoov/f114ea61eebee66b89e6e730252ecab5 to your computer and use it in GitHub Desktop.
Save githoov/f114ea61eebee66b89e6e730252ecab5 to your computer and use it in GitHub Desktop.
Download ZIP
Pinger Benchmarks: Queries
Raw
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment