🌚🌞

ClickBench — a Benchmark For Analytical DBMS

Methodology | Reproduce and Validate the Results | Add a System | Hardware Benchmark | Versions Benchmark | See also: JSONBench
System: All AlloyDBAlloyDB (tuned)Athena (partitioned)Athena (single)Aurora for MySQLAurora for PostgreSQLByConityByteHousechDB (DataFrame)chDB (Parquet, partitioned)chDBCHYTCitusClickHouse Cloud (aws)ClickHouse Cloud (azure)ClickHouse Cloud (gcp)ClickHouse (data lake, partitioned)ClickHouse (data lake, single)ClickHouse (Parquet, partitioned)ClickHouse (Parquet, single)ClickHouse (web)ClickHouseClickHouse (tuned)ClickHouse (tuned, memory)CloudberryCrateDBCrunchy Bridge for Analytics (Parquet)DatabendDataFusion (Parquet, partitioned)DataFusion (Parquet, single)Apache DorisDrillDruidDuckDB (DataFrame)DuckDB (memory)DuckDB (Parquet, partitioned)DuckDBElasticsearchElasticsearch (tuned)GlareDBGreenplumHeavyAIHydraSalesforce Hyper (Parquet)Salesforce HyperInfobrightKineticaMariaDB ColumnStoreMariaDBMonetDBMongoDBMotherDuckMySQL (MyISAM)MySQLOctoSQLOpteryxOxlaPandas (DataFrame)ParadeDB (Parquet, partitioned)ParadeDB (Parquet, single)Parseable (Parquet, partitioned)pg_duckdb (with indexes)pg_duckdb (MotherDuck enabled)pg_duckdbpg_duckdb (Parquet)PostgreSQL with pg_mooncakepgpro_tam (parquet, local storage)pgpro_tam (parquet, local, parallel)pgpro_tam (parquet, local + cache)pgpro_tam (feather, local + cache)PinotPolars (DataFrame)Polars (Parquet)PostgreSQL (with indexes)PostgreSQLQuestDBRedshiftSelectDBSigLensSingleStoreSnowflakeSparkSQLiteStarRocksTablespaceTembo OLAP (columnar)Timescale CloudTimescaleDB (no columnstore)TimescaleDBTinybird (Free Trial)UmbraUrsaVictoriaLogsYDB
Type: All Ccolumn-orientedPostgreSQL compatiblemanagedgcpstatelessJavaC++MySQL compatiblerow-orientedClickHouse derivativeembeddedserverlessdataframeYTawsazureanalyticalRustsearchdocumentGosomewhat PostgreSQL compatibleparquetDataFrametime-serieslogsSigLensobservabilitydedicated
Machine: All 16 vCPU 128GB8 vCPU 64GBserverless16acuc6a.4xlarge, 500gb gp2LMSXSc6a.metal, 500gb gp212 vCPU 48GB10 vCPU 40GB12GiB, 1 replica(s)8GiB, 1 replica(s)12GiB, 2 replica(s)120GiB, 2 replica(s)16GiB, 2 replica(s)236GiB, 2 replica(s)32GiB, 2 replica(s)64GiB, 2 replica(s)8GiB, 2 replica(s)12GiB, 3 replica(s)120GiB, 3 replica(s)16GiB, 3 replica(s)236GiB, 3 replica(s)32GiB, 3 replica(s)64GiB, 3 replica(s)8GiB, 3 replica(s)c5n.4xlarge, 500gb gp2Analytics-256GB (64 vCores, 256 GB)c5.4xlarge, 500gb gp2c6a.4xlarge, 1500gb gp2XLJumboPulseStandard16 vCPU 32GBdc2.8xlargera3.16xlargera3.4xlargera3.xlplusc6a.4xlarge, 700gb gp2S2S242XL3XL4XLL1 - 16CPU 32GBc6a.4xlarge, 500gb gp316 vCPU 64GB4 vCPU 16GB8 vCPU 32GB64 vCPU 256GB
Cluster size: All 123489163264128serverless123undefined
Metric: Cold Run Hot Run Load Time Storage Size
System & Machine Relative time (lower is better)
Umbra (c6a.metal, 500gb gp2):
×1.60
Salesforce Hyper (c6a.metal, 500gb gp2):
×1.68
DuckDB (c6a.metal, 500gb gp2):
×2.15
ClickHouse (tuned, memory) (c6a.metal, 500gb gp2):
×2.16
ClickHouse (tuned) (c6a.metal, 500gb gp2):
×2.29
ClickHouse (c6a.metal, 500gb gp2):
×2.53
Umbra (c6a.4xlarge, 500gb gp2):
×2.58
SelectDB (c6a.metal, 500gb gp2):
×2.62
Apache Doris (c6a.metal, 500gb gp2):
×2.64
DuckDB (memory) (c6a.metal, 500gb gp2):
×2.71
ClickHouse (web) (c6a.metal, 500gb gp2):
×2.78
ClickHouse Cloud (aws) (236GiB, 2 replica(s)):
×2.90
StarRocks (c6a.metal, 500gb gp2):
×2.91
Databend (c6a.metal, 500gb gp2):
×3.01
ClickHouse Cloud (aws) (236GiB, 3 replica(s)):
×3.11
chDB (c6a.metal, 500gb gp2):
×3.15
MotherDuck (Jumbo):
×3.18
QuestDB (c6a.metal, 500gb gp2)†Uses multi-threaded COPY SQL for data load.:
×3.23
pg_duckdb (MotherDuck enabled) (Jumbo):
×3.31
DuckDB (c6a.4xlarge, 500gb gp2):
×3.50
ClickHouse Cloud (aws) (120GiB, 2 replica(s)):
×3.78
Salesforce Hyper (Parquet) (c6a.metal, 500gb gp2):
×3.81
Salesforce Hyper (c6a.4xlarge, 500gb gp2):
×3.87
ClickHouse Cloud (aws) (120GiB, 3 replica(s)):
×3.91
DuckDB (DataFrame) (c6a.metal, 500gb gp2):
×4.05
ClickHouse Cloud (gcp) (236GiB, 2 replica(s)):
×4.06
ClickHouse Cloud (azure) (120GiB, 2 replica(s)):
×4.10
ClickHouse Cloud (gcp) (236GiB, 3 replica(s)):
×4.28
Ursa (c6a.4xlarge, 500gb gp2):
×4.31
Redshift (4×ra3.16xlarge):
×4.39
Hydra (XL):
×4.42
DuckDB (Parquet, partitioned) (c6a.metal, 500gb gp2):
×4.47
ClickHouse Cloud (azure) (120GiB, 3 replica(s)):
×4.56
ClickHouse Cloud (gcp) (120GiB, 2 replica(s)):
×4.82
SingleStore (S24)†Previous name: MemSQL. Some queries did not run due to unsupported regex:
×4.91
MotherDuck (Standard):
×5.04
ClickHouse Cloud (gcp) (120GiB, 3 replica(s)):
×5.16
ClickHouse Cloud (azure) (64GiB, 2 replica(s)):
×5.17
ClickHouse Cloud (aws) (64GiB, 3 replica(s)):
×5.37
chDB (DataFrame) (c6a.metal, 500gb gp2):
×5.57
Databend (c6a.4xlarge, 500gb gp2):
×5.59
ClickHouse Cloud (aws) (64GiB, 2 replica(s)):
×5.63
ClickHouse (c6a.4xlarge, 500gb gp2):
×5.65
chDB (c6a.4xlarge, 500gb gp2):
×5.88
ClickHouse Cloud (azure) (64GiB, 3 replica(s)):
×5.98
Crunchy Bridge for Analytics (Parquet) (Analytics-256GB (64 vCores, 256 GB)):
×6.02
ClickHouse (web) (c5n.4xlarge, 500gb gp2):
×6.03
Databend (c5.4xlarge, 500gb gp2):
×6.06
ClickHouse Cloud (gcp) (64GiB, 2 replica(s)):
×6.07
ClickHouse Cloud (gcp) (64GiB, 3 replica(s)):
×6.33
QuestDB (c6a.4xlarge, 500gb gp2):
×6.74
chDB (Parquet, partitioned) (c6a.metal, 500gb gp2):
×7.00
Apache Doris (c6a.4xlarge, 500gb gp2):
×7.03
StarRocks (c6a.4xlarge, 500gb gp2):
×7.08
Snowflake (64×3XL):
×7.15
pgpro_tam (parquet, local + cache) (c6a.metal, 500gb gp2):
×7.25
pgpro_tam (parquet, local storage) (c6a.metal, 500gb gp2):
×7.32
Snowflake (32×2XL):
×7.43
ClickHouse Cloud (azure) (32GiB, 2 replica(s)):
×7.65
ClickHouse Cloud (azure) (32GiB, 3 replica(s)):
×7.72
Snowflake (128×4XL):
×7.91
Redshift (serverless):
×8.19
DuckDB (Parquet, partitioned) (c6a.4xlarge, 500gb gp2):
×8.28
Tablespace (L1 - 16CPU 32GB):
×8.48
YDB (3×64 vCPU 256GB):
×8.58
Snowflake (16×XL):
×8.72
pgpro_tam (parquet, local, parallel) (c6a.metal, 500gb gp2):
×8.83
Parseable (Parquet, partitioned) (c6a.metal, 500gb gp2)†v1.7.5 (6e5242f):
×8.84
Oxla (c6a.4xlarge, 500gb gp2)†Ingests data only from non-compressed cvs.:
×8.92
pgpro_tam (feather, local + cache) (c6a.metal, 500gb gp2):
×9.43
ClickHouse Cloud (aws) (32GiB, 2 replica(s)):
×9.48
ByConity (c6a.4xlarge, 500gb gp2):
×9.50
ByteHouse (8×L):
×9.61
CHYT (9×10 vCPU 40GB):
×9.64
pgpro_tam (parquet, local storage) (16 vCPU 32GB):
×9.80
Redshift (4×ra3.4xlarge):
×9.84
pgpro_tam (parquet, local + cache) (16 vCPU 32GB):
×9.93
ClickHouse (Parquet, single) (c6a.metal, 500gb gp2):
×10.11
Salesforce Hyper (Parquet) (c6a.4xlarge, 500gb gp2):
×10.18
ClickHouse Cloud (gcp) (32GiB, 2 replica(s)):
×10.35
ClickHouse (Parquet, partitioned) (c6a.metal, 500gb gp2):
×10.82
pgpro_tam (parquet, local, parallel) (16 vCPU 32GB):
×10.87
ClickHouse Cloud (aws) (32GiB, 3 replica(s)):
×10.96
ClickHouse Cloud (gcp) (32GiB, 3 replica(s)):
×11.15
Snowflake (8×L):
×11.48
PostgreSQL with pg_mooncake (c6a.4xlarge, 500gb gp2):
×11.67
Kinetica (c6a.4xlarge, 500gb gp2):
×12.16
DataFusion (Parquet, partitioned) (c6a.4xlarge, 500gb gp2)†v45.0.0 (26058ac):
×12.43
ClickHouse Cloud (aws) (16GiB, 3 replica(s)):
×12.77
ClickHouse Cloud (azure) (16GiB, 3 replica(s)):
×12.85
CHYT (4×12 vCPU 48GB):
×13.23
ClickHouse Cloud (azure) (16GiB, 2 replica(s)):
×13.31
SingleStore (S2)†Previous name: MemSQL. Some queries did not run due to unsupported regex:
×13.50
Parseable (Parquet, partitioned) (c6a.4xlarge, 500gb gp2)†v1.7.5 (6e5242f):
×13.69
chDB (Parquet, partitioned) (c6a.4xlarge, 500gb gp2):
×14.19
ClickHouse Cloud (aws) (16GiB, 2 replica(s)):
×14.20
pg_duckdb (Parquet) (c6a.4xlarge, 500gb gp2):
×14.29
ClickHouse Cloud (gcp) (16GiB, 2 replica(s)):
×14.56
ClickHouse Cloud (gcp) (16GiB, 3 replica(s)):
×14.95
ByteHouse (4×M):
×14.98
ClickHouse (Parquet, single) (c6a.4xlarge, 500gb gp2):
×15.36
DataFusion (Parquet, single) (c6a.4xlarge, 500gb gp2)†v45.0.0 (26058ac):
×15.38
Snowflake (4×M):
×15.70
VictoriaLogs (c6a.4xlarge, 500gb gp2):
×15.97
Redshift (2×dc2.8xlarge):
×16.00
ParadeDB (Parquet, single) (c6a.4xlarge, 500gb gp2):
×16.10
ParadeDB (Parquet, partitioned) (c6a.4xlarge, 500gb gp2):
×16.37
ClickHouse (data lake, partitioned) (c6a.metal, 500gb gp2):
×16.63
Polars (Parquet) (c6a.metal, 500gb gp2):
×17.32
ClickHouse (Parquet, partitioned) (c6a.4xlarge, 500gb gp2):
×17.38
ClickHouse (data lake, single) (c6a.metal, 500gb gp2):
×17.45
ClickHouse Cloud (azure) (12GiB, 3 replica(s)):
×17.62
Polars (DataFrame) (c6a.metal, 500gb gp2):
×17.63
Redshift (4×ra3.xlplus):
×17.64
ClickHouse Cloud (azure) (12GiB, 1 replica(s)):
×17.70
CHYT (2×12 vCPU 48GB):
×17.78
ClickHouse Cloud (azure) (12GiB, 2 replica(s)):
×17.79
ClickHouse Cloud (gcp) (12GiB, 3 replica(s)):
×18.88
Tinybird (Free Trial) (serverless):
×19.06
ClickHouse Cloud (aws) (12GiB, 3 replica(s)):
×19.16
CHYT (12 vCPU 48GB):
×19.16
ClickHouse Cloud (aws) (12GiB, 2 replica(s)):
×19.18
ByteHouse (2×S):
×19.18
ClickHouse Cloud (gcp) (12GiB, 2 replica(s)):
×20.55
ClickHouse Cloud (aws) (12GiB, 1 replica(s)):
×21.89
Snowflake (2×S):
×21.98
MonetDB (c6a.4xlarge, 500gb gp2):
×22.46
SingleStore (c6a.4xlarge, 500gb gp2)†Previous name: MemSQL. Some queries did not run due to memory limits:
×23.97
ClickHouse Cloud (azure) (8GiB, 2 replica(s)):
×24.04
MotherDuck (Pulse):
×24.67
ClickHouse Cloud (azure) (8GiB, 1 replica(s)):
×24.74
ClickHouse Cloud (azure) (8GiB, 3 replica(s)):
×24.76
ClickHouse Cloud (aws) (8GiB, 3 replica(s)):
×25.17
ClickHouse Cloud (gcp) (12GiB, 1 replica(s)):
×25.47
ClickHouse Cloud (gcp) (8GiB, 2 replica(s)):
×25.95
ClickHouse Cloud (aws) (8GiB, 2 replica(s)):
×26.38
ClickHouse Cloud (gcp) (8GiB, 3 replica(s)):
×28.32
ClickHouse Cloud (gcp) (8GiB, 1 replica(s)):
×28.54
Polars (Parquet) (c6a.4xlarge, 500gb gp2):
×29.65
ClickHouse (data lake, single) (c6a.4xlarge, 500gb gp2):
×31.79
ByteHouse (XS):
×31.99
Snowflake (XS):
×32.00
ClickHouse (data lake, partitioned) (c6a.4xlarge, 500gb gp2):
×32.57
ClickHouse Cloud (aws) (8GiB, 1 replica(s)):
×35.56
TimescaleDB (c6a.4xlarge, 500gb gp2):
×38.46
GlareDB (c6a.4xlarge, 500gb gp2):
×39.05
SigLens (c6a.4xlarge, 700gb gp2):
×48.66
Timescale Cloud (16 vCPU 64GB):
×48.97
Cloudberry (c6a.4xlarge, 500gb gp2)†14 segments, ORCA enabled:
×50.40
Greenplum (c6a.4xlarge, 500gb gp2):
×53.40
Pinot (c6a.4xlarge, 500gb gp2)†It successfully loaded only 94465149 out of 99997497 records. Some queries returned NullPointerException. The loading process is painful - splitting to 100 pieces required. It does not correctly report errors on data loading, the results may be incorrect.:
×57.46
Athena (single) (serverless):
×62.13
Timescale Cloud (8 vCPU 32GB):
×68.55
Athena (partitioned) (serverless):
×70.06
PostgreSQL (with indexes) (c6a.4xlarge, 500gb gp2):
×70.56
Tembo OLAP (columnar) (c6a.4xlarge, 500gb gp3):
×72.73
CrateDB (c6a.4xlarge, 500gb gp2)†CrateDB 5.10.2. Some queries exceed the available heap space (CircuitBreakingException).:
×75.86
Timescale Cloud (4 vCPU 16GB):
×86.66
CrateDB (c6a.4xlarge, 500gb gp2)†CrateDB 5.10.2. Some queries exceed the available heap space (CircuitBreakingException).:
×88.97
Opteryx (c6a.4xlarge, 500gb gp2):
×94.48
AlloyDB (16 vCPU 128GB):
×94.88
AlloyDB (8 vCPU 64GB):
×101.04
MariaDB ColumnStore (c6a.4xlarge, 500gb gp2)†Previous name: InfiniDB.:
×118.23
GlareDB (c6a.metal, 500gb gp2):
×119.23
Elasticsearch (c6a.4xlarge, 1500gb gp2):
×147.35
AlloyDB (tuned) (8 vCPU 64GB):
×203.38
Spark (c6a.4xlarge, 500gb gp2):
×249.44
Drill (c6a.4xlarge, 500gb gp2):
×286.53
Druid (c6a.4xlarge, 500gb gp2)†Druid is killed and restarted after every query. Otherwise some queries make Druid degraded and results are incorrect. For example after Q13 even SELECT 1 works for 7 seconds:
×300.18
Pandas (DataFrame) (c6a.metal, 500gb gp2):
×318.53
HeavyAI (c6a.4xlarge, 500gb gp2)†Previous names: OmniSci, mapD. Many queries cannot run due to errors and limitations.:
×324.83
pg_duckdb (with indexes) (c6a.4xlarge, 500gb gp2):
×383.05
Citus (c6a.4xlarge, 500gb gp2):
×441.39
Aurora for PostgreSQL (16acu):
×763.54
MongoDB (c6a.4xlarge, 500gb gp2):
×799.73
TimescaleDB (no columnstore) (c6a.4xlarge, 500gb gp2):
×1115.68
Infobright (c6a.4xlarge, 500gb gp2)†Only 90% of data successfully loaded. Some queries run for days.:
×1120.92
SQLite (c6a.4xlarge, 500gb gp2):
×1721.29
MySQL (MyISAM) (c6a.4xlarge, 500gb gp2):
×2638.54
MySQL (c6a.4xlarge, 500gb gp2):
×5146.23
pg_duckdb (c6a.4xlarge, 500gb gp2):
×6405.95
PostgreSQL (c6a.4xlarge, 500gb gp2):
×6679.41
Aurora for MySQL (16acu)†Some queries cannot run due to ERROR 1114 (HY000) at line 1: The table '/rdsdbdata/tmp/#sqlaff_e5_0' is full:
×7793.57
OctoSQL (c6a.4xlarge, 500gb gp2):
×9856.97

Detailed Comparison

Umbra (c6a.metal, 500gb gp2)Salesforce Hyper (c6a.metal, 500gb gp2)DuckDB (c6a.metal, 500gb gp2)ClickHouse (tuned, memory) (c6a.metal, 500gb gp2)ClickHouse (tuned) (c6a.metal, 500gb gp2)ClickHouse (c6a.metal, 500gb gp2)Umbra (c6a.4xlarge, 500gb gp2)SelectDB (c6a.metal, 500gb gp2)Apache Doris (c6a.metal, 500gb gp2)DuckDB (memory) (c6a.metal, 500gb gp2)ClickHouse (web) (c6a.metal, 500gb gp2)ClickHouse Cloud (aws) (236GiB, 2 replica(s))StarRocks (c6a.metal, 500gb gp2)Databend (c6a.metal, 500gb gp2)ClickHouse Cloud (aws) (236GiB, 3 replica(s))chDB (c6a.metal, 500gb gp2)MotherDuck (Jumbo)QuestDB (c6a.metal, 500gb gp2)pg_duckdb (MotherDuck enabled) (Jumbo)DuckDB (c6a.4xlarge, 500gb gp2)ClickHouse Cloud (aws) (120GiB, 2 replica(s))Salesforce Hyper (Parquet) (c6a.metal, 500gb gp2)Salesforce Hyper (c6a.4xlarge, 500gb gp2)ClickHouse Cloud (aws) (120GiB, 3 replica(s))DuckDB (DataFrame) (c6a.metal, 500gb gp2)ClickHouse Cloud (gcp) (236GiB, 2 replica(s))ClickHouse Cloud (azure) (120GiB, 2 replica(s))ClickHouse Cloud (gcp) (236GiB, 3 replica(s))Ursa (c6a.4xlarge, 500gb gp2)Redshift (4×ra3.16xlarge)Hydra (XL)DuckDB (Parquet, partitioned) (c6a.metal, 500gb gp2)ClickHouse Cloud (azure) (120GiB, 3 replica(s))ClickHouse Cloud (gcp) (120GiB, 2 replica(s))SingleStore (S24)MotherDuck (Standard)ClickHouse Cloud (gcp) (120GiB, 3 replica(s))ClickHouse Cloud (azure) (64GiB, 2 replica(s))ClickHouse Cloud (aws) (64GiB, 3 replica(s))chDB (DataFrame) (c6a.metal, 500gb gp2)Databend (c6a.4xlarge, 500gb gp2)ClickHouse Cloud (aws) (64GiB, 2 replica(s))ClickHouse (c6a.4xlarge, 500gb gp2)chDB (c6a.4xlarge, 500gb gp2)ClickHouse Cloud (azure) (64GiB, 3 replica(s))Crunchy Bridge for Analytics (Parquet) (Analytics-256GB (64 vCores, 256 GB))ClickHouse (web) (c5n.4xlarge, 500gb gp2)Databend (c5.4xlarge, 500gb gp2)ClickHouse Cloud (gcp) (64GiB, 2 replica(s))ClickHouse Cloud (gcp) (64GiB, 3 replica(s))QuestDB (c6a.4xlarge, 500gb gp2)chDB (Parquet, partitioned) (c6a.metal, 500gb gp2)Apache Doris (c6a.4xlarge, 500gb gp2)StarRocks (c6a.4xlarge, 500gb gp2)Snowflake (64×3XL)pgpro_tam (parquet, local + cache) (c6a.metal, 500gb gp2)pgpro_tam (parquet, local storage) (c6a.metal, 500gb gp2)Snowflake (32×2XL)ClickHouse Cloud (azure) (32GiB, 2 replica(s))ClickHouse Cloud (azure) (32GiB, 3 replica(s))Snowflake (128×4XL)Redshift (serverless)DuckDB (Parquet, partitioned) (c6a.4xlarge, 500gb gp2)Tablespace (L1 - 16CPU 32GB)YDB (3×64 vCPU 256GB)Snowflake (16×XL)pgpro_tam (parquet, local, parallel) (c6a.metal, 500gb gp2)Parseable (Parquet, partitioned) (c6a.metal, 500gb gp2)Oxla (c6a.4xlarge, 500gb gp2)pgpro_tam (feather, local + cache) (c6a.metal, 500gb gp2)ClickHouse Cloud (aws) (32GiB, 2 replica(s))ByConity (c6a.4xlarge, 500gb gp2)ByteHouse (8×L)CHYT (9×10 vCPU 40GB)pgpro_tam (parquet, local storage) (16 vCPU 32GB)Redshift (4×ra3.4xlarge)pgpro_tam (parquet, local + cache) (16 vCPU 32GB)ClickHouse (Parquet, single) (c6a.metal, 500gb gp2)Salesforce Hyper (Parquet) (c6a.4xlarge, 500gb gp2)ClickHouse Cloud (gcp) (32GiB, 2 replica(s))ClickHouse (Parquet, partitioned) (c6a.metal, 500gb gp2)pgpro_tam (parquet, local, parallel) (16 vCPU 32GB)ClickHouse Cloud (aws) (32GiB, 3 replica(s))ClickHouse Cloud (gcp) (32GiB, 3 replica(s))Snowflake (8×L)PostgreSQL with pg_mooncake (c6a.4xlarge, 500gb gp2)Kinetica (c6a.4xlarge, 500gb gp2)DataFusion (Parquet, partitioned) (c6a.4xlarge, 500gb gp2)ClickHouse Cloud (aws) (16GiB, 3 replica(s))ClickHouse Cloud (azure) (16GiB, 3 replica(s))CHYT (4×12 vCPU 48GB)ClickHouse Cloud (azure) (16GiB, 2 replica(s))SingleStore (S2)Parseable (Parquet, partitioned) (c6a.4xlarge, 500gb gp2)chDB (Parquet, partitioned) (c6a.4xlarge, 500gb gp2)ClickHouse Cloud (aws) (16GiB, 2 replica(s))pg_duckdb (Parquet) (c6a.4xlarge, 500gb gp2)ClickHouse Cloud (gcp) (16GiB, 2 replica(s))ClickHouse Cloud (gcp) (16GiB, 3 replica(s))ByteHouse (4×M)ClickHouse (Parquet, single) (c6a.4xlarge, 500gb gp2)DataFusion (Parquet, single) (c6a.4xlarge, 500gb gp2)Snowflake (4×M)VictoriaLogs (c6a.4xlarge, 500gb gp2)Redshift (2×dc2.8xlarge)ParadeDB (Parquet, single) (c6a.4xlarge, 500gb gp2)ParadeDB (Parquet, partitioned) (c6a.4xlarge, 500gb gp2)ClickHouse (data lake, partitioned) (c6a.metal, 500gb gp2)Polars (Parquet) (c6a.metal, 500gb gp2)ClickHouse (Parquet, partitioned) (c6a.4xlarge, 500gb gp2)ClickHouse (data lake, single) (c6a.metal, 500gb gp2)ClickHouse Cloud (azure) (12GiB, 3 replica(s))Polars (DataFrame) (c6a.metal, 500gb gp2)Redshift (4×ra3.xlplus)ClickHouse Cloud (azure) (12GiB, 1 replica(s))CHYT (2×12 vCPU 48GB)ClickHouse Cloud (azure) (12GiB, 2 replica(s))ClickHouse Cloud (gcp) (12GiB, 3 replica(s))Tinybird (Free Trial) (serverless)ClickHouse Cloud (aws) (12GiB, 3 replica(s))CHYT (12 vCPU 48GB)ClickHouse Cloud (aws) (12GiB, 2 replica(s))ByteHouse (2×S)ClickHouse Cloud (gcp) (12GiB, 2 replica(s))ClickHouse Cloud (aws) (12GiB, 1 replica(s))Snowflake (2×S)MonetDB (c6a.4xlarge, 500gb gp2)SingleStore (c6a.4xlarge, 500gb gp2)ClickHouse Cloud (azure) (8GiB, 2 replica(s))MotherDuck (Pulse)ClickHouse Cloud (azure) (8GiB, 1 replica(s))ClickHouse Cloud (azure) (8GiB, 3 replica(s))ClickHouse Cloud (aws) (8GiB, 3 replica(s))ClickHouse Cloud (gcp) (12GiB, 1 replica(s))ClickHouse Cloud (gcp) (8GiB, 2 replica(s))ClickHouse Cloud (aws) (8GiB, 2 replica(s))ClickHouse Cloud (gcp) (8GiB, 3 replica(s))ClickHouse Cloud (gcp) (8GiB, 1 replica(s))Polars (Parquet) (c6a.4xlarge, 500gb gp2)ClickHouse (data lake, single) (c6a.4xlarge, 500gb gp2)ByteHouse (XS)Snowflake (XS)ClickHouse (data lake, partitioned) (c6a.4xlarge, 500gb gp2)ClickHouse Cloud (aws) (8GiB, 1 replica(s))TimescaleDB (c6a.4xlarge, 500gb gp2)GlareDB (c6a.4xlarge, 500gb gp2)SigLens (c6a.4xlarge, 700gb gp2)Timescale Cloud (16 vCPU 64GB)Cloudberry (c6a.4xlarge, 500gb gp2)Greenplum (c6a.4xlarge, 500gb gp2)Pinot (c6a.4xlarge, 500gb gp2)Athena (single) (serverless)Timescale Cloud (8 vCPU 32GB)Athena (partitioned) (serverless)PostgreSQL (with indexes) (c6a.4xlarge, 500gb gp2)Tembo OLAP (columnar) (c6a.4xlarge, 500gb gp3)CrateDB (c6a.4xlarge, 500gb gp2)Timescale Cloud (4 vCPU 16GB)CrateDB (c6a.4xlarge, 500gb gp2)Opteryx (c6a.4xlarge, 500gb gp2)AlloyDB (16 vCPU 128GB)AlloyDB (8 vCPU 64GB)MariaDB ColumnStore (c6a.4xlarge, 500gb gp2)GlareDB (c6a.metal, 500gb gp2)Elasticsearch (c6a.4xlarge, 1500gb gp2)AlloyDB (tuned) (8 vCPU 64GB)Spark (c6a.4xlarge, 500gb gp2)Drill (c6a.4xlarge, 500gb gp2)Druid (c6a.4xlarge, 500gb gp2)Pandas (DataFrame) (c6a.metal, 500gb gp2)HeavyAI (c6a.4xlarge, 500gb gp2)pg_duckdb (with indexes) (c6a.4xlarge, 500gb gp2)Citus (c6a.4xlarge, 500gb gp2)Aurora for PostgreSQL (16acu)MongoDB (c6a.4xlarge, 500gb gp2)TimescaleDB (no columnstore) (c6a.4xlarge, 500gb gp2)Infobright (c6a.4xlarge, 500gb gp2)SQLite (c6a.4xlarge, 500gb gp2)MySQL (MyISAM) (c6a.4xlarge, 500gb gp2)MySQL (c6a.4xlarge, 500gb gp2)pg_duckdb (c6a.4xlarge, 500gb gp2)PostgreSQL (c6a.4xlarge, 500gb gp2)Aurora for MySQL (16acu)OctoSQL (c6a.4xlarge, 500gb gp2)
Load time: 242s (×242.17)413s (×413.00)124s (×123.60)85s (×84.73)136s (×136.44)128s (×128.43)522s (×521.79)459s (×459.00)451s (×451.00)30s (×29.57)1s (×1.00)203s (×203.44)433s (×433.00)70s (×70.00)184s (×184.29)133s (×133.28)69s (×69.39)157s (×157.00)119s (×118.62)372s (×372.30)224s (×224.07)0782s (×782.00)228s (×227.84)0187s (×186.89)231s (×230.81)225s (×225.24)457s (×456.65)1829s (×1829.00)136s (×136.00)0184s (×184.13)232s (×232.15)1043s (×1043.00)77s (×76.80)189s (×189.44)376s (×376.31)232s (×232.40)0357s (×357.00)210s (×210.42)470s (×469.59)514s (×514.26)819s (×818.80)01s (×1.00)368s (×368.00)215s (×215.19)191s (×190.56)24242s (×24242.00)0415s (×415.00)492s (×492.00)2524s (×2524.00)851s (×851.00)845s (×845.00)2524s (×2524.00)782s (×782.03)840s (×840.27)2524s (×2524.00)1889s (×1889.00)013711s (×13711.00)978s (×978.00)2524s (×2524.00)377s (×377.00)0498s (×497.81)1013s (×1013.00)264s (×264.26)343s (×343.48)745s (×745.00)0896s (×896.00)1904s (×1904.00)901s (×901.00)00231s (×231.04)0231s (×231.00)184s (×184.29)295s (×294.62)2524s (×2524.00)576s (×576.00)645s (×645.00)0295s (×295.36)349s (×348.56)0336s (×336.07)1145s (×1145.00)00408s (×408.47)0432s (×432.45)429s (×428.75)745s (×745.00)002524s (×2524.00)2108s (×2108.00)2485s (×2485.00)000000902s (×901.80)2s (×2.30)2103s (×2103.00)805s (×805.39)0411s (×411.30)528s (×528.42)0452s (×452.18)0459s (×459.39)745s (×745.00)594s (×594.47)441s (×440.98)2524s (×2524.00)939s (×939.00)690s (×690.00)1246s (×1246.14)756s (×755.88)820s (×819.73)951s (×951.21)726s (×725.81)613s (×613.28)923s (×923.25)748s (×748.31)947s (×947.37)961s (×960.80)00745s (×745.00)2524s (×2524.00)01590s (×1590.43)2925s (×2925.00)06346s (×6345.89)3582s (×3582.00)601s (×601.00)1080s (×1080.00)2032s (×2032.00)04100s (×4100.00)010357s (×10357.00)4903s (×4903.00)5898s (×5898.00)4536s (×4536.00)5868s (×5868.00)001543s (×1542.70)2508s (×2507.80)010072s (×10071.80)00019620s (×19620.00)0573s (×572.63)10701s (×10701.00)1579s (×1579.00)2127s (×2127.00)44824s (×44824.00)2633s (×2633.00)2317s (×2317.00)2608s (×2608.00)2512s (×2512.00)9472s (×9472.00)1022s (×1022.00)937s (×937.00)7687s (×7687.32)0
Data size: 34.74 GiB (×1313.66)17.66 GiB (×667.66)22.07 GiB (×834.56)77.11 GiB (×2915.87)13.79 GiB (×521.38)13.48 GiB (×509.55)33.96 GiB (×1284.02)16.17 GiB (×611.53)16.17 GiB (×611.40)95.29 GiB (×3603.10)13.56 GiB (×512.64)9.26 GiB (×350.26)16.49 GiB (×623.50)19.49 GiB (×736.80)9.26 GiB (×350.20)13.73 GiB (×519.00)22.00 GiB (×831.80)67.84 GiB (×2565.36)24.50 GiB (×926.41)22.03 GiB (×832.89)9.26 GiB (×350.26)13.73 GiB (×519.00)17.66 GiB (×667.66)9.27 GiB (×350.46)43.77 GiB (×1655.10)9.26 GiB (×350.19)9.26 GiB (×350.18)9.26 GiB (×350.28)14.49 GiB (×548.00)24.52 GiB (×927.26)28.70 GiB (×1085.22)13.73 GiB (×519.00)9.26 GiB (×350.28)9.27 GiB (×350.36)17.90 GiB (×676.85)22.00 GiB (×831.80)9.26 GiB (×350.26)9.26 GiB (×350.23)9.27 GiB (×350.34)43.77 GiB (×1655.10)19.49 GiB (×736.80)9.26 GiB (×350.26)13.48 GiB (×509.53)13.73 GiB (×519.00)9.26 GiB (×350.30)13.76 GiB (×520.49)13.56 GiB (×512.64)19.49 GiB (×736.80)9.26 GiB (×350.33)9.27 GiB (×350.45)67.84 GiB (×2565.19)13.73 GiB (×519.00)15.99 GiB (×604.67)16.05 GiB (×606.91)11.46 GiB (×433.15)9.01 GiB (×340.73)9.03 GiB (×341.27)11.46 GiB (×433.15)9.27 GiB (×350.35)9.26 GiB (×350.28)11.46 GiB (×433.15)28.22 GiB (×1067.04)13.73 GiB (×519.00)126.17 GiB (×4770.65)25.59 GiB (×967.52)11.46 GiB (×433.15)8.66 GiB (×327.40)13.06 GiB (×493.68)16.20 GiB (×612.58)65.75 GiB (×2486.06)9.26 GiB (×350.22)13.60 GiB (×514.24)25.32 GiB (×957.52)11.17 GiB (×422.29)9.03 GiB (×341.26)20.78 GiB (×785.79)9.03 GiB (×341.27)13.73 GiB (×519.00)13.73 GiB (×519.00)9.26 GiB (×350.23)13.73 GiB (×519.00)8.66 GiB (×327.40)9.26 GiB (×350.24)9.27 GiB (×350.35)11.46 GiB (×433.15)13.62 GiB (×514.85)☠13.76 GiB (×520.49)9.26 GiB (×350.11)9.26 GiB (×350.11)11.17 GiB (×422.29)9.26 GiB (×350.29)17.90 GiB (×676.85)13.06 GiB (×493.68)13.73 GiB (×519.00)9.26 GiB (×350.18)13.80 GiB (×521.93)9.26 GiB (×350.10)9.26 GiB (×350.11)25.32 GiB (×957.52)13.73 GiB (×519.00)13.76 GiB (×520.49)11.46 GiB (×433.15)15.81 GiB (×597.81)25.41 GiB (×960.64)13.76 GiB (×520.49)13.76 GiB (×520.49)13.73 GiB (×519.00)NaN GiB (×NaN)13.73 GiB (×519.00)13.73 GiB (×519.00)9.26 GiB (×350.28)NaN GiB (×NaN)19.61 GiB (×741.67)9.26 GiB (×350.28)11.17 GiB (×422.29)9.26 GiB (×350.26)9.26 GiB (×350.10)0.00 GiB (×0.00)9.26 GiB (×350.11)11.17 GiB (×422.29)9.26 GiB (×350.11)25.32 GiB (×957.52)9.26 GiB (×350.11)9.26 GiB (×350.27)11.46 GiB (×433.15)46.28 GiB (×1750.10)27.79 GiB (×1050.71)9.26 GiB (×350.27)22.00 GiB (×831.80)9.27 GiB (×350.37)9.27 GiB (×350.46)9.26 GiB (×350.25)9.26 GiB (×350.10)9.27 GiB (×350.40)9.26 GiB (×350.25)9.26 GiB (×350.29)9.26 GiB (×350.29)NaN GiB (×NaN)13.73 GiB (×519.00)25.32 GiB (×957.52)11.46 GiB (×433.15)13.73 GiB (×519.00)9.26 GiB (×350.26)17.98 GiB (×679.83)13.76 GiB (×520.49)0.03 GiB (×1.00)17.98 GiB (×679.83)33.53 GiB (×1267.77)39.12 GiB (×1479.06)☠12.85 GiB (×485.98)17.98 GiB (×679.83)12.85 GiB (×485.98)115.84 GiB (×4380.35)31.54 GiB (×1192.57)51.96 GiB (×1964.71)17.98 GiB (×679.83)37.91 GiB (×1433.45)13.73 GiB (×519.00)9.26 GiB (×350.09)9.26 GiB (×350.09)18.36 GiB (×694.20)13.76 GiB (×520.49)71.37 GiB (×2698.71)9.26 GiB (×350.09)13.73 GiB (×519.00)13.73 GiB (×519.00)42.09 GiB (×1591.35)43.77 GiB (×1655.10)47.39 GiB (×1792.04)118.42 GiB (×4477.62)17.68 GiB (×668.43)48.60 GiB (×1837.69)80.46 GiB (×3042.56)67.08 GiB (×2536.30)12.82 GiB (×484.58)70.57 GiB (×2668.53)113.24 GiB (×4281.85)160.14 GiB (×6055.47)99.17 GiB (×3749.86)99.18 GiB (×3750.11)83.46 GiB (×3155.84)13.73 GiB (×519.00)
Q0. Query 0: SELECT COUNT(*) FROM hits;0.014s (×2.35)0.006s (×1.59)0.000s (×1.00)0.010s (×1.99)0.003s (×1.30)0.003s (×1.30)0.011s (×2.13)0.020s (×2.99)0.020s (×2.99)0.010s (×2.04)0.003s (×1.30)0.002s (×1.20)0.030s (×3.99)0.002s (×1.22)0.003s (×1.30)0.003s (×1.28)0.017s (×2.65)0.000s (×1.03)0.019s (×2.88)0.000s (×1.00)0.003s (×1.30)0.014s (×2.43)0.006s (×1.58)0.002s (×1.20)0.015s (×2.46)0.003s (×1.30)0.002s (×1.20)0.003s (×1.30)0.001s (×1.10)0.023s (×3.32)0.018s (×2.81)0.140s (×14.96)0.003s (×1.30)0.003s (×1.30)0.040s (×4.99)0.016s (×2.56)0.003s (×1.30)0.002s (×1.20)0.002s (×1.20)0.025s (×3.53)0.002s (×1.16)0.002s (×1.20)0.002s (×1.20)0.001s (×1.14)0.002s (×1.20)0.070s (×7.97)0.002s (×1.20)0.002s (×1.20)0.003s (×1.30)0.003s (×1.30)0.000s (×1.03)0.053s (×6.33)0.030s (×3.99)0.020s (×2.99)0.049s (×5.88)0.067s (×7.69)0.055s (×6.44)0.052s (×6.18)0.002s (×1.20)0.002s (×1.20)0.061s (×7.08)0.200s (×20.91)0.082s (×9.18)0.033s (×4.27)0.056s (×6.60)0.053s (×6.28)0.078s (×8.76)0.010s (×1.99)0.026s (×3.64)0.125s (×13.45)0.002s (×1.20)0.003s (×1.30)0.087s (×9.68)0.094s (×10.38)0.050s (×6.03)0.018s (×2.77)0.054s (×6.43)0.053s (×6.28)0.027s (×3.71)0.002s (×1.20)0.067s (×7.68)0.067s (×7.64)0.002s (×1.20)0.003s (×1.30)0.051s (×6.08)0.133s (×14.31)0.050s (×5.98)0.019s (×2.89)0.002s (×1.20)0.002s (×1.20)0.168s (×17.74)0.003s (×1.30)0.010s (×1.99)0.009s (×1.90)0.012s (×2.15)0.002s (×1.20)0.138s (×14.74)0.003s (×1.30)0.002s (×1.20)0.111s (×12.10)0.050s (×5.98)0.058s (×6.78)0.062s (×7.18)0.012s (×2.19)0.086s (×9.61)0.135s (×14.46)0.166s (×17.53)0.149s (×15.86)0.030s (×3.95)0.028s (×3.79)0.153s (×16.26)0.002s (×1.20)0.000s (×1.00)0.034s (×4.34)0.002s (×1.20)0.200s (×20.93)0.002s (×1.20)0.002s (×1.20)0.002s (×1.20)0.002s (×1.20)0.271s (×28.06)0.002s (×1.20)0.104s (×11.35)0.003s (×1.30)0.002s (×1.20)0.060s (×6.98)0.000s (×1.01)0.000s (×1.00)0.002s (×1.20)0.018s (×2.76)0.002s (×1.20)0.002s (×1.20)0.002s (×1.20)0.002s (×1.20)0.003s (×1.30)0.002s (×1.20)0.002s (×1.20)0.002s (×1.20)0.160s (×16.98)0.120s (×12.97)0.091s (×10.07)0.055s (×6.48)0.387s (×39.60)0.002s (×1.20)0.036s (×4.60)0.069s (×7.88)0.079s (×8.88)0.061s (×7.07)1.206s (×121.30)1.073s (×108.06)0.001s (×1.10)1.327s (×133.36)0.059s (×6.90)2.925s (×292.75)0.757s (×76.52)0.288s (×29.76)0.001s (×1.11)0.066s (×7.60)0.001s (×1.14)0.082s (×9.20)3.547s (×354.76)0.045s (×5.45)0.148s (×15.76)0.070s (×7.98)0.000s (×1.00)6.812s (×680.42)1.446s (×145.21)0.261s (×27.03)0.017s (×2.66)94.346s (×9411.56)0.022s (×3.19)0.834s (×84.15)6.525s (×651.83)5.718s (×571.35)62.480s (×6233.08)0.794s (×80.20)0.000s (×1.00)1.200s (×120.69)0.000s (×1.00)339.770s (×33891.44)258.418s (×25776.96)258.511s (×25786.24)739.910s (×73803.50)6.622s (×661.51)
Q1. Query 1: SELECT COUNT(*) FROM hits WHERE AdvEngineID <> 0;0.013s (×2.08)0.011s (×1.92)0.006s (×1.45)0.012s (×2.00)0.014s (×2.18)0.013s (×2.09)0.005s (×1.35)0.020s (×2.73)0.020s (×2.73)0.010s (×1.83)0.014s (×2.18)0.018s (×2.55)0.030s (×3.64)0.014s (×2.18)0.019s (×2.64)0.032s (×3.86)0.009s (×1.76)0.018s (×2.51)0.012s (×2.01)0.003s (×1.18)0.016s (×2.36)0.019s (×2.66)0.009s (×1.73)0.017s (×2.45)0.016s (×2.40)0.026s (×3.27)0.013s (×2.09)0.024s (×3.09)0.001s (×1.00)0.028s (×3.43)0.016s (×2.40)0.068s (×7.09)0.015s (×2.27)0.021s (×2.82)0.000s (×0.91)0.014s (×2.18)0.414s (×38.55)0.012s (×2.00)0.013s (×2.09)0.029s (×3.58)0.020s (×2.73)0.017s (×2.45)0.008s (×1.64)0.008s (×1.67)0.463s (×43.00)0.071s (×7.33)0.012s (×2.00)0.026s (×3.30)0.020s (×2.73)0.091s (×9.18)0.065s (×6.86)0.059s (×6.30)0.040s (×4.55)0.030s (×3.64)1.252s (×114.73)0.035s (×4.13)0.039s (×4.43)0.324s (×30.36)0.012s (×2.00)0.013s (×2.09)1.927s (×176.09)0.030s (×3.62)0.060s (×6.36)0.063s (×6.61)0.078s (×7.97)0.240s (×22.73)0.048s (×5.25)0.202s (×19.27)0.010s (×1.83)0.126s (×12.37)0.025s (×3.18)0.025s (×3.18)0.105s (×10.47)0.095s (×9.51)0.053s (×5.70)0.022s (×2.91)0.053s (×5.72)0.116s (×11.45)0.049s (×5.33)0.023s (×3.00)0.142s (×13.82)0.058s (×6.18)0.025s (×3.18)0.732s (×67.45)0.190s (×18.18)0.152s (×14.69)0.066s (×6.91)0.035s (×4.09)0.028s (×3.45)0.017s (×2.45)0.126s (×12.34)0.032s (×3.82)0.000s (×0.91)0.078s (×8.00)0.042s (×4.69)0.027s (×3.36)0.142s (×13.84)0.030s (×3.64)0.138s (×13.45)0.120s (×11.83)0.093s (×9.36)0.077s (×7.91)0.407s (×37.91)0.010s (×1.82)0.091s (×9.19)0.159s (×15.39)0.181s (×17.38)0.274s (×25.82)0.036s (×4.19)0.130s (×12.73)0.373s (×34.82)0.043s (×4.82)0.032s (×3.83)0.041s (×4.66)0.020s (×2.73)0.167s (×16.09)0.028s (×3.45)0.041s (×4.64)0.030s (×3.64)0.028s (×3.45)0.239s (×22.60)0.055s (×5.91)0.121s (×11.88)0.061s (×6.45)0.028s (×3.45)0.311s (×29.18)0.018s (×2.59)0.010s (×1.82)0.023s (×3.00)0.014s (×2.18)0.025s (×3.18)0.021s (×2.82)0.029s (×3.55)0.056s (×6.00)0.025s (×3.18)0.029s (×3.55)0.023s (×3.00)0.027s (×3.36)0.025s (×3.21)0.484s (×44.91)0.122s (×11.96)0.386s (×36.00)0.715s (×65.91)0.040s (×4.55)0.168s (×16.21)0.424s (×39.45)0.411s (×38.27)0.217s (×20.65)0.456s (×42.40)1.001s (×91.89)0.185s (×17.73)2.248s (×205.27)0.294s (×27.65)3.136s (×286.00)0.694s (×64.02)0.276s (×26.01)0.004s (×1.32)0.418s (×38.94)0.003s (×1.18)0.315s (×29.53)0.084s (×8.53)0.054s (×5.80)0.101s (×10.09)3.978s (×362.55)1.667s (×152.45)0.102s (×10.18)1.431s (×130.97)1.615s (×147.73)0.271s (×25.55)1.384s (×126.77)0.040s (×4.55)0.823s (×75.76)5.002s (×455.67)62.140s (×5650.02)0.398s (×37.09)248.585s (×22599.55)2.400s (×219.09)286.965s (×26088.64)274.520s (×24957.27)367.550s (×33414.55)258.429s (×23494.45)258.532s (×23503.82)832.870s (×75716.36)40.846s (×3714.18)
Q2. Query 2: SELECT SUM(AdvEngineID), COUNT(*), AVG(ResolutionWidth) FROM hits;0.016s (×1.37)0.015s (×1.34)0.019s (×1.55)0.015s (×1.33)0.018s (×1.49)0.018s (×1.49)0.027s (×1.96)0.040s (×2.67)0.030s (×2.13)0.013s (×1.23)0.020s (×1.60)0.021s (×1.65)0.060s (×3.73)0.021s (×1.64)0.022s (×1.71)0.032s (×2.24)0.021s (×1.65)0.009s (×1.00)0.024s (×1.79)0.017s (×1.44)0.026s (×1.92)0.048s (×3.08)0.030s (×2.11)0.029s (×2.08)0.019s (×1.54)0.036s (×2.45)0.026s (×1.92)0.035s (×2.40)0.022s (×1.71)0.036s (×2.46)0.037s (×2.53)0.081s (×4.85)0.027s (×1.97)0.037s (×2.51)0.010s (×1.07)0.034s (×2.34)0.039s (×2.61)0.031s (×2.19)0.045s (×2.93)0.027s (×1.96)0.031s (×2.21)0.034s (×2.35)0.020s (×1.60)0.023s (×1.77)0.370s (×20.26)0.082s (×4.90)0.030s (×2.13)0.046s (×3.00)0.047s (×3.04)0.044s (×2.88)0.038s (×2.57)0.069s (×4.21)0.030s (×2.13)0.070s (×4.26)0.325s (×17.86)0.052s (×3.30)0.056s (×3.51)0.275s (×15.19)0.049s (×3.15)0.053s (×3.36)0.222s (×12.37)0.038s (×2.58)0.086s (×5.12)0.108s (×6.29)0.096s (×5.65)1.051s (×56.56)0.058s (×3.65)0.114s (×6.61)0.016s (×1.36)0.122s (×7.02)0.085s (×5.06)0.048s (×3.09)0.121s (×6.99)0.103s (×6.00)0.083s (×4.97)0.056s (×3.50)0.081s (×4.87)0.148s (×8.42)0.170s (×9.61)0.068s (×4.16)0.171s (×9.65)0.092s (×5.45)0.058s (×3.62)0.083s (×4.96)0.566s (×30.70)0.172s (×9.70)0.053s (×3.36)0.081s (×4.85)0.099s (×5.81)2.121s (×113.60)0.143s (×8.15)0.080s (×4.80)0.090s (×5.33)0.104s (×6.08)0.076s (×4.57)0.156s (×8.85)0.169s (×9.53)0.112s (×6.50)0.090s (×5.33)0.101s (×5.91)0.120s (×6.93)0.117s (×6.77)0.266s (×14.71)0.200s (×11.19)0.142s (×8.11)0.209s (×11.70)0.195s (×10.93)0.374s (×20.47)0.125s (×7.19)0.233s (×12.95)0.494s (×26.87)0.176s (×9.91)0.450s (×24.50)0.109s (×6.34)0.187s (×10.50)0.194s (×10.89)0.163s (×9.22)0.120s (×6.93)0.080s (×4.80)0.242s (×13.43)0.296s (×16.34)0.299s (×16.47)0.151s (×8.58)0.127s (×7.30)0.316s (×17.38)0.426s (×23.24)0.035s (×2.40)0.150s (×8.53)0.159s (×9.01)0.044s (×2.86)0.403s (×22.02)0.150s (×8.53)0.171s (×9.65)0.290s (×15.99)0.177s (×9.97)0.171s (×9.65)0.242s (×13.43)0.245s (×13.59)0.105s (×6.13)0.786s (×42.43)0.160s (×9.06)0.560s (×30.38)0.857s (×46.22)0.327s (×17.96)0.246s (×13.66)0.462s (×25.16)0.081s (×4.85)0.319s (×17.55)1.552s (×83.29)1.934s (×103.64)0.258s (×14.29)2.316s (×123.99)0.474s (×25.78)3.640s (×194.57)237.615s (×12666.89)1.027s (×55.30)2.291s (×122.65)0.696s (×37.63)2.043s (×109.42)0.665s (×35.98)2.977s (×159.24)5.538s (×295.74)1.226s (×65.89)3.812s (×203.74)13.991s (×746.34)6.171s (×329.50)1.431s (×76.81)1.750s (×93.82)0.152s (×8.62)0.085s (×5.08)0.093s (×5.49)237.665s (×12669.55)9.864s (×526.35)67.609s (×3604.51)115.775s (×6172.06)248.325s (×13237.80)0.000s (×0.53)287.219s (×15311.09)278.290s (×14835.12)368.910s (×19665.73)258.416s (×13775.71)258.521s (×13781.31)830.980s (×44296.93)48.597s (×2591.06)
Q3. Query 3: SELECT AVG(UserID) FROM hits;0.025s (×1.78)0.026s (×1.82)0.012s (×1.12)0.017s (×1.37)0.020s (×1.53)0.020s (×1.53)0.027s (×1.89)0.040s (×2.54)0.050s (×3.05)0.018s (×1.42)0.021s (×1.58)0.026s (×1.83)0.060s (×3.56)0.019s (×1.49)0.027s (×1.88)0.031s (×2.09)0.024s (×1.75)0.010s (×1.00)0.026s (×1.84)0.027s (×1.88)0.038s (×2.44)0.044s (×2.74)0.029s (×2.00)0.038s (×2.44)0.022s (×1.61)0.045s (×2.80)0.036s (×2.34)0.039s (×2.49)0.029s (×1.98)0.059s (×3.50)0.042s (×2.65)0.065s (×3.82)0.037s (×2.39)0.043s (×2.70)0.010s (×1.02)0.039s (×2.51)0.044s (×2.75)0.047s (×2.90)0.052s (×3.16)0.023s (×1.68)0.030s (×2.04)0.059s (×3.51)0.029s (×1.98)0.030s (×2.03)0.195s (×10.43)0.088s (×4.98)0.038s (×2.44)0.042s (×2.67)0.052s (×3.16)0.060s (×3.56)0.037s (×2.38)0.070s (×4.06)0.040s (×2.54)0.090s (×5.09)0.181s (×9.72)0.058s (×3.47)0.064s (×3.78)0.166s (×8.96)0.077s (×4.43)0.067s (×3.92)0.206s (×10.99)0.036s (×2.35)0.079s (×4.53)0.108s (×5.99)0.064s (×3.77)0.178s (×9.57)0.078s (×4.46)0.108s (×6.01)0.025s (×1.79)0.135s (×7.37)0.111s (×6.16)0.056s (×3.36)0.107s (×5.94)0.103s (×5.76)0.092s (×5.17)0.177s (×9.52)0.082s (×4.68)0.183s (×9.82)0.129s (×7.07)0.097s (×5.45)0.188s (×10.08)0.113s (×6.28)0.089s (×5.04)0.122s (×6.72)0.264s (×13.95)0.170s (×9.14)0.051s (×3.10)0.086s (×4.89)0.135s (×7.38)0.100s (×5.60)0.143s (×7.79)0.184s (×9.87)0.080s (×4.58)0.112s (×6.21)0.085s (×4.83)0.275s (×14.51)0.151s (×8.19)0.134s (×7.33)0.150s (×8.14)0.148s (×8.05)0.129s (×7.07)0.121s (×6.67)0.301s (×15.83)0.229s (×12.16)0.218s (×11.63)0.194s (×10.39)0.208s (×11.12)0.341s (×17.86)0.096s (×5.40)0.159s (×8.60)0.373s (×19.49)0.192s (×10.28)0.071s (×4.11)0.298s (×15.70)0.299s (×15.73)0.194s (×10.38)0.222s (×11.81)0.179s (×9.62)0.102s (×5.70)0.290s (×15.27)0.325s (×17.05)0.416s (×21.68)0.125s (×6.89)0.194s (×10.38)0.570s (×29.52)0.404s (×21.07)0.029s (×2.00)0.080s (×4.58)0.339s (×17.76)0.051s (×3.08)0.636s (×32.88)0.230s (×12.21)0.310s (×16.29)0.422s (×21.99)0.248s (×13.13)0.740s (×38.17)0.397s (×20.71)0.352s (×18.42)0.115s (×6.37)0.579s (×29.98)0.200s (×10.69)0.538s (×27.89)0.798s (×41.12)0.524s (×27.18)0.206s (×10.99)0.470s (×24.43)0.080s (×4.58)0.257s (×13.60)1.150s (×59.06)0.998s (×51.28)0.238s (×12.62)2.314s (×118.28)0.367s (×19.19)2.514s (×128.46)1.294s (×66.35)0.699s (×36.09)0.363s (×18.99)0.533s (×27.64)0.398s (×20.78)0.491s (×25.50)2.369s (×121.09)0.171s (×9.22)0.736s (×37.97)4.122s (×210.30)6.694s (×341.21)7.651s (×389.93)1.416s (×72.60)1.736s (×88.86)0.129s (×7.07)0.074s (×4.28)0.039s (×2.49)8.245s (×420.15)9.171s (×467.25)5.902s (×300.89)91.646s (×4664.91)248.262s (×12636.01)6.040s (×307.92)5.650s (×288.07)21.550s (×1097.31)377.530s (×19215.21)258.394s (×13151.68)258.487s (×13156.42)830.870s (×42288.32)☠
Q4. Query 4: SELECT COUNT(DISTINCT UserID) FROM hits;0.073s (×1.00)0.084s (×1.13)0.158s (×2.02)0.112s (×1.47)0.113s (×1.48)0.168s (×2.14)0.139s (×1.79)0.160s (×2.04)0.150s (×1.92)0.242s (×3.03)0.185s (×2.34)0.108s (×1.42)0.080s (×1.08)0.246s (×3.08)0.110s (×1.44)0.194s (×2.45)0.153s (×1.96)0.282s (×3.50)0.166s (×2.11)0.301s (×3.74)0.165s (×2.10)0.139s (×1.79)0.567s (×6.93)0.178s (×2.26)0.155s (×1.99)0.184s (×2.33)0.202s (×2.55)0.232s (×2.91)0.342s (×4.23)0.109s (×1.43)0.230s (×2.89)0.145s (×1.86)0.198s (×2.50)0.214s (×2.69)0.230s (×2.88)0.227s (×2.85)0.232s (×2.91)0.246s (×3.08)0.221s (×2.78)0.202s (×2.55)0.423s (×5.21)0.228s (×2.86)0.351s (×4.34)0.350s (×4.33)0.237s (×2.97)0.145s (×1.87)0.311s (×3.86)0.378s (×4.66)0.249s (×3.11)0.354s (×4.38)0.900s (×10.94)0.222s (×2.78)1.050s (×12.74)0.330s (×4.09)0.265s (×3.31)0.328s (×4.06)0.335s (×4.15)0.256s (×3.20)0.497s (×6.09)0.435s (×5.35)0.373s (×4.60)0.303s (×3.76)0.353s (×4.36)0.840s (×10.22)0.215s (×2.70)0.312s (×3.87)0.364s (×4.50)0.519s (×6.36)0.858s (×10.43)0.353s (×4.37)0.699s (×8.52)0.475s (×5.83)0.315s (×3.91)2.084s (×25.17)0.408s (×5.03)0.300s (×3.73)0.371s (×4.58)0.410s (×5.05)0.725s (×8.83)0.712s (×8.68)0.403s (×4.96)0.380s (×4.69)0.627s (×7.66)0.733s (×8.93)0.489s (×6.00)0.437s (×5.37)4.949s (×59.61)0.843s (×10.25)0.657s (×8.02)0.675s (×8.23)2.452s (×29.60)0.631s (×7.71)1.320s (×15.99)0.842s (×10.24)0.419s (×5.15)0.702s (×8.56)0.460s (×5.65)0.811s (×9.87)0.730s (×8.90)0.636s (×7.77)0.464s (×5.70)0.900s (×10.94)0.825s (×10.04)2.118s (×25.58)0.837s (×10.18)0.569s (×6.96)0.536s (×6.56)0.552s (×6.76)1.211s (×14.68)0.517s (×6.33)0.541s (×6.62)1.123s (×13.62)1.163s (×14.10)0.582s (×7.12)1.847s (×22.32)2.506s (×30.24)1.031s (×12.51)1.204s (×14.59)0.637s (×7.78)1.003s (×12.18)0.673s (×8.21)1.009s (×12.25)1.034s (×12.55)1.196s (×14.50)2.328s (×28.10)1.349s (×16.34)4.511s (×54.34)1.200s (×14.54)2.344s (×28.30)6.806s (×81.93)2.718s (×32.79)1.958s (×23.66)1.532s (×18.54)2.348s (×28.34)1.698s (×20.53)1.528s (×18.49)1.727s (×20.88)3.020s (×36.42)0.953s (×11.57)0.805s (×9.80)2.468s (×29.79)2.506s (×30.24)0.928s (×11.28)3.632s (×43.78)10.188s (×122.58)1.200s (×14.54)0.081s (×1.09)14.673s (×176.49)3.525s (×42.50)10.006s (×120.40)3.633s (×43.79)2.876s (×34.69)22.391s (×269.27)2.186s (×26.40)7.274s (×87.55)23.023s (×276.87)☠22.578s (×271.53)☠3.521s (×42.45)39.898s (×479.71)38.158s (×458.79)2.004s (×24.21)6.210s (×74.77)4.413s (×53.17)46.462s (×558.62)5.222s (×62.89)3.731s (×44.97)2.515s (×30.35)4.051s (×48.82)☠10.342s (×124.44)38.119s (×458.33)48.023s (×577.39)25.618s (×308.06)263.995s (×3173.48)15.690s (×188.72)48.452s (×582.54)40.810s (×490.68)384.860s (×4626.34)258.508s (×3107.52)272.624s (×3277.21)842.400s (×10126.22)☠
Q5. Query 5: SELECT COUNT(DISTINCT SearchPhrase) FROM hits;0.095s (×1.58)0.057s (×1.00)0.141s (×2.26)0.129s (×2.08)0.135s (×2.17)0.167s (×2.65)0.222s (×3.48)0.200s (×3.14)0.200s (×3.14)0.182s (×2.87)0.182s (×2.87)0.151s (×2.41)0.210s (×3.29)0.265s (×4.12)0.148s (×2.36)0.200s (×3.14)0.183s (×2.89)0.128s (×2.07)0.200s (×3.14)0.371s (×5.70)0.216s (×3.38)0.130s (×2.10)0.162s (×2.57)0.209s (×3.28)0.209s (×3.28)0.248s (×3.86)0.257s (×3.99)0.284s (×4.40)0.420s (×6.43)0.176s (×2.78)0.279s (×4.32)0.199s (×3.13)0.751s (×11.38)0.297s (×4.59)0.250s (×3.89)0.281s (×4.35)0.282s (×4.37)0.385s (×5.91)0.379s (×5.82)0.295s (×4.56)0.579s (×8.80)0.383s (×5.88)0.443s (×6.78)0.450s (×6.89)0.410s (×6.28)0.236s (×3.68)0.497s (×7.58)0.514s (×7.84)0.423s (×6.48)0.440s (×6.73)0.408s (×6.25)0.494s (×7.54)0.760s (×11.52)0.840s (×12.72)0.298s (×4.61)0.469s (×7.17)0.453s (×6.92)0.325s (×5.01)0.673s (×10.22)0.662s (×10.05)0.326s (×5.03)0.334s (×5.15)0.457s (×6.99)1.174s (×17.71)0.355s (×5.46)0.420s (×6.43)0.513s (×7.82)0.404s (×6.19)1.088s (×16.43)0.398s (×6.10)0.968s (×14.63)0.766s (×11.61)0.347s (×5.33)0.940s (×14.22)0.597s (×9.08)0.454s (×6.94)0.607s (×9.23)0.425s (×6.51)0.415s (×6.35)1.016s (×15.35)0.467s (×7.14)0.653s (×9.92)0.847s (×12.82)1.237s (×18.66)0.650s (×9.87)0.593s (×9.03)2.578s (×38.72)0.858s (×12.99)1.038s (×15.68)1.496s (×22.53)1.121s (×16.91)1.242s (×18.73)1.950s (×29.32)0.875s (×13.24)0.616s (×9.36)1.141s (×17.22)0.632s (×9.61)1.204s (×18.16)1.569s (×23.62)0.563s (×8.57)0.647s (×9.83)0.950s (×14.36)1.024s (×15.47)1.531s (×23.05)0.614s (×9.34)0.764s (×11.58)0.714s (×10.83)0.584s (×8.89)2.616s (×39.28)0.737s (×11.18)0.707s (×10.73)3.720s (×55.80)3.356s (×50.36)1.061s (×16.02)2.770s (×41.59)1.223s (×18.45)2.246s (×33.75)3.577s (×53.66)0.582s (×8.86)1.747s (×26.29)1.039s (×15.70)2.109s (×31.70)1.207s (×18.20)2.290s (×34.41)3.221s (×48.34)1.697s (×25.54)4.269s (×64.01)2.630s (×39.49)3.475s (×52.14)7.505s (×112.42)4.024s (×60.35)2.806s (×42.13)2.664s (×40.00)4.110s (×61.64)2.831s (×42.50)2.750s (×41.29)3.756s (×56.34)4.695s (×70.39)2.658s (×39.92)1.096s (×16.55)1.867s (×28.08)2.649s (×39.78)1.065s (×16.08)5.797s (×86.87)15.258s (×228.40)1.644s (×24.74)0.081s (×1.36)21.811s (×326.45)4.112s (×61.67)3.235s (×48.55)14.687s (×219.87)2.698s (×40.51)43.402s (×649.45)2.742s (×41.17)6.374s (×95.51)35.965s (×538.20)7.286s (×109.15)44.330s (×663.34)☠3.833s (×57.50)128.084s (×1916.31)124.599s (×1864.17)3.755s (×56.33)5.242s (×78.57)156.142s (×2336.06)147.708s (×2209.89)5.352s (×80.22)3.603s (×54.05)6.503s (×97.44)8.552s (×128.09)☠13.245s (×198.30)113.441s (×1697.25)282.436s (×4225.45)10.204s (×152.80)270.091s (×4040.76)42.370s (×634.01)344.884s (×5159.68)467.390s (×6992.39)574.680s (×8597.47)258.359s (×3865.25)278.177s (×4161.73)869.750s (×13011.77)☠
Q6. Query 6: SELECT MIN(EventDate), MAX(EventDate) FROM hits;0.015s (×2.49)0.015s (×2.46)0.016s (×2.56)0.011s (×2.06)0.018s (×2.75)0.016s (×2.56)0.023s (×3.28)0.020s (×2.95)0.020s (×2.95)0.011s (×2.08)0.017s (×2.65)0.014s (×2.36)0.020s (×2.95)0.015s (×2.44)0.016s (×2.56)0.030s (×3.95)0.016s (×2.54)0.018s (×2.73)0.018s (×2.74)0.009s (×1.87)0.018s (×2.75)0.029s (×3.84)0.003s (×1.27)0.017s (×2.65)0.024s (×3.38)0.023s (×3.24)0.012s (×2.16)0.023s (×3.24)0.002s (×1.18)0.029s (×3.81)0.025s (×3.48)0.063s (×7.17)0.013s (×2.26)0.021s (×3.05)0.000s (×0.98)0.024s (×3.31)0.021s (×3.05)0.014s (×2.36)0.018s (×2.75)0.025s (×3.40)0.014s (×2.38)0.023s (×3.24)0.010s (×1.97)0.010s (×1.99)0.014s (×2.36)0.076s (×8.46)0.010s (×1.97)0.024s (×3.36)0.018s (×2.75)0.020s (×2.95)0.025s (×3.43)0.061s (×6.98)0.020s (×2.95)0.020s (×2.95)0.062s (×7.08)0.036s (×4.48)0.033s (×4.27)0.060s (×6.88)0.019s (×2.85)0.016s (×2.56)0.051s (×5.99)0.138s (×14.56)0.061s (×6.98)0.003s (×1.27)0.118s (×12.61)0.054s (×6.29)0.049s (×5.76)0.115s (×12.28)0.014s (×2.39)0.115s (×12.32)0.030s (×3.93)0.036s (×4.52)0.105s (×11.28)0.096s (×10.45)0.045s (×5.37)0.037s (×4.59)0.045s (×5.36)0.109s (×11.69)0.104s (×11.18)0.024s (×3.34)0.139s (×14.64)0.049s (×5.83)0.027s (×3.64)0.040s (×4.91)0.055s (×6.39)0.153s (×16.02)0.053s (×6.19)0.033s (×4.23)0.041s (×5.01)0.029s (×3.83)0.112s (×11.98)0.033s (×4.23)0.000s (×0.98)0.073s (×8.16)0.039s (×4.85)0.040s (×4.91)0.561s (×56.11)0.030s (×3.93)0.031s (×4.03)0.105s (×11.33)0.075s (×8.35)0.068s (×7.67)0.062s (×7.08)0.033s (×4.23)0.102s (×11.02)0.164s (×17.13)0.184s (×19.11)0.276s (×28.11)0.053s (×6.19)0.122s (×12.97)0.284s (×28.89)0.032s (×4.13)0.017s (×2.70)0.082s (×9.06)0.033s (×4.23)0.164s (×17.15)0.035s (×4.42)0.043s (×5.21)0.055s (×6.39)0.088s (×9.63)0.255s (×26.07)0.071s (×7.96)0.117s (×12.50)0.036s (×4.52)0.058s (×6.68)0.059s (×6.78)0.063s (×7.19)0.000s (×0.98)0.051s (×5.99)0.295s (×29.94)0.048s (×5.70)0.045s (×5.40)0.089s (×9.73)0.044s (×5.31)0.040s (×4.91)0.082s (×9.04)0.050s (×5.90)0.074s (×8.25)0.052s (×6.06)0.498s (×49.92)0.111s (×11.89)0.050s (×5.90)0.690s (×68.79)0.084s (×9.24)0.174s (×18.05)0.410s (×41.27)0.081s (×8.94)0.217s (×22.29)1.352s (×133.82)1.224s (×121.31)☠2.199s (×217.08)0.292s (×29.67)1.984s (×195.95)0.000s (×1.00)0.075s (×8.32)0.725s (×72.19)0.423s (×42.58)0.771s (×76.76)0.400s (×40.34)4.024s (×396.41)0.149s (×15.61)0.736s (×73.31)4.054s (×399.37)6.206s (×610.85)7.985s (×785.63)1.453s (×143.80)☠☠0.201s (×20.71)0.093s (×10.12)7.957s (×782.91)7.707s (×758.38)6.216s (×611.83)0.003s (×1.28)248.046s (×24376.57)0.000s (×0.98)10.795s (×1061.81)24.200s (×2379.13)368.230s (×36187.11)258.323s (×25386.50)258.399s (×25393.97)825.540s (×81127.16)59.693s (×5867.04)
Q7. Query 7: SELECT AdvEngineID, COUNT(*) FROM hits WHERE AdvEngineID <> 0 GROUP BY AdvEngineID ORDER BY COUNT(*) DESC;0.013s (×1.65)0.012s (×1.57)0.009s (×1.36)0.015s (×1.79)0.019s (×2.07)0.018s (×2.00)0.005s (×1.10)0.030s (×2.86)0.030s (×2.86)0.011s (×1.51)0.017s (×1.93)0.020s (×2.14)0.040s (×3.57)0.018s (×2.02)0.019s (×2.07)0.035s (×3.19)0.016s (×1.86)0.024s (×2.42)0.019s (×2.04)0.004s (×1.00)0.019s (×2.07)0.019s (×2.10)0.009s (×1.39)0.018s (×2.00)0.030s (×2.89)0.024s (×2.43)0.014s (×1.71)0.025s (×2.50)0.019s (×2.07)0.034s (×3.13)0.023s (×2.36)0.078s (×6.29)0.022s (×2.29)0.023s (×2.36)0.010s (×1.43)0.019s (×2.09)0.024s (×2.43)0.015s (×1.79)0.017s (×1.93)0.033s (×3.10)0.022s (×2.29)0.020s (×2.14)0.010s (×1.43)0.012s (×1.57)0.015s (×1.79)0.073s (×5.96)0.014s (×1.71)0.029s (×2.76)0.019s (×2.07)0.022s (×2.29)0.065s (×5.34)0.068s (×5.54)0.030s (×2.86)0.030s (×2.86)0.194s (×14.57)0.042s (×3.73)0.047s (×4.09)0.280s (×20.71)0.015s (×1.79)0.034s (×3.14)0.358s (×26.29)0.218s (×16.31)0.060s (×5.00)0.075s (×6.06)0.550s (×40.02)0.200s (×15.00)0.057s (×4.77)0.104s (×8.14)0.013s (×1.65)0.202s (×15.17)0.025s (×2.50)0.030s (×2.86)0.122s (×9.42)0.101s (×7.93)0.056s (×4.70)0.024s (×2.42)0.058s (×4.88)0.126s (×9.71)0.046s (×4.01)0.027s (×2.64)0.145s (×11.07)0.059s (×4.91)0.030s (×2.86)0.027s (×2.64)0.307s (×22.64)0.150s (×11.45)0.064s (×5.29)0.037s (×3.36)0.104s (×8.14)0.023s (×2.36)0.121s (×9.39)0.025s (×2.50)0.010s (×1.43)0.078s (×6.29)0.045s (×3.91)0.027s (×2.64)0.143s (×10.91)0.036s (×3.29)0.030s (×2.86)0.129s (×9.93)0.099s (×7.79)0.083s (×6.64)0.254s (×18.86)0.010s (×1.43)0.106s (×8.31)0.160s (×12.16)0.187s (×14.09)0.290s (×21.43)0.013s (×1.67)0.129s (×9.93)0.271s (×20.07)0.023s (×2.36)0.037s (×3.36)0.045s (×3.90)0.025s (×2.50)0.166s (×12.55)0.024s (×2.43)0.030s (×2.86)0.032s (×3.00)0.033s (×3.07)0.276s (×20.46)0.033s (×3.07)0.118s (×9.11)0.029s (×2.79)0.030s (×2.86)0.508s (×37.00)0.021s (×2.21)0.020s (×2.14)0.035s (×3.21)0.197s (×14.78)0.039s (×3.50)0.034s (×3.14)0.036s (×3.29)0.060s (×5.00)0.034s (×3.14)0.038s (×3.43)0.037s (×3.36)0.037s (×3.36)0.013s (×1.62)0.462s (×33.71)0.129s (×9.90)0.387s (×28.36)0.613s (×44.50)0.058s (×4.86)0.186s (×14.03)0.423s (×30.93)0.284s (×21.00)0.238s (×17.69)0.453s (×33.10)1.021s (×73.65)0.134s (×10.29)3.072s (×220.14)0.324s (×23.87)2.403s (×172.36)0.688s (×49.89)0.277s (×20.49)0.415s (×30.37)0.469s (×34.24)0.030s (×2.89)0.324s (×23.85)0.093s (×7.37)0.057s (×4.78)0.103s (×8.07)3.961s (×283.64)1.709s (×122.79)0.123s (×9.48)1.628s (×116.98)1.711s (×122.93)0.274s (×20.27)0.709s (×51.36)0.038s (×3.43)0.844s (×61.01)4.728s (×338.44)53.531s (×3824.34)0.644s (×46.71)247.977s (×17713.36)2.420s (×173.57)286.879s (×20492.07)275.300s (×19665.00)384.020s (×27430.71)258.307s (×18451.21)258.382s (×18456.57)829.250s (×59232.86)40.871s (×2920.07)
Q8. Query 8: SELECT RegionID, COUNT(DISTINCT UserID) AS u FROM hits GROUP BY RegionID ORDER BY u DESC LIMIT 10;0.077s (×1.00)0.148s (×1.81)0.183s (×2.21)0.165s (×2.00)0.158s (×1.92)0.259s (×3.08)0.174s (×2.11)0.210s (×2.52)0.230s (×2.75)0.249s (×2.96)0.262s (×3.11)0.222s (×2.65)0.120s (×1.49)0.287s (×3.40)0.236s (×2.82)0.302s (×3.57)0.188s (×2.27)1.947s (×22.39)0.193s (×2.32)0.362s (×4.26)0.256s (×3.04)0.222s (×2.66)0.814s (×9.43)0.389s (×4.57)0.148s (×1.81)0.302s (×3.57)0.314s (×3.71)0.480s (×5.61)0.499s (×5.82)0.133s (×1.64)0.284s (×3.36)0.161s (×1.96)0.310s (×3.66)0.328s (×3.87)0.310s (×3.66)0.285s (×3.37)0.375s (×4.41)0.429s (×5.02)0.362s (×4.26)0.305s (×3.60)0.525s (×6.12)0.395s (×4.63)0.505s (×5.89)0.529s (×6.16)0.403s (×4.73)0.165s (×2.01)0.535s (×6.24)0.582s (×6.78)0.574s (×6.68)0.457s (×5.34)2.234s (×25.68)0.332s (×3.91)0.540s (×6.29)0.470s (×5.49)0.319s (×3.76)0.391s (×4.59)0.394s (×4.63)0.314s (×3.71)0.600s (×6.98)0.660s (×7.67)0.477s (×5.57)0.682s (×7.92)0.465s (×5.44)1.380s (×15.91)0.341s (×4.02)0.366s (×4.30)0.419s (×4.91)0.823s (×9.53)1.301s (×15.00)0.415s (×4.87)0.834s (×9.66)0.600s (×6.98)0.444s (×5.19)0.778s (×9.02)0.432s (×5.05)0.465s (×5.44)0.439s (×5.14)0.508s (×5.93)0.937s (×10.84)0.932s (×10.78)0.491s (×5.73)0.458s (×5.35)0.640s (×7.44)1.092s (×12.61)0.593s (×6.90)0.535s (×6.24)2.544s (×29.23)0.943s (×10.91)0.911s (×10.54)1.093s (×12.62)0.816s (×9.45)1.607s (×18.50)1.710s (×19.68)1.050s (×12.13)0.690s (×8.01)1.012s (×11.70)0.570s (×6.64)2.219s (×25.51)1.112s (×12.84)0.891s (×10.31)0.672s (×7.80)0.977s (×11.29)0.952s (×11.01)2.209s (×25.39)1.313s (×15.14)0.680s (×7.89)0.639s (×7.43)0.693s (×8.04)1.372s (×15.82)0.726s (×8.42)0.614s (×7.14)1.444s (×16.64)0.933s (×10.80)0.868s (×10.05)2.282s (×26.23)0.977s (×11.30)1.751s (×20.15)1.908s (×21.95)2.341s (×26.90)2.236s (×25.70)0.960s (×11.10)1.960s (×22.54)1.515s (×17.45)2.381s (×27.36)2.758s (×31.68)1.631s (×18.78)4.408s (×50.56)1.390s (×16.02)2.845s (×32.67)6.255s (×71.69)2.168s (×24.92)2.657s (×30.52)2.579s (×29.63)3.447s (×39.56)2.481s (×28.51)3.214s (×36.89)3.868s (×44.38)4.231s (×48.53)1.347s (×15.53)0.960s (×11.10)3.743s (×42.95)2.993s (×34.37)1.096s (×12.66)4.587s (×52.61)19.960s (×228.53)1.880s (×21.63)5.590s (×64.08)25.260s (×289.18)7.482s (×85.74)3.511s (×40.29)2.902s (×33.32)2.477s (×28.46)80.652s (×923.06)2.014s (×23.16)8.181s (×93.73)27.189s (×311.26)29.734s (×340.38)81.032s (×927.41)☠5.473s (×62.74)35.256s (×403.57)47.638s (×545.26)2.029s (×23.33)6.742s (×77.27)16.050s (×183.78)48.581s (×556.06)6.921s (×79.31)4.427s (×50.78)10.598s (×121.39)9.746s (×111.65)☠10.555s (×120.90)76.922s (×880.38)131.102s (×1500.39)377.012s (×4314.49)277.788s (×3179.01)22.210s (×254.28)354.126s (×4052.59)325.350s (×3723.29)495.680s (×5672.48)258.278s (×2955.75)284.965s (×3261.14)909.460s (×10407.62)☠
Q9. Query 9: SELECT RegionID, SUM(AdvEngineID), COUNT(*) AS c, AVG(ResolutionWidth), COUNT(DISTINCT UserID) FROM hits GROUP BY RegionID ORDER BY c DESC LIMIT 10;0.102s (×1.00)0.167s (×1.58)0.212s (×1.98)0.367s (×3.36)0.384s (×3.51)0.277s (×2.56)0.253s (×2.34)0.250s (×2.32)0.250s (×2.32)0.278s (×2.57)0.268s (×2.48)0.238s (×2.21)0.700s (×6.33)0.304s (×2.80)0.247s (×2.29)0.307s (×2.82)0.255s (×2.36)1.967s (×17.62)0.262s (×2.43)0.488s (×4.44)0.284s (×2.62)0.229s (×2.13)0.814s (×7.34)0.291s (×2.68)0.174s (×1.64)0.344s (×3.15)0.347s (×3.18)0.319s (×2.93)0.544s (×4.94)1.413s (×12.68)0.394s (×3.60)0.177s (×1.67)0.384s (×3.51)0.389s (×3.56)0.850s (×7.66)0.397s (×3.63)0.372s (×3.40)0.451s (×4.11)0.423s (×3.86)0.305s (×2.80)0.595s (×5.39)0.470s (×4.28)0.545s (×4.95)0.592s (×5.36)0.437s (×3.98)0.210s (×1.96)0.584s (×5.29)0.663s (×6.00)0.632s (×5.72)0.567s (×5.14)2.822s (×25.23)0.379s (×3.47)0.610s (×5.52)1.470s (×13.19)0.411s (×3.75)0.451s (×4.11)0.472s (×4.30)0.417s (×3.80)0.675s (×6.10)0.669s (×6.05)0.499s (×4.54)1.545s (×13.86)0.578s (×5.24)1.315s (×11.80)0.886s (×7.98)0.498s (×4.53)0.468s (×4.26)0.505s (×4.59)1.756s (×15.73)0.466s (×4.24)0.697s (×6.30)0.633s (×5.73)0.932s (×8.39)0.790s (×7.13)0.541s (×4.91)3.530s (×31.54)0.549s (×4.98)0.552s (×5.01)1.097s (×9.86)1.015s (×9.13)0.565s (×5.12)0.561s (×5.09)0.752s (×6.79)1.094s (×9.84)0.860s (×7.75)0.756s (×6.83)4.434s (×39.60)1.041s (×9.36)1.215s (×10.92)1.198s (×10.76)0.850s (×7.66)1.217s (×10.93)5.100s (×45.53)1.025s (×9.22)0.858s (×7.74)1.204s (×10.82)0.710s (×6.42)2.336s (×20.90)1.240s (×11.14)1.085s (×9.76)0.761s (×6.87)1.095s (×9.85)1.171s (×10.52)3.174s (×28.37)5.365s (×47.89)0.908s (×8.18)0.868s (×7.82)0.849s (×7.65)1.796s (×16.09)0.913s (×8.22)0.766s (×6.91)1.633s (×14.64)1.063s (×9.56)2.313s (×20.70)2.234s (×20.00)1.057s (×9.51)1.887s (×16.90)2.092s (×18.73)2.042s (×18.28)1.644s (×14.74)1.056s (×9.50)1.825s (×16.35)1.417s (×12.72)2.565s (×22.94)3.300s (×29.49)1.908s (×17.09)6.548s (×58.43)3.480s (×31.10)2.694s (×24.09)10.108s (×90.16)2.404s (×21.51)2.907s (×25.99)2.410s (×21.56)2.989s (×26.72)3.083s (×27.56)2.553s (×22.84)3.484s (×31.13)3.390s (×30.30)1.602s (×14.37)1.542s (×13.83)5.140s (×45.89)3.627s (×32.41)1.383s (×12.41)5.439s (×48.55)22.609s (×201.55)3.134s (×28.01)7.360s (×65.67)29.304s (×261.20)8.233s (×73.45)5.905s (×52.70)3.212s (×28.71)2.782s (×24.88)88.083s (×784.95)4.434s (×39.60)267.431s (×2383.01)30.803s (×274.56)☠89.389s (×796.58)☠6.628s (×59.15)46.522s (×414.62)50.892s (×453.56)4.271s (×38.15)5.433s (×48.50)32.350s (×288.34)62.632s (×558.17)☠6.238s (×55.67)12.337s (×110.02)11.317s (×100.93)☠237.662s (×2117.76)82.473s (×734.96)136.921s (×1220.11)2617.011s (×23318.79)281.095s (×2504.77)31.710s (×282.64)362.261s (×3227.99)336.950s (×3002.46)635.960s (×5666.77)258.252s (×2301.23)286.655s (×2554.31)932.320s (×8307.46)☠
Q10. Query 10: SELECT MobilePhoneModel, COUNT(DISTINCT UserID) AS u FROM hits WHERE MobilePhoneModel <> '' GROUP BY MobilePhoneModel ORDER BY u DESC LIMIT 10;0.038s (×1.26)0.029s (×1.03)0.065s (×1.97)0.040s (×1.32)0.043s (×1.39)0.094s (×2.74)0.028s (×1.00)0.080s (×2.37)0.070s (×2.11)0.067s (×2.02)0.105s (×3.03)0.107s (×3.08)0.050s (×1.58)0.286s (×7.80)0.111s (×3.18)0.119s (×3.38)0.063s (×1.91)0.114s (×3.27)0.059s (×1.83)0.080s (×2.37)0.124s (×3.53)0.055s (×1.70)0.046s (×1.48)0.122s (×3.47)0.055s (×1.72)0.141s (×3.97)0.125s (×3.55)0.139s (×3.92)0.149s (×4.18)0.089s (×2.60)0.092s (×2.68)0.092s (×2.68)0.123s (×3.50)0.169s (×4.71)0.090s (×2.63)0.091s (×2.65)0.149s (×4.18)0.154s (×4.32)0.199s (×5.50)0.134s (×3.80)0.175s (×4.88)0.145s (×4.08)0.121s (×3.45)0.128s (×3.62)0.151s (×4.24)0.110s (×3.16)0.189s (×5.24)0.254s (×6.94)0.157s (×4.39)0.173s (×4.82)0.120s (×3.41)0.184s (×5.12)0.110s (×3.16)0.100s (×2.89)0.247s (×6.76)0.130s (×3.69)0.139s (×3.92)0.241s (×6.60)0.241s (×6.60)0.233s (×6.39)0.303s (×8.24)0.663s (×17.70)0.148s (×4.16)0.338s (×9.17)0.417s (×11.24)0.293s (×7.97)0.164s (×4.58)0.361s (×9.76)0.137s (×3.87)0.222s (×6.11)0.252s (×6.89)0.234s (×6.42)0.139s (×3.91)0.212s (×5.85)0.170s (×4.73)0.161s (×4.51)0.180s (×5.00)0.367s (×9.92)0.128s (×3.63)0.328s (×8.89)0.349s (×9.45)0.213s (×5.87)☠0.383s (×10.34)0.370s (×10.00)0.229s (×6.30)0.543s (×14.55)0.253s (×6.92)0.401s (×10.82)0.397s (×10.71)0.262s (×7.17)0.353s (×9.55)0.250s (×6.84)0.278s (×7.58)0.349s (×9.46)0.593s (×15.87)0.246s (×6.74)0.447s (×12.03)0.339s (×9.18)0.229s (×6.29)0.331s (×8.97)0.290s (×7.89)0.456s (×12.26)0.375s (×10.13)0.277s (×7.55)0.288s (×7.84)0.271s (×7.39)0.520s (×13.95)0.325s (×8.82)0.425s (×11.45)0.543s (×14.55)0.594s (×15.89)0.469s (×12.61)0.290s (×7.90)0.546s (×14.63)0.389s (×10.51)0.482s (×12.95)0.610s (×16.31)0.322s (×8.74)0.569s (×15.24)0.517s (×13.87)0.557s (×14.92)0.302s (×8.21)0.652s (×17.42)0.848s (×22.58)0.587s (×15.71)0.230s (×6.33)0.220s (×6.05)0.714s (×19.05)1.218s (×32.31)0.708s (×18.89)0.756s (×20.16)0.735s (×19.60)0.706s (×18.84)0.823s (×21.92)0.740s (×19.74)0.751s (×20.03)0.878s (×23.37)0.463s (×12.45)1.009s (×26.81)0.503s (×13.51)0.966s (×25.68)0.915s (×24.34)1.486s (×39.37)1.778s (×47.05)0.695s (×18.55)0.653s (×17.45)2.483s (×65.60)1.143s (×30.35)1.264s (×33.52)4.197s (×110.70)2.047s (×54.13)9.258s (×243.87)3.155s (×83.29)2.053s (×54.28)2.960s (×78.16)0.772s (×20.58)9.273s (×244.27)0.724s (×19.31)1.242s (×32.95)2.892s (×76.36)3.714s (×97.98)1.402s (×37.16)4.463s (×117.70)1.772s (×46.89)3.372s (×88.99)2.692s (×71.09)2.166s (×57.26)0.821s (×21.88)9.526s (×250.94)☠2.382s (×62.95)10.082s (×265.55)56.215s (×1479.53)389.201s (×10241.86)248.555s (×6540.84)14.110s (×371.56)293.888s (×7733.75)279.870s (×7364.88)396.490s (×10433.66)258.240s (×6795.69)258.933s (×6813.93)854.740s (×22492.24)☠
Q11. Query 11: SELECT MobilePhone, MobilePhoneModel, COUNT(DISTINCT UserID) AS u FROM hits WHERE MobilePhoneModel <> '' GROUP BY MobilePhone, MobilePhoneModel ORDER BY u DESC LIMIT 10;0.041s (×1.62)0.021s (×1.00)0.061s (×2.28)0.040s (×1.60)0.057s (×2.15)0.098s (×3.47)0.031s (×1.32)0.080s (×2.89)0.070s (×2.57)0.061s (×2.28)0.091s (×3.24)0.102s (×3.59)0.060s (×2.25)0.177s (×6.00)0.108s (×3.79)0.124s (×4.30)0.069s (×2.53)0.102s (×3.58)0.063s (×2.35)0.089s (×3.18)0.131s (×4.52)0.053s (×2.04)0.049s (×1.91)0.127s (×4.40)0.060s (×2.23)0.136s (×4.69)0.134s (×4.62)0.134s (×4.62)0.159s (×5.42)0.103s (×3.62)0.098s (×3.48)0.100s (×3.53)0.132s (×4.56)0.168s (×5.71)0.080s (×2.89)0.099s (×3.50)0.322s (×10.65)0.156s (×5.33)0.171s (×5.81)0.109s (×3.83)0.181s (×6.14)0.173s (×5.87)0.136s (×4.69)0.153s (×5.24)0.160s (×5.46)0.113s (×3.96)0.206s (×6.93)0.255s (×8.50)0.196s (×6.61)0.185s (×6.26)0.162s (×5.51)0.165s (×5.61)0.130s (×4.49)0.120s (×4.17)0.250s (×8.34)0.152s (×5.20)0.164s (×5.59)0.235s (×7.86)0.270s (×8.98)0.237s (×7.93)0.290s (×9.63)0.325s (×10.76)0.182s (×6.16)0.361s (×11.92)0.501s (×16.40)0.339s (×11.20)0.187s (×6.32)0.375s (×12.35)0.160s (×5.45)0.243s (×8.11)0.291s (×9.66)0.256s (×8.54)0.166s (×5.65)0.225s (×7.53)0.201s (×6.77)0.167s (×5.67)0.205s (×6.90)0.296s (×9.82)0.151s (×5.17)0.374s (×12.32)0.304s (×10.08)0.227s (×7.61)0.428s (×14.06)0.437s (×14.34)0.369s (×12.16)0.268s (×8.92)0.594s (×19.38)0.287s (×9.53)0.630s (×20.54)0.476s (×15.60)0.285s (×9.45)0.456s (×14.95)0.250s (×8.34)0.303s (×10.04)0.396s (×13.01)0.724s (×23.55)0.278s (×9.24)0.549s (×17.94)0.465s (×15.24)0.220s (×7.39)0.348s (×11.49)0.310s (×10.27)0.495s (×16.21)0.475s (×15.56)0.279s (×9.27)0.337s (×11.14)0.308s (×10.19)0.473s (×15.50)0.325s (×10.76)0.501s (×16.40)0.482s (×15.79)0.724s (×23.55)0.429s (×14.10)0.313s (×10.37)0.599s (×19.54)0.411s (×13.50)0.659s (×21.47)0.693s (×22.56)0.401s (×13.19)0.688s (×22.40)0.572s (×18.68)0.700s (×22.78)0.318s (×10.52)0.756s (×24.58)1.141s (×36.93)0.631s (×20.57)0.266s (×8.86)0.230s (×7.70)0.859s (×27.89)1.327s (×42.89)0.962s (×31.19)0.864s (×28.05)0.856s (×27.79)0.811s (×26.35)1.036s (×33.57)0.866s (×28.11)0.907s (×29.43)0.967s (×31.35)0.488s (×15.98)0.999s (×32.38)0.556s (×18.15)1.073s (×34.75)0.934s (×30.29)1.422s (×45.95)2.318s (×74.69)0.721s (×23.46)0.690s (×22.46)3.279s (×105.55)1.420s (×45.89)1.541s (×49.76)4.121s (×132.56)1.969s (×63.50)13.221s (×424.58)3.065s (×98.67)735.659s (×23607.06)3.322s (×106.91)0.813s (×26.39)13.252s (×425.55)0.947s (×30.72)1.303s (×42.14)2.636s (×84.89)4.482s (×144.15)1.420s (×45.89)4.616s (×148.44)2.212s (×71.30)3.290s (×105.89)2.783s (×89.61)2.308s (×74.38)0.441s (×14.46)9.517s (×305.71)☠353.140s (×11332.31)11.188s (×359.33)55.957s (×1795.94)384.638s (×12343.06)248.660s (×7979.63)16.530s (×530.76)291.729s (×9361.68)282.000s (×9049.49)412.550s (×13238.74)258.207s (×8285.99)259.255s (×8319.62)825.140s (×26478.44)☠
Q12. Query 12: SELECT SearchPhrase, COUNT(*) AS c FROM hits WHERE SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;0.100s (×1.40)0.068s (×1.00)0.144s (×1.96)0.157s (×2.13)0.148s (×2.01)0.148s (×2.01)0.180s (×2.42)0.200s (×2.68)0.190s (×2.55)0.208s (×2.79)0.171s (×2.31)0.161s (×2.18)0.170s (×2.30)0.289s (×3.82)0.158s (×2.14)0.155s (×2.10)0.173s (×2.34)0.206s (×2.76)0.184s (×2.47)0.347s (×4.55)0.222s (×2.96)0.150s (×2.04)0.293s (×3.87)0.227s (×3.02)0.213s (×2.85)0.255s (×3.38)0.267s (×3.53)0.256s (×3.39)0.488s (×6.35)0.158s (×2.15)0.253s (×3.35)0.226s (×3.01)0.344s (×4.51)0.320s (×4.21)0.260s (×3.44)0.259s (×3.43)0.329s (×4.32)0.386s (×5.05)0.369s (×4.83)0.260s (×3.44)0.678s (×8.77)0.369s (×4.83)0.595s (×7.71)0.598s (×7.75)0.434s (×5.66)0.242s (×3.21)0.536s (×6.96)0.638s (×8.26)0.461s (×6.01)0.509s (×6.62)0.535s (×6.95)0.307s (×4.04)0.580s (×7.52)0.540s (×7.01)0.289s (×3.81)0.504s (×6.55)0.486s (×6.32)0.326s (×4.28)0.696s (×9.00)0.704s (×9.10)0.319s (×4.20)0.344s (×4.51)0.476s (×6.20)1.218s (×15.66)0.917s (×11.82)0.371s (×4.86)0.547s (×7.10)0.434s (×5.66)0.813s (×10.50)0.430s (×5.61)0.708s (×9.16)0.756s (×9.77)0.408s (×5.33)0.761s (×9.83)0.605s (×7.84)0.480s (×6.25)0.614s (×7.95)0.517s (×6.72)0.437s (×5.70)1.069s (×13.76)0.504s (×6.55)0.644s (×8.34)0.631s (×8.17)0.852s (×10.99)0.566s (×7.34)0.529s (×6.88)2.936s (×37.57)0.891s (×11.49)1.077s (×13.86)1.061s (×13.66)1.203s (×15.47)2.123s (×27.20)1.740s (×22.31)0.961s (×12.38)0.808s (×10.43)1.214s (×15.61)0.657s (×8.51)1.976s (×25.32)1.293s (×16.61)0.751s (×9.70)0.875s (×11.28)0.971s (×12.51)0.888s (×11.45)1.312s (×16.86)0.517s (×6.72)0.692s (×8.95)0.648s (×8.39)0.571s (×7.41)2.105s (×26.97)0.915s (×11.79)0.624s (×8.08)3.987s (×50.97)0.631s (×8.17)1.085s (×13.96)2.390s (×30.60)1.603s (×20.56)2.232s (×28.59)2.125s (×27.22)1.085s (×13.96)1.690s (×21.68)1.000s (×12.87)1.685s (×21.61)1.394s (×17.90)2.455s (×31.43)3.432s (×43.89)1.404s (×18.03)3.074s (×39.33)2.250s (×28.82)2.656s (×34.00)4.600s (×58.79)2.449s (×31.36)2.608s (×33.38)2.523s (×32.30)3.507s (×44.85)2.691s (×34.44)2.606s (×33.36)2.924s (×37.41)3.050s (×39.02)2.549s (×32.63)1.251s (×16.08)2.049s (×26.25)2.035s (×26.08)1.208s (×15.53)3.848s (×49.19)5.519s (×70.50)1.646s (×21.12)0.222s (×2.96)6.918s (×88.34)2.631s (×33.68)2.225s (×28.49)3.145s (×40.23)1.935s (×24.80)7.552s (×96.43)2.576s (×32.97)2.207s (×28.28)9.301s (×118.73)9.672s (×123.46)9.285s (×118.52)10.825s (×138.15)5.216s (×66.64)23.462s (×299.30)28.544s (×364.10)3.610s (×46.16)5.243s (×66.98)5.201s (×66.45)29.293s (×373.66)5.296s (×67.66)3.665s (×46.86)1.770s (×22.69)35.031s (×446.81)0.294s (×3.88)3.453s (×44.16)15.500s (×197.78)82.887s (×1057.04)70.314s (×896.73)256.911s (×3276.09)1961.400s (×25010.60)298.180s (×3802.32)334.830s (×4269.66)448.060s (×5713.49)258.182s (×3292.29)263.000s (×3353.73)☠☠
Q13. Query 13: SELECT SearchPhrase, COUNT(DISTINCT UserID) AS u FROM hits WHERE SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY u DESC LIMIT 10;0.172s (×1.00)0.240s (×1.38)0.348s (×1.98)0.172s (×1.01)0.171s (×1.00)0.193s (×1.12)0.321s (×1.83)0.260s (×1.49)0.250s (×1.44)0.453s (×2.56)0.198s (×1.15)0.218s (×1.26)0.230s (×1.33)0.428s (×2.42)0.226s (×1.30)0.191s (×1.11)0.390s (×2.21)0.267s (×1.53)0.343s (×1.95)0.609s (×3.42)0.347s (×1.97)0.496s (×2.79)0.944s (×5.27)0.351s (×1.99)0.463s (×2.62)0.325s (×1.85)0.429s (×2.43)0.321s (×1.83)0.796s (×4.45)0.305s (×1.74)0.426s (×2.41)0.340s (×1.93)0.416s (×2.35)0.498s (×2.81)0.430s (×2.43)0.434s (×2.45)0.435s (×2.46)0.583s (×3.28)0.557s (×3.13)0.282s (×1.61)1.048s (×5.84)0.595s (×3.34)0.831s (×4.65)0.822s (×4.59)0.548s (×3.08)0.280s (×1.60)0.764s (×4.28)1.039s (×5.79)0.832s (×4.65)0.749s (×4.19)0.757s (×4.24)0.368s (×2.09)0.880s (×4.92)0.960s (×5.36)0.392s (×2.22)0.713s (×3.99)0.734s (×4.11)0.493s (×2.78)0.962s (×5.37)0.957s (×5.34)0.436s (×2.46)0.606s (×3.40)0.880s (×4.92)2.163s (×12.00)0.656s (×3.68)0.581s (×3.27)0.908s (×5.07)0.641s (×3.60)1.621s (×9.01)0.739s (×4.14)1.095s (×6.10)1.070s (×5.97)2.856s (×15.84)1.135s (×6.33)0.889s (×4.97)0.923s (×5.16)0.910s (×5.08)0.612s (×3.44)1.334s (×7.42)1.576s (×8.76)0.649s (×3.64)0.974s (×5.44)1.095s (×6.10)1.341s (×7.46)0.976s (×5.45)0.848s (×4.74)4.443s (×24.60)1.370s (×7.62)2.183s (×12.12)1.791s (×9.95)1.880s (×10.44)2.934s (×16.27)3.400s (×18.84)1.448s (×8.06)1.144s (×6.38)1.890s (×10.50)0.979s (×5.47)2.150s (×11.93)2.092s (×11.61)3.431s (×19.01)1.203s (×6.70)1.532s (×8.52)1.646s (×9.15)2.557s (×14.18)1.036s (×5.78)1.036s (×5.78)0.986s (×5.50)0.735s (×4.12)1.612s (×8.96)1.265s (×7.04)0.774s (×4.33)2.888s (×16.01)0.725s (×4.06)1.961s (×10.89)3.440s (×19.06)2.465s (×13.67)3.365s (×18.65)3.050s (×16.91)1.729s (×9.61)2.618s (×14.52)1.314s (×7.32)2.901s (×16.08)6.562s (×36.31)3.576s (×19.81)4.231s (×23.43)2.554s (×14.17)7.759s (×42.92)4.620s (×25.58)3.586s (×19.87)10.402s (×57.53)3.760s (×20.83)4.560s (×25.25)3.843s (×21.29)5.627s (×31.14)4.403s (×24.38)4.192s (×23.22)4.346s (×24.07)4.491s (×24.87)2.261s (×12.55)1.750s (×9.72)9.243s (×51.12)3.626s (×20.09)1.569s (×8.72)5.937s (×32.86)8.007s (×44.29)2.974s (×16.49)0.307s (×1.75)10.254s (×56.70)4.896s (×27.11)3.030s (×16.80)6.374s (×35.27)3.071s (×17.02)32.035s (×177.05)3.085s (×17.10)9.281s (×51.33)10.352s (×57.25)☠32.715s (×180.80)☠7.157s (×39.60)31.815s (×175.83)34.048s (×188.16)4.729s (×26.18)6.115s (×33.84)5.187s (×28.71)44.272s (×244.65)☠21.401s (×118.29)7.261s (×40.17)41.217s (×227.77)☠4.557s (×25.23)72.517s (×400.70)96.473s (×533.06)133.416s (×737.16)258.080s (×1425.91)1167.000s (×6447.57)301.150s (×1663.87)307.300s (×1697.85)813.600s (×4495.08)258.195s (×1426.55)267.208s (×1476.34)860.200s (×4752.54)☠
Q14. Query 14: SELECT SearchEngineID, SearchPhrase, COUNT(*) AS c FROM hits WHERE SearchPhrase <> '' GROUP BY SearchEngineID, SearchPhrase ORDER BY c DESC LIMIT 10;0.108s (×1.39)0.075s (×1.00)0.148s (×1.86)0.148s (×1.86)0.150s (×1.88)0.160s (×2.00)0.182s (×2.26)0.230s (×2.83)0.230s (×2.83)0.211s (×2.60)0.184s (×2.28)0.177s (×2.20)0.180s (×2.24)0.272s (×3.32)0.172s (×2.14)0.167s (×2.08)0.180s (×2.24)0.198s (×2.45)0.187s (×2.32)0.352s (×4.26)0.271s (×3.31)0.148s (×1.86)0.293s (×3.56)0.285s (×3.47)0.220s (×2.71)0.273s (×3.33)0.338s (×4.10)0.369s (×4.46)0.535s (×6.42)0.182s (×2.26)0.263s (×3.22)0.214s (×2.64)0.317s (×3.85)0.396s (×4.78)0.270s (×3.30)0.268s (×3.28)0.370s (×4.48)0.512s (×6.15)0.553s (×6.63)0.252s (×3.09)0.814s (×9.70)0.627s (×7.50)0.667s (×7.97)0.653s (×7.81)0.489s (×5.88)0.252s (×3.08)0.625s (×7.48)0.806s (×9.61)0.675s (×8.07)0.584s (×7.00)0.599s (×7.17)0.286s (×3.48)0.770s (×9.19)0.770s (×9.19)0.304s (×3.70)0.533s (×6.39)0.547s (×6.56)0.349s (×4.23)0.862s (×10.27)0.815s (×9.72)0.317s (×3.85)0.359s (×4.35)0.535s (×6.42)1.290s (×15.31)1.175s (×13.96)0.400s (×4.83)0.560s (×6.71)0.415s (×5.01)0.875s (×10.43)0.433s (×5.22)1.238s (×14.70)0.861s (×10.26)0.482s (×5.79)0.810s (×9.65)0.652s (×7.80)0.510s (×6.12)0.650s (×7.77)0.494s (×5.94)0.490s (×5.88)1.550s (×18.37)0.529s (×6.35)0.709s (×8.47)0.975s (×11.60)1.497s (×17.75)0.603s (×7.22)0.585s (×7.01)3.202s (×37.83)0.854s (×10.18)1.679s (×19.89)1.812s (×21.46)1.371s (×16.27)2.242s (×26.52)1.600s (×18.96)0.991s (×11.79)0.880s (×10.48)1.603s (×19.00)0.718s (×8.58)1.697s (×20.10)1.669s (×19.77)0.942s (×11.21)0.960s (×11.42)0.922s (×10.98)0.966s (×11.49)1.473s (×17.46)0.537s (×6.44)0.753s (×8.99)0.709s (×8.47)0.625s (×7.48)1.635s (×19.37)1.070s (×12.72)0.615s (×7.36)2.425s (×28.68)0.684s (×8.18)1.123s (×13.34)3.039s (×35.91)1.776s (×21.03)2.709s (×32.02)3.070s (×36.27)1.423s (×16.88)2.654s (×31.37)1.180s (×14.01)2.353s (×27.83)1.617s (×19.16)3.597s (×42.48)3.525s (×41.63)1.538s (×18.23)3.292s (×38.89)2.280s (×26.97)3.222s (×38.06)5.093s (×60.09)3.566s (×42.11)4.349s (×51.33)3.447s (×40.71)4.664s (×55.04)3.779s (×44.62)3.595s (×42.46)4.295s (×50.70)4.358s (×51.44)2.348s (×27.77)1.312s (×15.57)2.517s (×29.76)2.159s (×25.54)1.301s (×15.44)4.839s (×57.11)6.522s (×76.92)1.746s (×20.68)0.244s (×2.99)8.172s (×96.36)2.864s (×33.85)2.968s (×35.08)3.129s (×36.97)2.387s (×28.23)8.503s (×100.26)3.278s (×38.72)255.972s (×3014.62)9.956s (×117.37)10.237s (×120.67)10.458s (×123.28)9.858s (×116.21)6.223s (×73.40)12.339s (×145.43)30.534s (×359.70)3.860s (×45.58)5.259s (×62.05)5.598s (×66.04)17.052s (×200.94)5.790s (×68.31)3.961s (×46.77)59.251s (×697.90)98.991s (×1165.91)☠248.691s (×2928.88)17.569s (×207.02)86.280s (×1016.22)57.136s (×672.99)258.061s (×3039.23)2224.140s (×26193.16)301.021s (×3545.15)338.520s (×3986.77)453.980s (×5346.51)258.140s (×3040.16)265.019s (×3121.17)☠☠
Q15. Query 15: SELECT UserID, COUNT(*) FROM hits GROUP BY UserID ORDER BY COUNT(*) DESC LIMIT 10;0.084s (×1.04)0.164s (×1.93)0.190s (×2.22)0.119s (×1.43)0.124s (×1.49)0.127s (×1.52)0.181s (×2.12)0.120s (×1.44)0.110s (×1.33)0.272s (×3.14)0.124s (×1.49)0.115s (×1.39)0.080s (×1.00)0.219s (×2.54)0.117s (×1.41)0.130s (×1.55)0.167s (×1.97)0.421s (×4.79)0.175s (×2.05)0.365s (×4.17)0.158s (×1.87)0.170s (×2.00)0.701s (×7.90)0.208s (×2.42)0.162s (×1.91)0.186s (×2.18)0.208s (×2.42)0.208s (×2.42)0.443s (×5.03)0.143s (×1.70)0.263s (×3.03)0.172s (×2.02)0.218s (×2.53)0.238s (×2.76)0.360s (×4.11)0.267s (×3.08)0.249s (×2.88)0.285s (×3.28)0.304s (×3.49)0.126s (×1.51)0.591s (×6.68)0.266s (×3.07)0.515s (×5.83)0.502s (×5.69)0.320s (×3.67)0.157s (×1.85)0.404s (×4.60)0.528s (×5.98)0.326s (×3.73)0.356s (×4.07)1.187s (×13.30)0.177s (×2.08)0.370s (×4.22)0.390s (×4.44)0.264s (×3.04)0.346s (×3.95)0.327s (×3.74)0.302s (×3.47)0.530s (×6.00)0.520s (×5.89)0.283s (×3.26)0.324s (×3.71)0.420s (×4.78)0.915s (×10.27)0.535s (×6.06)0.388s (×4.42)0.433s (×4.92)0.578s (×6.53)0.939s (×10.54)0.501s (×5.68)0.533s (×6.03)0.882s (×9.91)0.403s (×4.59)0.527s (×5.96)0.420s (×4.78)0.411s (×4.68)0.413s (×4.70)0.426s (×4.84)0.779s (×8.76)0.786s (×8.84)0.408s (×4.64)0.440s (×4.99)0.569s (×6.43)0.649s (×7.32)0.533s (×6.03)0.487s (×5.52)2.630s (×29.33)1.016s (×11.40)0.750s (×8.44)1.129s (×12.66)0.610s (×6.89)0.930s (×10.44)1.550s (×17.33)1.010s (×11.33)0.597s (×6.75)0.854s (×9.60)0.515s (×5.84)1.004s (×11.27)1.137s (×12.74)0.827s (×9.30)0.691s (×7.79)1.056s (×11.84)0.874s (×9.82)2.617s (×29.19)1.127s (×12.64)0.622s (×7.02)0.574s (×6.49)0.467s (×5.30)1.906s (×21.29)0.720s (×8.11)0.536s (×6.07)1.395s (×15.61)0.917s (×10.30)0.734s (×8.26)1.718s (×19.20)0.810s (×9.11)1.415s (×15.83)1.487s (×16.63)1.317s (×14.74)1.207s (×13.52)0.921s (×10.35)1.230s (×13.78)1.328s (×14.87)1.792s (×20.02)1.682s (×18.80)1.509s (×16.88)3.465s (×38.61)2.280s (×25.44)1.780s (×19.89)3.496s (×38.95)1.887s (×21.08)2.230s (×24.89)1.786s (×19.96)2.267s (×25.30)2.288s (×25.53)1.941s (×21.68)2.876s (×32.07)2.316s (×25.84)2.170s (×24.22)0.985s (×11.06)2.554s (×28.49)2.637s (×29.41)1.054s (×11.82)2.746s (×30.62)13.958s (×155.20)1.321s (×14.79)0.165s (×1.94)16.315s (×181.39)4.537s (×50.52)2.988s (×33.32)5.027s (×55.97)2.210s (×24.67)17.418s (×193.65)2.419s (×26.99)14.331s (×159.35)23.755s (×264.06)17.142s (×190.58)21.697s (×241.19)17.709s (×196.88)4.915s (×54.72)21.200s (×235.66)33.773s (×375.37)2.629s (×29.32)6.451s (×71.79)5.455s (×60.72)38.043s (×422.81)5.496s (×61.18)4.324s (×48.16)8.225s (×91.50)11.301s (×125.68)☠10.591s (×117.79)53.575s (×595.38)42.431s (×471.57)419.999s (×4666.77)273.497s (×3038.97)30.690s (×341.11)47.000s (×522.33)306.270s (×3403.11)586.490s (×6516.67)258.118s (×2868.09)272.948s (×3032.87)893.680s (×9929.89)☠
Q16. Query 16: SELECT UserID, SearchPhrase, COUNT(*) FROM hits GROUP BY UserID, SearchPhrase ORDER BY COUNT(*) DESC LIMIT 10;0.124s (×1.00)0.208s (×1.63)0.336s (×2.59)0.304s (×2.35)0.309s (×2.38)0.330s (×2.54)0.375s (×2.88)0.270s (×2.09)0.300s (×2.32)0.320s (×2.47)0.362s (×2.78)0.396s (×3.03)0.300s (×2.32)0.480s (×3.66)0.382s (×2.93)0.332s (×2.55)0.388s (×2.97)0.772s (×5.84)0.417s (×3.19)0.819s (×6.19)0.640s (×4.86)0.344s (×2.65)1.008s (×7.61)0.745s (×5.64)0.286s (×2.21)0.657s (×4.98)0.713s (×5.40)0.764s (×5.78)1.407s (×10.59)0.340s (×2.61)0.563s (×4.28)0.304s (×2.35)1.224s (×9.22)0.955s (×7.21)0.750s (×5.68)0.611s (×4.64)1.010s (×7.62)1.188s (×8.95)1.073s (×8.09)0.408s (×3.12)2.480s (×18.61)1.219s (×9.18)1.731s (×13.01)1.749s (×13.14)1.128s (×8.50)0.289s (×2.23)1.547s (×11.63)2.557s (×19.18)1.510s (×11.36)1.373s (×10.33)2.052s (×15.41)0.448s (×3.42)1.070s (×8.07)1.490s (×11.21)0.386s (×2.96)0.704s (×5.33)0.704s (×5.33)0.461s (×3.52)2.216s (×16.63)2.513s (×18.85)0.350s (×2.69)0.393s (×3.01)1.021s (×7.70)2.586s (×19.40)1.504s (×11.31)0.639s (×4.85)0.767s (×5.81)0.716s (×5.42)2.644s (×19.83)0.749s (×5.67)2.504s (×18.79)2.385s (×17.90)0.982s (×7.41)1.563s (×11.75)1.073s (×8.09)1.104s (×8.32)1.085s (×8.18)0.871s (×6.58)1.124s (×8.47)3.122s (×23.40)0.818s (×6.19)1.162s (×8.76)2.737s (×20.53)2.753s (×20.65)1.001s (×7.55)1.195s (×9.00)7.110s (×53.20)1.820s (×13.67)3.481s (×26.09)3.775s (×28.28)2.440s (×18.31)3.934s (×29.47)4.260s (×31.91)1.958s (×14.71)2.015s (×15.13)4.205s (×31.50)1.217s (×9.17)4.370s (×32.73)4.043s (×30.28)2.146s (×16.11)2.102s (×15.78)1.930s (×14.50)1.779s (×13.37)5.619s (×42.06)2.010s (×15.09)1.265s (×9.52)1.239s (×9.33)1.043s (×7.87)5.237s (×39.21)2.175s (×16.33)1.075s (×8.11)6.411s (×47.98)2.244s (×16.84)2.257s (×16.94)6.128s (×45.86)3.509s (×26.29)8.346s (×62.44)7.351s (×55.00)4.385s (×32.84)6.646s (×49.73)2.623s (×19.67)5.791s (×43.35)4.117s (×30.84)8.722s (×65.25)8.974s (×67.13)2.990s (×22.42)9.143s (×68.39)4.420s (×33.10)8.758s (×65.52)12.457s (×93.15)9.225s (×69.01)9.625s (×71.99)8.549s (×63.95)12.088s (×90.40)9.194s (×68.77)9.178s (×68.65)9.911s (×74.13)11.041s (×82.57)6.788s (×50.80)2.639s (×19.79)6.987s (×52.28)5.667s (×42.42)2.444s (×18.34)12.285s (×91.87)24.363s (×182.12)3.327s (×24.93)0.220s (×1.72)29.735s (×222.26)6.015s (×45.02)3.986s (×29.86)5.257s (×39.36)3.698s (×27.71)31.233s (×233.45)2.155s (×16.18)14.991s (×112.09)26.750s (×199.95)☠38.017s (×284.15)☠11.398s (×85.24)46.106s (×344.59)37.309s (×278.86)☠7.337s (×54.90)12.748s (×95.33)60.361s (×451.10)☠7.084s (×53.01)☠327.781s (×2449.31)☠18.163s (×135.79)69.784s (×521.51)111.807s (×835.52)266.801s (×1993.66)314.388s (×2349.23)16168.440s (×120813.35)342.442s (×2558.86)740.750s (×5535.08)856.360s (×6398.94)258.062s (×1928.36)455.687s (×3405.04)☠☠
Q17. Query 17: SELECT UserID, SearchPhrase, COUNT(*) FROM hits GROUP BY UserID, SearchPhrase LIMIT 10;0.055s (×6.45)0.147s (×15.49)0.345s (×34.98)0.078s (×8.67)0.094s (×10.25)0.254s (×26.01)0.216s (×22.30)0.090s (×9.85)0.080s (×8.87)0.305s (×31.02)0.256s (×26.21)0.242s (×24.83)0.100s (×10.84)0.457s (×46.03)0.245s (×25.13)0.246s (×25.19)0.342s (×34.71)0.632s (×63.22)0.381s (×38.53)0.574s (×57.54)0.436s (×43.95)0.221s (×22.80)0.904s (×90.06)0.485s (×48.77)0.270s (×27.62)0.434s (×43.75)0.498s (×50.05)0.459s (×46.21)0.893s (×88.97)0.385s (×38.94)0.464s (×46.72)0.281s (×28.67)0.620s (×62.08)0.673s (×67.30)0.710s (×70.94)0.510s (×51.27)0.516s (×51.83)0.794s (×79.22)0.779s (×77.74)0.310s (×31.57)1.345s (×133.51)0.878s (×87.50)0.917s (×91.34)0.980s (×97.58)0.779s (×77.74)0.272s (×27.80)0.936s (×93.21)1.659s (×164.45)0.836s (×83.36)0.875s (×87.20)2.059s (×203.90)0.369s (×37.33)0.260s (×26.60)0.510s (×51.24)0.434s (×43.75)0.672s (×67.17)0.743s (×74.21)0.455s (×45.82)1.513s (×150.06)1.408s (×139.72)0.993s (×98.83)0.534s (×53.59)0.789s (×78.73)0.003s (×1.32)1.457s (×144.54)0.569s (×57.05)0.722s (×72.09)0.682s (×68.18)2.629s (×260.01)0.738s (×73.73)2.145s (×212.34)1.591s (×157.75)0.991s (×98.64)0.433s (×43.62)1.027s (×102.22)1.336s (×132.66)0.998s (×99.32)0.763s (×76.17)1.030s (×102.52)2.330s (×230.56)0.752s (×75.08)1.072s (×106.60)1.503s (×149.08)1.623s (×160.90)0.940s (×93.61)1.089s (×108.32)2.961s (×292.74)1.684s (×166.91)2.509s (×248.20)2.358s (×233.32)0.716s (×71.51)2.942s (×290.87)4.010s (×396.10)1.879s (×186.13)1.206s (×119.79)4.203s (×415.11)1.019s (×101.38)3.840s (×379.35)3.061s (×302.59)1.969s (×194.98)1.334s (×132.43)1.800s (×178.34)1.526s (×151.34)6.701s (×661.25)1.813s (×179.65)1.264s (×125.55)1.223s (×121.54)0.931s (×92.72)4.914s (×485.16)1.403s (×139.23)0.983s (×97.84)4.957s (×489.41)1.925s (×190.66)2.404s (×237.83)4.430s (×437.48)1.104s (×109.78)5.245s (×517.79)4.752s (×469.21)3.165s (×312.84)4.446s (×439.06)1.952s (×193.29)4.290s (×423.69)3.939s (×389.11)7.273s (×717.61)6.561s (×647.45)2.549s (×252.14)9.419s (×929.06)4.120s (×406.94)6.208s (×612.67)2.614s (×258.57)6.545s (×645.88)6.239s (×615.73)6.704s (×661.54)9.302s (×917.53)6.539s (×645.29)6.848s (×675.73)7.053s (×695.93)7.487s (×738.69)6.212s (×613.04)1.860s (×184.25)7.038s (×694.46)3.879s (×383.19)1.668s (×165.34)1.808s (×179.13)12.968s (×1278.73)2.993s (×295.89)0.308s (×31.33)15.458s (×1524.07)2.235s (×221.21)3.026s (×299.10)0.829s (×82.67)2.274s (×225.05)17.478s (×1723.09)2.822s (×279.04)0.000s (×1.00)0.378s (×38.24)☠25.145s (×2478.53)☠10.970s (×1081.84)0.066s (×7.50)23.503s (×2316.74)☠7.538s (×743.72)12.167s (×1199.82)39.632s (×3906.04)7.216s (×711.96)5.915s (×583.80)☠40.213s (×3963.28)3.910s (×386.24)18.068s (×1781.26)26.322s (×2594.50)87.790s (×8651.09)246.484s (×24287.52)301.501s (×29708.44)120.490s (×11873.09)305.007s (×30053.90)734.010s (×72324.37)848.920s (×83646.66)258.076s (×25429.70)268.499s (×26456.70)☠☠
Q18. Query 18: SELECT UserID, extract(minute FROM EventTime) AS m, SearchPhrase, COUNT(*) FROM hits GROUP BY UserID, m, SearchPhrase ORDER BY COUNT(*) DESC LIMIT 10;0.238s (×1.00)0.498s (×2.05)0.401s (×1.66)0.590s (×2.42)0.634s (×2.60)0.630s (×2.58)0.835s (×3.41)0.480s (×1.98)0.500s (×2.06)0.772s (×3.16)0.659s (×2.70)0.745s (×3.05)0.440s (×1.82)0.635s (×2.60)0.748s (×3.06)0.659s (×2.70)0.695s (×2.85)2.327s (×9.43)0.716s (×2.93)1.556s (×6.32)1.258s (×5.12)0.553s (×2.27)2.053s (×8.33)1.243s (×5.06)0.517s (×2.13)1.323s (×5.38)1.528s (×6.21)1.777s (×7.22)2.734s (×11.08)0.664s (×2.72)0.994s (×4.05)0.433s (×1.79)1.574s (×6.40)1.803s (×7.32)0.960s (×3.92)1.098s (×4.47)1.674s (×6.80)2.393s (×9.70)2.591s (×10.50)0.684s (×2.80)4.236s (×17.15)2.161s (×8.77)3.428s (×13.88)3.527s (×14.28)2.909s (×11.79)0.828s (×3.38)3.066s (×12.42)4.181s (×16.92)2.437s (×9.88)3.023s (×12.25)4.173s (×16.89)1.021s (×4.16)2.020s (×8.20)2.560s (×10.38)0.506s (×2.08)0.888s (×3.63)0.942s (×3.84)0.659s (×2.70)4.230s (×17.12)4.403s (×17.82)0.558s (×2.29)0.822s (×3.36)1.930s (×7.83)5.167s (×20.90)1.635s (×6.64)0.901s (×3.68)0.994s (×4.05)1.318s (×5.36)4.627s (×18.72)0.946s (×3.86)5.085s (×20.57)4.366s (×17.67)2.029s (×8.23)3.386s (×13.71)1.808s (×7.34)1.966s (×7.98)1.793s (×7.28)1.583s (×6.43)2.625s (×10.64)5.839s (×23.62)1.510s (×6.14)1.877s (×7.62)4.759s (×19.26)4.611s (×18.66)1.560s (×6.34)2.577s (×10.45)8.997s (×36.37)3.718s (×15.05)6.385s (×25.82)8.901s (×35.98)3.894s (×15.76)9.029s (×36.50)9.560s (×38.64)3.773s (×15.27)3.967s (×16.06)7.711s (×31.17)2.428s (×9.84)12.040s (×48.65)8.748s (×35.36)4.954s (×20.04)4.366s (×17.67)3.746s (×15.17)2.818s (×11.42)12.727s (×51.43)2.558s (×10.37)2.163s (×8.77)2.177s (×8.83)1.744s (×7.08)7.873s (×31.83)4.468s (×18.08)1.865s (×7.57)16.844s (×68.05)4.481s (×18.13)3.470s (×14.05)18.629s (×75.26)6.306s (×25.50)22.652s (×91.50)22.314s (×90.14)8.164s (×33.00)17.070s (×68.96)4.978s (×20.14)26.546s (×107.22)7.220s (×29.19)24.412s (×98.61)24.758s (×100.01)5.766s (×23.32)19.611s (×79.22)☠27.640s (×111.64)5.272s (×21.33)27.297s (×110.26)31.746s (×128.22)24.743s (×99.94)34.376s (×138.84)30.432s (×122.92)26.852s (×108.46)29.243s (×118.11)30.688s (×123.95)10.509s (×42.47)5.993s (×24.24)☠9.844s (×39.79)4.856s (×19.65)38.470s (×155.37)58.951s (×238.07)6.293s (×25.45)☠72.096s (×291.14)11.479s (×46.39)9.005s (×36.40)☠2.970s (×12.03)76.583s (×309.26)3.579s (×14.49)287.009s (×1158.89)46.251s (×186.79)☠38.327s (×154.79)☠29.177s (×117.85)48.821s (×197.16)72.146s (×291.34)☠11.362s (×45.92)36.493s (×147.39)113.701s (×459.13)☠14.216s (×57.44)☠709.130s (×2863.28)☠244.129s (×985.76)121.182s (×489.33)161.394s (×651.70)465.399s (×1879.17)361.127s (×1458.16)78504.890s (×316977.64)380.383s (×1535.91)868.840s (×3508.14)1011.160s (×4082.78)258.047s (×1041.95)300.785s (×1214.51)1419.340s (×5730.88)☠
Q19. Query 19: SELECT UserID FROM hits WHERE UserID = 435090932899640449;0.012s (×2.13)0.014s (×2.30)0.004s (×1.37)0.015s (×2.44)0.014s (×2.34)0.010s (×1.95)0.002s (×1.21)0.010s (×1.95)0.010s (×1.95)0.013s (×2.19)0.016s (×2.54)0.013s (×2.24)0.000s (×0.98)0.004s (×1.36)0.013s (×2.24)0.013s (×2.21)0.007s (×1.69)0.009s (×1.90)0.010s (×1.91)0.003s (×1.27)0.015s (×2.44)0.036s (×4.45)0.003s (×1.25)0.015s (×2.44)0.026s (×3.49)0.021s (×3.02)0.015s (×2.44)0.018s (×2.73)0.003s (×1.27)0.029s (×3.85)0.013s (×2.28)0.060s (×6.83)0.050s (×5.85)0.020s (×2.93)0.010s (×1.95)0.008s (×1.73)0.022s (×3.12)0.019s (×2.83)0.024s (×3.32)0.024s (×3.35)0.003s (×1.28)0.019s (×2.83)0.015s (×2.44)0.016s (×2.50)0.020s (×2.93)0.703s (×69.49)0.018s (×2.73)0.004s (×1.32)0.024s (×3.32)0.023s (×3.22)0.021s (×3.05)0.054s (×6.21)0.010s (×1.95)0.000s (×0.98)0.307s (×30.91)0.063s (×7.16)0.064s (×7.21)0.156s (×16.19)0.028s (×3.71)0.026s (×3.51)0.278s (×28.08)0.025s (×3.41)0.073s (×8.09)0.003s (×1.24)0.044s (×5.22)0.160s (×16.58)0.106s (×11.28)0.112s (×11.90)0.056s (×6.43)0.140s (×14.59)0.027s (×3.61)0.106s (×11.31)0.087s (×9.50)0.108s (×11.55)0.084s (×9.12)0.030s (×3.88)0.113s (×12.04)0.173s (×17.84)0.058s (×6.63)0.031s (×4.00)0.177s (×18.24)0.106s (×11.33)0.034s (×4.29)0.032s (×4.10)0.184s (×18.92)0.172s (×17.77)0.057s (×6.53)0.076s (×8.39)0.047s (×5.56)0.044s (×5.27)0.124s (×13.09)0.033s (×4.19)0.050s (×5.85)0.093s (×10.04)0.076s (×8.40)0.049s (×5.75)0.154s (×15.96)0.039s (×4.78)0.043s (×5.17)0.105s (×11.26)0.137s (×14.33)0.116s (×12.29)0.256s (×25.94)0.024s (×3.32)0.099s (×10.62)0.192s (×19.73)0.199s (×20.37)0.298s (×30.03)0.028s (×3.70)0.170s (×17.55)0.306s (×30.81)0.049s (×5.75)0.065s (×7.34)0.053s (×6.13)0.053s (×6.14)0.169s (×17.48)0.049s (×5.75)0.047s (×5.56)0.074s (×8.19)0.179s (×18.43)0.262s (×26.51)0.061s (×6.92)0.102s (×10.93)0.050s (×5.85)0.060s (×6.83)0.416s (×41.54)0.001s (×1.04)0.040s (×4.88)0.066s (×7.41)0.008s (×1.77)0.066s (×7.41)0.070s (×7.80)0.088s (×9.56)0.054s (×6.24)0.075s (×8.29)0.086s (×9.36)0.074s (×8.19)0.076s (×8.39)0.081s (×8.90)0.564s (×55.97)0.105s (×11.20)0.375s (×37.54)0.629s (×62.31)0.106s (×11.31)0.155s (×16.10)0.469s (×46.71)0.478s (×47.59)0.200s (×20.50)0.273s (×27.55)0.854s (×84.22)0.015s (×2.44)2.384s (×233.45)0.193s (×19.75)3.543s (×346.47)0.000s (×1.00)0.312s (×31.44)0.009s (×1.82)0.200s (×20.43)0.003s (×1.31)0.449s (×44.77)0.057s (×6.57)0.037s (×4.58)0.109s (×11.60)4.085s (×399.32)0.002s (×1.17)0.068s (×7.61)2.021s (×198.02)1.582s (×155.24)☠0.050s (×5.88)0.083s (×9.07)0.008s (×1.71)2.127s (×208.42)2.101s (×205.82)0.002s (×1.17)247.374s (×24123.26)1.210s (×118.97)4.913s (×480.06)18.460s (×1801.07)375.610s (×36627.99)312.830s (×30506.09)258.051s (×25164.41)0.210s (×21.45)☠
Q20. Query 20: SELECT COUNT(*) FROM hits WHERE URL LIKE '%google%';0.084s (×1.22)0.079s (×1.15)0.121s (×1.70)0.116s (×1.64)0.106s (×1.51)0.117s (×1.65)0.281s (×3.78)0.110s (×1.56)0.110s (×1.56)0.098s (×1.41)0.131s (×1.83)0.230s (×3.12)0.150s (×2.08)0.087s (×1.26)0.244s (×3.30)0.156s (×2.16)0.352s (×4.71)0.104s (×1.48)0.325s (×4.34)0.666s (×8.78)0.380s (×5.06)0.412s (×5.49)0.475s (×6.30)0.379s (×5.05)0.321s (×4.30)0.328s (×4.39)0.412s (×5.48)0.296s (×3.97)0.299s (×4.01)0.336s (×4.49)0.516s (×6.83)0.302s (×4.05)0.410s (×5.45)0.436s (×5.79)0.200s (×2.73)0.526s (×6.96)0.352s (×4.70)0.554s (×7.32)0.678s (×8.94)0.670s (×8.83)0.439s (×5.83)0.917s (×12.04)0.602s (×7.95)0.598s (×7.90)0.559s (×7.39)0.573s (×7.57)0.741s (×9.75)0.552s (×7.29)0.646s (×8.52)0.612s (×8.08)0.393s (×5.23)0.737s (×9.70)1.140s (×14.94)1.100s (×14.42)0.280s (×3.77)0.848s (×11.14)0.857s (×11.26)0.312s (×4.18)1.083s (×14.19)1.065s (×13.96)0.249s (×3.36)0.235s (×3.19)1.194s (×15.64)0.169s (×2.33)0.128s (×1.80)0.442s (×5.87)0.904s (×11.86)0.483s (×6.40)0.705s (×9.29)0.610s (×8.05)1.265s (×16.56)0.722s (×9.51)0.381s (×5.08)0.270s (×3.64)1.570s (×20.51)1.515s (×19.81)1.420s (×18.57)1.061s (×13.91)1.700s (×22.20)1.335s (×17.47)1.276s (×16.70)1.619s (×21.16)1.422s (×18.60)1.358s (×17.77)0.609s (×8.04)1.345s (×17.60)0.067s (×1.00)1.077s (×14.12)1.993s (×26.01)1.933s (×25.23)0.420s (×5.58)1.896s (×24.75)1.240s (×16.23)1.811s (×23.65)3.340s (×43.51)2.071s (×27.03)1.754s (×22.91)1.963s (×25.62)1.880s (×24.55)0.738s (×9.72)3.354s (×43.69)1.139s (×14.92)0.993s (×13.03)0.196s (×2.68)0.860s (×11.30)2.163s (×28.23)2.089s (×27.27)1.837s (×23.99)0.381s (×5.08)4.051s (×52.74)1.871s (×24.43)3.445s (×44.87)1.926s (×25.15)2.498s (×32.57)2.909s (×37.91)0.698s (×9.19)3.805s (×49.55)3.099s (×40.38)1.204s (×15.77)3.275s (×42.66)1.157s (×15.16)3.310s (×43.12)0.816s (×10.72)4.029s (×52.45)4.536s (×59.04)1.609s (×21.03)1.570s (×20.52)1.740s (×22.73)4.234s (×55.12)3.089s (×40.25)4.224s (×54.99)5.541s (×72.09)5.025s (×65.39)4.217s (×54.90)4.292s (×55.87)5.064s (×65.90)4.953s (×64.45)4.576s (×59.56)1.256s (×16.45)4.457s (×58.01)1.572s (×20.55)3.060s (×39.87)4.318s (×56.21)7.243s (×94.19)1.433s (×18.75)1.943s (×25.36)29.918s (×388.68)1.685s (×22.01)2.855s (×37.20)3.300s (×42.99)19.128s (×248.55)3.174s (×41.35)3.032s (×39.51)2.807s (×36.58)0.069s (×1.03)2.662s (×34.71)0.343s (×4.59)4.903s (×63.80)0.551s (×7.29)40.237s (×522.68)7.223s (×93.94)1.827s (×23.85)6.069s (×78.95)4.449s (×57.91)13.321s (×173.13)28.239s (×366.87)4.606s (×59.94)4.266s (×55.53)25.598s (×332.57)23.531s (×305.73)0.070s (×1.04)241.086s (×3131.12)27.973s (×363.41)56.154s (×729.40)69.911s (×908.06)247.304s (×3211.87)285.830s (×3712.21)286.573s (×3721.86)306.660s (×3982.73)419.900s (×5453.38)258.017s (×3351.00)258.041s (×3351.31)916.920s (×11908.18)☠
Q21. Query 21: SELECT SearchPhrase, MIN(URL), COUNT(*) AS c FROM hits WHERE URL LIKE '%google%' AND SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;0.050s (×1.00)0.066s (×1.27)0.096s (×1.77)0.126s (×2.27)0.136s (×2.43)0.148s (×2.64)0.087s (×1.62)0.060s (×1.17)0.060s (×1.17)0.088s (×1.64)0.159s (×2.82)0.265s (×4.59)0.120s (×2.17)0.103s (×1.89)0.270s (×4.67)0.166s (×2.94)0.212s (×3.70)0.105s (×1.91)0.187s (×3.29)0.416s (×7.10)0.426s (×7.27)0.393s (×6.73)0.393s (×6.73)0.420s (×7.17)0.293s (×5.05)0.361s (×6.19)0.480s (×8.17)0.356s (×6.10)0.096s (×1.77)0.364s (×6.24)0.294s (×5.08)0.191s (×3.35)0.489s (×8.32)0.484s (×8.24)0.140s (×2.50)0.304s (×5.23)0.472s (×8.04)0.664s (×11.24)0.726s (×12.28)0.742s (×12.55)0.532s (×9.04)0.997s (×16.79)0.676s (×11.44)0.714s (×12.08)0.669s (×11.32)0.496s (×8.44)0.831s (×14.03)0.677s (×11.45)0.684s (×11.57)0.714s (×12.07)0.409s (×7.00)1.046s (×17.62)0.940s (×15.84)0.910s (×15.34)0.248s (×4.30)0.480s (×8.17)0.477s (×8.11)0.292s (×5.04)1.246s (×20.95)1.245s (×20.93)0.294s (×5.07)0.587s (×9.96)0.668s (×11.31)0.175s (×3.08)0.228s (×3.96)0.337s (×5.79)0.752s (×12.71)0.570s (×9.67)0.739s (×12.49)0.453s (×7.73)1.394s (×23.42)0.799s (×13.49)0.363s (×6.22)0.284s (×4.91)0.928s (×15.64)1.582s (×26.54)0.939s (×15.83)1.160s (×19.51)1.727s (×28.98)1.499s (×25.17)1.171s (×19.70)1.064s (×17.91)1.362s (×22.88)1.572s (×26.38)0.524s (×8.91)1.172s (×19.72)0.067s (×1.28)1.288s (×21.65)2.818s (×47.17)2.054s (×34.42)0.430s (×7.34)2.088s (×34.99)0.550s (×9.34)2.052s (×34.39)3.751s (×62.73)2.255s (×37.78)1.058s (×17.82)2.063s (×34.57)2.955s (×49.45)0.791s (×13.35)3.708s (×62.01)1.439s (×24.17)0.735s (×12.43)0.204s (×3.57)0.966s (×16.27)2.075s (×34.77)1.972s (×33.05)2.064s (×34.59)0.477s (×8.12)4.590s (×76.72)2.146s (×35.96)3.582s (×59.91)2.136s (×35.79)2.608s (×43.66)3.197s (×53.49)0.734s (×12.40)3.727s (×62.33)3.468s (×58.01)1.122s (×18.88)3.561s (×59.56)1.268s (×21.32)4.904s (×81.96)0.890s (×15.02)3.743s (×62.59)5.087s (×85.01)1.163s (×19.56)0.396s (×6.77)0.980s (×16.51)4.937s (×82.51)2.788s (×46.67)4.897s (×81.84)5.689s (×95.05)5.392s (×90.09)4.745s (×79.30)5.259s (×87.88)5.476s (×91.50)5.410s (×90.40)5.257s (×87.84)1.237s (×20.79)5.097s (×85.17)1.634s (×27.42)1.971s (×33.04)5.053s (×84.44)8.020s (×133.92)1.441s (×24.21)2.172s (×36.39)1.952s (×32.72)1.697s (×28.46)2.989s (×50.01)3.529s (×59.03)☠2.971s (×49.72)3.009s (×50.36)2.928s (×49.00)0.067s (×1.29)2.894s (×48.43)0.332s (×5.70)5.244s (×87.63)0.562s (×9.55)12.527s (×209.09)7.032s (×117.45)1.832s (×30.73)2.178s (×36.49)4.562s (×76.25)16.459s (×274.67)7.298s (×121.88)5.742s (×95.93)4.516s (×75.48)☠28.037s (×467.76)☠241.076s (×4020.85)29.297s (×488.78)59.527s (×992.97)20.130s (×335.90)247.245s (×4123.73)389.230s (×6491.77)287.182s (×4789.81)305.120s (×5088.98)432.880s (×7219.77)257.984s (×4302.84)258.013s (×4303.32)921.700s (×15372.34)☠
Q22. Query 22: SELECT SearchPhrase, MIN(URL), MIN(Title), COUNT(*) AS c, COUNT(DISTINCT UserID) FROM hits WHERE Title LIKE '%Google%' AND URL NOT LIKE '%.google.%' AND SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;0.077s (×1.28)0.058s (×1.00)0.158s (×2.47)0.137s (×2.16)0.152s (×2.38)0.215s (×3.31)0.139s (×2.19)0.090s (×1.47)0.080s (×1.32)0.192s (×2.97)0.227s (×3.49)0.346s (×5.24)0.240s (×3.68)0.432s (×6.50)0.762s (×11.36)0.237s (×3.63)0.286s (×4.35)0.097s (×1.57)0.275s (×4.20)0.628s (×9.39)0.500s (×7.51)0.350s (×5.30)0.261s (×3.99)0.496s (×7.45)0.606s (×9.07)0.472s (×7.10)0.609s (×9.11)0.454s (×6.83)0.684s (×10.22)1.030s (×15.31)0.417s (×6.29)0.320s (×4.86)0.601s (×8.99)0.566s (×8.48)0.310s (×4.71)1.580s (×23.41)0.526s (×7.89)0.886s (×13.19)0.906s (×13.48)0.898s (×13.37)1.007s (×14.97)1.165s (×17.30)1.131s (×16.80)1.103s (×16.39)0.792s (×11.81)0.795s (×11.85)1.053s (×15.65)1.268s (×18.81)0.860s (×12.81)0.817s (×12.17)0.377s (×5.69)1.555s (×23.04)0.980s (×14.57)1.940s (×28.70)0.477s (×7.17)0.752s (×11.21)0.746s (×11.12)0.419s (×6.31)1.481s (×21.95)1.516s (×22.46)0.478s (×7.18)0.933s (×13.88)1.392s (×20.64)0.242s (×3.71)0.453s (×6.81)0.505s (×7.58)1.260s (×18.70)1.015s (×15.09)1.391s (×20.62)0.879s (×13.08)1.600s (×23.70)1.682s (×24.91)0.610s (×9.12)0.346s (×5.24)1.613s (×23.90)3.555s (×52.48)1.567s (×23.21)2.058s (×30.44)1.712s (×25.34)1.840s (×27.23)1.991s (×29.46)1.860s (×27.52)1.573s (×23.30)1.519s (×22.51)0.827s (×12.32)1.971s (×29.17)0.078s (×1.30)2.510s (×37.09)3.153s (×46.56)2.363s (×34.93)0.585s (×8.76)3.691s (×54.48)0.890s (×13.25)4.295s (×63.37)7.139s (×105.23)4.651s (×68.61)1.917s (×28.36)2.435s (×35.99)2.590s (×38.27)1.909s (×28.25)7.044s (×103.84)3.480s (×51.37)1.080s (×16.05)0.528s (×7.92)2.509s (×37.08)3.804s (×56.14)3.674s (×54.23)3.032s (×44.78)0.786s (×11.72)8.634s (×127.24)3.168s (×46.78)4.117s (×60.75)4.507s (×66.49)6.774s (×99.86)3.771s (×55.66)1.053s (×15.64)3.903s (×57.60)4.117s (×60.75)1.670s (×24.73)6.098s (×89.91)2.016s (×29.82)5.997s (×88.42)1.891s (×27.99)4.365s (×64.40)5.667s (×83.57)1.370s (×20.31)0.395s (×5.97)1.220s (×18.11)5.617s (×82.83)6.096s (×89.88)5.650s (×83.32)6.423s (×94.69)6.238s (×91.97)5.823s (×85.86)5.718s (×84.32)6.335s (×93.40)23.379s (×344.29)5.960s (×87.88)1.367s (×20.27)8.963s (×132.08)3.657s (×53.97)2.471s (×36.52)9.482s (×139.72)9.106s (×134.19)1.604s (×23.76)4.410s (×65.06)5.526s (×81.49)1.995s (×29.52)3.898s (×57.53)4.562s (×67.30)14.228s (×209.59)2.906s (×42.92)3.606s (×53.23)4.048s (×59.73)0.083s (×1.37)3.765s (×55.57)0.604s (×9.04)5.874s (×86.61)1.079s (×16.03)18.490s (×272.32)2.477s (×36.61)2.800s (×41.36)26.639s (×392.28)5.088s (×75.04)25.728s (×378.87)11.491s (×169.30)☠6.898s (×101.69)☠107.893s (×1588.35)☠241.004s (×3547.77)37.699s (×555.09)57.394s (×844.99)23.201s (×341.67)247.155s (×3638.32)575.060s (×8465.14)288.638s (×4248.95)298.440s (×4393.24)420.730s (×6193.37)257.963s (×3797.41)257.996s (×3797.90)918.370s (×13518.73)☠
Q23. Query 23: SELECT * FROM hits WHERE URL LIKE '%google%' ORDER BY EventTime LIMIT 10;0.221s (×6.72)0.083s (×2.72)0.096s (×3.08)0.168s (×5.17)0.444s (×13.19)0.562s (×16.62)114.726s (×3334.48)0.060s (×2.03)0.050s (×1.74)0.562s (×16.62)0.736s (×21.68)0.793s (×23.34)0.860s (×25.28)0.233s (×7.05)0.801s (×23.57)0.662s (×19.52)1.173s (×34.38)0.024s (×1.00)1.194s (×35.00)0.290s (×8.72)1.377s (×40.31)0.550s (×16.27)0.480s (×14.23)1.276s (×37.37)0.959s (×28.16)1.319s (×38.62)1.602s (×46.85)1.408s (×41.21)0.354s (×10.58)1.355s (×39.66)1.770s (×51.74)1.231s (×36.07)1.542s (×45.10)1.781s (×52.05)0.390s (×11.62)9.633s (×280.23)1.501s (×43.91)2.347s (×68.50)2.375s (×69.31)1.917s (×56.00)0.195s (×5.95)2.380s (×69.46)2.533s (×73.91)2.506s (×73.13)2.181s (×63.68)2.347s (×68.50)2.683s (×78.26)0.273s (×8.22)2.288s (×66.78)2.383s (×69.55)0.449s (×13.34)4.546s (×132.41)2.270s (×66.26)1.220s (×35.75)0.492s (×14.59)2.913s (×84.95)2.699s (×78.73)0.696s (×20.52)4.166s (×121.36)4.110s (×119.74)0.425s (×12.64)0.913s (×26.82)5.336s (×155.37)0.172s (×5.30)1.987s (×58.04)0.959s (×28.16)4.382s (×127.65)3.505s (×102.15)3.861s (×112.50)2.578s (×75.22)6.901s (×200.85)4.243s (×123.60)1.919s (×56.07)1.353s (×39.61)6.653s (×193.63)4.885s (×142.27)7.053s (×205.27)5.389s (×156.91)1.797s (×52.51)4.591s (×133.72)5.370s (×156.35)7.510s (×218.54)5.850s (×170.30)5.483s (×159.64)2.107s (×61.52)9.391s (×273.22)0.131s (×4.10)9.451s (×274.96)6.702s (×195.07)6.957s (×202.48)2.280s (×66.56)8.735s (×254.15)2.150s (×62.77)11.302s (×328.75)19.359s (×562.91)12.135s (×352.96)8.983s (×261.35)6.672s (×194.19)7.148s (×208.03)5.961s (×173.54)17.863s (×519.43)9.912s (×288.35)2.642s (×77.07)0.541s (×16.01)3.803s (×110.80)12.030s (×349.92)12.112s (×352.28)6.638s (×193.21)1.826s (×53.36)21.406s (×622.40)8.502s (×247.38)9.676s (×281.50)1.947s (×56.87)9.553s (×277.91)10.301s (×299.66)3.913s (×114.02)12.097s (×351.86)10.998s (×319.92)7.513s (×218.63)15.167s (×441.08)12.134s (×352.92)11.251s (×327.27)6.811s (×198.22)11.640s (×338.57)14.702s (×427.56)4.139s (×120.58)1.804s (×52.72)3.350s (×97.65)18.204s (×529.34)49.810s (×1447.87)16.885s (×491.01)18.274s (×531.37)19.700s (×572.82)16.529s (×480.66)22.646s (×658.43)19.115s (×555.81)20.464s (×595.02)19.149s (×556.80)2.555s (×74.55)22.849s (×664.33)13.140s (×382.16)9.518s (×276.90)23.578s (×685.52)26.189s (×761.40)0.079s (×2.60)11.754s (×341.89)7.137s (×207.71)0.099s (×3.18)11.557s (×336.16)16.446s (×478.26)5.770s (×167.98)7.597s (×221.08)0.105s (×3.35)6.123s (×178.24)0.069s (×2.29)21.846s (×635.17)0.328s (×9.82)0.102s (×3.26)0.557s (×16.47)71.633s (×2082.11)1.166s (×34.18)1.853s (×54.15)90.208s (×2621.93)8.542s (×248.54)13.365s (×388.71)1.970s (×57.54)☠26.150s (×760.27)6.630s (×192.97)23.712s (×689.41)☠248.730s (×7228.92)148.471s (×4315.18)55.140s (×1602.77)74.994s (×2179.78)0.266s (×8.03)285.640s (×8301.61)287.127s (×8344.82)309.900s (×9006.66)545.450s (×15852.25)263.292s (×7652.13)257.974s (×7497.57)1001.200s (×29097.33)☠
Q24. Query 24: SELECT SearchPhrase FROM hits WHERE SearchPhrase <> '' ORDER BY EventTime LIMIT 10;0.026s (×3.56)0.017s (×2.60)0.013s (×2.25)0.034s (×4.30)0.043s (×5.18)0.043s (×5.18)0.010s (×1.99)0.070s (×7.82)0.190s (×19.54)0.056s (×6.44)0.057s (×6.55)0.082s (×8.99)0.020s (×2.93)0.039s (×4.81)0.090s (×9.77)0.132s (×13.90)0.086s (×9.34)0.006s (×1.59)0.097s (×10.41)0.025s (×3.42)0.130s (×13.68)0.099s (×10.62)0.057s (×6.58)0.126s (×13.29)0.071s (×7.90)0.115s (×12.21)0.150s (×15.63)0.126s (×13.29)0.155s (×16.12)0.093s (×10.10)0.105s (×11.19)0.084s (×9.18)0.199s (×20.42)0.149s (×15.53)0.080s (×8.79)0.193s (×19.83)0.155s (×16.12)0.200s (×20.52)0.206s (×21.10)0.153s (×15.95)0.028s (×3.68)0.269s (×27.26)0.179s (×18.46)0.179s (×18.50)0.201s (×20.61)0.138s (×14.48)0.242s (×24.62)0.028s (×3.74)0.243s (×24.72)0.209s (×21.40)0.005s (×1.47)0.196s (×20.09)0.130s (×13.68)0.070s (×7.82)0.184s (×18.95)0.176s (×18.20)0.178s (×18.33)0.199s (×20.42)0.339s (×34.10)0.313s (×31.56)0.184s (×18.95)0.066s (×7.40)0.094s (×10.16)0.003s (×1.28)0.257s (×26.12)0.241s (×24.52)0.282s (×28.57)0.174s (×17.98)0.098s (×10.50)0.207s (×21.20)0.354s (×35.56)0.267s (×27.06)0.167s (×17.25)0.160s (×16.60)0.234s (×23.84)0.240s (×24.40)0.252s (×25.61)0.365s (×36.64)0.263s (×26.63)0.457s (×45.62)0.360s (×36.15)0.322s (×32.46)0.389s (×38.98)0.353s (×35.46)0.426s (×42.59)0.412s (×41.25)0.103s (×11.04)0.445s (×44.45)0.588s (×58.42)0.529s (×52.66)0.250s (×25.42)0.545s (×54.22)0.200s (×20.52)0.525s (×52.27)0.673s (×66.68)0.577s (×57.35)0.564s (×56.08)0.628s (×62.33)0.576s (×57.25)0.226s (×23.05)0.665s (×65.94)0.563s (×55.98)0.467s (×46.60)0.528s (×52.56)0.248s (×25.20)0.562s (×55.93)0.515s (×51.27)1.084s (×106.88)0.776s (×76.78)0.753s (×74.54)0.598s (×59.40)0.824s (×81.48)0.506s (×50.40)0.474s (×47.30)0.864s (×85.38)0.358s (×35.93)0.876s (×86.56)0.861s (×85.09)0.338s (×34.00)0.921s (×90.95)0.620s (×61.50)0.928s (×91.64)0.257s (×26.09)0.901s (×89.00)0.935s (×92.32)0.641s (×63.60)0.156s (×16.26)0.320s (×32.24)1.253s (×123.39)2.123s (×208.34)1.242s (×122.31)1.304s (×128.37)1.353s (×133.16)1.422s (×139.90)1.456s (×143.22)1.461s (×143.71)1.396s (×137.36)1.382s (×135.99)110.251s (×10771.92)1.456s (×143.22)0.484s (×48.22)1.026s (×101.21)1.050s (×103.56)1.992s (×195.58)0.044s (×5.23)0.917s (×90.56)23.550s (×2301.68)0.056s (×6.47)1.207s (×118.86)1.597s (×156.95)0.286s (×28.92)1.951s (×191.58)0.055s (×6.37)2.827s (×277.16)0.000s (×1.00)1.421s (×139.78)0.088s (×9.57)0.057s (×6.53)0.154s (×16.04)2.577s (×252.78)0.733s (×72.58)0.248s (×25.19)1.763s (×173.21)4.324s (×423.41)1.026s (×101.21)1.428s (×140.48)2.653s (×260.13)2.881s (×282.43)0.017s (×2.64)27.952s (×2731.68)0.258s (×26.18)241.036s (×23548.85)10.386s (×1015.59)52.469s (×5126.91)11.393s (×1114.01)0.006s (×1.53)37.480s (×3662.56)286.865s (×28026.08)275.000s (×26866.94)386.370s (×37747.17)257.904s (×25196.76)257.945s (×25200.76)901.800s (×88101.80)☠
Q25. Query 25: SELECT SearchPhrase FROM hits WHERE SearchPhrase <> '' ORDER BY SearchPhrase LIMIT 10;0.020s (×2.97)0.015s (×2.42)0.080s (×8.81)0.031s (×4.01)0.038s (×4.70)0.041s (×4.99)0.011s (×2.05)0.050s (×5.87)0.040s (×4.90)0.044s (×5.30)0.048s (×5.68)0.071s (×7.93)0.040s (×4.90)0.044s (×5.25)0.069s (×7.73)0.070s (×7.79)0.062s (×7.04)0.565s (×56.26)0.063s (×7.14)0.023s (×3.23)0.091s (×9.89)0.063s (×7.13)0.056s (×6.42)0.093s (×10.08)0.067s (×7.49)0.087s (×9.50)0.115s (×12.24)0.107s (×11.45)0.135s (×14.20)0.079s (×8.72)0.096s (×10.35)0.094s (×10.18)0.116s (×12.34)0.122s (×12.92)0.080s (×8.81)0.131s (×13.83)0.116s (×12.34)0.145s (×15.18)0.158s (×16.45)0.138s (×14.49)0.180s (×18.62)0.143s (×14.98)0.159s (×16.55)0.155s (×16.14)0.156s (×16.25)0.133s (×13.95)0.201s (×20.66)0.225s (×22.98)0.178s (×18.41)0.159s (×16.55)0.537s (×53.59)0.188s (×19.43)0.120s (×12.73)0.120s (×12.73)0.169s (×17.52)0.204s (×20.92)0.194s (×19.96)0.182s (×18.80)0.252s (×25.65)0.252s (×25.65)0.201s (×20.66)0.066s (×7.40)0.248s (×25.26)0.003s (×1.30)0.215s (×22.00)0.239s (×24.38)0.282s (×28.55)0.314s (×31.72)0.112s (×11.92)0.162s (×16.84)0.381s (×38.28)0.205s (×21.05)0.161s (×16.74)0.149s (×15.52)0.327s (×33.00)0.231s (×23.64)0.324s (×32.70)0.275s (×27.90)0.179s (×18.47)0.296s (×29.96)0.306s (×30.94)0.376s (×37.75)0.272s (×27.61)0.257s (×26.14)0.296s (×29.96)0.296s (×29.92)0.150s (×15.66)0.358s (×36.03)0.391s (×39.26)0.433s (×43.37)0.222s (×22.69)0.560s (×55.81)0.160s (×16.64)0.475s (×47.48)0.536s (×53.42)0.405s (×40.63)0.436s (×43.64)0.419s (×42.00)0.413s (×41.41)0.166s (×17.20)0.432s (×43.27)0.507s (×50.62)0.382s (×38.38)0.433s (×43.37)0.210s (×21.51)0.440s (×44.08)0.387s (×38.89)0.431s (×43.18)1.183s (×116.75)0.501s (×50.03)0.454s (×45.43)0.604s (×60.11)0.942s (×93.18)0.455s (×45.53)0.632s (×62.85)0.328s (×33.10)0.624s (×62.07)0.691s (×68.63)0.255s (×25.94)0.607s (×60.41)0.583s (×58.07)0.607s (×60.41)0.253s (×25.74)0.650s (×64.62)0.620s (×61.68)0.509s (×50.81)0.168s (×17.39)0.350s (×35.25)0.939s (×92.91)1.487s (×146.52)0.905s (×89.58)0.937s (×92.72)0.917s (×90.76)1.036s (×102.41)1.002s (×99.08)0.963s (×95.26)0.982s (×97.12)0.981s (×97.02)1.235s (×121.89)1.008s (×99.67)0.370s (×37.17)0.846s (×83.81)0.839s (×83.12)1.461s (×144.02)0.407s (×40.83)0.854s (×84.59)23.025s (×2255.24)0.516s (×51.51)1.073s (×106.06)1.513s (×149.07)0.395s (×39.65)2.718s (×267.08)0.812s (×80.48)2.567s (×252.30)0.000s (×1.00)0.337s (×33.96)0.118s (×12.52)1.341s (×132.27)0.101s (×10.91)5.241s (×514.12)6.647s (×651.75)0.242s (×24.66)1.749s (×172.21)4.233s (×415.41)1.288s (×127.08)6.814s (×668.11)2.247s (×220.94)2.832s (×278.25)☠58.988s (×5776.19)☠1.825s (×179.70)8.469s (×830.10)52.401s (×5131.27)0.002s (×1.17)247.091s (×24192.38)72.070s (×7056.98)288.587s (×28255.04)277.460s (×27165.65)385.050s (×37699.24)257.886s (×25249.27)257.926s (×25253.18)898.300s (×87948.89)☠
Q26. Query 26: SELECT SearchPhrase FROM hits WHERE SearchPhrase <> '' ORDER BY EventTime, SearchPhrase LIMIT 10;0.021s (×3.01)0.015s (×2.43)0.020s (×2.88)0.034s (×4.23)0.043s (×5.10)0.045s (×5.29)0.010s (×1.97)0.070s (×7.69)0.030s (×3.85)0.106s (×11.15)0.059s (×6.63)0.083s (×8.94)0.020s (×2.88)0.040s (×4.77)0.088s (×9.42)0.140s (×14.38)0.070s (×7.69)0.005s (×1.42)0.069s (×7.64)0.022s (×3.08)0.130s (×13.46)0.104s (×10.95)0.058s (×6.50)0.127s (×13.17)0.094s (×9.97)0.121s (×12.60)0.139s (×14.33)0.123s (×12.79)0.156s (×15.96)0.081s (×8.76)0.109s (×11.43)0.086s (×9.23)0.149s (×15.29)0.144s (×14.81)0.070s (×7.69)0.204s (×20.54)0.146s (×15.00)0.201s (×20.29)0.203s (×20.48)0.153s (×15.70)0.027s (×3.60)0.214s (×21.54)0.176s (×17.88)0.180s (×18.28)0.185s (×18.75)0.141s (×14.48)0.245s (×24.52)0.028s (×3.61)0.214s (×21.54)0.230s (×23.08)0.006s (×1.54)0.224s (×22.51)0.140s (×14.42)0.040s (×4.81)0.186s (×18.85)0.199s (×20.09)0.177s (×17.94)0.195s (×19.71)0.323s (×32.02)0.328s (×32.50)0.402s (×39.62)0.068s (×7.49)0.092s (×9.81)0.003s (×1.27)0.273s (×27.24)0.232s (×23.27)0.290s (×28.81)0.355s (×35.10)0.149s (×15.25)0.209s (×21.06)0.526s (×51.54)0.244s (×24.42)0.178s (×18.12)0.160s (×16.39)0.252s (×25.15)0.243s (×24.32)0.216s (×21.77)0.376s (×37.12)0.273s (×27.17)0.417s (×41.06)0.381s (×37.60)0.330s (×32.69)0.486s (×47.69)0.359s (×35.48)0.314s (×31.15)0.424s (×41.77)0.124s (×12.88)0.504s (×49.42)0.569s (×55.67)0.548s (×53.65)0.225s (×22.63)0.527s (×51.63)0.160s (×16.35)0.611s (×59.71)0.657s (×64.11)0.581s (×56.83)0.573s (×56.09)0.576s (×56.35)0.599s (×58.56)0.234s (×23.49)0.657s (×64.13)0.640s (×62.50)0.471s (×46.25)0.563s (×55.10)0.216s (×21.75)0.574s (×56.11)0.528s (×51.76)0.503s (×49.33)1.950s (×188.44)0.752s (×73.27)0.637s (×62.21)0.831s (×80.87)1.611s (×155.82)0.474s (×46.55)0.843s (×82.02)0.344s (×34.00)0.859s (×83.56)0.992s (×96.35)0.407s (×40.10)0.917s (×89.13)0.623s (×60.91)0.905s (×87.98)0.290s (×28.83)0.943s (×91.63)0.920s (×89.42)0.621s (×60.67)0.171s (×17.43)0.320s (×31.73)1.240s (×120.19)2.102s (×203.10)1.282s (×124.23)1.301s (×126.06)1.371s (×132.79)1.282s (×124.23)1.553s (×150.29)1.396s (×135.19)1.449s (×140.29)1.406s (×136.15)1.440s (×139.39)1.514s (×146.54)0.504s (×49.45)1.083s (×105.10)1.073s (×104.13)2.008s (×194.04)0.044s (×5.19)0.973s (×94.52)29.992s (×2884.81)0.056s (×6.33)1.271s (×123.17)1.819s (×175.89)0.499s (×48.94)2.417s (×233.37)0.055s (×6.21)2.925s (×282.21)0.000s (×1.00)1.226s (×118.80)0.092s (×9.78)0.058s (×6.55)0.078s (×8.47)4.396s (×423.65)0.986s (×95.73)0.258s (×25.75)1.821s (×176.06)4.398s (×423.85)1.030s (×100.00)1.621s (×156.87)2.615s (×252.44)3.379s (×325.87)☠53.331s (×5128.99)☠240.822s (×23156.92)10.408s (×1001.69)51.958s (×4996.93)15.353s (×1477.21)0.006s (×1.51)40.110s (×3857.69)286.910s (×27588.46)278.040s (×26735.58)394.670s (×37950.00)257.855s (×24794.71)257.889s (×24797.98)898.890s (×86432.69)☠
Q27. Query 27: SELECT CounterID, AVG(length(URL)) AS l, COUNT(*) AS c FROM hits WHERE URL <> '' GROUP BY CounterID HAVING COUNT(*) > 100000 ORDER BY l DESC LIMIT 25;0.088s (×1.28)0.093s (×1.34)0.105s (×1.49)0.169s (×2.32)0.157s (×2.17)0.240s (×3.25)0.264s (×3.56)0.220s (×2.99)0.220s (×2.99)0.084s (×1.22)0.302s (×4.05)0.264s (×3.56)0.210s (×2.86)0.089s (×1.28)0.266s (×3.58)0.268s (×3.61)0.205s (×2.79)0.161s (×2.21)0.390s (×5.20)0.359s (×4.79)0.376s (×5.01)0.596s (×7.86)0.528s (×6.99)0.369s (×4.92)0.255s (×3.44)0.365s (×4.87)0.437s (×5.81)0.404s (×5.38)0.109s (×1.55)0.295s (×3.96)0.611s (×8.07)0.228s (×3.09)0.450s (×5.97)0.483s (×6.40)0.130s (×1.82)1.384s (×18.10)0.428s (×5.69)0.651s (×8.58)0.639s (×8.43)0.810s (×10.65)0.397s (×5.29)0.938s (×12.31)0.692s (×9.12)0.747s (×9.83)0.611s (×8.06)0.553s (×7.32)0.749s (×9.86)0.502s (×6.65)0.689s (×9.08)0.699s (×9.21)0.649s (×8.56)0.971s (×12.73)1.180s (×15.45)1.420s (×18.57)0.397s (×5.29)0.831s (×10.92)0.838s (×11.01)0.330s (×4.42)1.074s (×14.08)1.119s (×14.66)0.322s (×4.31)0.396s (×5.27)0.889s (×11.68)1.707s (×22.30)0.290s (×3.89)0.403s (×5.36)0.851s (×11.18)0.989s (×12.97)0.674s (×8.89)1.516s (×19.82)1.870s (×24.42)0.707s (×9.31)0.393s (×5.23)0.448s (×5.94)1.417s (×18.53)1.254s (×16.41)1.565s (×20.45)1.197s (×15.68)3.030s (×39.48)1.419s (×18.56)1.225s (×16.04)1.517s (×19.83)1.250s (×16.36)1.197s (×15.68)0.637s (×8.40)1.283s (×16.79)0.067s (×1.00)1.479s (×19.34)1.964s (×25.64)1.752s (×22.88)0.589s (×7.78)1.772s (×23.14)0.560s (×7.40)3.104s (×40.44)3.765s (×49.03)2.034s (×26.55)1.773s (×23.15)1.858s (×24.26)1.970s (×25.71)0.896s (×11.76)3.739s (×48.69)1.607s (×21.00)1.192s (×15.61)1.112s (×14.57)0.786s (×10.33)2.082s (×27.17)1.995s (×26.04)1.879s (×24.53)9.622s (×125.09)4.412s (×57.43)1.914s (×24.99)2.814s (×36.68)3.929s (×51.16)2.060s (×26.88)2.918s (×38.03)0.765s (×10.06)2.960s (×38.57)2.825s (×36.82)1.326s (×17.35)4.072s (×53.01)1.291s (×16.90)3.062s (×39.90)0.853s (×11.21)3.155s (×41.10)3.034s (×39.53)1.509s (×19.73)3.113s (×40.56)1.150s (×15.06)4.258s (×55.43)7.731s (×100.53)4.243s (×55.23)4.467s (×58.14)4.547s (×59.18)4.279s (×55.70)4.295s (×55.91)4.732s (×61.58)4.475s (×58.25)4.798s (×62.44)2.172s (×28.33)4.855s (×63.18)1.583s (×20.68)3.117s (×40.61)4.820s (×62.73)7.072s (×91.97)4.172s (×54.31)2.688s (×35.04)12.391s (×161.05)6.024s (×78.37)5.870s (×76.36)5.187s (×67.49)2.378s (×31.01)2.521s (×32.87)10.035s (×130.45)2.780s (×36.23)238.994s (×3103.95)4.922s (×64.06)13.464s (×174.99)19.058s (×247.64)12.986s (×168.78)48.762s (×633.40)6.445s (×83.83)13.809s (×179.47)9.590s (×124.68)4.721s (×61.44)117.058s (×1520.36)15.775s (×205.00)6.084s (×79.14)6.101s (×79.36)29.222s (×379.64)150.044s (×1948.75)☠241.054s (×3130.70)39.689s (×515.57)59.219s (×769.20)109.007s (×1415.81)247.028s (×3208.29)445.030s (×5779.74)305.626s (×3969.30)406.880s (×5284.29)387.210s (×5028.83)257.841s (×3348.71)257.873s (×3349.13)901.280s (×11705.06)☠
Q28. Query 28: SELECT REGEXP_REPLACE(Referer, '^https?://(?:www\.)?([^/]+)/.*$', '\1') AS k, AVG(length(Referer)) AS l, COUNT(*) AS c, MIN(Referer) FROM hits WHERE Referer <> '' GROUP BY k HAVING COUNT(*) > 100000 ORDER BY l DESC LIMIT 25;0.872s (×4.77)0.367s (×2.04)1.325s (×7.22)0.216s (×1.22)0.175s (×1.00)1.172s (×6.39)8.151s (×44.11)0.930s (×5.08)0.920s (×5.03)2.002s (×10.88)1.232s (×6.71)1.821s (×9.90)1.600s (×8.70)1.566s (×8.52)1.825s (×9.92)1.358s (×7.39)3.924s (×21.27)1.960s (×10.65)4.040s (×21.89)9.062s (×49.04)3.440s (×18.65)1.466s (×7.98)2.395s (×13.00)3.418s (×18.53)2.344s (×12.73)2.929s (×15.89)4.037s (×21.88)3.043s (×16.50)5.614s (×30.40)1.052s (×5.74)6.602s (×35.74)1.881s (×10.22)3.880s (×21.03)4.182s (×22.66)☠6.755s (×36.57)3.567s (×19.34)5.473s (×29.64)6.209s (×33.62)1.736s (×9.44)11.803s (×63.85)6.690s (×36.22)8.872s (×48.01)10.054s (×54.40)5.600s (×30.32)2.102s (×11.42)11.365s (×61.49)6.921s (×37.46)6.226s (×33.71)6.520s (×35.30)3.654s (×19.81)1.646s (×8.95)9.520s (×51.51)10.200s (×55.19)0.544s (×2.99)2.332s (×12.66)2.669s (×14.48)0.645s (×3.54)10.580s (×57.24)10.559s (×57.13)0.483s (×2.66)0.800s (×4.38)9.455s (×51.16)4.599s (×24.91)1.422s (×7.74)0.883s (×4.83)2.800s (×15.19)1.746s (×9.49)51.115s (×276.35)2.211s (×12.00)12.530s (×67.78)10.222s (×55.31)3.055s (×16.57)2.628s (×14.26)6.484s (×35.10)4.587s (×24.85)6.542s (×35.41)1.627s (×8.85)4.585s (×24.84)12.680s (×68.59)2.034s (×11.05)6.429s (×34.81)15.040s (×81.35)14.615s (×79.05)1.000s (×5.46)3.752s (×20.33)9.099s (×49.24)9.552s (×51.69)19.923s (×107.75)19.645s (×106.24)4.405s (×23.87)23.891s (×129.19)☠9.495s (×51.38)10.233s (×55.37)20.156s (×109.01)10.296s (×55.71)20.637s (×111.61)21.909s (×118.48)8.909s (×48.21)9.189s (×49.72)10.256s (×55.49)2.486s (×13.49)12.461s (×67.41)129.588s (×700.53)4.449s (×24.10)4.333s (×23.48)2.224s (×12.08)12.430s (×67.24)9.376s (×50.74)2.007s (×10.90)28.185s (×152.41)57.807s (×312.52)7.737s (×41.88)28.605s (×154.68)8.014s (×43.37)29.671s (×160.44)32.019s (×173.13)☠33.539s (×181.35)13.387s (×72.42)33.875s (×183.16)10.928s (×59.12)35.585s (×192.41)33.312s (×180.12)4.485s (×24.30)☠☠43.227s (×233.71)19.519s (×105.56)43.732s (×236.44)43.271s (×233.95)49.816s (×269.33)34.888s (×188.64)54.059s (×292.26)50.618s (×273.66)49.242s (×266.23)50.773s (×274.50)10.803s (×58.45)9.622s (×52.06)21.513s (×116.34)9.019s (×48.81)9.958s (×53.88)79.434s (×429.43)33.807s (×182.80)5.614s (×30.40)☠41.156s (×222.52)46.377s (×250.74)52.076s (×281.54)☠3.863s (×20.94)90.542s (×489.47)3.778s (×20.48)250.466s (×1353.92)42.490s (×229.73)48.559s (×262.54)140.618s (×760.15)44.750s (×241.94)98.438s (×532.15)71.687s (×387.55)135.558s (×732.80)☠5.245s (×28.41)☠137.007s (×740.63)☠17.581s (×95.09)☠351.645s (×1900.84)☠245.739s (×1328.37)742.979s (×4016.16)242.954s (×1313.32)177.878s (×961.56)260.902s (×1410.34)☠☠705.000s (×3810.86)807.110s (×4362.81)261.119s (×1411.51)268.611s (×1452.01)☠☠
Q29. Query 29: SELECT SUM(ResolutionWidth), SUM(ResolutionWidth + 1), SUM(ResolutionWidth + 2), SUM(ResolutionWidth + 3), ..., SUM(ResolutionWidth + 89) FROM hits;0.017s (×1.76)0.054s (×4.23)0.036s (×3.02)0.037s (×3.08)0.041s (×3.35)0.038s (×3.15)0.028s (×2.49)0.030s (×2.62)0.050s (×3.94)0.068s (×5.12)0.040s (×3.28)0.039s (×3.21)0.100s (×7.22)0.049s (×3.87)0.040s (×3.28)0.065s (×4.89)0.043s (×3.46)0.005s (×1.00)0.040s (×3.30)0.021s (×2.03)0.036s (×3.02)0.567s (×37.84)0.489s (×32.71)0.040s (×3.28)0.471s (×31.58)0.041s (×3.35)0.033s (×2.82)0.045s (×3.61)0.028s (×2.49)0.203s (×13.97)0.067s (×5.08)0.078s (×5.77)0.037s (×3.08)0.042s (×3.41)0.340s (×22.96)0.054s (×4.19)0.039s (×3.21)0.038s (×3.15)0.042s (×3.41)0.063s (×4.80)0.057s (×4.39)0.042s (×3.41)0.026s (×2.36)0.036s (×3.05)0.036s (×3.02)0.159s (×11.10)0.037s (×3.08)0.074s (×5.50)0.044s (×3.54)0.052s (×4.07)0.007s (×1.09)0.486s (×32.54)0.650s (×43.30)0.100s (×7.22)0.754s (×50.12)0.057s (×4.37)0.056s (×4.31)0.871s (×57.79)0.051s (×4.00)0.054s (×4.20)0.743s (×49.40)1.133s (×75.00)0.073s (×5.44)0.533s (×35.63)1.632s (×107.70)1.009s (×66.85)0.066s (×4.95)0.194s (×13.38)0.099s (×7.18)0.135s (×9.51)0.059s (×4.53)2.104s (×138.68)0.944s (×62.61)0.290s (×19.69)0.070s (×5.28)0.874s (×57.96)0.077s (×5.68)0.151s (×10.56)4.482s (×294.70)0.069s (×5.18)0.181s (×12.53)0.076s (×5.67)0.084s (×6.17)0.080s (×5.90)1.322s (×87.38)4.259s (×280.05)0.093s (×6.76)0.413s (×27.75)0.084s (×6.17)0.071s (×5.31)0.493s (×32.96)0.071s (×5.31)1.510s (×99.71)0.463s (×31.03)2.436s (×160.44)0.114s (×8.13)0.157s (×10.97)0.096s (×6.95)0.083s (×6.10)2.700s (×177.79)0.119s (×8.46)0.454s (×30.44)1.954s (×128.84)9.876s (×648.53)0.436s (×29.25)0.605s (×40.33)3.663s (×240.95)0.279s (×18.96)1.206s (×79.76)0.180s (×12.46)0.288s (×19.55)0.099s (×7.15)1.595s (×105.31)1.273s (×84.16)0.109s (×7.81)0.860s (×57.05)0.100s (×7.22)0.105s (×7.54)0.092s (×6.69)0.110s (×7.87)1.512s (×99.86)0.111s (×7.94)3.040s (×200.08)0.101s (×7.28)0.112s (×8.00)3.098s (×203.89)2.676s (×176.20)2.400s (×158.10)0.135s (×9.51)0.063s (×4.76)0.138s (×9.71)0.147s (×10.30)0.159s (×11.09)0.106s (×7.61)0.144s (×10.10)0.172s (×11.94)0.153s (×10.69)0.158s (×11.02)16.513s (×1083.92)0.504s (×33.72)5.732s (×376.67)6.243s (×410.20)0.699s (×46.51)0.218s (×14.96)11.986s (×786.98)0.814s (×54.06)0.123s (×8.72)12.979s (×852.06)12.557s (×824.39)63.353s (×4156.65)2.167s (×142.81)4.027s (×264.83)23.297s (×1528.95)4.030s (×265.03)6.231s (×409.43)8.102s (×532.17)131.590s (×8633.09)38.622s (×2534.28)122.647s (×8046.42)0.886s (×58.78)0.006s (×1.06)32.687s (×2144.96)77.806s (×5104.80)4.175s (×274.54)1483.256s (×97303.67)32.987s (×2164.64)3.952s (×259.91)16.952s (×1112.72)6.972s (×458.05)33.073s (×2170.25)1.602s (×105.75)8.033s (×527.64)67.213s (×4409.88)91.588s (×6008.94)1064.104s (×69806.90)246.867s (×16195.37)453.830s (×29772.34)394.253s (×25864.03)665.960s (×43688.27)718.900s (×47161.18)257.820s (×16913.89)257.808s (×16913.11)1154.000s (×75704.16)59.664s (×3914.67)
Q30. Query 30: SELECT SearchEngineID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth) FROM hits WHERE SearchPhrase <> '' GROUP BY SearchEngineID, ClientIP ORDER BY c DESC LIMIT 10;0.055s (×1.00)0.067s (×1.18)0.135s (×2.23)0.077s (×1.34)0.108s (×1.81)0.124s (×2.06)0.093s (×1.59)0.120s (×2.00)0.130s (×2.15)0.174s (×2.82)0.163s (×2.66)0.150s (×2.46)0.130s (×2.15)0.226s (×3.62)0.165s (×2.69)0.170s (×2.77)0.158s (×2.58)0.146s (×2.40)0.159s (×2.59)0.300s (×4.76)0.228s (×3.66)0.157s (×2.56)0.268s (×4.27)0.238s (×3.81)0.178s (×2.90)0.241s (×3.86)0.274s (×4.36)0.254s (×4.06)0.266s (×4.24)0.163s (×2.65)0.239s (×3.83)0.179s (×2.90)0.274s (×4.36)0.343s (×5.43)0.170s (×2.77)0.310s (×4.92)0.312s (×4.95)0.411s (×6.47)0.381s (×6.01)0.184s (×2.98)0.488s (×7.66)0.417s (×6.56)0.415s (×6.53)0.429s (×6.75)0.382s (×6.02)0.193s (×3.12)0.517s (×8.10)0.551s (×8.62)0.501s (×7.85)0.465s (×7.30)0.425s (×6.69)0.307s (×4.88)0.420s (×6.61)0.360s (×5.69)0.374s (×5.90)0.519s (×8.13)0.483s (×7.57)0.282s (×4.49)0.662s (×10.33)0.592s (×9.25)0.310s (×4.92)0.327s (×5.19)0.571s (×8.93)1.132s (×17.54)1.025s (×15.91)0.363s (×5.73)0.560s (×8.76)0.422s (×6.64)0.408s (×6.43)0.554s (×8.66)0.690s (×10.76)0.614s (×9.59)0.345s (×5.45)0.361s (×5.71)0.647s (×10.09)0.405s (×6.37)0.645s (×10.07)0.432s (×6.79)0.537s (×8.40)0.837s (×13.02)0.508s (×7.96)0.728s (×11.34)0.948s (×14.72)0.804s (×12.51)0.537s (×8.41)0.649s (×10.13)1.082s (×16.78)0.796s (×12.39)1.395s (×21.59)1.014s (×15.74)0.617s (×9.64)1.049s (×16.28)1.030s (×15.98)0.850s (×13.22)0.906s (×14.07)1.172s (×18.17)0.755s (×11.77)1.344s (×20.81)1.302s (×20.16)0.657s (×10.26)0.825s (×12.83)0.920s (×14.29)0.830s (×12.91)2.829s (×43.63)0.850s (×13.21)0.860s (×13.38)0.800s (×12.44)0.668s (×10.42)0.821s (×12.77)1.032s (×16.02)0.727s (×11.33)1.720s (×26.59)0.774s (×12.04)0.846s (×13.15)1.593s (×24.64)0.890s (×13.83)1.718s (×26.56)1.976s (×30.52)0.897s (×13.94)1.717s (×26.54)0.978s (×15.19)1.698s (×26.25)1.067s (×16.55)1.898s (×29.32)1.775s (×27.43)1.224s (×18.97)2.447s (×37.76)1.110s (×17.21)2.578s (×39.78)0.984s (×15.27)2.317s (×35.76)2.367s (×36.53)2.599s (×40.10)2.178s (×33.63)2.697s (×41.61)2.586s (×39.90)2.919s (×45.02)2.936s (×45.28)2.660s (×41.04)1.844s (×28.50)2.033s (×31.40)2.017s (×31.15)1.487s (×23.01)3.553s (×54.76)7.140s (×109.89)1.497s (×23.16)0.270s (×4.30)9.178s (×141.22)2.342s (×36.15)2.890s (×44.57)4.565s (×70.32)2.337s (×36.07)9.792s (×150.65)2.953s (×45.54)243.726s (×3746.10)10.821s (×166.47)7.197s (×110.77)15.410s (×237.00)7.674s (×118.10)4.398s (×67.75)10.952s (×168.47)10.603s (×163.11)2.654s (×40.94)5.378s (×82.81)2.155s (×33.27)12.759s (×196.25)5.090s (×78.39)4.099s (×63.15)19.237s (×295.82)18.191s (×279.73)☠240.464s (×3695.96)20.952s (×322.18)64.277s (×988.06)4873.488s (×74903.14)269.624s (×4144.14)58.070s (×892.66)295.181s (×4536.93)331.940s (×5101.90)489.590s (×7524.90)257.766s (×3961.88)262.204s (×4030.09)859.690s (×13213.14)☠
Q31. Query 31: SELECT WatchID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth) FROM hits WHERE SearchPhrase <> '' GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10;0.062s (×1.00)0.093s (×1.44)0.274s (×3.95)0.112s (×1.70)0.150s (×2.23)0.160s (×2.37)0.138s (×2.06)0.150s (×2.23)0.150s (×2.23)0.162s (×2.39)0.230s (×3.34)0.196s (×2.87)0.180s (×2.64)0.279s (×4.03)0.212s (×3.09)0.240s (×3.49)0.203s (×2.96)0.201s (×2.94)0.194s (×2.83)0.357s (×5.11)0.297s (×4.27)0.287s (×4.13)0.459s (×6.52)0.371s (×5.30)0.261s (×3.77)0.391s (×5.58)0.401s (×5.72)0.343s (×4.91)0.431s (×6.14)0.204s (×2.99)0.289s (×4.16)0.214s (×3.12)0.406s (×5.79)0.466s (×6.63)0.290s (×4.18)0.523s (×7.42)0.472s (×6.71)0.479s (×6.81)0.465s (×6.61)0.232s (×3.36)0.975s (×13.71)0.543s (×7.70)0.601s (×8.51)0.674s (×9.53)0.516s (×7.32)0.217s (×3.16)0.611s (×8.64)0.867s (×12.20)0.778s (×10.97)0.564s (×7.99)0.555s (×7.87)0.483s (×6.86)0.500s (×7.10)0.520s (×7.38)0.286s (×4.12)0.567s (×8.03)0.586s (×8.30)0.404s (×5.76)0.855s (×12.04)0.891s (×12.54)0.363s (×5.19)0.340s (×4.87)0.676s (×9.55)1.392s (×19.52)1.075s (×15.10)0.413s (×5.89)0.737s (×10.40)0.527s (×7.48)0.674s (×9.53)0.629s (×8.90)1.178s (×16.54)0.765s (×10.79)0.547s (×7.75)0.651s (×9.20)0.745s (×10.51)0.587s (×8.31)0.749s (×10.56)0.604s (×8.55)0.857s (×12.07)1.210s (×16.98)0.646s (×9.13)0.872s (×12.28)1.168s (×16.40)0.987s (×13.88)0.659s (×9.31)0.729s (×10.28)1.345s (×18.86)0.911s (×12.82)1.453s (×20.37)1.626s (×22.77)1.049s (×14.74)2.056s (×28.76)1.450s (×20.32)1.004s (×14.12)1.327s (×18.61)2.431s (×33.98)0.835s (×11.76)2.383s (×33.31)1.890s (×26.45)1.115s (×15.66)1.354s (×18.99)1.004s (×14.12)1.062s (×14.92)3.606s (×50.34)0.533s (×7.56)0.959s (×13.48)0.915s (×12.88)0.981s (×13.80)1.435s (×20.11)1.560s (×21.86)1.073s (×15.08)2.401s (×33.56)0.984s (×13.83)1.071s (×15.04)1.935s (×27.08)1.500s (×21.02)2.516s (×35.16)2.614s (×36.53)1.106s (×15.54)2.289s (×32.00)1.334s (×18.71)2.755s (×38.49)1.634s (×22.89)2.545s (×35.57)2.190s (×30.63)1.497s (×20.98)3.467s (×48.40)1.700s (×23.80)3.476s (×48.53)1.632s (×22.85)3.069s (×42.86)3.744s (×52.26)3.667s (×51.19)2.726s (×38.09)4.102s (×57.24)3.346s (×46.72)4.203s (×58.65)3.737s (×52.16)1.495s (×20.95)2.817s (×39.35)3.410s (×47.61)2.565s (×35.85)2.114s (×29.57)4.476s (×62.45)15.143s (×210.94)1.887s (×26.41)0.352s (×5.04)20.000s (×278.54)3.145s (×43.93)3.419s (×47.73)5.007s (×69.84)3.591s (×50.13)20.748s (×288.97)3.158s (×44.10)245.973s (×3424.23)17.746s (×247.17)12.943s (×180.31)55.999s (×779.68)12.558s (×174.95)6.794s (×94.72)22.782s (×317.27)15.420s (×214.80)3.678s (×51.34)5.983s (×83.43)2.233s (×31.22)20.326s (×283.09)6.476s (×90.29)4.879s (×68.06)52.451s (×730.29)27.595s (×384.28)☠240.377s (×3346.33)25.635s (×356.99)68.954s (×960.01)4748.195s (×66097.85)280.375s (×3903.13)78.920s (×1098.75)298.190s (×4151.12)500.530s (×6967.82)647.320s (×9011.22)257.753s (×3588.21)264.514s (×3682.33)921.100s (×12822.40)☠
Q32. Query 32: SELECT WatchID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth) FROM hits GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10;0.471s (×1.00)0.757s (×1.59)0.618s (×1.31)0.677s (×1.43)0.749s (×1.58)0.732s (×1.54)1.360s (×2.85)0.830s (×1.75)0.830s (×1.75)0.604s (×1.28)0.938s (×1.97)0.889s (×1.87)0.860s (×1.81)0.910s (×1.91)0.854s (×1.80)0.919s (×1.93)0.896s (×1.88)2.183s (×4.56)1.347s (×2.82)1.732s (×3.62)1.364s (×2.86)0.824s (×1.73)3.708s (×7.73)1.456s (×3.05)0.542s (×1.15)1.598s (×3.34)1.674s (×3.50)1.833s (×3.83)2.383s (×4.97)0.659s (×1.39)1.407s (×2.95)0.686s (×1.45)1.801s (×3.76)1.929s (×4.03)1.040s (×2.18)1.660s (×3.47)2.421s (×5.05)2.054s (×4.29)1.590s (×3.33)0.731s (×1.54)5.489s (×11.43)1.585s (×3.31)4.164s (×8.67)4.368s (×9.10)1.839s (×3.84)0.670s (×1.41)2.784s (×5.81)4.602s (×9.59)2.158s (×4.51)2.144s (×4.48)4.957s (×10.32)1.269s (×2.66)3.160s (×6.59)3.480s (×7.25)0.505s (×1.07)0.976s (×2.05)1.037s (×2.17)0.750s (×1.58)3.391s (×7.07)4.094s (×8.53)0.784s (×1.65)0.742s (×1.56)2.040s (×4.26)7.265s (×15.12)1.885s (×3.94)1.085s (×2.28)1.058s (×2.22)2.234s (×4.66)76.414s (×158.82)1.069s (×2.24)2.965s (×6.18)4.947s (×10.30)2.774s (×5.78)4.278s (×8.91)1.999s (×4.18)1.685s (×3.52)2.018s (×4.22)1.638s (×3.42)4.426s (×9.22)4.622s (×9.63)1.573s (×3.29)2.051s (×4.28)3.506s (×7.31)3.979s (×8.29)1.681s (×3.51)5.804s (×12.08)10.053s (×20.91)3.666s (×7.64)12.345s (×25.68)11.224s (×23.35)5.737s (×11.94)12.362s (×25.71)10.420s (×21.68)4.059s (×8.46)5.288s (×11.01)12.115s (×25.20)2.249s (×4.69)13.943s (×29.00)12.175s (×25.32)6.493s (×13.51)4.542s (×9.46)3.731s (×7.77)3.621s (×7.55)☠2.438s (×5.09)2.541s (×5.30)2.581s (×5.38)1.913s (×4.00)6.261s (×13.03)4.751s (×9.89)1.872s (×3.91)17.008s (×35.37)5.623s (×11.71)3.870s (×8.06)16.114s (×33.51)12.196s (×25.37)16.513s (×34.34)18.165s (×37.77)5.432s (×11.31)17.056s (×35.47)5.820s (×12.12)15.151s (×31.51)11.251s (×23.40)20.371s (×42.36)15.833s (×32.92)5.751s (×11.97)22.567s (×46.92)☠24.381s (×50.69)37.261s (×77.46)24.216s (×50.35)24.025s (×49.95)25.782s (×53.60)22.298s (×46.36)26.018s (×54.09)26.591s (×55.28)29.340s (×60.99)29.976s (×62.32)1.985s (×4.15)5.294s (×11.02)19.814s (×41.20)9.557s (×19.88)5.192s (×10.81)49.382s (×102.65)140.552s (×292.11)8.891s (×18.50)0.528s (×1.12)188.070s (×390.86)17.224s (×35.81)39.469s (×82.04)5.006s (×10.42)3.150s (×6.57)192.585s (×400.25)4.234s (×8.82)544.768s (×1132.15)71.490s (×148.59)☠237.298s (×493.17)☠31.803s (×66.11)195.917s (×407.17)128.124s (×266.28)☠15.575s (×32.39)8.538s (×17.76)174.994s (×363.69)☠21.676s (×45.07)☠111.831s (×232.43)☠241.117s (×501.10)129.738s (×269.64)240.316s (×499.44)912.187s (×1895.71)451.233s (×937.76)504.960s (×1049.42)376.963s (×783.42)2681.960s (×5573.61)2792.120s (×5802.54)258.090s (×536.38)475.877s (×988.98)1401.440s (×2912.46)☠
Q33. Query 33: SELECT URL, COUNT(*) AS c FROM hits GROUP BY URL ORDER BY c DESC LIMIT 10;0.472s (×1.54)0.302s (×1.00)0.604s (×1.97)0.526s (×1.72)0.558s (×1.82)0.621s (×2.02)1.102s (×3.56)1.010s (×3.27)0.990s (×3.20)0.549s (×1.79)0.711s (×2.31)0.714s (×2.32)0.960s (×3.11)0.685s (×2.22)0.712s (×2.31)0.727s (×2.36)1.388s (×4.48)0.783s (×2.54)1.059s (×3.42)1.848s (×5.95)1.089s (×3.52)0.890s (×2.88)1.425s (×4.59)1.098s (×3.55)0.579s (×1.89)1.252s (×4.04)1.378s (×4.44)1.232s (×3.98)2.714s (×8.72)0.916s (×2.97)1.281s (×4.13)0.713s (×2.32)1.408s (×4.54)1.731s (×5.57)1.410s (×4.55)3.101s (×9.96)1.595s (×5.14)1.863s (×6.00)1.892s (×6.09)1.197s (×3.87)3.426s (×11.00)2.034s (×6.55)3.443s (×11.06)3.303s (×10.61)1.798s (×5.79)0.900s (×2.91)2.515s (×8.09)2.964s (×9.52)2.587s (×8.32)2.555s (×8.21)2.491s (×8.01)1.476s (×4.76)4.400s (×14.12)6.080s (×19.50)0.598s (×1.95)2.022s (×6.51)2.167s (×6.97)0.835s (×2.71)3.280s (×10.54)3.211s (×10.31)0.713s (×2.32)0.784s (×2.54)2.372s (×7.63)5.436s (×17.44)1.220s (×3.94)1.272s (×4.11)2.396s (×7.71)1.456s (×4.69)6.002s (×19.25)1.099s (×3.55)3.596s (×11.55)3.651s (×11.72)1.963s (×6.32)4.138s (×13.28)2.639s (×8.48)2.822s (×9.07)2.742s (×8.81)1.720s (×5.54)3.167s (×10.17)5.135s (×16.47)1.959s (×6.30)2.711s (×8.71)4.223s (×13.55)5.997s (×19.24)2.130s (×6.85)5.071s (×16.27)10.504s (×33.67)3.796s (×12.19)5.952s (×19.09)5.437s (×17.44)6.645s (×21.31)5.211s (×16.72)9.610s (×30.80)5.690s (×18.25)5.166s (×16.57)6.314s (×20.25)3.096s (×9.95)7.623s (×24.44)8.751s (×28.05)4.529s (×14.54)5.314s (×17.05)3.861s (×12.40)3.663s (×11.76)6.600s (×21.17)3.522s (×11.31)3.151s (×10.12)3.097s (×9.95)2.385s (×7.67)21.617s (×69.25)5.936s (×19.04)2.515s (×8.09)7.975s (×25.57)3.134s (×10.07)5.260s (×16.87)8.201s (×26.29)10.491s (×33.63)8.506s (×27.27)9.773s (×31.33)8.451s (×27.09)9.114s (×29.22)3.734s (×11.99)8.817s (×28.27)6.419s (×20.59)10.983s (×35.20)9.024s (×28.93)6.712s (×21.52)18.889s (×60.52)☠21.842s (×69.97)57.626s (×184.56)21.873s (×70.07)22.562s (×72.28)22.103s (×70.81)12.337s (×39.54)31.417s (×100.63)23.555s (×75.46)25.213s (×80.77)27.361s (×87.65)8.348s (×26.76)6.382s (×20.47)10.160s (×32.57)9.368s (×30.03)6.334s (×20.31)33.403s (×106.99)28.527s (×91.38)7.063s (×22.65)0.333s (×1.10)34.065s (×109.11)58.395s (×187.02)10.360s (×33.21)5.105s (×16.38)3.187s (×10.24)36.238s (×116.07)3.107s (×9.98)332.194s (×1063.76)42.159s (×135.03)☠46.385s (×148.56)☠☠190.582s (×610.30)299.398s (×958.74)☠8.974s (×28.77)16.863s (×54.03)270.724s (×866.93)☠16.168s (×51.80)☠97.224s (×311.36)0.494s (×1.61)308.246s (×987.08)90.161s (×288.74)460.466s (×1474.50)585.970s (×1876.38)349.146s (×1118.04)182468.890s (×584289.32)409.554s (×1311.48)831.140s (×2661.45)954.940s (×3057.87)257.759s (×825.41)347.904s (×1114.07)1455.550s (×4660.89)☠
Q34. Query 34: SELECT 1, URL, COUNT(*) AS c FROM hits GROUP BY 1, URL ORDER BY c DESC LIMIT 10;0.475s (×1.75)0.267s (×1.00)0.554s (×2.04)0.522s (×1.92)0.569s (×2.09)0.646s (×2.37)1.103s (×4.02)0.990s (×3.61)0.950s (×3.47)0.567s (×2.08)0.701s (×2.57)0.695s (×2.55)0.970s (×3.54)0.683s (×2.50)0.708s (×2.59)0.666s (×2.44)1.251s (×4.55)1.221s (×4.44)1.154s (×4.20)1.931s (×7.01)1.111s (×4.05)0.898s (×3.28)1.421s (×5.17)1.055s (×3.85)0.551s (×2.03)1.253s (×4.56)1.331s (×4.84)1.164s (×4.24)2.689s (×9.75)0.940s (×3.43)1.388s (×5.05)0.827s (×3.02)1.362s (×4.95)1.739s (×6.32)1.400s (×5.09)2.568s (×9.31)1.846s (×6.70)1.921s (×6.97)1.962s (×7.12)1.196s (×4.36)3.466s (×12.55)1.974s (×7.16)3.300s (×11.95)3.313s (×12.00)1.826s (×6.63)0.906s (×3.31)2.564s (×9.29)2.948s (×10.68)2.503s (×9.07)2.550s (×9.24)2.937s (×10.64)1.329s (×4.84)4.270s (×15.45)6.310s (×22.82)0.609s (×2.24)2.272s (×8.24)2.040s (×7.40)0.823s (×3.01)3.264s (×11.82)3.113s (×11.28)0.544s (×2.00)1.048s (×3.82)2.403s (×8.71)6.080s (×21.99)2.115s (×7.67)1.241s (×4.52)2.411s (×8.74)1.483s (×5.39)5.825s (×21.07)1.155s (×4.21)5.389s (×19.50)3.661s (×13.26)1.906s (×6.92)4.007s (×14.51)2.682s (×9.72)2.835s (×10.27)2.744s (×9.95)1.750s (×6.36)3.169s (×11.48)5.165s (×18.69)1.915s (×6.95)2.793s (×10.12)3.872s (×14.02)6.295s (×22.77)2.110s (×7.66)4.941s (×17.88)10.907s (×39.42)3.756s (×13.60)5.424s (×19.62)5.386s (×19.48)6.740s (×24.37)5.814s (×21.03)9.840s (×35.57)5.689s (×20.58)5.185s (×18.76)6.302s (×22.79)3.181s (×11.52)7.497s (×27.11)7.827s (×28.30)4.498s (×16.28)5.376s (×19.45)3.870s (×14.01)3.614s (×13.09)6.846s (×24.76)3.533s (×12.80)3.193s (×11.57)3.124s (×11.32)2.410s (×8.74)22.069s (×79.73)5.914s (×21.39)2.403s (×8.71)7.921s (×28.64)3.173s (×11.49)5.164s (×18.68)8.002s (×28.93)10.368s (×37.47)8.505s (×30.75)9.887s (×35.74)6.861s (×24.81)9.084s (×32.84)3.687s (×13.35)9.358s (×33.83)6.382s (×23.08)11.928s (×43.11)9.226s (×33.35)6.676s (×24.14)19.047s (×68.81)☠21.365s (×77.18)14.079s (×50.88)21.836s (×78.89)22.174s (×80.11)23.139s (×83.59)12.422s (×44.89)24.573s (×88.77)23.433s (×84.65)26.012s (×93.96)26.799s (×96.81)☠6.306s (×22.81)10.112s (×36.55)9.185s (×33.20)6.238s (×22.56)33.153s (×119.75)29.175s (×105.39)7.661s (×27.70)65.075s (×235.02)35.727s (×129.04)63.914s (×230.83)10.829s (×39.14)6.238s (×22.56)2.695s (×9.77)37.741s (×136.32)2.790s (×10.11)335.163s (×1210.30)44.155s (×159.48)☠47.551s (×171.74)☠☠190.226s (×686.94)290.848s (×1050.28)☠9.371s (×33.87)16.850s (×60.88)280.282s (×1012.12)☠16.963s (×61.29)☠97.119s (×350.73)☠309.810s (×1118.75)94.479s (×341.20)471.809s (×1703.72)570.279s (×2059.30)351.725s (×1270.10)182468.890s (×658889.58)453.709s (×1638.37)830.460s (×2998.80)953.780s (×3444.11)257.797s (×930.93)344.891s (×1245.43)1461.830s (×5278.66)☠
Q35. Query 35: SELECT ClientIP, ClientIP - 1, ClientIP - 2, ClientIP - 3, COUNT(*) AS c FROM hits GROUP BY ClientIP, ClientIP - 1, ClientIP - 2, ClientIP - 3 ORDER BY c DESC LIMIT 10;0.112s (×1.21)0.123s (×1.31)0.253s (×2.60)0.102s (×1.11)0.097s (×1.06)0.096s (×1.05)0.177s (×1.85)0.160s (×1.68)0.170s (×1.78)0.152s (×1.61)0.097s (×1.06)0.091s (×1.00)0.120s (×1.29)0.261s (×2.68)0.096s (×1.05)0.110s (×1.19)0.256s (×2.63)0.700s (×7.03)0.259s (×2.67)0.431s (×4.37)0.140s (×1.49)0.131s (×1.40)0.618s (×6.22)0.179s (×1.87)0.155s (×1.63)0.140s (×1.49)0.170s (×1.78)0.150s (×1.58)0.327s (×3.34)0.138s (×1.46)0.413s (×4.19)0.167s (×1.75)0.213s (×2.21)0.207s (×2.15)0.450s (×4.55)0.418s (×4.24)0.272s (×2.79)0.283s (×2.90)0.239s (×2.47)0.095s (×1.04)0.542s (×5.47)0.251s (×2.58)0.400s (×4.06)0.403s (×4.09)0.277s (×2.84)0.173s (×1.81)0.329s (×3.36)0.492s (×4.97)0.272s (×2.79)0.338s (×3.45)1.846s (×18.37)0.161s (×1.70)1.110s (×11.09)0.510s (×5.15)0.298s (×3.05)0.418s (×4.24)0.428s (×4.34)0.360s (×3.66)0.424s (×4.30)0.400s (×4.06)0.338s (×3.45)0.326s (×3.33)0.587s (×5.91)2.086s (×20.76)0.794s (×7.96)0.393s (×3.99)0.474s (×4.79)0.590s (×5.94)0.656s (×6.59)0.584s (×5.88)0.538s (×5.43)1.160s (×11.58)0.638s (×6.42)0.889s (×8.90)0.572s (×5.76)0.313s (×3.20)0.590s (×5.94)0.360s (×3.66)0.709s (×7.12)0.539s (×5.44)0.365s (×3.71)0.585s (×5.89)0.437s (×4.43)0.458s (×4.63)0.619s (×6.23)0.673s (×6.77)1.535s (×15.30)1.249s (×12.47)0.571s (×5.75)0.622s (×6.26)1.089s (×10.88)0.717s (×7.20)1.790s (×17.82)1.279s (×12.76)0.436s (×4.41)0.973s (×9.73)0.668s (×6.71)0.755s (×7.57)0.838s (×8.40)1.313s (×13.10)0.535s (×5.40)1.281s (×12.78)1.055s (×10.54)5.806s (×57.58)0.872s (×8.73)0.713s (×7.16)0.756s (×7.59)0.436s (×4.42)1.066s (×10.65)0.574s (×5.78)0.490s (×4.95)0.973s (×9.73)0.450s (×4.56)0.647s (×6.50)0.970s (×9.70)1.436s (×14.31)0.992s (×9.92)1.161s (×11.59)3.412s (×33.88)0.955s (×9.55)1.577s (×15.71)0.963s (×9.63)1.591s (×15.85)1.168s (×11.66)1.029s (×10.29)1.676s (×16.69)12.984s (×128.65)1.840s (×18.32)1.451s (×14.47)1.291s (×12.88)1.345s (×13.42)1.318s (×13.15)1.354s (×13.50)1.342s (×13.39)1.487s (×14.82)1.415s (×14.11)1.767s (×17.59)1.862s (×18.53)☠0.790s (×7.92)3.392s (×33.68)2.685s (×26.68)0.909s (×9.10)1.928s (×19.19)11.309s (×112.07)2.210s (×21.98)93.870s (×929.50)12.538s (×124.23)6.415s (×63.61)5.209s (×51.67)5.933s (×58.84)1.815s (×18.07)13.880s (×137.52)1.629s (×16.23)32.119s (×318.11)17.890s (×177.22)41.503s (×411.02)21.629s (×214.24)40.754s (×403.60)6.374s (×63.20)21.083s (×208.84)34.835s (×345.00)3.546s (×35.21)6.473s (×64.19)46.439s (×459.89)38.026s (×376.60)5.836s (×57.88)4.955s (×49.16)60.055s (×594.70)297.457s (×2945.21)☠17.698s (×175.32)60.185s (×595.99)103.467s (×1024.52)419.334s (×4151.92)272.881s (×2701.89)66.930s (×662.77)346.728s (×3433.05)608.510s (×6024.95)708.750s (×7017.43)257.661s (×2551.20)264.630s (×2620.20)937.230s (×9279.60)☠
Q36. Query 36: SELECT URL, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND DontCountHits = 0 AND IsRefresh = 0 AND URL <> '' GROUP BY URL ORDER BY PageViews DESC LIMIT 10;0.018s (×1.41)0.022s (×1.64)0.027s (×1.87)0.040s (×2.53)0.044s (×2.73)0.030s (×2.02)0.010s (×1.00)0.030s (×2.02)0.040s (×2.53)0.050s (×3.04)0.033s (×2.17)0.036s (×2.33)0.060s (×3.54)0.084s (×4.75)0.036s (×2.33)0.040s (×2.55)0.042s (×2.62)0.077s (×4.39)0.044s (×2.72)0.029s (×1.97)0.038s (×2.43)0.129s (×7.03)0.012s (×1.09)0.039s (×2.48)0.260s (×13.67)0.042s (×2.63)0.035s (×2.28)0.051s (×3.08)0.034s (×2.22)0.301s (×15.71)0.060s (×3.53)0.123s (×6.72)0.037s (×2.38)0.051s (×3.08)0.120s (×6.57)0.044s (×2.73)0.044s (×2.73)0.040s (×2.53)0.051s (×3.08)0.693s (×35.56)0.055s (×3.30)0.049s (×2.98)0.042s (×2.63)0.040s (×2.51)0.044s (×2.73)0.180s (×9.62)0.040s (×2.53)0.062s (×3.65)0.045s (×2.78)0.052s (×3.13)0.108s (×5.95)0.159s (×8.57)0.050s (×3.03)0.080s (×4.55)0.212s (×11.22)0.226s (×11.91)0.223s (×11.76)0.186s (×9.91)0.041s (×2.58)0.044s (×2.73)0.221s (×11.68)0.553s (×28.47)0.111s (×6.12)0.310s (×16.16)0.082s (×4.66)0.190s (×10.11)0.272s (×14.27)0.131s (×7.13)0.062s (×3.65)0.232s (×12.22)0.050s (×3.03)0.101s (×5.61)0.275s (×14.43)0.159s (×8.56)0.247s (×13.00)0.956s (×48.86)0.247s (×12.99)0.154s (×8.29)0.118s (×6.47)0.066s (×3.84)0.199s (×10.57)0.282s (×14.74)0.052s (×3.13)0.071s (×4.10)0.195s (×10.36)0.054s (×3.26)0.241s (×12.69)0.203s (×10.77)0.063s (×3.69)0.059s (×3.49)0.249s (×13.09)0.067s (×3.89)0.140s (×7.58)0.101s (×5.61)0.133s (×7.22)0.086s (×4.85)0.257s (×13.51)0.089s (×5.01)0.213s (×11.27)0.279s (×14.61)0.158s (×8.49)0.243s (×12.79)0.196s (×10.42)0.060s (×3.54)0.959s (×48.98)0.277s (×14.50)0.205s (×10.88)0.438s (×22.65)0.224s (×11.83)0.192s (×10.21)0.450s (×23.26)0.085s (×4.80)0.299s (×15.63)1.880s (×95.57)0.078s (×4.45)0.186s (×9.89)0.079s (×4.50)0.100s (×5.56)1.121s (×57.18)0.091s (×5.11)0.135s (×7.34)0.087s (×4.90)0.259s (×13.60)0.136s (×7.38)0.092s (×5.16)0.218s (×11.53)0.322s (×16.79)0.190s (×10.11)0.129s (×7.03)0.043s (×2.68)0.109s (×6.02)0.172s (×9.20)0.128s (×6.98)0.120s (×6.57)0.152s (×8.19)0.143s (×7.74)0.155s (×8.34)0.172s (×9.20)1.544s (×78.57)0.437s (×22.60)0.232s (×12.25)0.249s (×13.09)0.384s (×19.92)0.183s (×9.76)0.260s (×13.65)2.066s (×104.96)9.286s (×469.99)0.342s (×17.81)0.161s (×8.66)0.159s (×8.53)0.202s (×10.72)2.053s (×104.30)0.385s (×19.97)1.962s (×99.70)0.736s (×37.70)0.394s (×20.44)0.380s (×19.73)0.467s (×24.13)0.356s (×18.48)0.795s (×40.71)0.554s (×28.50)1.773s (×90.14)1.787s (×90.85)4.587s (×232.42)10.063s (×509.28)3.122s (×158.35)1.941s (×98.65)☠1.462s (×74.42)7.722s (×390.93)0.255s (×13.40)0.412s (×21.34)5.870s (×297.29)3.341s (×169.40)4.975s (×252.03)0.981s (×50.11)3.610s (×183.02)0.757s (×38.78)4.130s (×209.31)3.770s (×191.11)257.628s (×13025.84)257.630s (×13025.94)2.770s (×140.55)☠
Q37. Query 37: SELECT Title, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND DontCountHits = 0 AND IsRefresh = 0 AND Title <> '' GROUP BY Title ORDER BY PageViews DESC LIMIT 10;0.010s (×1.35)0.015s (×1.69)0.009s (×1.29)0.035s (×3.06)0.031s (×2.79)0.023s (×2.25)0.006s (×1.08)0.030s (×2.72)0.030s (×2.72)0.017s (×1.85)0.023s (×2.25)0.022s (×2.18)0.040s (×3.40)0.022s (×2.18)0.022s (×2.18)0.028s (×2.60)0.018s (×1.93)0.047s (×3.86)0.020s (×2.02)0.008s (×1.23)0.023s (×2.25)0.048s (×3.93)0.005s (×1.00)0.024s (×2.31)0.347s (×24.31)0.025s (×2.38)0.022s (×2.18)0.029s (×2.66)0.020s (×2.04)0.315s (×22.11)0.024s (×2.34)0.101s (×7.56)0.022s (×2.18)0.030s (×2.72)0.090s (×6.81)0.019s (×1.95)0.034s (×3.00)0.023s (×2.25)0.027s (×2.52)0.454s (×31.57)0.023s (×2.27)0.025s (×2.38)0.020s (×2.04)0.025s (×2.37)0.021s (×2.11)0.135s (×9.84)0.022s (×2.18)0.031s (×2.80)0.028s (×2.59)0.033s (×2.93)0.084s (×6.40)0.113s (×8.37)0.020s (×2.04)0.050s (×4.08)0.139s (×10.14)0.285s (×20.11)0.286s (×20.18)0.137s (×10.01)0.026s (×2.45)0.031s (×2.79)0.139s (×10.14)0.588s (×40.72)0.087s (×6.60)0.446s (×31.04)0.037s (×3.23)0.140s (×10.21)0.326s (×22.90)0.092s (×6.94)0.024s (×2.29)0.187s (×13.43)0.036s (×3.13)0.041s (×3.47)0.204s (×14.60)0.097s (×7.32)0.305s (×21.47)1.103s (×75.79)0.345s (×24.19)0.142s (×10.35)0.043s (×3.63)0.035s (×3.06)0.153s (×11.10)0.331s (×23.22)0.030s (×2.72)0.043s (×3.61)0.152s (×11.03)0.036s (×3.14)0.099s (×7.42)0.082s (×6.26)0.034s (×3.00)0.032s (×2.86)0.115s (×8.53)0.035s (×3.06)0.090s (×6.81)0.058s (×4.63)0.113s (×8.35)0.040s (×3.40)0.219s (×15.56)0.044s (×3.68)0.044s (×3.68)0.159s (×11.50)0.124s (×9.12)0.154s (×11.16)0.139s (×10.14)0.035s (×3.06)1.012s (×69.54)0.212s (×15.13)0.178s (×12.83)0.310s (×21.78)0.151s (×10.95)0.113s (×8.37)0.354s (×24.78)0.035s (×3.06)0.342s (×23.98)2.172s (×148.55)0.037s (×3.20)0.126s (×9.25)0.036s (×3.13)0.038s (×3.27)1.189s (×81.63)0.043s (×3.61)0.120s (×8.83)0.041s (×3.47)0.201s (×14.34)0.047s (×3.88)0.038s (×3.27)0.134s (×9.80)0.176s (×12.66)0.080s (×6.13)0.046s (×3.81)0.020s (×2.04)0.046s (×3.81)0.048s (×3.95)0.052s (×4.22)0.050s (×4.08)0.048s (×3.95)0.056s (×4.49)0.056s (×4.49)0.059s (×4.70)0.225s (×16.02)0.338s (×23.69)0.176s (×12.69)0.145s (×10.55)0.351s (×24.58)0.071s (×5.51)0.065s (×5.08)2.722s (×185.99)9.323s (×635.37)0.095s (×7.16)0.102s (×7.62)0.112s (×8.32)0.069s (×5.38)1.524s (×104.43)0.102s (×7.64)2.154s (×147.32)0.512s (×35.56)0.197s (×14.09)0.106s (×7.91)0.128s (×9.41)0.118s (×8.73)0.572s (×39.61)0.147s (×10.71)0.208s (×14.85)0.906s (×62.36)4.580s (×312.48)7.821s (×533.12)0.418s (×29.13)1.517s (×103.92)☠0.907s (×62.44)6.617s (×451.12)0.172s (×12.39)0.333s (×23.38)1.806s (×123.63)0.832s (×57.33)1.626s (×111.38)0.725s (×50.01)0.620s (×42.89)0.587s (×40.64)3.700s (×252.57)3.270s (×223.30)257.602s (×17537.68)257.613s (×17538.43)2.520s (×172.24)☠
Q38. Query 38: SELECT URL, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND IsRefresh = 0 AND IsLink <> 0 AND IsDownload = 0 GROUP BY URL ORDER BY PageViews DESC LIMIT 10 OFFSET 1000;0.009s (×1.35)0.017s (×1.90)0.016s (×1.86)0.025s (×2.50)0.025s (×2.50)0.018s (×2.00)0.004s (×1.02)0.020s (×2.14)0.020s (×2.14)0.046s (×3.99)0.023s (×2.36)0.025s (×2.50)0.030s (×2.86)0.013s (×1.68)0.025s (×2.50)0.022s (×2.28)0.018s (×1.97)0.016s (×1.85)0.020s (×2.16)0.015s (×1.79)0.025s (×2.50)0.043s (×3.79)0.004s (×1.00)0.025s (×2.50)0.243s (×18.03)0.027s (×2.64)0.024s (×2.43)0.030s (×2.86)0.016s (×1.86)0.066s (×5.39)0.025s (×2.52)0.077s (×6.21)0.023s (×2.36)0.030s (×2.86)0.110s (×8.57)0.018s (×1.99)0.035s (×3.21)0.027s (×2.64)0.026s (×2.57)0.678s (×49.12)0.015s (×1.76)0.026s (×2.57)0.016s (×1.86)0.019s (×2.07)0.023s (×2.36)0.153s (×11.61)0.023s (×2.36)0.016s (×1.86)0.035s (×3.21)0.035s (×3.21)0.031s (×2.95)0.123s (×9.46)0.020s (×2.14)0.040s (×3.57)0.151s (×11.50)0.094s (×7.45)0.096s (×7.54)0.132s (×10.14)0.031s (×2.93)0.028s (×2.71)0.136s (×10.43)0.424s (×30.96)0.055s (×4.64)0.154s (×11.73)0.118s (×9.16)0.141s (×10.78)0.145s (×11.09)0.089s (×7.07)0.041s (×3.63)0.205s (×15.37)0.033s (×3.07)0.035s (×3.21)0.190s (×14.28)0.091s (×7.21)0.106s (×8.25)0.107s (×8.37)0.106s (×8.31)0.150s (×11.43)0.037s (×3.32)0.044s (×3.86)0.154s (×11.71)0.140s (×10.69)0.032s (×3.00)0.048s (×4.14)0.136s (×10.43)0.049s (×4.24)0.073s (×5.93)0.117s (×9.07)0.034s (×3.14)0.032s (×3.00)0.119s (×9.24)0.045s (×3.93)0.080s (×6.43)0.052s (×4.43)0.104s (×8.12)0.040s (×3.57)0.150s (×11.43)0.046s (×4.00)0.045s (×3.93)0.140s (×10.73)0.140s (×10.71)0.169s (×12.78)0.144s (×11.00)0.034s (×3.14)0.370s (×27.11)0.216s (×16.16)0.176s (×13.27)0.445s (×32.49)0.073s (×5.95)0.136s (×10.43)0.441s (×32.21)0.037s (×3.36)0.233s (×17.33)0.228s (×17.00)0.037s (×3.36)0.115s (×8.93)0.036s (×3.29)0.037s (×3.36)0.854s (×61.70)0.043s (×3.79)0.112s (×8.68)0.043s (×3.79)0.157s (×11.89)0.051s (×4.36)0.042s (×3.71)0.156s (×11.85)0.159s (×12.10)0.050s (×4.28)0.048s (×4.14)0.018s (×2.03)0.051s (×4.36)0.050s (×4.28)0.058s (×4.86)0.044s (×3.86)0.054s (×4.57)0.058s (×4.86)0.053s (×4.50)0.060s (×5.00)0.138s (×10.56)0.444s (×32.42)0.147s (×11.21)0.146s (×11.14)0.387s (×28.35)0.081s (×6.50)0.038s (×3.44)2.079s (×149.19)2.136s (×153.26)0.053s (×4.50)0.087s (×6.91)0.101s (×7.94)0.034s (×3.14)1.805s (×129.62)0.060s (×5.02)2.477s (×177.61)0.251s (×18.61)0.117s (×9.10)0.025s (×2.50)0.068s (×5.58)0.025s (×2.49)0.567s (×41.19)0.101s (×7.94)0.081s (×6.47)0.091s (×7.21)4.471s (×320.01)9.961s (×712.08)0.109s (×8.53)1.649s (×118.46)☠0.287s (×21.24)0.625s (×45.33)0.256s (×19.00)0.423s (×30.90)0.800s (×57.87)0.307s (×22.62)2.222s (×159.40)0.141s (×10.79)0.180s (×13.57)0.238s (×17.71)1.450s (×104.27)0.960s (×69.27)304.596s (×21753.56)257.667s (×18402.11)1.520s (×109.27)☠
Q39. Query 39: SELECT TraficSourceID, SearchEngineID, AdvEngineID, CASE WHEN (SearchEngineID = 0 AND AdvEngineID = 0) THEN Referer ELSE '' END AS Src, URL AS Dst, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND IsRefresh = 0 GROUP BY TraficSourceID, SearchEngineID, AdvEngineID, Src, Dst ORDER BY PageViews DESC LIMIT 10 OFFSET 1000;0.031s (×1.34)0.037s (×1.52)0.050s (×1.94)0.054s (×2.07)0.043s (×1.71)0.055s (×2.10)0.024s (×1.09)0.080s (×2.91)0.080s (×2.91)0.049s (×1.90)0.059s (×2.23)0.060s (×2.26)0.090s (×3.23)0.058s (×2.20)0.064s (×2.39)0.069s (×2.54)0.081s (×2.93)0.195s (×6.62)0.080s (×2.90)0.057s (×2.17)0.062s (×2.33)0.154s (×5.30)0.021s (×1.00)0.060s (×2.26)0.387s (×12.83)0.072s (×2.65)0.063s (×2.36)0.085s (×3.07)0.067s (×2.49)0.101s (×3.58)0.089s (×3.20)0.213s (×7.21)0.069s (×2.55)0.076s (×2.78)0.220s (×7.43)0.081s (×2.95)0.085s (×3.07)0.063s (×2.36)0.064s (×2.39)0.860s (×28.13)0.083s (×3.00)0.063s (×2.36)0.074s (×2.71)0.077s (×2.80)0.068s (×2.52)0.320s (×10.67)0.075s (×2.75)0.094s (×3.35)0.085s (×3.07)0.090s (×3.23)0.206s (×6.99)0.293s (×9.78)0.120s (×4.20)0.180s (×6.14)0.296s (×9.89)0.330s (×10.98)0.339s (×11.27)0.301s (×10.05)0.073s (×2.68)0.087s (×3.13)0.348s (×11.57)0.495s (×16.30)0.217s (×7.34)0.786s (×25.71)0.096s (×3.44)0.291s (×9.73)0.386s (×12.80)0.264s (×8.85)0.133s (×4.61)0.235s (×7.92)0.117s (×4.10)0.169s (×5.78)0.391s (×12.96)0.289s (×9.67)0.361s (×11.99)0.149s (×5.14)0.362s (×12.01)0.231s (×7.79)0.159s (×5.45)0.130s (×4.52)0.342s (×11.38)0.404s (×13.38)0.085s (×3.07)0.114s (×4.01)0.290s (×9.69)0.086s (×3.12)0.479s (×15.80)0.369s (×12.25)0.114s (×4.01)0.121s (×4.23)0.353s (×11.73)0.131s (×4.56)0.280s (×9.37)0.217s (×7.34)0.257s (×8.63)0.121s (×4.23)0.351s (×11.66)0.156s (×5.36)0.134s (×4.65)0.434s (×14.36)0.242s (×8.14)0.413s (×13.67)0.287s (×9.60)0.208s (×7.04)0.460s (×15.18)0.427s (×14.12)0.349s (×11.59)0.652s (×21.39)0.244s (×8.22)0.299s (×9.99)0.642s (×21.07)0.166s (×5.69)0.250s (×8.41)0.275s (×9.22)0.157s (×5.40)0.321s (×10.69)0.165s (×5.66)0.226s (×7.63)1.919s (×62.34)0.185s (×6.30)0.193s (×6.57)0.171s (×5.85)0.450s (×14.88)0.205s (×6.95)0.178s (×6.08)0.319s (×10.63)0.561s (×18.44)0.360s (×11.96)0.251s (×8.43)0.089s (×3.19)0.252s (×8.47)0.237s (×7.98)0.264s (×8.85)0.238s (×8.01)0.294s (×9.82)0.270s (×9.05)0.325s (×10.83)0.314s (×10.47)0.096s (×3.42)0.640s (×21.01)0.420s (×13.90)0.356s (×11.83)0.640s (×21.01)0.350s (×11.63)0.538s (×17.72)3.284s (×106.45)68.193s (×2204.08)0.703s (×23.04)0.264s (×8.85)0.246s (×8.27)0.651s (×21.36)2.793s (×90.58)0.833s (×27.24)3.584s (×116.15)1.054s (×34.37)0.806s (×26.37)0.700s (×22.96)1.091s (×35.57)0.699s (×22.92)1.658s (×53.92)59.116s (×1910.76)79.523s (×2570.22)1.133s (×36.94)4.932s (×159.71)16.064s (×519.45)96.762s (×3127.32)2.885s (×93.55)☠☠6.064s (×196.28)0.178s (×6.08)0.528s (×17.39)7.709s (×249.46)4.541s (×147.07)8.762s (×283.48)1.793s (×58.28)563.020s (×18195.10)1.520s (×49.44)5.140s (×166.43)4.680s (×151.56)257.572s (×8324.12)257.543s (×8323.19)3.570s (×115.69)☠
Q40. Query 40: SELECT URLHash, EventDate, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND IsRefresh = 0 AND TraficSourceID IN (-1, 6) AND RefererHash = 3594120000172545465 GROUP BY URLHash, EventDate ORDER BY PageViews DESC LIMIT 10 OFFSET 100;0.012s (×1.70)0.019s (×2.17)0.005s (×1.14)0.033s (×3.26)0.026s (×2.73)0.015s (×1.89)0.006s (×1.20)0.030s (×3.03)0.030s (×3.03)0.014s (×1.79)0.015s (×1.89)0.016s (×1.97)0.030s (×3.03)0.015s (×1.88)0.018s (×2.12)0.018s (×2.13)0.013s (×1.75)0.025s (×2.68)0.015s (×1.86)0.004s (×1.06)0.016s (×1.97)0.029s (×2.97)0.003s (×1.00)0.016s (×1.97)0.024s (×2.57)0.020s (×2.27)0.014s (×1.82)0.020s (×2.27)0.014s (×1.82)0.047s (×4.30)0.020s (×2.24)0.054s (×4.85)0.014s (×1.82)0.019s (×2.20)0.070s (×6.06)0.013s (×1.74)0.024s (×2.57)0.014s (×1.82)0.019s (×2.20)0.061s (×5.36)0.014s (×1.80)0.020s (×2.27)0.012s (×1.67)0.015s (×1.88)0.013s (×1.74)0.081s (×6.88)0.013s (×1.74)0.019s (×2.21)0.018s (×2.12)0.020s (×2.27)0.058s (×5.13)0.062s (×5.44)0.020s (×2.27)0.030s (×3.03)0.144s (×11.66)0.053s (×4.75)0.060s (×5.28)0.170s (×13.63)0.014s (×1.82)0.014s (×1.82)0.132s (×10.75)0.502s (×38.76)0.050s (×4.54)0.090s (×7.58)0.034s (×3.34)0.138s (×11.21)0.070s (×6.09)0.079s (×6.74)0.010s (×1.51)0.206s (×16.40)0.017s (×2.04)0.025s (×2.65)0.139s (×11.25)0.092s (×7.69)0.055s (×4.93)0.043s (×4.01)0.055s (×4.89)0.096s (×8.03)0.022s (×2.41)0.024s (×2.57)0.114s (×9.39)0.059s (×5.24)0.021s (×2.35)0.024s (×2.57)0.129s (×10.53)0.027s (×2.80)0.069s (×5.98)0.051s (×4.62)0.017s (×2.04)0.015s (×1.89)0.098s (×8.17)0.017s (×2.04)0.020s (×2.27)0.034s (×3.33)0.049s (×4.43)0.019s (×2.20)0.123s (×10.07)0.023s (×2.50)0.024s (×2.57)0.146s (×11.79)0.086s (×7.27)0.082s (×6.97)0.119s (×9.77)0.035s (×3.41)0.137s (×11.15)0.144s (×11.66)0.176s (×14.06)0.233s (×18.40)0.824s (×63.14)0.072s (×6.21)0.261s (×20.52)0.019s (×2.20)1.171s (×89.47)0.077s (×6.61)0.018s (×2.12)0.111s (×9.13)0.021s (×2.35)0.026s (×2.73)0.015s (×1.89)0.022s (×2.42)0.114s (×9.40)0.022s (×2.42)0.138s (×11.20)0.029s (×2.95)0.021s (×2.35)0.133s (×10.83)0.103s (×8.53)0.030s (×3.03)0.024s (×2.57)0.014s (×1.85)0.021s (×2.35)0.024s (×2.57)0.031s (×3.11)0.026s (×2.73)0.039s (×3.71)0.028s (×2.88)0.034s (×3.33)0.027s (×2.80)0.298s (×23.35)0.256s (×20.15)0.181s (×14.46)0.133s (×10.83)0.244s (×19.24)0.034s (×3.33)0.043s (×4.00)0.917s (×70.21)1.496s (×114.06)0.058s (×5.13)0.092s (×7.73)0.109s (×9.00)0.071s (×6.13)2.082s (×158.44)0.065s (×5.68)2.613s (×198.65)0.221s (×17.49)0.113s (×9.32)0.038s (×3.60)0.079s (×6.71)0.035s (×3.41)0.332s (×25.88)0.153s (×12.34)0.166s (×13.32)0.062s (×5.45)4.282s (×325.05)0.144s (×11.66)0.177s (×14.15)1.578s (×120.28)☠0.359s (×27.95)1.398s (×106.63)0.112s (×9.24)0.378s (×29.39)0.638s (×49.11)0.298s (×23.29)0.445s (×34.46)0.184s (×14.72)0.110s (×9.09)0.283s (×22.19)1.410s (×107.54)0.740s (×56.80)311.557s (×23596.30)257.672s (×19515.36)0.940s (×71.95)☠
Q41. Query 41: SELECT WindowClientWidth, WindowClientHeight, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND IsRefresh = 0 AND DontCountHits = 0 AND URLHash = 2868770270353813622 GROUP BY WindowClientWidth, WindowClientHeight ORDER BY PageViews DESC LIMIT 10 OFFSET 10000;0.010s (×1.46)0.017s (×2.06)0.007s (×1.27)0.030s (×3.00)0.026s (×2.70)0.012s (×1.65)0.006s (×1.16)0.020s (×2.25)0.020s (×2.25)0.009s (×1.44)0.016s (×1.95)0.015s (×1.87)0.030s (×3.00)0.016s (×1.93)0.092s (×7.65)0.015s (×1.85)0.014s (×1.77)0.019s (×2.14)0.015s (×1.88)0.005s (×1.12)0.015s (×1.87)0.023s (×2.46)0.003s (×1.00)0.015s (×1.87)0.031s (×3.04)0.020s (×2.25)0.012s (×1.65)0.019s (×2.17)0.010s (×1.50)0.047s (×4.31)0.019s (×2.18)0.078s (×6.60)0.012s (×1.65)0.018s (×2.10)0.160s (×12.75)0.013s (×1.71)0.019s (×2.17)0.013s (×1.72)0.016s (×1.95)0.053s (×4.75)0.009s (×1.42)0.016s (×1.95)0.009s (×1.42)0.010s (×1.48)0.013s (×1.72)0.078s (×6.58)0.012s (×1.65)0.011s (×1.56)0.018s (×2.10)0.021s (×2.32)0.047s (×4.29)0.059s (×5.20)0.020s (×2.25)0.030s (×3.00)0.121s (×9.82)0.050s (×4.48)0.055s (×4.84)0.174s (×13.80)0.013s (×1.72)0.013s (×1.72)0.124s (×10.05)0.232s (×18.13)0.055s (×4.87)0.084s (×7.08)0.073s (×6.19)0.150s (×12.00)0.072s (×6.12)0.078s (×6.60)0.021s (×2.35)0.195s (×15.36)0.020s (×2.25)0.027s (×2.77)0.132s (×10.68)0.082s (×6.86)0.052s (×4.64)0.042s (×3.91)0.052s (×4.66)0.095s (×7.87)0.024s (×2.53)0.020s (×2.25)0.098s (×8.10)0.064s (×5.55)0.021s (×2.32)0.020s (×2.25)0.128s (×10.35)0.026s (×2.66)0.066s (×5.70)0.045s (×4.12)0.015s (×1.87)0.016s (×1.95)0.096s (×7.97)0.015s (×1.87)0.010s (×1.50)0.033s (×3.22)0.047s (×4.25)0.019s (×2.17)0.127s (×10.26)0.020s (×2.25)0.166s (×13.20)0.120s (×9.75)0.081s (×6.82)0.078s (×6.60)0.137s (×11.02)0.024s (×2.55)0.130s (×10.50)0.143s (×11.51)0.169s (×13.43)0.218s (×17.10)0.017s (×2.04)0.085s (×7.12)0.279s (×21.67)0.014s (×1.80)0.285s (×22.13)0.075s (×6.40)0.013s (×1.72)0.099s (×8.14)0.017s (×2.02)0.018s (×2.10)0.284s (×22.05)0.016s (×1.95)0.100s (×8.23)0.016s (×1.95)0.127s (×10.28)0.020s (×2.25)0.016s (×1.95)0.120s (×9.75)0.154s (×12.28)0.020s (×2.25)0.016s (×1.95)0.012s (×1.68)0.016s (×1.95)0.018s (×2.10)0.020s (×2.25)0.018s (×2.10)0.019s (×2.17)0.020s (×2.25)0.019s (×2.17)0.021s (×2.32)0.031s (×3.05)0.260s (×20.25)0.121s (×9.85)0.135s (×10.87)0.245s (×19.12)0.025s (×2.62)0.031s (×3.10)0.936s (×70.94)1.738s (×131.09)0.044s (×4.08)0.096s (×7.97)0.117s (×9.54)0.037s (×3.52)1.946s (×146.69)0.050s (×4.50)1.820s (×137.24)0.239s (×18.67)0.118s (×9.60)0.020s (×2.28)0.058s (×5.09)0.019s (×2.17)0.324s (×25.02)0.105s (×8.61)0.088s (×7.36)0.061s (×5.32)4.242s (×318.87)0.131s (×10.57)0.111s (×9.10)1.641s (×123.80)☠0.297s (×23.01)0.709s (×53.90)0.116s (×9.45)0.412s (×31.62)0.680s (×51.76)0.278s (×21.57)0.388s (×29.85)0.175s (×13.88)0.080s (×6.75)0.314s (×24.30)1.390s (×104.99)0.750s (×56.99)304.830s (×22860.91)257.513s (×19312.46)0.910s (×68.99)☠
Q42. Query 42: SELECT DATE_TRUNC('minute', EventTime) AS M, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-14' AND EventDate <= '2013-07-15' AND IsRefresh = 0 AND DontCountHits = 0 GROUP BY DATE_TRUNC('minute', EventTime) ORDER BY DATE_TRUNC('minute', EventTime) LIMIT 10 OFFSET 1000;0.011s (×1.50)0.017s (×1.91)0.006s (×1.13)0.022s (×2.25)0.024s (×2.39)0.012s (×1.55)0.005s (×1.06)0.020s (×2.11)0.030s (×2.81)0.007s (×1.21)0.015s (×1.76)0.013s (×1.62)0.030s (×2.81)0.011s (×1.48)0.012s (×1.55)0.013s (×1.63)0.017s (×1.91)0.005s (×1.06)0.018s (×1.97)0.006s (×1.13)0.012s (×1.55)0.045s (×3.84)0.004s (×1.00)0.012s (×1.55)0.036s (×3.25)0.014s (×1.69)0.010s (×1.41)0.014s (×1.69)0.011s (×1.48)0.043s (×3.72)0.025s (×2.44)0.064s (×5.21)0.017s (×1.90)0.015s (×1.76)0.060s (×4.93)0.017s (×1.92)0.014s (×1.69)0.010s (×1.41)0.012s (×1.55)0.049s (×4.15)0.009s (×1.36)0.012s (×1.55)0.008s (×1.27)0.009s (×1.37)0.010s (×1.41)0.241s (×17.69)0.012s (×1.55)0.010s (×1.42)0.015s (×1.76)0.014s (×1.69)0.012s (×1.58)0.054s (×4.47)0.020s (×2.11)0.020s (×2.11)0.148s (×11.12)0.060s (×4.95)0.056s (×4.64)0.172s (×12.81)0.012s (×1.55)0.010s (×1.41)0.139s (×10.48)0.284s (×20.68)0.047s (×4.01)0.094s (×7.31)0.049s (×4.17)0.138s (×10.41)0.076s (×6.02)0.084s (×6.61)0.016s (×1.81)0.195s (×14.40)0.013s (×1.62)0.019s (×2.04)0.138s (×10.42)0.063s (×5.14)0.059s (×4.83)0.027s (×2.60)0.059s (×4.86)0.096s (×7.46)0.040s (×3.52)0.014s (×1.69)0.097s (×7.53)0.070s (×5.61)0.012s (×1.55)0.019s (×2.04)0.129s (×9.78)0.026s (×2.52)0.068s (×5.49)0.054s (×4.50)0.017s (×1.90)0.016s (×1.83)0.079s (×6.24)0.015s (×1.76)0.030s (×2.81)0.039s (×3.45)0.043s (×3.74)0.014s (×1.69)0.153s (×11.44)0.022s (×2.25)0.019s (×2.04)0.117s (×8.97)0.089s (×6.97)0.089s (×6.97)0.130s (×9.85)0.027s (×2.60)0.113s (×8.66)0.160s (×11.93)0.172s (×12.84)0.187s (×13.86)0.017s (×1.87)0.065s (×5.28)0.232s (×17.03)0.012s (×1.55)0.206s (×15.17)0.051s (×4.28)0.011s (×1.48)0.083s (×6.56)0.012s (×1.55)0.015s (×1.76)0.205s (×15.13)0.014s (×1.69)0.087s (×6.80)0.015s (×1.76)0.112s (×8.55)0.017s (×1.90)0.014s (×1.69)0.119s (×9.08)0.096s (×7.43)0.110s (×8.44)0.014s (×1.69)0.017s (×1.91)0.013s (×1.62)0.017s (×1.90)0.019s (×2.04)0.018s (×1.97)0.016s (×1.83)0.020s (×2.11)0.017s (×1.90)0.019s (×2.04)0.020s (×2.11)0.220s (×16.18)0.140s (×10.54)0.152s (×11.40)0.250s (×18.29)0.022s (×2.25)0.041s (×3.60)0.864s (×61.50)☠0.055s (×4.60)0.120s (×9.14)0.137s (×10.34)☠1.994s (×141.01)0.070s (×5.59)2.343s (×165.56)0.810s (×57.70)0.150s (×11.28)0.036s (×3.22)0.095s (×7.37)0.032s (×2.96)0.446s (×32.05)0.062s (×5.04)0.266s (×19.41)☠4.215s (×297.28)0.336s (×24.35)0.091s (×7.08)1.540s (×109.05)☠0.141s (×10.60)2.278s (×161.02)0.088s (×6.90)0.707s (×50.46)0.766s (×54.60)0.320s (×23.23)2.202s (×155.64)0.705s (×50.33)1.320s (×93.58)0.602s (×43.06)1.130s (×80.21)1.130s (×80.21)257.541s (×18121.96)257.493s (×18118.58)1.690s (×119.62)☠