Created
April 23, 2016 00:19
-
-
Save githoov/2a5ad8d5b561f88837c7154497a6d7db to your computer and use it in GitHub Desktop.
Pinger Benchmarks: Create Table Statements
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* simple sort */ | |
| create table pinger.event_tmp1 ( | |
| event_id bigint encode mostly16 | |
| , agent character varying(65535) encode lzo | |
| , referrer character varying(65535) encode lzo | |
| , user_id integer encode mostly8 | |
| , version character varying(100) encode bytedict | |
| , created_at timestamp without time zone encode delta | |
| , ip_address character varying(100) encode lzo | |
| , event_type character varying(200) encode bytedict | |
| , license_slug character varying(200) encode lzo | |
| , recipient character varying(200) encode lzo | |
| , killed boolean encode runlength | |
| , source_url character varying(2000) encode lzo | |
| , source character varying(2000) encode lzo | |
| , email character varying(200) encode lzo | |
| , export_format character varying(40) encode bytedict | |
| , dashboard_id integer encode mostly8 | |
| , uri character varying(65535) encode lzo | |
| , errors character varying(2000) encode lzo | |
| , sudoer_id integer encode mostly8 | |
| , successful boolean encode runlength | |
| , external_email character varying(200) encode lzo | |
| , query_params character varying(2000) encode lzo | |
| , runtime numeric(18,0) encode delta32k | |
| , sent boolean encode runlength | |
| , ldap boolean encode runlength | |
| , browser_instance_id character varying(100) encode lzo | |
| , looker_instance_slug character varying(200) encode lzo | |
| , user_agent character varying(65535) encode lzo | |
| , response_status integer encode mostly8 | |
| , elapsed_seconds real encode runlength | |
| , file_type character varying(256) encode bytedict | |
| , base_route character varying(256) encode bytedict | |
| , api_version real encode bytedict | |
| , sdk_operation_id character varying(128) encode lzo | |
| , dynamic_fields character varying(65535) encode lzo) | |
| diststyle even | |
| sortkey(created_at); | |
| /* compound sort */ | |
| create table pinger.event_tmp2 ( | |
| event_id bigint encode mostly16 | |
| , agent character varying(65535) encode lzo | |
| , referrer character varying(65535) encode lzo | |
| , user_id integer encode mostly8 | |
| , version character varying(100) encode bytedict | |
| , created_at timestamp without time zone encode delta | |
| , ip_address character varying(100) encode lzo | |
| , event_type character varying(200) encode bytedict | |
| , license_slug character varying(200) encode lzo | |
| , recipient character varying(200) encode lzo | |
| , killed boolean encode runlength | |
| , source_url character varying(2000) encode lzo | |
| , source character varying(2000) encode lzo | |
| , email character varying(200) encode lzo | |
| , export_format character varying(40) encode bytedict | |
| , dashboard_id integer encode mostly8 | |
| , uri character varying(65535) encode lzo | |
| , errors character varying(2000) encode lzo | |
| , sudoer_id integer encode mostly8 | |
| , successful boolean encode runlength | |
| , external_email character varying(200) encode lzo | |
| , query_params character varying(2000) encode lzo | |
| , runtime numeric(18,0) encode delta32k | |
| , sent boolean encode runlength | |
| , ldap boolean encode runlength | |
| , browser_instance_id character varying(100) encode lzo | |
| , looker_instance_slug character varying(200) encode lzo | |
| , user_agent character varying(65535) encode lzo | |
| , response_status integer encode mostly8 | |
| , elapsed_seconds real encode runlength | |
| , file_type character varying(256) encode bytedict | |
| , base_route character varying(256) encode bytedict | |
| , api_version real encode bytedict | |
| , sdk_operation_id character varying(128) encode lzo | |
| , dynamic_fields character varying(65535) encode lzo) | |
| diststyle even | |
| sortkey(created_at, user_id, looker_instance_slug, license_slug); | |
| /* interleaved sort */ | |
| create table pinger.event_tmp3 ( | |
| event_id bigint encode mostly16 | |
| , agent character varying(65535) encode lzo | |
| , referrer character varying(65535) encode lzo | |
| , user_id integer encode mostly8 | |
| , version character varying(100) encode bytedict | |
| , created_at timestamp without time zone encode delta | |
| , ip_address character varying(100) encode lzo | |
| , event_type character varying(200) encode bytedict | |
| , license_slug character varying(200) encode lzo | |
| , recipient character varying(200) encode lzo | |
| , killed boolean encode runlength | |
| , source_url character varying(2000) encode lzo | |
| , source character varying(2000) encode lzo | |
| , email character varying(200) encode lzo | |
| , export_format character varying(40) encode bytedict | |
| , dashboard_id integer encode mostly8 | |
| , uri character varying(65535) encode lzo | |
| , errors character varying(2000) encode lzo | |
| , sudoer_id integer encode mostly8 | |
| , successful boolean encode runlength | |
| , external_email character varying(200) encode lzo | |
| , query_params character varying(2000) encode lzo | |
| , runtime numeric(18,0) encode delta32k | |
| , sent boolean encode runlength | |
| , ldap boolean encode runlength | |
| , browser_instance_id character varying(100) encode lzo | |
| , looker_instance_slug character varying(200) encode lzo | |
| , user_agent character varying(65535) encode lzo | |
| , response_status integer encode mostly8 | |
| , elapsed_seconds real encode runlength | |
| , file_type character varying(256) encode bytedict | |
| , base_route character varying(256) encode bytedict | |
| , api_version real encode bytedict | |
| , sdk_operation_id character varying(128) encode lzo | |
| , dynamic_fields character varying(65535) encode lzo) | |
| diststyle even | |
| interleaved sortkey(created_at, user_id, looker_instance_slug, license_slug); | |
| /* interleaved sort distributing on license_slug */ | |
| create table pinger.event_tmp4 ( | |
| event_id bigint encode mostly16 | |
| , agent character varying(65535) encode lzo | |
| , referrer character varying(65535) encode lzo | |
| , user_id integer encode mostly8 | |
| , version character varying(100) encode bytedict | |
| , created_at timestamp without time zone encode delta | |
| , ip_address character varying(100) encode lzo | |
| , event_type character varying(200) encode bytedict | |
| , license_slug character varying(200) encode lzo | |
| , recipient character varying(200) encode lzo | |
| , killed boolean encode runlength | |
| , source_url character varying(2000) encode lzo | |
| , source character varying(2000) encode lzo | |
| , email character varying(200) encode lzo | |
| , export_format character varying(40) encode bytedict | |
| , dashboard_id integer encode mostly8 | |
| , uri character varying(65535) encode lzo | |
| , errors character varying(2000) encode lzo | |
| , sudoer_id integer encode mostly8 | |
| , successful boolean encode runlength | |
| , external_email character varying(200) encode lzo | |
| , query_params character varying(2000) encode lzo | |
| , runtime numeric(18,0) encode delta32k | |
| , sent boolean encode runlength | |
| , ldap boolean encode runlength | |
| , browser_instance_id character varying(100) encode lzo | |
| , looker_instance_slug character varying(200) encode lzo | |
| , user_agent character varying(65535) encode lzo | |
| , response_status integer encode mostly8 | |
| , elapsed_seconds real encode runlength | |
| , file_type character varying(256) encode bytedict | |
| , base_route character varying(256) encode bytedict | |
| , api_version real encode bytedict | |
| , sdk_operation_id character varying(128) encode lzo | |
| , dynamic_fields character varying(65535) encode lzo) | |
| distkey(license_slug) | |
| interleaved sortkey(created_at, user_id, looker_instance_slug, license_slug); | |
| /* compound sort distributing on license_slug */ | |
| create table pinger.event_tmp5 ( | |
| event_id bigint encode mostly16 | |
| , agent character varying(65535) encode lzo | |
| , referrer character varying(65535) encode lzo | |
| , user_id integer encode mostly8 | |
| , version character varying(100) encode bytedict | |
| , created_at timestamp without time zone encode delta | |
| , ip_address character varying(100) encode lzo | |
| , event_type character varying(200) encode bytedict | |
| , license_slug character varying(200) encode lzo | |
| , recipient character varying(200) encode lzo | |
| , killed boolean encode runlength | |
| , source_url character varying(2000) encode lzo | |
| , source character varying(2000) encode lzo | |
| , email character varying(200) encode lzo | |
| , export_format character varying(40) encode bytedict | |
| , dashboard_id integer encode mostly8 | |
| , uri character varying(65535) encode lzo | |
| , errors character varying(2000) encode lzo | |
| , sudoer_id integer encode mostly8 | |
| , successful boolean encode runlength | |
| , external_email character varying(200) encode lzo | |
| , query_params character varying(2000) encode lzo | |
| , runtime numeric(18,0) encode delta32k | |
| , sent boolean encode runlength | |
| , ldap boolean encode runlength | |
| , browser_instance_id character varying(100) encode lzo | |
| , looker_instance_slug character varying(200) encode lzo | |
| , user_agent character varying(65535) encode lzo | |
| , response_status integer encode mostly8 | |
| , elapsed_seconds real encode runlength | |
| , file_type character varying(256) encode bytedict | |
| , base_route character varying(256) encode bytedict | |
| , api_version real encode bytedict | |
| , sdk_operation_id character varying(128) encode lzo | |
| , dynamic_fields character varying(65535) encode lzo) | |
| distkey(license_slug) | |
| sortkey(created_at, user_id, looker_instance_slug, license_slug); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment