| Machine | Relative time (lower is better) | |
|---|---|---|
| AWS c8g.48xlarge (Graviton 4)†AWS c8g.48xlarge (Graviton 4) 192 vCPU, 384 GiB RAM, EBS: | ×1.25 | |
| AMD EPYC 9454P NVMe†AMD EPYC 9454P 48-Core Processor CPU @ 2.7GHz: | ×1.41 | |
| AWS c7g.metal, 500 GB EBS: | ×1.45 | |
| AWS c7a.metal-48xl, 500 GB EBS: | ×1.45 | |
| AWS c7i.metal-48xl, 500 GB EBS: | ×1.54 | |
| AMD EPYC 9454P†AMD EPYC 9454P 48-Core Processor CPU @ 2.7GHz: | ×1.54 | |
| AWS c6i.metal, 500 GB EBS: | ×1.63 | |
| AWS c6a.metal, 500 GB EBS: | ×1.63 | |
| AWS r7g.8xlarge (Graviton 3)†AWS r7g.8xlarge (Graviton 3): | ×1.65 | |
| Dell R660†Dell R660, 1TB DRAM: | ×1.71 | |
| AWS c6a.metal†AWS c6a.metal 192 vCPU (96 cores) 384GiB RAM, 200 GB EBS: | ×1.72 | |
| AMD EPYC 7742†AMD EPYC 7742, 256 cores, 1 TiB Samsung 16x64GB DDR4-3200 ECC, 2 * Samsung PM1725b 12.8TB (RAID 0): | ×1.73 | |
| AWS m7n.16xlarge†AWS m7n.16xlarge 64 vCPU, 512 GiB RAM, EBS: | ×1.80 | |
| AWS c6i.32xlarge†AWS c6i.32xlarge 128vCPU 256GiB 200GB gp2 EBS, Xeon(R) Platinum 8375C CPU @ 2.90GHz, Amazon Linux: | ×1.83 | |
| AWS c5.metal, 500 GB EBS: | ×1.88 | |
| AWS c6g.metal, 500 GB EBS: | ×1.94 | |
| AMD EPYC 7642, 7.2 TB NVM†2x AMD EPYC 7642 - 512 GB RAM - 7.2 TB NVM: | ×1.95 | |
| Huawei TaiShan (2)†Huawei TaiShan 2280 (AArch64) 2280 (2x64 cores, SSD): | ×1.97 | |
| AMD EPYC 3.2 GHz, Intel P4610 NVM SSD†2x AMD EPYC 7F72 3.2 Ghz - Total 96 Cores - IBM Cloud's Bare Metal Service - 512 GB RAM - 1.8 TB Intel P4610 NVM SSD: | ×1.98 | |
| AMD Ryzen Threadripper PRO 3995WX 64-Cores†AMD Ryzen Threadripper PRO 3995WX 64-Cores, 256 GB RAM (8-channel): | ×2.00 | |
| AMD EPYC 3.2 GHz, Micron 5100 MAX 960 GB†2x AMD EPYC 7F72 3.2 Ghz - Total 96 Cores - IBM Cloud's Bare Metal Service - 512 GB RAM - Micron 5100 MAX 960 GB SSD: | ×2.04 | |
| AWS c5a.24xlarge, 500 GB EBS: | ×2.07 | |
| AMD EPYC 7642†2x AMD EPYC 7642 / 512 GB RAM / 12x 1TB SSD (RAID 6): | ×2.13 | |
| AMD EPYC 3.2 GHz, 4x1.8 TB Intel P4610 NVM SSD†2x AMD EPYC 7F72 3.2 Ghz - Total 96 Cores - IBM Cloud's Bare Metal Service - 512 GB RAM - RAID 0 4X 1.8 TB Intel P4610 NVM SSD: | ×2.13 | |
| AWS c5a.24xlarge†AWS c5a.24xlarge 96vCPU 192GiB 200GB gp2 EBS, AMD EPYC 7R32, Amazon Linux: | ×2.17 | |
| AWS r7i.8xlarge†AWS r7i.8xlarge: | ×2.20 | |
| AWS c5a.24xlarge†AWS c5a.24xlarge 96vCPU 192GiB 200GB gp2 EBS, AMD EPYC 7R32, Ubuntu 20.04: | ×2.25 | |
| AWS c7g.16xlarge (Graviton 3)†AWS c7g.16xlarge (Graviton 3) 64 vCPU, 128 GiB RAM, EBS: | ×2.26 | |
| Intel(R) Xeon Silver 4314 with ScaleFlux CSD3000†Intel(R) Xeon(R) Silver 4314 CPU @ 2.40GHz, 376 GB RAM, ScaleFlux CSD300 3.5 TB: | ×2.28 | |
| Hetzner CCX62†Hetzner CCX62 (AMD EPYC, 48 cores, 192 GiB RAM, NVMe): | ×2.30 | |
| EPYC 7702 on ZFS mirror NVME†2x EPYC 7702 on ZFS mirror NVME, AMD EPYC 7702 64-Core Processor: | ×2.33 | |
| AMD EPYC 7502P†AMD EPYC 7502P 32-Core Processor with HT (64 thread) / 512 Gb RAM / mdadm RAID1 SAMSUNG MZQLB3T8HALS-00007 + LVM: | ×2.34 | |
| UpCloud 4CPU AMD EPYC†UpCloud 4CPU, AMD EPYC 7542 32-Core Processor, 64 GiB RAM: | ×2.35 | |
| AWS i3en.24xlarge†AWS i3en.24xlarge 96vCPU 768GiB 8x7500 NVMe SSD: | ×2.47 | |
| AWS m5d.24xlarge†AWS m5d.24xlarge 96vCPU 384GiB 4x900 NVMe SSD: | ×2.48 | |
| AMD EPYC 7402P SSD†AMD EPYC 7402P 2.8 GHz, 128 GB DDR4, SSD RAID1 2×1920 GB SSD (INTEL SSDSC2KB019T7): | ×2.51 | |
| AMD EPYC 7402P HDD†AMD EPYC 7402P 2.8 GHz, 128 GB DDR4, HDD RAID1 2×8000 GB HDD (TOSHIBA MG06ACA800E): | ×2.56 | |
| AWS c6.metal (Graviton 2)†AWS c6.metal (Graviton 2) 64 CPU 128GiB 2x1.7TB local SSD md-RAID-0: | ×2.56 | |
| Xeon Gold 6230†Xeon Gold 6230, 2 sockets, 40 threads: | ×2.57 | |
| AWS c5.metal 300GB†AWS c5.metal 96vCPU 192GiB 300GB SSD: | ×2.57 | |
| AMD EPYC 7702†AMD EPYC 7702, 256 cores, 512 GiB, NVMe SSD: | ×2.70 | |
| Intel Xeon Gold 6338, 64vCPU†Intel Xeon Gold 6338, 64vCPU: | ×2.72 | |
| AWS c5.metal 100GB†AWS c5.metal 96vCPU 192GiB 100GB SSD: | ×2.73 | |
| AWS m6g.16xlarge (Graviton 2)†AWS m6g.16xlarge (Graviton 2) 64 vCPU, 256 GiB RAM, EBS: | ×2.74 | |
| AWS im4gn.16xlarge†AWS im4gn.16xlarge Neoverse-N1 4x7,500 NVMe SSD: | ×2.74 | |
| AMD EPYC 7662†AMD EPYC 7662 64-Core Processor: | ×2.75 | |
| DigitalOcean General 40†DigitalOcean, 40 CPUs, 64 GB RAM, 1 TB SSD, General Purpose, San Francisco, Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz: | ×2.80 | |
| Ampere Altra Q64-22, 8 memory channels, DDR4-2933, NVMe SSD†Ampere Altra Q64-22 (64 cores, Neoverse-N1, 2.2 GHz), 8 memory channels, DDR4-2933, NVMe SSD PCIe Gen4 x4 WD SN850: | ×2.81 | |
| Huawei TaiShan†Huawei TaiShan Kunpeng 920, 96 vCPU, 256GB RAM: | ×2.84 | |
| AMD EPYC 7502P nVME†AMD EPYC 7502P / 128G DDR4 / 2NVME SAMSUNG MZQLB960HAJR: | ×2.84 | |
| AMD Ryzen 9 (2022)† AMD Ryzen 9 5950X 16-Core Processor, 125Gi RAM: | ×2.84 | |
| Intel CLX 6230R†2x Intel CLX 6230R, 384 GB RAM, P4600 1.6 TB ext4: | ×2.86 | |
| AWS c6g.16xlarge (Graviton 2)†AWS c6g.16xlarge (Graviton 2) 64 vCPU, 128 GiB RAM, EBS: | ×2.86 | |
| Yandex Cloud 80vCPU†Yandex Cloud Cascade Lake, 80 vCPU, 160 GB RAM, 4TB SSD: | ×2.87 | |
| DigitalOcean CPU-opt, 32†DigitalOcean, 32 CPUs, 64 GB RAM, 3.52 TB SSD, CPU Intensive, Frankfurt, Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz: | ×2.89 | |
| AWS im4gn.8xlarge†AWS im4gn.8xlarge Neoverse-N1 2x7,500 NVMe SSD: | ×2.91 | |
| DigitalOcean Memory-opt 32†DigitalOcean, 32 CPUs, 256 GB RAM, 4.8 TB SSD, Memory Intensive, Frankfurt, Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz: | ×2.98 | |
| DigitalOcean Storage-opt 32†DigitalOcean, 32 CPUs, 256 GB RAM, 4.56 TB NVM SSD, Storage Intensive, Frankfurt, Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz: | ×3.01 | |
| AMD Ryzen 9 7950X 16-Core Processor†AMD Ryzen 9 7950X 16-Core Processor, 128 GB RAM: | ×3.03 | |
| Yandex Cloud s2.6xlarge 4TB SSD†Yandex Cloud Cascade Lake, 64 vCPU (32 threads), 128 GB RAM, 4 TB SSD: | ×3.10 | |
| Xeon Gold 6140†Xeon Gold 6140, 1 socket, 32 threads, 64 GB RAM, vda: | ×3.17 | |
| Equinix metal n3.xlarge.x84†Equinix metal n3.xlarge.x84 503 Gib local NVMe : | ×3.19 | |
| MacBook Pro M1, 14", 2021†MacBook Pro M1, 14", 10 core, 32GB: | ×3.24 | |
| Yandex Cloud s2.6xlarge†Yandex Cloud Cascade Lake, 64 vCPU (32 threads), 128 GB RAM, 400 GB SSD: | ×3.25 | |
| Scaleway GP1-L†Scaleway GP1-XS (AMD EPYC 7402P, 24 cores, 125 GiB RAM): | ×3.29 | |
| MacBook Pro M1†MacBook Pro M1 Max 16" 2022, 64 GiB RAM, 1 TB SSD: | ×3.33 | |
| GCP c2-standard-30†GCP c2-standard-30, 128 GiB RAM: | ×3.36 | |
| AWS m5ad.24xlarge†AWS m5ad.24xlarge 96vCPU 384GiB 4x900 NVMe SSD, AMD EPYC 7000 series 2.5 GHz: | ×3.38 | |
| DigitalOcean Storage-opt 24†DigitalOcean, 24 CPUs, 192 GB RAM, 3.52 TB NVM SSD, Storage Intensive, Frankfurt, Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz: | ×3.42 | |
| GCP n2-highmem-32†GCP n2-highmem-32, 256 GiB RAM: | ×3.56 | |
| Ampere Altra M128-26, 6 memory channels, DDR4-3200, NVMe SSD†Ampere Altra M128-26 (128 cores, Neoverse-N1, 2.6 GHz), 8 memory channels, DDR4-3200, NVMe SSD PCIe Gen4 x4: | ×3.62 | |
| Dell PowerEdge R640†Dell PowerEdge R640 DX292 2x Xeon SP Gold 16-Core 2.10GHz, 196 GB RAM, 2x SSD 960 GB RAID-1: | ×3.67 | |
| AMD Ryzen 9 (2021)†AMD Ryzen 9 3950X 16-Core Processor, 64 GiB RAM, Samsung evo 970 plus 1TB: | ×3.79 | |
| Yandex Cloud 32vCPU†Yandex Cloud Cascade Lake, 32 vCPU, 128 GB RAM, 300 GB SSD: | ×3.85 | |
| Huawei TaiShan†Huawei TaiShan 2280 v2 (AArch64) 64 core (2-die), one physical HDD: | ×3.93 | |
| Selectel Cloud 'universal disk'†Selectel Cloud, 16 vCPU, 32 GB RAM, 'universal disk': | ×4.04 | |
| AWS im4gn.4xlarge†AWS im4gn.4xlarge Neoverse-N1 1x7,500 NVMe SSD: | ×4.10 | |
| Selectel Cloud 'basic disk'†Selectel Cloud, 16 vCPU, 32 GB RAM, 'basic disk': | ×4.15 | |
| DigitalOcean Storage-opt 16†DigitalOcean 16 CPUs, 128 GB RAM, 2.34 TB NVM SSD, Storage Intensive, Frankfurt, Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz: | ×4.19 | |
| Dell PowerEdge R730xd†Dell PowerEdge R730xd, 2 socket 10 cores E5-2640 v4, HW RAID5 3TBx12 SATA: | ×4.29 | |
| Selectel Cloud 'fast disk'†Selectel Cloud, 16 vCPU, 32 GB RAM, 'fast disk': | ×4.33 | |
| Xeon E5-2650†Xeon E5-2650 v2 @ 2.60GHz, 2 sockets, 16 threads, 4xHDD RAID-10: | ×4.33 | |
| AWS i3.8xlarge†AWS i3.8xlarge 32vCPU 244GiB 4x1900 NVMe SSD: | ×4.34 | |
| AWS m5a.8xlarge†AWS m5a.8xlarge 32 vCPU, 128 GiB RAM, EBS: | ×4.43 | |
| Dell PowerEdge R740xd†Dell PowerEdge R740xd, 256GB, 2 * Intel(R) Xeon(R) Silver 4214R CPU @ 2.40GHz, 48 vCPU: | ×4.43 | |
| Intel Xeon E5-2680†Intel Xeon E5-2680 56 vCPU (28 cores) 68GiB RAM: | ×4.61 | |
| AMD Ryzen 9 (2020)†AMD Ryzen 9 3950X 16-Core Processor, 64 GiB RAM, Intel Optane 900P 280 GB: | ×4.71 | |
| Intel(R) 11th Gen Core i9-11900KF†Intel(R) 11th Gen Core i9-11900KF, 64 GB RAM, 1 TB SSD: | ×4.75 | |
| Dell PowerEdge R6415†Dell PowerEdge R6415 DX180 AMD EPYC™ 7551P 32-Core Naples (Zen), 128 GB RAM, 2x SSD 960 GB RAID-1: | ×4.78 | |
| GCP n2d-16-highmem†GCP compute n2d-16-highmem, AMD EPYC 7B12, 16vCPU, 128 GiB RAM: | ×4.79 | |
| AMD Ryzen 5 5600G with Radeon Graphics†AMD Ryzen 5 4600U 12 vCPU, 29 GiB RAM: | ×4.94 | |
| Azure E32s v3†Azure E32s v3 32 256 GiB 512 GiB: | ×4.99 | |
| Xeon E5-2650†Xeon E5-2650 v2 @ 2.60GHz, 2 sockets, 16 threads, 8xHDD RAID-5: | ×5.06 | |
| Hetzner EX62†Hetzner EX62 (Intel(R) Core(TM) i9-9900K CPU @ 3.60GHz, 128 RAM DDR4 2666, NVMe): | ×5.09 | |
| Hetzner EX62†Hetzner EX62 (Intel(R) Core(TM) i9-9900K CPU @ 3.60GHz, 128 RAM DDR4 2666, NVMe): | ×5.09 | |
| Dell R530†Dell R530, 128GB DDR4, 2x480 GB SATA SSD, Perc H730 RAID-1: | ×5.12 | |
| MacBook Air M1†MacBook Air M1 13" 2020, 8‑core CPU, 16 GiB RAM, 512 GB SSD: | ×5.15 | |
| ThinkPad P15†Lenovo ThinkPad P15, i7-11800H @ 2.30GHz, 16 cores, 32 GiB RAM, NVMe: | ×5.15 | |
| SSDNodes G6†G6 Performance+ 48GB RAM, 720GB NVMe, 12x Intel Silver vCPU, KVM: | ×5.32 | |
| UpCloud 8CPU 32GiB†UpCloud 8CPU 32GiB, AMD EPYC 7542: | ×5.55 | |
| Xeon 2176G†Xeon 2176G, 64GB RAM, 2xSSD 960GB (SAMSUNG MZQLB960HAJR-00007), ZFS RAID-1: | ×5.65 | |
| scaleway GP1-S 8x x86†scaleway GP1-M 16x x86 64bit 64GB ram 600gb NVMe: | ×5.77 | |
| ASUS Z390-Plus Server†ASUS Z390-Plus Server with Intel I5-9600K and DDR4 16GB: | ×5.83 | |
| MacBook Pro M1†MacBook Pro M1 13" 2020, 8‑core CPU, 16 GiB RAM, 512 GB SSD: | ×5.90 | |
| Asus A15†Asus A15 (16 × AMD Ryzen 7 4800H, 16 GiB RAM): | ×6.11 | |
| AWS c6g.2xlarge (Graviton 2)†AWS c6g.2xlarge (Graviton 2) 8 vCPU, 16 GiB RAM, EBS: | ×6.26 | |
| Intel Xeon E5-1650v3†Intel Xeon E5-1650v3 3.5 GHz, 64 GB DDR4, RAID1 2×480 GB SSD (INTEL SSDSC2BB480G4): | ×6.41 | |
| Xeon Silver 4114†Xeon Silver 4114, 256 Gb RAM, SSD RAID1: | ×6.56 | |
| DigitalOcean Storage-opt 8†DigitalOcean 8 CPUs, 64 GB RAM, 1.17 TB NVM SSD, Storage Intensive, Frankfurt, Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz: | ×6.62 | |
| AWS m5a.4xlarge†AWS m5a.4xlarge 16 vCPU, 512 GiB RAM, EBS GP3: | ×6.66 | |
| ThinkPad X1 Carbon R9†ThinkPad X1 Carbon R9, Intel(R) 11th Gen Core i7-1165G7, 32 GiB, 1TB SSD: | ×6.73 | |
| AWS i3en.3xlarge†AWS i3en.3xlarge 12vCPU 96GiB 7TB NVMe SSD: | ×6.75 | |
| scaleway GP1-S 8x x86†scaleway GP1-S 8x x86 64bit 32GB ram 300gb NVMe: | ×6.96 | |
| ProLiant DL380 G7 (2 CPU)†ProLiant DL380 G7, 12Gb RAM, 2x Xeon X5675 3.07GHz, 8x300GB SAS soft RAID5: | ×6.99 | |
| Dell XPS 15†Dell XPS 15, 6 cores, 32 GB RAM, i7-8750H CPU @ 2.20GHz: | ×7.50 | |
| Xeon E5645†Xeon E5645 @ 2.40GHz, 2 sockets, 12 threads, 96 GiB, 14 x 2TB HDD RAID-10: | ×7.87 | |
| DO Xeon E5-2650Lv3†Digital Ocean, Xeon E5-2650L v3 @ 1.80GHz, 16 cores, 64 GB, SSD Disk 1.28 TB: | ×8.04 | |
| AMD EPYC-Rome†AMD EPYC-Rome, 8 cores, 64GB RAM: | ×8.26 | |
| Intel NUC†Intel NUC, 4 cores (Intel i7-6770HQ), 32 GiB RAM, 1 TB NVMe SSD: | ×8.51 | |
| MacBook Pro 2014†MacBook Pro 2014, 2.5 GHz Quad-Core Intel Core i7, 16 GiB RAM: | ×8.61 | |
| Hetzner CCX32†Hetzner CCX32 (AMD EPYC 7003, 8 cores, 32 GiB RAM, NVMe): | ×8.66 | |
| AMD Ryzen 5 4600U†AMD Ryzen 5 4600U 12 vCPU, 16 GiB RAM, SSD: | ×8.71 | |
| Intel(R) Core(TM) i5-4440 CPU @ 3.10GHz†Intel(R) Core(TM) i5-4440 CPU @ 3.10GHz: | ×8.93 | |
| GCP n2d-standard-8†GCP n2d-standard-8, AMD EPYC 7B12, 8vCPU, 64 GiB RAM: | ×9.23 | |
| MacBook Pro 2018†MacBook Pro 2018, 2.7 GHz Quad-Core Intel Core i7, 16 GiB RAM, 1TB SSD: | ×9.27 | |
| Oracle Cloud ARM 4vCPU†Oracle Cloud (free tier), Ampere Altra, 4 vCPU, 24 GiB RAM: | ×9.33 | |
| Steam Deck 512 GB†Steam Deck 512 GB: AMD Custom APU 0405: | ×9.34 | |
| Linode 16GB†Linode Cloud 16GB RAM, 6 AMD EPYC 7601 CPU Cores 2200 MHz, 320GB Storage, CentOS Linux release 7.9.2009 kernel 3.10.0-1160, KVM: | ×9.56 | |
| Intel 80vCPU, QEMU, AArch64†Intel Cascade Lake 80vCPU running AArch64 ClickHouse under qemu-aarch64 version 4.2.1 (userspace emulation): | ×9.68 | |
| AWS a1.4xlarge†AWS a1.4xlarge (Graviton) 16 vCPU, 2.3 GHz, 32 GiB RAM, EBS: | ×9.78 | |
| AWS i3.2xlarge†AWS i3.2xlarge Intel(R) Xeon(R) CPU E5-2686 v4 @ 2.30GHz: | ×9.85 | |
| Lenovo Thinkpad X1 Carbon†Lenovo Thinkpad X1 Carbon 6th Gen i7-8550U CPU @ 1.80GHz 4 threads, 16 GiB: | ×9.89 | |
| MacBook Pro 2020†MacBook Pro 2020, 2.3 GHz Quad-Core Intel Core i7 (10th gen), 32 GiB RAM, 2TB SSD: | ×10.00 | |
| Yandex Cloud 8vCPU†Yandex Cloud Broadwell, 8 vCPU (4 threads), 64 GB RAM, 500 GB SSD: | ×10.00 | |
| Time4vps.eu†Time4vps.eu VPS (KVM) Linux Ubuntu 4 Core (Skylake) 16GB RAM 160GB Disk: | ×10.04 | |
| Scaleway GP1-XS†Scaleway GP1-XS (AMD EPYC 7401P, 4 cores, 16 GiB RAM, NVMe): | ×10.09 | |
| Azure DS3v2 Premium SSD†Azure DS3v2 4vcpu 14GB RAM 1TB Premium SSD: | ×10.65 | |
| Azure DS3v2 Standard SSD†Azure DS3v2 4vcpu 14GB RAM 1TB Standard SSD: | ×10.66 | |
| DigitalOcean General 40†DigitalOcean, 4 CPUs, 8 GiB RAM, x86_64 32-bit, 64-bit : | ×10.72 | |
| AWS Lightsail 4vCPU†AWS Lightsail E5-2686 v4 @ 2.30GHz, 16 GiB RAM: | ×11.02 | |
| POWER9 x_large VM†POWER9 x_large VM (8 vCPU, pSeries, 16GiB RAM): | ×11.26 | |
| ProLiant DL380 G7 (1 CPU)†ProLiant DL380 G7, 128Gb RAM, 1x Xeon X5675 3.07GHz, 8x300GB SAS Soft RAID5: | ×12.43 | |
| Huawei Cloud c6.xlarge.4, 4vCPUs, 16 GiB†Huawei Cloud c6.xlarge.4, Xeon Gold 6266C, 3GHz, 4vCPU, 16GiB RAM, vda1 40GB: | ×13.16 | |
| Hetzner CCX22†Hetzner CCX22 (AMD EPYC 7003, 4 cores, 16 GiB RAM, NVMe): | ×13.37 | |
| t3.xlarge, EBS†t3.xlarge, EBS 1 TiB gp2, 3000 IOPS: | ×15.55 | |
| Yandex Cloud s1.small†Yandex Cloud Broadwell, 4 vCPU (2 threads), 16 GB RAM, 30 GB SSD: | ×15.60 | |
| DigitalOcean CPU-opt 4†DigitalOcean CPU-Optimized 4CPU/8GB RAM Intel(R) Xeon(R) Gold 6140: | ×15.86 | |
| t3.xlarge, EFS†t3.xlarge, EFS 1 TiB gp, prov. at 1000 MiB/s: | ×16.18 | |
| Yandex Cloud s2.small†Yandex Cloud Cascade Lake, 4 vCPU (2 threads), 16 GB RAM, 30 GB SSD: | ×16.69 | |
| Lenovo B580†Lenovo B580 Laptop (i5-3210M): | ×17.90 | |
| Cavium ARM64 CPU (4 Core, 1.5 GHz, NVMe SSD)†Cavium ARM64 CPU (4 Corem 1.5 GHz, NVMe SSD), 16 GiB: | ×40.58 | |
| Raspberry Pi 4†Raspberry Pi 4 Model B 8GB: | ×62.42 | |
| Rock Pi 4, 4GiB, NVMe†Rock Pi 4, 4GiB C, NVMe: | ×78.21 | |
| RISC-V SiFive U74 (RVspace VisionFive 2)†RISC-V SiFive U74 Quad-Core 64-bit RV64GC ISA SoC with 2MB L2 cache @ 1.5GHz, 8GB RAM, Samsung 980 1Tb NVMe SSD: | ×83.37 | |
| Google Pixel 3a†Google Pixel 3a, 8 cores, 4 GB RAM, Qualcomm Snapdragon 670: | ×125.85 | |
| RISC-V SiFive U74 (RVspace VisionFive)†RISC-V SiFive U74 Dual-Core 64-bit RV64GC ISA SoC with 2MB L2 cache @ 1.0GHz, Samsung EVO Plus microSDXC 64 GB: | ×350.42 | |
| Pinebook Pro†Pinebook Pro (AArch64, 4 GiB RAM): | ×893.19 | |
| AWS c8g.48xlarge (Graviton 4) | AMD EPYC 9454P NVMe | AWS c7g.metal, 500 GB EBS | AWS c7a.metal-48xl, 500 GB EBS | AWS c7i.metal-48xl, 500 GB EBS | AMD EPYC 9454P | AWS c6i.metal, 500 GB EBS | AWS c6a.metal, 500 GB EBS | AWS r7g.8xlarge (Graviton 3) | Dell R660 | AWS c6a.metal | AMD EPYC 7742 | AWS m7n.16xlarge | AWS c6i.32xlarge | AWS c5.metal, 500 GB EBS | AWS c6g.metal, 500 GB EBS | AMD EPYC 7642, 7.2 TB NVM | Huawei TaiShan (2) | AMD EPYC 3.2 GHz, Intel P4610 NVM SSD | AMD Ryzen Threadripper PRO 3995WX 64-Cores | AMD EPYC 3.2 GHz, Micron 5100 MAX 960 GB | AWS c5a.24xlarge, 500 GB EBS | AMD EPYC 7642 | AMD EPYC 3.2 GHz, 4x1.8 TB Intel P4610 NVM SSD | AWS c5a.24xlarge | AWS r7i.8xlarge | AWS c5a.24xlarge | AWS c7g.16xlarge (Graviton 3) | Intel(R) Xeon Silver 4314 with ScaleFlux CSD3000 | Hetzner CCX62 | EPYC 7702 on ZFS mirror NVME | AMD EPYC 7502P | UpCloud 4CPU AMD EPYC | AWS i3en.24xlarge | AWS m5d.24xlarge | AMD EPYC 7402P SSD | AMD EPYC 7402P HDD | AWS c6.metal (Graviton 2) | Xeon Gold 6230 | AWS c5.metal 300GB | AMD EPYC 7702 | Intel Xeon Gold 6338, 64vCPU | AWS c5.metal 100GB | AWS m6g.16xlarge (Graviton 2) | AWS im4gn.16xlarge | AMD EPYC 7662 | DigitalOcean General 40 | Ampere Altra Q64-22, 8 memory channels, DDR4-2933, NVMe SSD | Huawei TaiShan | AMD EPYC 7502P nVME | AMD Ryzen 9 (2022) | Intel CLX 6230R | AWS c6g.16xlarge (Graviton 2) | Yandex Cloud 80vCPU | DigitalOcean CPU-opt, 32 | AWS im4gn.8xlarge | DigitalOcean Memory-opt 32 | DigitalOcean Storage-opt 32 | AMD Ryzen 9 7950X 16-Core Processor | Yandex Cloud s2.6xlarge 4TB SSD | Xeon Gold 6140 | Equinix metal n3.xlarge.x84 | MacBook Pro M1, 14", 2021 | Yandex Cloud s2.6xlarge | Scaleway GP1-L | MacBook Pro M1 | GCP c2-standard-30 | AWS m5ad.24xlarge | DigitalOcean Storage-opt 24 | GCP n2-highmem-32 | Ampere Altra M128-26, 6 memory channels, DDR4-3200, NVMe SSD | Dell PowerEdge R640 | AMD Ryzen 9 (2021) | Yandex Cloud 32vCPU | Huawei TaiShan | Selectel Cloud 'universal disk' | AWS im4gn.4xlarge | Selectel Cloud 'basic disk' | DigitalOcean Storage-opt 16 | Dell PowerEdge R730xd | Selectel Cloud 'fast disk' | Xeon E5-2650 | AWS i3.8xlarge | AWS m5a.8xlarge | Dell PowerEdge R740xd | Intel Xeon E5-2680 | AMD Ryzen 9 (2020) | Intel(R) 11th Gen Core i9-11900KF | Dell PowerEdge R6415 | GCP n2d-16-highmem | AMD Ryzen 5 5600G with Radeon Graphics | Azure E32s v3 | Xeon E5-2650 | Hetzner EX62 | Hetzner EX62 | Dell R530 | MacBook Air M1 | ThinkPad P15 | SSDNodes G6 | UpCloud 8CPU 32GiB | Xeon 2176G | scaleway GP1-S 8x x86 | ASUS Z390-Plus Server | MacBook Pro M1 | Asus A15 | AWS c6g.2xlarge (Graviton 2) | Intel Xeon E5-1650v3 | Xeon Silver 4114 | DigitalOcean Storage-opt 8 | AWS m5a.4xlarge | ThinkPad X1 Carbon R9 | AWS i3en.3xlarge | scaleway GP1-S 8x x86 | ProLiant DL380 G7 (2 CPU) | Dell XPS 15 | Xeon E5645 | DO Xeon E5-2650Lv3 | AMD EPYC-Rome | Intel NUC | MacBook Pro 2014 | Hetzner CCX32 | AMD Ryzen 5 4600U | Intel(R) Core(TM) i5-4440 CPU @ 3.10GHz | GCP n2d-standard-8 | MacBook Pro 2018 | Oracle Cloud ARM 4vCPU | Steam Deck 512 GB | Linode 16GB | Intel 80vCPU, QEMU, AArch64 | AWS a1.4xlarge | AWS i3.2xlarge | Lenovo Thinkpad X1 Carbon | MacBook Pro 2020 | Yandex Cloud 8vCPU | Time4vps.eu | Scaleway GP1-XS | Azure DS3v2 Premium SSD | Azure DS3v2 Standard SSD | DigitalOcean General 40 | AWS Lightsail 4vCPU | POWER9 x_large VM | ProLiant DL380 G7 (1 CPU) | Huawei Cloud c6.xlarge.4, 4vCPUs, 16 GiB | Hetzner CCX22 | t3.xlarge, EBS | Yandex Cloud s1.small | DigitalOcean CPU-opt 4 | t3.xlarge, EFS | Yandex Cloud s2.small | Lenovo B580 | Cavium ARM64 CPU (4 Core, 1.5 GHz, NVMe SSD) | Raspberry Pi 4 | Rock Pi 4, 4GiB, NVMe | RISC-V SiFive U74 (RVspace VisionFive 2) | Google Pixel 3a | RISC-V SiFive U74 (RVspace VisionFive) | Pinebook Pro | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Q0. Query 0: SELECT count() FROM {table}; | 0.01s (×1.45) | 0.00s (×1.00) | 0.00s (×1.09) | 0.01s (×1.64) | 0.00s (×1.27) | 0.00s (×1.00) | 0.00s (×1.18) | 0.00s (×1.27) | 0.00s (×1.09) | 0.01s (×1.73) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.18) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.18) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.18) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.18) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.18) | 0.00s (×1.09) | 0.00s (×1.18) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.00) | 0.01s (×1.55) | 0.00s (×1.00) | 0.01s (×1.73) | 0.00s (×1.00) | 0.00s (×1.18) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.18) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.18) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.00) | 0.01s (×2.09) | 0.00s (×1.18) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.18) | 0.00s (×1.18) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.00) | 0.01s (×1.36) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.18) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.27) | 0.01s (×1.36) | 0.00s (×1.09) | 0.00s (×1.18) | 0.00s (×1.27) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.18) | 0.00s (×1.00) | 0.00s (×1.18) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.18) | 0.00s (×1.09) | 0.01s (×1.45) | 0.00s (×1.18) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.18) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.18) | 0.00s (×1.27) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.27) | 0.01s (×1.36) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.18) | 0.00s (×1.27) | 0.01s (×1.36) | 0.01s (×1.36) | 0.01s (×1.55) | 0.03s (×3.55) | 0.02s (×2.64) | 0.01s (×1.55) | |
| Q1. Query 1: SELECT count() FROM {table} WHERE AdvEngineID != 0; | 0.02s (×1.93) | 0.01s (×1.20) | 0.01s (×1.27) | 0.16s (×11.13) | 0.05s (×4.20) | 0.04s (×3.13) | 0.09s (×6.93) | 0.09s (×6.87) | 0.02s (×1.73) | 0.04s (×3.67) | 0.01s (×1.47) | 0.01s (×1.67) | 0.01s (×1.33) | 0.01s (×1.00) | 0.07s (×5.07) | 0.01s (×1.40) | 0.04s (×3.40) | 0.02s (×2.27) | 0.01s (×1.53) | 0.04s (×3.40) | 0.01s (×1.47) | 0.07s (×5.27) | 0.02s (×2.27) | 0.04s (×3.13) | 0.01s (×1.20) | 0.01s (×1.40) | 0.01s (×1.27) | 0.02s (×2.13) | 0.01s (×1.53) | 0.01s (×1.53) | 0.02s (×2.07) | 0.01s (×1.40) | 0.01s (×1.53) | 0.01s (×1.27) | 0.01s (×1.20) | 0.01s (×1.33) | 0.01s (×1.40) | 0.03s (×2.67) | 0.01s (×1.20) | 0.02s (×1.87) | 0.06s (×4.47) | 0.08s (×6.27) | 0.02s (×1.87) | 0.03s (×2.53) | 0.02s (×1.80) | 0.02s (×1.93) | 0.01s (×1.27) | 0.02s (×2.27) | 0.02s (×1.93) | 0.03s (×2.40) | 0.01s (×1.07) | 0.02s (×2.13) | 0.02s (×2.27) | 0.01s (×1.47) | 0.01s (×1.27) | 0.01s (×1.33) | 0.01s (×1.27) | 0.01s (×1.33) | 0.04s (×3.20) | 0.01s (×1.27) | 0.01s (×1.20) | 0.20s (×13.87) | 0.01s (×1.47) | 0.01s (×1.20) | 0.02s (×1.80) | 0.01s (×1.33) | 0.01s (×1.07) | 0.02s (×2.00) | 0.01s (×1.27) | 0.01s (×1.33) | 0.04s (×3.13) | 0.01s (×1.53) | 0.01s (×1.33) | 0.01s (×1.33) | 0.02s (×1.80) | 0.01s (×1.27) | 0.01s (×1.53) | 0.01s (×1.53) | 0.01s (×1.33) | 0.01s (×1.33) | 0.01s (×1.40) | 0.01s (×1.53) | 0.02s (×2.07) | 0.01s (×1.67) | 0.02s (×1.93) | 0.03s (×2.53) | 0.01s (×1.47) | 0.01s (×1.07) | 0.01s (×1.60) | 0.01s (×1.47) | 0.01s (×1.13) | 0.01s (×1.53) | 0.02s (×1.93) | 0.02s (×1.87) | 0.02s (×1.87) | 0.02s (×1.73) | 0.01s (×1.60) | 0.01s (×1.13) | 0.02s (×1.80) | 0.02s (×1.93) | 0.01s (×1.27) | 0.03s (×2.40) | 0.01s (×1.20) | 0.01s (×1.47) | 0.01s (×1.47) | 0.02s (×2.13) | 0.01s (×1.67) | 0.02s (×1.73) | 0.01s (×1.60) | 0.02s (×1.73) | 0.01s (×1.33) | 0.02s (×1.93) | 0.03s (×2.40) | 0.02s (×1.93) | 0.02s (×1.93) | 0.02s (×1.93) | 0.04s (×3.07) | 0.02s (×2.27) | 0.02s (×1.73) | 0.02s (×2.00) | 0.02s (×1.80) | 0.02s (×2.07) | 0.02s (×2.00) | 0.02s (×1.93) | 0.03s (×2.33) | 0.04s (×3.27) | 0.03s (×2.53) | 0.02s (×1.80) | 0.20s (×14.07) | 0.03s (×2.73) | 0.02s (×2.20) | 0.02s (×1.93) | 0.01s (×1.67) | 0.02s (×2.07) | 0.02s (×2.07) | 0.03s (×2.40) | 0.02s (×2.20) | 0.03s (×2.33) | 0.03s (×2.67) | 0.03s (×2.33) | 0.04s (×3.33) | 0.03s (×2.40) | 0.02s (×2.20) | 0.02s (×2.20) | 0.04s (×3.20) | 0.03s (×2.93) | 0.03s (×2.33) | 0.04s (×3.07) | 0.03s (×2.67) | 0.06s (×4.67) | 0.18s (×12.53) | 0.17s (×12.07) | 0.13s (×9.47) | 0.47s (×31.93) | 0.19s (×13.07) | 2.31s (×154.60) | 0.14s (×9.67) | |
| Q2. Query 2: SELECT sum(AdvEngineID), count(), avg(ResolutionWidth) FROM {table}; | 0.02s (×1.78) | 0.01s (×1.17) | 0.01s (×1.17) | 0.05s (×3.50) | 0.05s (×3.17) | 0.04s (×2.61) | 0.03s (×2.33) | 0.03s (×2.11) | 0.01s (×1.22) | 0.05s (×3.39) | 0.02s (×1.50) | 0.03s (×1.94) | 0.01s (×1.39) | 0.01s (×1.00) | 0.02s (×1.83) | 0.01s (×1.28) | 0.05s (×3.39) | 0.03s (×2.06) | 0.02s (×1.56) | 0.05s (×3.17) | 0.02s (×1.44) | 0.02s (×1.44) | 0.03s (×2.17) | 0.03s (×2.44) | 0.01s (×1.22) | 0.02s (×1.56) | 0.01s (×1.28) | 0.03s (×1.94) | 0.02s (×1.44) | 0.02s (×1.72) | 0.02s (×1.78) | 0.02s (×1.50) | 0.02s (×1.67) | 0.01s (×1.28) | 0.01s (×1.33) | 0.01s (×1.39) | 0.02s (×1.44) | 0.03s (×2.00) | 0.01s (×1.33) | 0.03s (×2.06) | 0.06s (×3.72) | 0.05s (×3.11) | 0.03s (×2.11) | 0.03s (×1.94) | 0.02s (×1.72) | 0.03s (×2.00) | 0.02s (×1.50) | 0.03s (×2.44) | 0.03s (×2.00) | 0.02s (×1.50) | 0.01s (×1.33) | 0.03s (×2.28) | 0.02s (×1.72) | 0.02s (×1.50) | 0.02s (×1.56) | 0.02s (×1.44) | 0.02s (×1.61) | 0.02s (×1.61) | 0.02s (×1.61) | 0.02s (×1.50) | 0.02s (×1.56) | 0.04s (×3.00) | 0.04s (×2.56) | 0.02s (×1.44) | 0.03s (×2.22) | 0.02s (×1.78) | 0.02s (×1.56) | 0.03s (×2.00) | 0.02s (×1.78) | 0.02s (×1.67) | 0.04s (×2.67) | 0.02s (×1.83) | 0.02s (×1.83) | 0.03s (×1.94) | 0.02s (×1.72) | 0.02s (×1.61) | 0.03s (×1.94) | 0.02s (×1.83) | 0.03s (×2.06) | 0.03s (×1.94) | 0.02s (×1.89) | 0.03s (×2.22) | 0.03s (×2.06) | 0.03s (×2.39) | 0.04s (×2.61) | 0.05s (×3.39) | 0.03s (×2.00) | 0.02s (×1.67) | 0.03s (×2.00) | 0.03s (×2.28) | 0.02s (×1.67) | 0.03s (×2.17) | 0.03s (×2.17) | 0.03s (×2.22) | 0.03s (×2.22) | 0.03s (×2.39) | 0.03s (×2.39) | 0.02s (×1.89) | 0.03s (×2.44) | 0.04s (×2.78) | 0.03s (×2.28) | 0.05s (×3.11) | 0.03s (×2.17) | 0.03s (×2.33) | 0.04s (×2.61) | 0.04s (×3.06) | 0.03s (×2.44) | 0.04s (×2.83) | 0.05s (×3.22) | 0.04s (×2.78) | 0.04s (×2.94) | 0.07s (×4.22) | 0.06s (×3.78) | 0.04s (×2.94) | 0.06s (×3.61) | 0.06s (×3.67) | 0.08s (×4.89) | 0.07s (×4.28) | 0.06s (×3.72) | 0.06s (×3.67) | 0.06s (×3.72) | 0.05s (×3.33) | 0.06s (×3.61) | 0.05s (×3.50) | 0.05s (×3.17) | 0.07s (×4.33) | 0.10s (×5.89) | 0.06s (×3.89) | 0.14s (×8.56) | 0.05s (×3.50) | 0.08s (×5.22) | 0.08s (×4.89) | 0.04s (×2.83) | 0.07s (×4.22) | 0.08s (×4.83) | 0.07s (×4.28) | 0.08s (×4.83) | 0.08s (×4.83) | 0.09s (×5.61) | 0.08s (×4.83) | 0.08s (×5.17) | 0.07s (×4.28) | 0.10s (×6.33) | 0.09s (×5.67) | 0.12s (×7.28) | 0.12s (×7.22) | 0.09s (×5.33) | 0.13s (×7.78) | 0.13s (×7.56) | 0.17s (×9.83) | 0.43s (×24.22) | 0.53s (×30.22) | 0.31s (×17.56) | 1.01s (×56.72) | 0.36s (×20.50) | 5.49s (×305.61) | 0.26s (×15.22) | |
| Q3. Query 3: SELECT sum(UserID) FROM {table}; | 0.02s (×1.45) | 0.01s (×1.05) | 0.01s (×1.00) | 0.04s (×2.32) | 0.03s (×1.68) | 0.01s (×1.00) | 0.03s (×1.82) | 0.03s (×1.95) | 0.02s (×1.23) | 0.03s (×1.59) | 0.02s (×1.32) | 0.03s (×1.68) | 0.02s (×1.41) | 0.01s (×1.00) | 0.02s (×1.27) | 0.01s (×1.14) | 0.03s (×2.00) | 0.03s (×1.68) | 0.02s (×1.41) | 0.02s (×1.36) | 0.02s (×1.27) | 0.02s (×1.27) | 0.03s (×1.86) | 0.02s (×1.55) | 0.02s (×1.23) | 0.02s (×1.55) | 0.02s (×1.18) | 0.06s (×3.14) | 0.02s (×1.45) | 0.03s (×1.59) | 0.02s (×1.55) | 0.02s (×1.45) | 0.02s (×1.55) | 0.02s (×1.23) | 0.02s (×1.18) | 0.02s (×1.32) | 0.02s (×1.36) | 0.07s (×3.55) | 0.02s (×1.27) | 0.03s (×1.86) | 0.06s (×2.95) | 0.06s (×3.14) | 0.03s (×1.95) | 0.06s (×3.23) | 0.06s (×3.36) | 0.04s (×2.18) | 0.02s (×1.41) | 0.04s (×2.18) | 0.03s (×1.82) | 0.03s (×1.59) | 0.02s (×1.45) | 0.04s (×2.09) | 0.06s (×3.23) | 0.02s (×1.36) | 0.02s (×1.55) | 0.02s (×1.36) | 0.03s (×1.59) | 0.03s (×1.59) | 0.03s (×1.59) | 0.02s (×1.45) | 0.03s (×1.59) | 0.07s (×3.64) | 0.04s (×2.05) | 0.02s (×1.45) | 0.04s (×2.14) | 0.03s (×1.82) | 0.03s (×1.64) | 0.04s (×2.05) | 0.03s (×1.73) | 0.03s (×1.86) | 0.04s (×2.32) | 0.03s (×1.68) | 0.03s (×1.86) | 0.03s (×1.95) | 0.03s (×1.91) | 0.03s (×1.86) | 0.03s (×1.91) | 0.03s (×1.91) | 0.04s (×2.18) | 0.04s (×2.27) | 0.03s (×1.86) | 0.04s (×2.41) | 0.04s (×2.05) | 0.05s (×2.77) | 0.05s (×2.73) | 0.04s (×2.45) | 0.04s (×2.27) | 0.03s (×1.95) | 0.04s (×2.36) | 0.05s (×2.55) | 0.03s (×1.77) | 0.04s (×2.36) | 0.04s (×2.41) | 0.04s (×2.45) | 0.04s (×2.45) | 0.04s (×2.45) | 0.04s (×2.32) | 0.04s (×2.27) | 0.05s (×2.59) | 0.06s (×3.09) | 0.06s (×3.00) | 0.06s (×2.95) | 0.04s (×2.50) | 0.04s (×2.45) | 0.06s (×3.00) | 0.06s (×3.00) | 0.05s (×2.82) | 0.06s (×3.14) | 0.06s (×3.27) | 0.06s (×3.23) | 0.07s (×3.41) | 0.08s (×4.05) | 0.07s (×3.59) | 0.08s (×4.14) | 0.10s (×5.14) | 0.08s (×4.09) | 0.09s (×4.64) | 0.09s (×4.64) | 0.09s (×4.32) | 0.08s (×4.18) | 0.08s (×3.91) | 0.08s (×3.91) | 0.08s (×4.27) | 0.10s (×4.91) | 0.07s (×3.64) | 0.09s (×4.50) | 0.15s (×7.36) | 0.09s (×4.45) | 0.11s (×5.45) | 0.14s (×6.77) | 0.11s (×5.59) | 0.09s (×4.64) | 0.07s (×3.55) | 0.10s (×4.77) | 0.09s (×4.55) | 0.10s (×5.05) | 0.10s (×5.14) | 0.10s (×5.05) | 0.12s (×5.86) | 0.10s (×4.77) | 0.12s (×5.91) | 0.12s (×5.73) | 0.16s (×7.73) | 0.14s (×6.86) | 0.17s (×8.36) | 0.19s (×9.27) | 0.11s (×5.41) | 0.20s (×9.77) | 0.19s (×9.27) | 0.25s (×11.86) | 0.50s (×23.14) | 1.32s (×60.45) | 0.77s (×35.36) | 1.55s (×71.14) | 0.53s (×24.73) | 10.04s (×456.77) | 0.67s (×31.00) | |
| Q4. Query 4: SELECT uniq(UserID) FROM {table}; | 0.11s (×2.05) | 0.05s (×1.00) | 0.07s (×1.32) | 0.12s (×2.23) | 0.10s (×1.77) | 0.06s (×1.08) | 0.08s (×1.55) | 0.09s (×1.62) | 0.06s (×1.10) | 0.12s (×2.08) | 0.10s (×1.82) | 0.10s (×1.90) | 0.07s (×1.30) | 0.07s (×1.33) | 0.07s (×1.28) | 0.07s (×1.42) | 0.10s (×1.92) | 0.10s (×1.77) | 0.07s (×1.33) | 0.09s (×1.63) | 0.07s (×1.32) | 0.07s (×1.27) | 0.10s (×1.92) | 0.07s (×1.25) | 0.06s (×1.22) | 0.07s (×1.27) | 0.06s (×1.23) | 0.07s (×1.38) | 0.08s (×1.43) | 0.06s (×1.15) | 0.12s (×2.08) | 0.08s (×1.47) | 0.07s (×1.32) | 0.08s (×1.43) | 0.07s (×1.40) | 0.07s (×1.38) | 0.08s (×1.43) | 0.07s (×1.42) | 0.07s (×1.30) | 0.09s (×1.72) | 0.20s (×3.48) | 0.13s (×2.33) | 0.09s (×1.70) | 0.08s (×1.47) | 0.07s (×1.42) | 0.18s (×3.13) | 0.09s (×1.60) | 0.14s (×2.55) | 0.13s (×2.33) | 0.08s (×1.50) | 0.06s (×1.23) | 0.11s (×1.98) | 0.08s (×1.50) | 0.07s (×1.30) | 0.08s (×1.55) | 0.07s (×1.32) | 0.09s (×1.67) | 0.09s (×1.68) | 0.06s (×1.23) | 0.08s (×1.53) | 0.08s (×1.57) | 0.16s (×2.85) | 0.07s (×1.40) | 0.08s (×1.53) | 0.10s (×1.83) | 0.07s (×1.33) | 0.07s (×1.35) | 0.12s (×2.12) | 0.10s (×1.85) | 0.09s (×1.63) | 0.82s (×13.78) | 0.09s (×1.62) | 0.07s (×1.27) | 0.10s (×1.75) | 0.10s (×1.78) | 0.09s (×1.60) | 0.08s (×1.57) | 0.09s (×1.62) | 0.11s (×1.95) | 0.09s (×1.67) | 0.09s (×1.62) | 0.10s (×1.87) | 0.10s (×1.83) | 0.12s (×2.17) | 0.15s (×2.63) | 0.11s (×1.95) | 0.07s (×1.40) | 0.07s (×1.40) | 0.12s (×2.12) | 0.10s (×1.88) | 0.07s (×1.35) | 0.12s (×2.22) | 0.10s (×1.92) | 0.11s (×1.98) | 0.11s (×1.98) | 0.12s (×2.13) | 0.10s (×1.85) | 0.10s (×1.83) | 0.12s (×2.12) | 0.12s (×2.15) | 0.12s (×2.18) | 0.12s (×2.22) | 0.10s (×1.87) | 0.10s (×1.80) | 0.11s (×2.00) | 0.13s (×2.25) | 0.14s (×2.43) | 0.13s (×2.38) | 0.18s (×3.12) | 0.15s (×2.62) | 0.13s (×2.35) | 0.19s (×3.38) | 0.15s (×2.68) | 0.13s (×2.28) | 0.28s (×4.88) | 0.20s (×3.53) | 0.23s (×4.05) | 0.22s (×3.77) | 0.19s (×3.33) | 0.21s (×3.63) | 0.18s (×3.20) | 0.17s (×2.92) | 0.19s (×3.37) | 0.18s (×3.22) | 0.17s (×2.97) | 0.23s (×4.00) | 0.23s (×3.97) | 0.19s (×3.27) | 0.26s (×4.48) | 0.20s (×3.50) | 0.23s (×3.92) | 0.21s (×3.60) | 0.17s (×2.92) | 0.25s (×4.28) | 0.20s (×3.58) | 0.21s (×3.62) | 0.26s (×4.50) | 0.26s (×4.48) | 0.21s (×3.65) | 0.22s (×3.80) | 0.26s (×4.47) | 0.18s (×3.25) | 0.33s (×5.62) | 0.29s (×5.02) | 0.38s (×6.42) | 0.46s (×7.87) | 0.31s (×5.38) | 0.36s (×6.18) | 0.43s (×7.28) | 0.56s (×9.52) | 0.80s (×13.42) | 1.49s (×24.98) | 0.88s (×14.82) | 2.08s (×34.75) | 1.14s (×19.17) | 17.84s (×297.58) | 0.79s (×13.33) | |
| Q5. Query 5: SELECT uniq(SearchPhrase) FROM {table}; | 0.11s (×1.29) | 0.08s (×1.00) | 0.09s (×1.09) | 0.18s (×2.09) | 0.12s (×1.44) | 0.09s (×1.04) | 0.11s (×1.30) | 0.12s (×1.34) | 0.10s (×1.18) | 0.15s (×1.76) | 0.11s (×1.32) | 0.13s (×1.47) | 0.12s (×1.42) | 0.12s (×1.42) | 0.11s (×1.30) | 0.12s (×1.34) | 0.12s (×1.44) | 0.11s (×1.28) | 0.10s (×1.22) | 0.12s (×1.37) | 0.11s (×1.27) | 0.12s (×1.35) | 0.13s (×1.48) | 0.10s (×1.19) | 0.12s (×1.38) | 0.14s (×1.63) | 0.12s (×1.44) | 0.10s (×1.16) | 0.14s (×1.63) | 0.13s (×1.47) | 0.15s (×1.72) | 0.13s (×1.45) | 0.15s (×1.76) | 0.12s (×1.35) | 0.12s (×1.38) | 0.14s (×1.56) | 0.14s (×1.59) | 0.12s (×1.44) | 0.12s (×1.41) | 0.14s (×1.62) | 0.18s (×2.08) | 0.20s (×2.24) | 0.13s (×1.53) | 0.15s (×1.71) | 0.14s (×1.60) | 0.23s (×2.55) | 0.16s (×1.86) | 0.18s (×2.01) | 0.17s (×1.89) | 0.12s (×1.44) | 0.13s (×1.48) | 0.17s (×1.95) | 0.14s (×1.59) | 0.12s (×1.42) | 0.17s (×1.90) | 0.17s (×1.96) | 0.17s (×1.99) | 0.18s (×2.05) | 0.12s (×1.34) | 0.16s (×1.82) | 0.19s (×2.12) | 0.22s (×2.43) | 0.20s (×2.24) | 0.14s (×1.57) | 0.17s (×1.89) | 0.20s (×2.20) | 0.20s (×2.23) | 0.17s (×1.89) | 0.21s (×2.35) | 0.21s (×2.35) | 0.84s (×9.14) | 0.15s (×1.73) | 0.14s (×1.58) | 0.21s (×2.34) | 0.17s (×1.88) | 0.22s (×2.49) | 0.29s (×3.24) | 0.22s (×2.52) | 0.27s (×3.02) | 0.22s (×2.46) | 0.23s (×2.54) | 0.22s (×2.48) | 0.24s (×2.68) | 0.25s (×2.82) | 0.23s (×2.58) | 0.23s (×2.55) | 0.15s (×1.75) | 0.21s (×2.35) | 0.20s (×2.24) | 0.31s (×3.46) | 0.25s (×2.76) | 0.26s (×2.94) | 0.27s (×3.00) | 0.28s (×3.13) | 0.28s (×3.13) | 0.24s (×2.68) | 0.28s (×3.15) | 0.28s (×3.10) | 0.32s (×3.58) | 0.35s (×3.87) | 0.30s (×3.33) | 0.27s (×2.96) | 0.31s (×3.46) | 0.30s (×3.30) | 0.26s (×2.92) | 0.50s (×5.46) | 0.43s (×4.69) | 0.35s (×3.83) | 0.50s (×5.45) | 0.39s (×4.25) | 0.40s (×4.39) | 0.48s (×5.25) | 0.40s (×4.42) | 0.31s (×3.43) | 0.50s (×5.44) | 0.41s (×4.53) | 0.54s (×5.92) | 0.60s (×6.56) | 0.54s (×5.90) | 0.58s (×6.37) | 0.98s (×10.61) | 0.47s (×5.17) | 0.60s (×6.56) | 0.70s (×7.60) | 0.56s (×6.10) | 0.74s (×8.09) | 0.56s (×6.18) | 0.60s (×6.58) | 0.64s (×7.01) | 0.44s (×4.80) | 0.70s (×7.63) | 0.51s (×5.62) | 0.55s (×6.02) | 0.77s (×8.37) | 0.60s (×6.59) | 0.69s (×7.56) | 0.73s (×7.91) | 0.72s (×7.83) | 0.71s (×7.72) | 0.63s (×6.84) | 1.04s (×11.27) | 0.59s (×6.41) | 1.16s (×12.53) | 1.36s (×14.70) | 1.23s (×13.28) | 1.25s (×13.56) | 0.95s (×10.28) | 1.24s (×13.41) | 1.22s (×13.26) | 1.51s (×16.30) | 3.75s (×40.43) | 3.23s (×34.84) | 2.25s (×24.29) | 6.39s (×68.78) | 1.96s (×21.15) | 46.81s (×503.49) | 1.95s (×21.04) | |
| Q6. Query 6: SELECT min(EventDate), max(EventDate) FROM {table}; | 0.01s (×1.55) | 0.00s (×1.09) | 0.00s (×1.09) | 0.01s (×1.36) | 0.01s (×2.18) | 0.00s (×1.09) | 0.01s (×1.55) | 0.00s (×1.27) | 0.00s (×1.18) | 0.01s (×1.91) | 0.00s (×1.00) | 0.02s (×2.45) | 0.00s (×1.09) | 0.01s (×1.55) | 0.00s (×1.18) | 0.00s (×1.18) | 0.03s (×3.27) | 0.02s (×3.00) | 0.02s (×2.45) | 0.00s (×1.00) | 0.01s (×2.27) | 0.00s (×1.27) | 0.03s (×3.36) | 0.02s (×2.45) | 0.01s (×1.82) | 0.00s (×1.18) | 0.01s (×1.91) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.09) | 0.02s (×2.91) | 0.01s (×2.18) | 0.00s (×1.27) | 0.01s (×1.73) | 0.01s (×1.73) | 0.01s (×2.00) | 0.01s (×2.00) | 0.01s (×2.00) | 0.01s (×1.64) | 0.02s (×2.73) | 0.04s (×5.00) | 0.00s (×1.18) | 0.02s (×2.91) | 0.02s (×2.36) | 0.01s (×2.09) | 0.03s (×3.45) | 0.01s (×1.91) | 0.01s (×1.45) | 0.00s (×1.09) | 0.01s (×1.82) | 0.00s (×1.00) | 0.03s (×3.45) | 0.00s (×1.09) | 0.01s (×2.18) | 0.01s (×1.91) | 0.02s (×2.45) | 0.01s (×2.00) | 0.01s (×2.00) | 0.00s (×1.00) | 0.01s (×1.82) | 0.01s (×2.00) | 0.00s (×1.27) | 0.00s (×1.00) | 0.01s (×1.82) | 0.01s (×1.36) | 0.00s (×1.00) | 0.01s (×2.09) | 0.02s (×2.45) | 0.01s (×2.09) | 0.01s (×2.27) | 0.04s (×4.18) | 0.02s (×2.36) | 0.01s (×2.18) | 0.01s (×2.18) | 0.01s (×2.18) | 0.02s (×2.36) | 0.03s (×3.45) | 0.02s (×2.45) | 0.02s (×2.36) | 0.01s (×2.09) | 0.02s (×2.55) | 0.02s (×2.73) | 0.01s (×2.09) | 0.02s (×2.73) | 0.00s (×1.27) | 0.00s (×1.09) | 0.01s (×2.18) | 0.00s (×1.00) | 0.01s (×2.18) | 0.02s (×3.09) | 0.00s (×1.00) | 0.02s (×2.36) | 0.03s (×3.18) | 0.00s (×1.00) | 0.00s (×1.00) | 0.02s (×2.64) | 0.03s (×3.36) | 0.01s (×2.27) | 0.02s (×2.73) | 0.03s (×3.18) | 0.02s (×2.36) | 0.01s (×1.36) | 0.02s (×2.55) | 0.03s (×3.27) | 0.02s (×3.09) | 0.05s (×5.64) | 0.03s (×3.36) | 0.03s (×4.00) | 0.03s (×3.27) | 0.00s (×1.09) | 0.00s (×1.00) | 0.00s (×1.09) | 0.00s (×1.27) | 0.03s (×3.45) | 0.03s (×3.82) | 0.03s (×3.55) | 0.05s (×5.36) | 0.00s (×1.09) | 0.03s (×3.91) | 0.00s (×1.09) | 0.05s (×5.55) | 0.00s (×1.18) | 0.03s (×4.00) | 0.03s (×4.00) | 0.04s (×4.27) | 0.09s (×8.82) | 0.00s (×1.18) | 0.04s (×4.09) | 0.09s (×8.73) | 0.04s (×4.64) | 0.05s (×5.64) | 0.04s (×4.64) | 0.03s (×3.27) | 0.04s (×4.73) | 0.03s (×3.55) | 0.05s (×5.45) | 0.04s (×4.36) | 0.04s (×4.36) | 0.00s (×1.09) | 0.04s (×4.27) | 0.00s (×1.27) | 0.04s (×4.82) | 0.05s (×5.55) | 0.09s (×8.82) | 0.07s (×7.73) | 0.06s (×6.55) | 0.05s (×5.18) | 0.08s (×7.82) | 0.06s (×6.18) | 0.10s (×9.64) | 0.27s (×25.73) | 0.23s (×21.91) | 0.21s (×20.18) | 0.01s (×1.55) | 0.33s (×31.09) | 0.02s (×2.45) | 0.20s (×18.82) | |
| Q7. Query 7: SELECT AdvEngineID, count() FROM {table} WHERE AdvEngineID != 0 GROUP BY AdvEngineID ORDER BY count() DESC; | 0.02s (×2.06) | 0.01s (×1.19) | 0.01s (×1.31) | 0.03s (×2.75) | 0.03s (×2.56) | 0.01s (×1.19) | 0.02s (×1.81) | 0.04s (×2.88) | 0.01s (×1.19) | 0.03s (×2.25) | 0.01s (×1.44) | 0.02s (×1.63) | 0.01s (×1.31) | 0.01s (×1.00) | 0.02s (×1.75) | 0.01s (×1.56) | 0.02s (×2.00) | 0.02s (×2.00) | 0.01s (×1.56) | 0.05s (×3.75) | 0.01s (×1.44) | 0.01s (×1.50) | 0.02s (×2.13) | 0.01s (×1.50) | 0.01s (×1.13) | 0.01s (×1.25) | 0.01s (×1.19) | 0.03s (×2.50) | 0.02s (×1.75) | 0.01s (×1.56) | 0.02s (×2.06) | 0.01s (×1.44) | 0.01s (×1.50) | 0.01s (×1.19) | 0.01s (×1.19) | 0.01s (×1.31) | 0.01s (×1.31) | 0.02s (×1.94) | 0.01s (×1.06) | 0.02s (×1.75) | 0.06s (×4.19) | 0.05s (×3.56) | 0.02s (×1.75) | 0.03s (×2.50) | 0.04s (×2.88) | 0.03s (×2.31) | 0.01s (×1.25) | 0.03s (×2.44) | 0.02s (×2.00) | 0.01s (×1.38) | 0.01s (×1.00) | 0.02s (×2.06) | 0.04s (×3.06) | 0.01s (×1.38) | 0.01s (×1.19) | 0.02s (×2.06) | 0.01s (×1.25) | 0.01s (×1.25) | 0.01s (×1.13) | 0.01s (×1.13) | 0.01s (×1.19) | 0.06s (×4.63) | 0.01s (×1.31) | 0.01s (×1.13) | 0.02s (×2.00) | 0.01s (×1.31) | 0.01s (×1.06) | 0.02s (×1.69) | 0.01s (×1.25) | 0.01s (×1.25) | 0.04s (×3.25) | 0.02s (×1.63) | 0.01s (×1.38) | 0.01s (×1.25) | 0.01s (×1.56) | 0.01s (×1.19) | 0.01s (×1.50) | 0.01s (×1.19) | 0.01s (×1.31) | 0.01s (×1.25) | 0.01s (×1.31) | 0.01s (×1.44) | 0.01s (×1.25) | 0.01s (×1.56) | 0.02s (×1.69) | 0.03s (×2.25) | 0.01s (×1.44) | 0.01s (×1.06) | 0.01s (×1.44) | 0.01s (×1.50) | 0.01s (×1.13) | 0.01s (×1.44) | 0.01s (×1.50) | 0.01s (×1.31) | 0.01s (×1.31) | 0.02s (×1.75) | 0.02s (×1.75) | 0.01s (×1.13) | 0.01s (×1.50) | 0.02s (×1.75) | 0.01s (×1.19) | 0.03s (×2.31) | 0.01s (×1.19) | 0.01s (×1.56) | 0.02s (×1.63) | 0.02s (×2.06) | 0.01s (×1.50) | 0.01s (×1.56) | 0.02s (×1.75) | 0.02s (×1.75) | 0.01s (×1.31) | 0.02s (×1.88) | 0.03s (×2.25) | 0.02s (×1.81) | 0.02s (×2.13) | 0.02s (×2.06) | 0.04s (×2.88) | 0.03s (×2.31) | 0.02s (×1.69) | 0.02s (×2.06) | 0.02s (×2.00) | 0.03s (×2.19) | 0.02s (×1.75) | 0.02s (×1.88) | 0.02s (×1.94) | 0.04s (×3.00) | 0.04s (×2.81) | 0.02s (×2.00) | 0.08s (×5.56) | 0.03s (×2.63) | 0.03s (×2.50) | 0.02s (×1.75) | 0.01s (×1.56) | 0.02s (×2.13) | 0.02s (×1.94) | 0.04s (×2.81) | 0.03s (×2.19) | 0.02s (×2.13) | 0.03s (×2.69) | 0.03s (×2.25) | 0.06s (×4.19) | 0.03s (×2.19) | 0.03s (×2.25) | 0.04s (×3.06) | 0.03s (×2.56) | 0.04s (×2.81) | 0.03s (×2.25) | 0.04s (×2.94) | 0.03s (×2.63) | 0.04s (×3.38) | 0.23s (×15.06) | 0.17s (×11.56) | 0.14s (×9.38) | 0.52s (×33.19) | 0.24s (×15.81) | 2.47s (×154.81) | 0.13s (×8.94) | |
| Q8. Query 8: SELECT RegionID, uniq(UserID) AS u FROM {table} GROUP BY RegionID ORDER BY u DESC LIMIT 10; | 0.08s (×1.00) | 0.09s (×1.09) | 0.11s (×1.28) | 0.12s (×1.38) | 0.12s (×1.33) | 0.09s (×1.06) | 0.12s (×1.34) | 0.09s (×1.11) | 0.14s (×1.61) | 0.18s (×2.02) | 0.12s (×1.33) | 0.10s (×1.13) | 0.18s (×2.00) | 0.14s (×1.60) | 0.13s (×1.52) | 0.14s (×1.56) | 0.12s (×1.40) | 0.12s (×1.37) | 0.12s (×1.37) | 0.12s (×1.40) | 0.12s (×1.41) | 0.13s (×1.53) | 0.13s (×1.44) | 0.12s (×1.33) | 0.14s (×1.59) | 0.25s (×2.80) | 0.14s (×1.56) | 0.11s (×1.31) | 0.19s (×2.12) | 0.18s (×2.05) | 0.13s (×1.52) | 0.15s (×1.68) | 0.21s (×2.39) | 0.20s (×2.18) | 0.20s (×2.27) | 0.19s (×2.11) | 0.19s (×2.16) | 0.14s (×1.57) | 0.21s (×2.37) | 0.18s (×1.98) | 0.14s (×1.64) | 0.21s (×2.30) | 0.17s (×1.90) | 0.14s (×1.62) | 0.14s (×1.57) | 0.18s (×2.07) | 0.20s (×2.28) | 0.20s (×2.18) | 0.19s (×2.12) | 0.18s (×2.04) | 0.20s (×2.18) | 0.20s (×2.18) | 0.14s (×1.65) | 0.17s (×1.89) | 0.23s (×2.53) | 0.18s (×2.03) | 0.23s (×2.60) | 0.24s (×2.63) | 0.19s (×2.15) | 0.29s (×3.17) | 0.24s (×2.66) | 0.28s (×3.13) | 0.34s (×3.69) | 0.28s (×3.09) | 0.21s (×2.33) | 0.30s (×3.31) | 0.28s (×3.06) | 0.25s (×2.80) | 0.29s (×3.23) | 0.29s (×3.15) | 0.47s (×5.13) | 0.36s (×3.90) | 0.26s (×2.88) | 0.30s (×3.33) | 0.28s (×3.12) | 0.41s (×4.47) | 0.30s (×3.31) | 0.41s (×4.51) | 0.40s (×4.33) | 0.42s (×4.55) | 0.41s (×4.52) | 0.39s (×4.21) | 0.45s (×4.84) | 0.39s (×4.27) | 0.30s (×3.35) | 0.60s (×6.52) | 0.31s (×3.44) | 0.51s (×5.54) | 0.38s (×4.15) | 0.47s (×5.14) | 0.44s (×4.79) | 0.52s (×5.67) | 0.52s (×5.66) | 0.55s (×5.98) | 0.55s (×5.98) | 0.57s (×6.16) | 0.49s (×5.31) | 0.53s (×5.71) | 0.51s (×5.54) | 0.55s (×5.95) | 0.66s (×7.07) | 0.49s (×5.28) | 0.61s (×6.62) | 0.50s (×5.39) | 0.58s (×6.30) | 0.54s (×5.87) | 0.71s (×7.63) | 0.56s (×6.12) | 0.73s (×7.87) | 0.74s (×7.98) | 0.80s (×8.63) | 0.87s (×9.40) | 0.67s (×7.26) | 0.60s (×6.53) | 0.63s (×6.85) | 0.74s (×8.03) | 0.75s (×8.04) | 1.17s (×12.60) | 1.09s (×11.70) | 1.10s (×11.81) | 1.27s (×13.64) | 0.93s (×9.99) | 1.00s (×10.77) | 1.19s (×12.78) | 0.82s (×8.83) | 0.97s (×10.46) | 1.20s (×12.88) | 1.03s (×11.02) | 0.45s (×4.94) | 0.72s (×7.77) | 1.12s (×12.01) | 1.32s (×14.18) | 0.88s (×9.46) | 1.00s (×10.78) | 1.21s (×12.94) | 1.12s (×12.06) | 1.30s (×13.98) | 1.31s (×14.07) | 1.25s (×13.40) | 1.16s (×12.44) | 0.92s (×9.84) | 1.30s (×13.91) | 1.80s (×19.21) | 1.47s (×15.78) | 1.97s (×21.10) | 1.94s (×20.69) | 1.37s (×14.66) | 1.94s (×20.79) | 2.15s (×22.93) | 2.28s (×24.36) | 2.92s (×31.15) | 5.44s (×57.98) | 3.81s (×40.59) | 7.11s (×75.72) | 2.59s (×27.68) | 49.45s (×526.13) | 3.62s (×38.59) | |
| Q9. Query 9: SELECT RegionID, sum(AdvEngineID), count() AS c, avg(ResolutionWidth), uniq(UserID) FROM {table} GROUP BY RegionID ORDER BY c DESC LIMIT 10; | 0.09s (×1.00) | 0.10s (×1.10) | 0.12s (×1.29) | 0.11s (×1.15) | 0.12s (×1.25) | 0.10s (×1.13) | 0.13s (×1.38) | 0.10s (×1.12) | 0.16s (×1.68) | 0.22s (×2.22) | 0.13s (×1.36) | 0.11s (×1.16) | 0.19s (×1.99) | 0.15s (×1.54) | 0.15s (×1.60) | 0.15s (×1.61) | 0.14s (×1.43) | 0.13s (×1.39) | 0.14s (×1.42) | 0.13s (×1.36) | 0.14s (×1.51) | 0.14s (×1.50) | 0.14s (×1.45) | 0.13s (×1.38) | 0.15s (×1.59) | 0.28s (×2.89) | 0.16s (×1.65) | 0.13s (×1.34) | 0.21s (×2.21) | 0.20s (×2.03) | 0.15s (×1.57) | 0.17s (×1.75) | 0.24s (×2.49) | 0.23s (×2.35) | 0.24s (×2.43) | 0.21s (×2.19) | 0.22s (×2.24) | 0.15s (×1.62) | 0.24s (×2.44) | 0.20s (×2.04) | 0.16s (×1.69) | 0.21s (×2.17) | 0.18s (×1.90) | 0.16s (×1.69) | 0.16s (×1.65) | 0.21s (×2.16) | 0.23s (×2.36) | 0.22s (×2.26) | 0.21s (×2.19) | 0.20s (×2.10) | 0.22s (×2.26) | 0.21s (×2.16) | 0.17s (×1.72) | 0.21s (×2.13) | 0.26s (×2.62) | 0.21s (×2.18) | 0.26s (×2.64) | 0.27s (×2.72) | 0.21s (×2.20) | 0.30s (×3.05) | 0.27s (×2.74) | 0.30s (×3.06) | 0.53s (×5.27) | 0.30s (×3.09) | 0.24s (×2.50) | 0.38s (×3.85) | 0.31s (×3.16) | 0.61s (×6.08) | 0.33s (×3.31) | 0.33s (×3.28) | 0.51s (×5.11) | 0.40s (×3.99) | 0.30s (×3.05) | 0.35s (×3.51) | 0.33s (×3.29) | 0.45s (×4.55) | 0.36s (×3.63) | 0.46s (×4.60) | 0.44s (×4.43) | 0.45s (×4.51) | 0.47s (×4.67) | 0.43s (×4.27) | 0.51s (×5.10) | 0.50s (×4.96) | 0.34s (×3.40) | 0.37s (×3.73) | 0.39s (×3.91) | 0.59s (×5.88) | 0.41s (×4.13) | 0.54s (×5.41) | 0.53s (×5.28) | 0.61s (×6.06) | 0.55s (×5.46) | 0.63s (×6.26) | 0.63s (×6.26) | 0.63s (×6.28) | 0.61s (×6.13) | 0.55s (×5.53) | 0.59s (×5.89) | 0.60s (×6.00) | 0.74s (×7.32) | 0.55s (×5.48) | 0.70s (×6.96) | 0.63s (×6.30) | 0.68s (×6.75) | 0.66s (×6.52) | 0.81s (×8.05) | 0.64s (×6.32) | 0.83s (×8.24) | 0.87s (×8.63) | 1.19s (×11.75) | 1.02s (×10.13) | 0.80s (×7.92) | 0.71s (×7.02) | 0.79s (×7.88) | 0.90s (×8.90) | 0.86s (×8.55) | 1.27s (×12.55) | 1.25s (×12.31) | 1.25s (×12.35) | 1.00s (×9.86) | 1.04s (×10.30) | 1.14s (×11.26) | 1.22s (×12.09) | 0.94s (×9.29) | 1.14s (×11.26) | 1.33s (×13.19) | 1.15s (×11.34) | 0.54s (×5.39) | 0.84s (×8.38) | 1.23s (×12.17) | 1.48s (×14.64) | 1.02s (×10.12) | 1.21s (×11.95) | 1.42s (×13.97) | 1.28s (×12.64) | 1.53s (×15.14) | 1.56s (×15.41) | 1.46s (×14.37) | 1.35s (×13.37) | 1.18s (×11.67) | 1.55s (×15.25) | 2.01s (×19.81) | 1.80s (×17.79) | 2.18s (×21.50) | 2.17s (×21.37) | 1.57s (×15.47) | 2.17s (×21.35) | 2.46s (×24.21) | 2.95s (×29.03) | 3.92s (×38.57) | 6.88s (×67.56) | 4.99s (×48.97) | 9.12s (×89.48) | 3.11s (×30.62) | 68.42s (×670.93) | 4.23s (×41.61) | |
| Q10. Query 10: SELECT MobilePhoneModel, uniq(UserID) AS u FROM {table} WHERE MobilePhoneModel != '' GROUP BY MobilePhoneModel ORDER BY u DESC LIMIT 10; | 0.05s (×1.00) | 0.05s (×1.00) | 0.06s (×1.03) | 0.06s (×1.14) | 0.06s (×1.08) | 0.06s (×1.02) | 0.06s (×1.13) | 0.06s (×1.06) | 0.07s (×1.23) | 0.10s (×1.67) | 0.10s (×1.75) | 0.07s (×1.23) | 0.07s (×1.20) | 0.07s (×1.28) | 0.07s (×1.23) | 0.07s (×1.20) | 0.08s (×1.39) | 0.08s (×1.38) | 0.07s (×1.33) | 0.08s (×1.45) | 0.07s (×1.31) | 0.07s (×1.20) | 0.09s (×1.52) | 0.07s (×1.27) | 0.08s (×1.36) | 0.08s (×1.41) | 0.08s (×1.45) | 0.07s (×1.25) | 0.08s (×1.42) | 0.08s (×1.47) | 0.08s (×1.45) | 0.08s (×1.44) | 0.08s (×1.36) | 0.09s (×1.53) | 0.11s (×1.91) | 0.10s (×1.67) | 0.10s (×1.70) | 0.09s (×1.56) | 0.09s (×1.52) | 0.09s (×1.58) | 0.12s (×1.95) | 0.15s (×2.47) | 0.09s (×1.61) | 0.10s (×1.75) | 0.09s (×1.55) | 0.14s (×2.30) | 0.10s (×1.75) | 0.15s (×2.52) | 0.11s (×1.81) | 0.08s (×1.36) | 0.09s (×1.55) | 0.10s (×1.72) | 0.10s (×1.64) | 0.08s (×1.44) | 0.10s (×1.78) | 0.12s (×2.02) | 0.11s (×1.89) | 0.11s (×1.92) | 0.08s (×1.38) | 0.11s (×1.81) | 0.12s (×2.03) | 0.28s (×4.53) | 0.13s (×2.14) | 0.10s (×1.80) | 0.12s (×2.03) | 0.13s (×2.25) | 0.11s (×1.86) | 0.14s (×2.33) | 0.12s (×2.09) | 0.12s (×1.98) | 0.17s (×2.89) | 0.14s (×2.27) | 0.09s (×1.55) | 0.14s (×2.27) | 0.14s (×2.27) | 0.15s (×2.50) | 0.18s (×2.98) | 0.15s (×2.53) | 0.15s (×2.55) | 0.14s (×2.31) | 0.15s (×2.52) | 0.15s (×2.44) | 0.14s (×2.34) | 0.14s (×2.39) | 0.16s (×2.63) | 0.15s (×2.47) | 0.16s (×2.69) | 0.13s (×2.19) | 0.19s (×3.14) | 0.18s (×2.94) | 0.14s (×2.27) | 0.17s (×2.80) | 0.15s (×2.58) | 0.15s (×2.47) | 0.15s (×2.47) | 0.16s (×2.63) | 0.20s (×3.23) | 0.16s (×2.69) | 0.17s (×2.88) | 0.23s (×3.77) | 0.18s (×2.98) | 0.17s (×2.89) | 0.20s (×3.20) | 0.21s (×3.39) | 0.20s (×3.23) | 0.32s (×5.09) | 0.28s (×4.61) | 0.23s (×3.67) | 0.26s (×4.23) | 0.22s (×3.56) | 0.27s (×4.39) | 0.29s (×4.75) | 0.23s (×3.81) | 0.18s (×2.98) | 0.33s (×5.34) | 0.25s (×4.05) | 0.31s (×5.02) | 0.28s (×4.59) | 0.30s (×4.78) | 0.30s (×4.91) | 0.49s (×7.84) | 0.35s (×5.70) | 0.35s (×5.64) | 0.31s (×5.06) | 0.44s (×7.09) | 0.51s (×8.11) | 0.30s (×4.81) | 0.41s (×6.48) | 0.46s (×7.34) | 0.38s (×6.05) | 0.39s (×6.28) | 0.33s (×5.27) | 0.36s (×5.75) | 0.48s (×7.70) | 0.32s (×5.22) | 0.38s (×6.03) | 0.39s (×6.31) | 0.40s (×6.33) | 0.42s (×6.75) | 0.38s (×6.02) | 0.43s (×6.88) | 0.34s (×5.42) | 0.58s (×9.20) | 0.93s (×14.61) | 0.67s (×10.61) | 0.65s (×10.36) | 0.48s (×7.63) | 0.71s (×11.27) | 0.68s (×10.77) | 0.75s (×11.86) | 2.23s (×34.94) | 3.00s (×46.95) | 2.19s (×34.42) | 3.85s (×60.34) | 2.01s (×31.59) | 32.05s (×500.92) | 1.78s (×28.05) | |
| Q11. Query 11: SELECT MobilePhone, MobilePhoneModel, uniq(UserID) AS u FROM {table} WHERE MobilePhoneModel != '' GROUP BY MobilePhone, MobilePhoneModel ORDER BY u DESC LIMIT 10; | 0.06s (×1.00) | 0.06s (×1.01) | 0.06s (×1.01) | 0.08s (×1.19) | 0.07s (×1.07) | 0.06s (×1.03) | 0.07s (×1.07) | 0.07s (×1.06) | 0.08s (×1.25) | 0.11s (×1.72) | 0.09s (×1.43) | 0.07s (×1.08) | 0.08s (×1.25) | 0.07s (×1.07) | 0.08s (×1.19) | 0.08s (×1.22) | 0.08s (×1.24) | 0.10s (×1.49) | 0.08s (×1.21) | 0.08s (×1.26) | 0.08s (×1.19) | 0.08s (×1.31) | 0.10s (×1.49) | 0.07s (×1.18) | 0.07s (×1.15) | 0.10s (×1.47) | 0.09s (×1.33) | 0.07s (×1.14) | 0.09s (×1.33) | 0.10s (×1.49) | 0.09s (×1.44) | 0.08s (×1.31) | 0.09s (×1.39) | 0.09s (×1.44) | 0.09s (×1.40) | 0.10s (×1.50) | 0.10s (×1.56) | 0.10s (×1.53) | 0.09s (×1.42) | 0.10s (×1.50) | 0.11s (×1.69) | 0.14s (×2.10) | 0.10s (×1.53) | 0.10s (×1.54) | 0.09s (×1.43) | 0.14s (×2.14) | 0.11s (×1.61) | 0.15s (×2.24) | 0.11s (×1.65) | 0.08s (×1.25) | 0.11s (×1.68) | 0.11s (×1.65) | 0.10s (×1.47) | 0.09s (×1.35) | 0.11s (×1.68) | 0.12s (×1.83) | 0.12s (×1.76) | 0.12s (×1.81) | 0.09s (×1.38) | 0.12s (×1.75) | 0.13s (×1.93) | 0.15s (×2.19) | 0.15s (×2.18) | 0.11s (×1.69) | 0.14s (×2.04) | 0.16s (×2.36) | 0.13s (×1.94) | 0.11s (×1.72) | 0.14s (×2.06) | 0.14s (×2.07) | 0.19s (×2.75) | 0.14s (×2.13) | 0.11s (×1.67) | 0.15s (×2.29) | 0.14s (×2.11) | 0.17s (×2.53) | 0.21s (×3.06) | 0.18s (×2.60) | 0.18s (×2.69) | 0.16s (×2.38) | 0.17s (×2.53) | 0.18s (×2.67) | 0.16s (×2.42) | 0.17s (×2.47) | 0.18s (×2.69) | 0.15s (×2.28) | 0.17s (×2.53) | 0.15s (×2.21) | 0.19s (×2.81) | 0.20s (×2.99) | 0.15s (×2.21) | 0.19s (×2.75) | 0.17s (×2.49) | 0.18s (×2.67) | 0.18s (×2.67) | 0.18s (×2.61) | 0.23s (×3.40) | 0.19s (×2.79) | 0.21s (×3.00) | 0.27s (×3.92) | 0.24s (×3.43) | 0.21s (×3.03) | 0.23s (×3.35) | 0.24s (×3.50) | 0.23s (×3.40) | 0.36s (×5.14) | 0.33s (×4.74) | 0.25s (×3.56) | 0.32s (×4.53) | 0.26s (×3.79) | 0.33s (×4.68) | 0.34s (×4.92) | 0.30s (×4.25) | 0.22s (×3.24) | 0.32s (×4.56) | 0.34s (×4.90) | 0.36s (×5.08) | 0.34s (×4.89) | 0.35s (×5.03) | 0.49s (×6.93) | 0.58s (×8.22) | 0.41s (×5.76) | 0.41s (×5.81) | 0.38s (×5.36) | 0.56s (×7.85) | 0.61s (×8.58) | 0.37s (×5.32) | 0.47s (×6.60) | 0.52s (×7.42) | 0.42s (×5.93) | 0.48s (×6.75) | 0.40s (×5.65) | 0.42s (×5.92) | 0.54s (×7.60) | 0.41s (×5.82) | 0.47s (×6.63) | 0.47s (×6.65) | 0.47s (×6.63) | 0.54s (×7.68) | 0.45s (×6.33) | 0.55s (×7.81) | 0.39s (×5.49) | 0.68s (×9.54) | 1.05s (×14.69) | 0.77s (×10.85) | 0.78s (×10.92) | 0.57s (×8.00) | 0.80s (×11.28) | 0.82s (×11.47) | 0.90s (×12.69) | 2.64s (×36.86) | 3.24s (×45.13) | 2.57s (×35.81) | 4.87s (×67.79) | 1.68s (×23.46) | 34.79s (×483.36) | 2.04s (×28.50) | |
| Q12. Query 12: SELECT SearchPhrase, count() AS c FROM {table} WHERE SearchPhrase != '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10; | 0.08s (×1.00) | 0.12s (×1.37) | 0.12s (×1.38) | 0.10s (×1.19) | 0.13s (×1.47) | 0.12s (×1.38) | 0.14s (×1.58) | 0.14s (×1.65) | 0.16s (×1.84) | 0.16s (×1.86) | 0.18s (×2.02) | 0.14s (×1.57) | 0.22s (×2.46) | 0.17s (×1.98) | 0.17s (×1.90) | 0.19s (×2.12) | 0.15s (×1.70) | 0.14s (×1.58) | 0.17s (×1.92) | 0.18s (×2.01) | 0.17s (×1.95) | 0.22s (×2.49) | 0.16s (×1.86) | 0.19s (×2.17) | 0.18s (×2.10) | 0.28s (×3.14) | 0.20s (×2.23) | 0.14s (×1.66) | 0.23s (×2.54) | 0.23s (×2.57) | 0.22s (×2.48) | 0.22s (×2.48) | 0.36s (×4.01) | 0.21s (×2.32) | 0.21s (×2.38) | 0.25s (×2.76) | 0.25s (×2.77) | 0.20s (×2.29) | 0.25s (×2.81) | 0.25s (×2.83) | 0.25s (×2.78) | 0.20s (×2.29) | 0.24s (×2.69) | 0.22s (×2.43) | 0.21s (×2.32) | 0.24s (×2.68) | 0.31s (×3.43) | 0.26s (×2.86) | 0.26s (×2.89) | 0.22s (×2.45) | 0.44s (×4.88) | 0.26s (×2.85) | 0.22s (×2.52) | 0.24s (×2.74) | 0.31s (×3.44) | 0.26s (×2.90) | 0.30s (×3.37) | 0.32s (×3.49) | 0.43s (×4.76) | 0.31s (×3.47) | 0.34s (×3.78) | 0.26s (×2.94) | 0.49s (×5.38) | 0.31s (×3.48) | 0.40s (×4.38) | 0.43s (×4.75) | 0.40s (×4.42) | 0.29s (×3.18) | 0.40s (×4.42) | 0.37s (×4.13) | 0.33s (×3.67) | 0.41s (×4.57) | 0.64s (×7.02) | 0.52s (×5.66) | 0.43s (×4.77) | 0.46s (×5.10) | 0.46s (×5.04) | 0.50s (×5.52) | 0.54s (×5.89) | 0.58s (×6.39) | 0.48s (×5.28) | 0.53s (×5.84) | 0.53s (×5.80) | 0.57s (×6.20) | 0.48s (×5.26) | 0.65s (×7.09) | 0.80s (×8.73) | 0.92s (×9.95) | 0.64s (×6.96) | 0.61s (×6.66) | 0.97s (×10.59) | 0.66s (×7.18) | 0.61s (×6.65) | 0.88s (×9.59) | 0.88s (×9.59) | 0.66s (×7.22) | 0.76s (×8.29) | 0.85s (×9.29) | 0.70s (×7.65) | 0.76s (×8.32) | 0.93s (×10.14) | 0.87s (×9.44) | 1.06s (×11.56) | 0.77s (×8.35) | 0.96s (×10.45) | 0.85s (×9.29) | 0.98s (×10.68) | 0.75s (×8.16) | 1.00s (×10.86) | 1.06s (×11.47) | 1.16s (×12.59) | 1.07s (×11.67) | 1.00s (×10.91) | 0.89s (×9.69) | 1.08s (×11.69) | 1.16s (×12.54) | 0.99s (×10.71) | 1.56s (×16.88) | 1.44s (×15.58) | 1.42s (×15.35) | 1.31s (×14.19) | 1.63s (×17.63) | 1.57s (×16.99) | 1.70s (×18.38) | 1.64s (×17.75) | 1.50s (×16.24) | 1.69s (×18.28) | 1.59s (×17.18) | 0.91s (×9.85) | 1.37s (×14.87) | 1.63s (×17.67) | 1.74s (×18.78) | 1.35s (×14.61) | 1.64s (×17.69) | 1.66s (×17.97) | 1.66s (×18.00) | 1.65s (×17.85) | 1.67s (×18.11) | 1.77s (×19.17) | 1.75s (×18.88) | 1.50s (×16.24) | 2.63s (×28.39) | 2.46s (×26.53) | 2.45s (×26.42) | 2.97s (×32.06) | 2.85s (×30.74) | 1.92s (×20.80) | 3.03s (×32.65) | 3.29s (×35.53) | 3.19s (×34.41) | 6.26s (×67.44) | 11.14s (×119.90) | 8.31s (×89.42) | 15.15s (×163.05) | ☠ | 67.63s (×727.27) | 6.89s (×74.19) | |
| Q13. Query 13: SELECT SearchPhrase, uniq(UserID) AS u FROM {table} WHERE SearchPhrase != '' GROUP BY SearchPhrase ORDER BY u DESC LIMIT 10; | 0.10s (×1.00) | 0.16s (×1.49) | 0.16s (×1.49) | 0.12s (×1.12) | 0.15s (×1.40) | 0.16s (×1.54) | 0.17s (×1.64) | 0.16s (×1.53) | 0.22s (×2.05) | 0.19s (×1.80) | 0.22s (×2.05) | 0.17s (×1.62) | 0.28s (×2.58) | 0.21s (×1.99) | 0.23s (×2.16) | 0.24s (×2.24) | 0.18s (×1.70) | 0.16s (×1.55) | 0.21s (×1.96) | 0.22s (×2.05) | 0.22s (×2.08) | 0.54s (×4.93) | 0.19s (×1.79) | 0.24s (×2.23) | 0.24s (×2.27) | 0.36s (×3.34) | 0.26s (×2.38) | 0.19s (×1.76) | 0.28s (×2.59) | 0.30s (×2.79) | 0.26s (×2.44) | 0.28s (×2.60) | 0.42s (×3.88) | 0.27s (×2.47) | 0.26s (×2.40) | 0.32s (×2.91) | 0.32s (×2.96) | 0.25s (×2.35) | 0.32s (×2.97) | 0.31s (×2.86) | 0.33s (×3.01) | 0.22s (×2.05) | 0.30s (×2.73) | 0.27s (×2.46) | 0.25s (×2.35) | 0.31s (×2.85) | 0.39s (×3.59) | 0.35s (×3.19) | 0.32s (×2.98) | 0.27s (×2.46) | 0.55s (×5.04) | 0.31s (×2.87) | 0.28s (×2.56) | 0.35s (×3.23) | 0.39s (×3.59) | 0.33s (×3.03) | 0.39s (×3.59) | 0.40s (×3.67) | 0.56s (×5.06) | 0.41s (×3.78) | 0.45s (×4.06) | 0.31s (×2.88) | 0.64s (×5.78) | 0.37s (×3.43) | 0.51s (×4.64) | 0.55s (×5.03) | 0.50s (×4.54) | 0.35s (×3.21) | 0.50s (×4.58) | 0.49s (×4.44) | 0.46s (×4.16) | 0.52s (×4.76) | 0.81s (×7.31) | 0.66s (×5.97) | 0.57s (×5.14) | 0.63s (×5.74) | 0.58s (×5.27) | 0.70s (×6.35) | 0.68s (×6.18) | 0.75s (×6.76) | 0.71s (×6.46) | 0.68s (×6.19) | 0.67s (×6.03) | 0.76s (×6.87) | 0.60s (×5.41) | 0.77s (×6.98) | 1.03s (×9.26) | 1.20s (×10.79) | 0.93s (×8.41) | 0.80s (×7.27) | 1.26s (×11.32) | 0.88s (×7.96) | 0.86s (×7.79) | 1.12s (×10.11) | 1.12s (×10.11) | 0.81s (×7.31) | 0.97s (×8.74) | 1.16s (×10.44) | 0.91s (×8.19) | 0.99s (×8.94) | 1.19s (×10.67) | 1.11s (×10.03) | 1.37s (×12.29) | 1.05s (×9.48) | 1.26s (×11.38) | 1.10s (×9.95) | 1.32s (×11.85) | 1.02s (×9.17) | 1.35s (×12.13) | 1.42s (×12.77) | 1.66s (×14.90) | 1.59s (×14.33) | 1.40s (×12.59) | 1.11s (×10.04) | 1.36s (×12.28) | 1.38s (×12.45) | 1.24s (×11.12) | 2.11s (×18.91) | 1.98s (×17.73) | 1.95s (×17.53) | 1.72s (×15.45) | 2.19s (×19.62) | 2.03s (×18.22) | 1.94s (×17.41) | 2.23s (×19.96) | 1.93s (×17.32) | 2.28s (×20.46) | 2.14s (×19.20) | 0.99s (×8.95) | 1.83s (×16.45) | 2.18s (×19.56) | 2.40s (×21.55) | 1.79s (×16.04) | 2.17s (×19.47) | 2.49s (×22.29) | 2.26s (×20.25) | 2.18s (×19.53) | 2.13s (×19.07) | 2.40s (×21.54) | 2.31s (×20.76) | 1.98s (×17.72) | 3.17s (×28.37) | 3.33s (×29.81) | 3.18s (×28.45) | 4.22s (×37.75) | 3.80s (×33.98) | 2.53s (×22.69) | 4.07s (×36.43) | 4.54s (×40.63) | 4.31s (×38.57) | 7.67s (×68.56) | 14.70s (×131.32) | 11.29s (×100.89) | 19.55s (×174.64) | ☠ | 76.60s (×684.05) | 9.31s (×83.22) | |
| Q14. Query 14: SELECT SearchEngineID, SearchPhrase, count() AS c FROM {table} WHERE SearchPhrase != '' GROUP BY SearchEngineID, SearchPhrase ORDER BY c DESC LIMIT 10; | 0.08s (×1.00) | 0.14s (×1.64) | 0.14s (×1.63) | 0.10s (×1.15) | 0.13s (×1.47) | 0.14s (×1.66) | 0.16s (×1.80) | 0.15s (×1.76) | 0.21s (×2.45) | 0.18s (×2.07) | 0.20s (×2.24) | 0.16s (×1.80) | 0.26s (×2.88) | 0.21s (×2.35) | 0.19s (×2.18) | 0.20s (×2.27) | 0.15s (×1.73) | 0.14s (×1.65) | 0.22s (×2.48) | 0.18s (×2.03) | 0.22s (×2.51) | 0.22s (×2.46) | 0.17s (×1.91) | 0.24s (×2.67) | 0.23s (×2.57) | 0.36s (×4.08) | 0.25s (×2.79) | 0.17s (×2.01) | 0.25s (×2.83) | 0.28s (×3.11) | 0.24s (×2.71) | 0.26s (×2.88) | 0.40s (×4.42) | 0.28s (×3.15) | 0.29s (×3.22) | 0.29s (×3.27) | 0.30s (×3.34) | 0.21s (×2.41) | 0.33s (×3.66) | 0.28s (×3.18) | 0.26s (×2.90) | 0.25s (×2.84) | 0.28s (×3.15) | 0.22s (×2.54) | 0.24s (×2.71) | 0.29s (×3.24) | 0.35s (×3.90) | 0.29s (×3.22) | 0.27s (×3.01) | 0.25s (×2.87) | 0.48s (×5.35) | 0.30s (×3.38) | 0.24s (×2.67) | 0.32s (×3.58) | 0.36s (×4.03) | 0.31s (×3.46) | 0.37s (×4.13) | 0.37s (×4.13) | 0.48s (×5.38) | 0.40s (×4.49) | 0.40s (×4.49) | 0.27s (×3.04) | 0.51s (×5.70) | 0.39s (×4.30) | 0.42s (×4.68) | 0.50s (×5.57) | 0.51s (×5.67) | 0.33s (×3.68) | 0.45s (×5.01) | 0.57s (×6.30) | 0.31s (×3.49) | 0.47s (×5.24) | 0.70s (×7.76) | 0.64s (×7.09) | 0.48s (×5.32) | 0.60s (×6.59) | 0.56s (×6.21) | 0.70s (×7.77) | 0.64s (×7.01) | 0.63s (×6.92) | 0.80s (×8.76) | 0.65s (×7.18) | 0.61s (×6.77) | 0.74s (×8.11) | 0.51s (×5.61) | 0.70s (×7.72) | 0.83s (×9.15) | 1.04s (×11.42) | 0.74s (×8.13) | 0.77s (×8.47) | 0.99s (×10.84) | 0.90s (×9.84) | 0.78s (×8.57) | 0.87s (×9.61) | 0.87s (×9.61) | 0.81s (×8.91) | 0.86s (×9.47) | 1.04s (×11.47) | 0.89s (×9.74) | 0.99s (×10.91) | 0.96s (×10.58) | 1.05s (×11.50) | 1.08s (×11.85) | 1.01s (×11.10) | 1.12s (×12.33) | 1.01s (×11.13) | 1.13s (×12.43) | 0.99s (×10.87) | 1.22s (×13.34) | 1.19s (×13.02) | 1.50s (×16.42) | 1.31s (×14.35) | 1.32s (×14.42) | 1.09s (×11.93) | 1.08s (×11.84) | 1.35s (×14.74) | 1.10s (×12.11) | 2.22s (×24.21) | 1.79s (×19.62) | 1.72s (×18.78) | 1.71s (×18.70) | 1.70s (×18.62) | 1.80s (×19.72) | 1.90s (×20.71) | 1.90s (×20.71) | 1.81s (×19.83) | 2.08s (×22.72) | 1.77s (×19.33) | 0.96s (×10.60) | 1.46s (×15.96) | 1.93s (×21.03) | 2.06s (×22.54) | 1.62s (×17.71) | 1.97s (×21.55) | 2.16s (×23.54) | 2.07s (×22.57) | 1.85s (×20.18) | 1.89s (×20.61) | 2.15s (×23.42) | 2.04s (×22.30) | 1.85s (×20.18) | 2.52s (×27.55) | 3.29s (×35.86) | 3.43s (×37.40) | 4.06s (×44.22) | 3.03s (×33.03) | 2.21s (×24.09) | 3.92s (×42.71) | 4.51s (×49.13) | 3.92s (×42.70) | 7.12s (×77.52) | 11.17s (×121.53) | 9.48s (×103.12) | 16.47s (×179.17) | 5.21s (×56.76) | 66.22s (×719.95) | 7.31s (×79.59) | |
| Q15. Query 15: SELECT UserID, count() FROM {table} GROUP BY UserID ORDER BY count() DESC LIMIT 10; | 0.10s (×1.20) | 0.10s (×1.27) | 0.11s (×1.34) | 0.08s (×1.00) | 0.12s (×1.47) | 0.11s (×1.39) | 0.12s (×1.43) | 0.12s (×1.44) | 0.14s (×1.67) | 0.17s (×2.00) | 0.18s (×2.17) | 0.12s (×1.51) | 0.18s (×2.22) | 0.20s (×2.40) | 0.16s (×1.91) | 0.18s (×2.11) | 0.15s (×1.83) | 0.16s (×1.97) | 0.22s (×2.61) | 0.19s (×2.30) | 0.23s (×2.78) | 0.19s (×2.27) | 0.16s (×1.94) | 0.25s (×2.91) | 0.24s (×2.80) | 0.26s (×3.01) | 0.26s (×3.05) | 0.19s (×2.25) | 0.24s (×2.90) | 0.20s (×2.34) | 0.23s (×2.70) | 0.24s (×2.81) | 0.28s (×3.26) | 0.31s (×3.59) | 0.30s (×3.48) | 0.27s (×3.14) | 0.27s (×3.16) | 0.22s (×2.65) | 0.40s (×4.64) | 0.29s (×3.47) | 0.22s (×2.63) | 0.27s (×3.20) | 0.32s (×3.72) | 0.23s (×2.67) | 0.23s (×2.70) | 0.22s (×2.57) | 0.43s (×4.99) | 0.21s (×2.55) | 0.31s (×3.65) | 0.24s (×2.85) | 0.62s (×7.11) | 0.32s (×3.73) | 0.28s (×3.30) | 0.38s (×4.39) | 0.46s (×5.28) | 0.31s (×3.63) | 0.45s (×5.22) | 0.45s (×5.23) | 0.55s (×6.36) | 0.52s (×6.03) | 0.45s (×5.17) | 0.30s (×3.52) | 0.46s (×5.35) | 0.47s (×5.47) | 0.35s (×4.14) | 0.44s (×5.10) | 0.45s (×5.18) | 0.33s (×3.90) | 0.53s (×6.17) | 0.49s (×5.72) | 0.28s (×3.30) | 0.55s (×6.35) | 0.65s (×7.52) | 0.64s (×7.40) | 0.48s (×5.55) | 0.67s (×7.73) | 0.45s (×5.22) | 0.57s (×6.61) | 0.69s (×7.99) | 0.68s (×7.80) | 0.83s (×9.51) | 0.70s (×8.07) | 0.59s (×6.80) | 0.74s (×8.55) | 0.56s (×6.43) | 0.53s (×6.18) | 1.01s (×11.63) | 1.20s (×13.70) | 0.64s (×7.40) | 0.77s (×8.84) | 0.92s (×10.61) | 0.86s (×9.89) | 0.83s (×9.57) | 1.06s (×12.18) | 1.06s (×12.18) | 0.84s (×9.68) | 0.94s (×10.83) | 1.06s (×12.16) | 0.74s (×8.50) | 0.99s (×11.39) | 1.08s (×12.35) | 0.90s (×10.28) | 1.20s (×13.78) | 0.86s (×9.93) | 1.35s (×15.41) | 0.90s (×10.34) | 1.11s (×12.74) | 1.03s (×11.82) | 1.39s (×15.93) | 1.33s (×15.22) | 1.31s (×14.98) | 1.15s (×13.15) | 1.24s (×14.23) | 1.09s (×12.50) | 1.25s (×14.30) | 1.27s (×14.53) | 1.06s (×12.18) | 1.81s (×20.66) | 1.85s (×21.15) | 1.49s (×17.08) | 1.48s (×16.95) | 1.75s (×20.05) | 1.60s (×18.28) | 1.71s (×19.56) | 1.88s (×21.52) | 1.58s (×18.03) | 1.77s (×20.20) | 1.80s (×20.63) | 0.78s (×8.99) | 1.58s (×18.02) | 1.62s (×18.53) | 1.97s (×22.51) | 1.48s (×16.95) | 2.13s (×24.35) | 2.28s (×25.98) | 1.78s (×20.31) | 1.86s (×21.26) | 1.82s (×20.77) | 1.33s (×15.27) | 2.06s (×23.50) | 1.84s (×21.05) | 3.20s (×36.48) | 2.83s (×32.24) | 2.81s (×31.99) | 3.19s (×36.38) | 3.21s (×36.64) | 2.40s (×27.44) | 3.12s (×35.57) | 3.85s (×43.81) | 3.69s (×42.00) | 4.54s (×51.67) | 11.58s (×131.66) | 8.87s (×100.88) | 13.57s (×154.32) | 5.21s (×59.35) | 50.54s (×574.41) | 8.01s (×91.15) | |
| Q16. Query 16: SELECT UserID, SearchPhrase, count() FROM {table} GROUP BY UserID, SearchPhrase ORDER BY count() DESC LIMIT 10; | 0.30s (×1.63) | 0.35s (×1.89) | 0.33s (×1.81) | 0.18s (×1.00) | 0.30s (×1.66) | 0.36s (×1.96) | 0.52s (×2.83) | 0.32s (×1.77) | 0.54s (×2.93) | 0.42s (×2.25) | 0.41s (×2.24) | 0.32s (×1.73) | 0.73s (×3.90) | 0.50s (×2.71) | 0.49s (×2.66) | 0.50s (×2.72) | 0.35s (×1.89) | 0.31s (×1.69) | 0.54s (×2.89) | 0.53s (×2.87) | 0.57s (×3.05) | 0.58s (×3.10) | 0.34s (×1.88) | 0.58s (×3.10) | 0.69s (×3.68) | 1.00s (×5.32) | 0.71s (×3.80) | 0.46s (×2.51) | 0.68s (×3.65) | 0.77s (×4.12) | 0.50s (×2.69) | 0.59s (×3.17) | 1.01s (×5.40) | 0.93s (×4.98) | 0.81s (×4.32) | 0.83s (×4.47) | 0.84s (×4.51) | 0.48s (×2.61) | 0.92s (×4.91) | 0.75s (×4.02) | 0.52s (×2.79) | 0.63s (×3.39) | 0.71s (×3.81) | 0.51s (×2.77) | 0.53s (×2.84) | 0.54s (×2.90) | 0.97s (×5.16) | 0.65s (×3.51) | 0.65s (×3.48) | 0.59s (×3.19) | 1.63s (×8.68) | 0.72s (×3.86) | 0.63s (×3.38) | 0.96s (×5.13) | 1.03s (×5.48) | 0.84s (×4.50) | 1.01s (×5.39) | 1.02s (×5.44) | 1.61s (×8.57) | 1.27s (×6.78) | 1.13s (×6.05) | 0.78s (×4.19) | 1.24s (×6.59) | 1.27s (×6.78) | 1.16s (×6.20) | 1.25s (×6.69) | 1.29s (×6.87) | 0.94s (×5.01) | 1.21s (×6.43) | 1.51s (×8.05) | 0.67s (×3.62) | 1.23s (×6.57) | 1.82s (×9.69) | 1.64s (×8.75) | 1.57s (×8.38) | 1.54s (×8.23) | 1.34s (×7.16) | 1.51s (×8.05) | 1.64s (×8.74) | 1.77s (×9.44) | 1.80s (×9.57) | 1.67s (×8.88) | 1.56s (×8.29) | 1.79s (×9.55) | 1.52s (×8.08) | 2.02s (×10.74) | 2.53s (×13.43) | 3.21s (×17.05) | 1.43s (×7.62) | 2.17s (×11.51) | 2.68s (×14.25) | 2.07s (×11.01) | 1.91s (×10.18) | 2.69s (×14.27) | 2.69s (×14.27) | 1.98s (×10.54) | 2.37s (×12.57) | 3.18s (×16.89) | 2.67s (×14.16) | 2.49s (×13.22) | 2.71s (×14.41) | 2.62s (×13.92) | 3.08s (×16.34) | 8.04s (×42.60) | 3.21s (×17.04) | 2.68s (×14.22) | 3.06s (×16.24) | 2.75s (×14.62) | 3.33s (×17.70) | 3.80s (×20.15) | 4.41s (×23.39) | 3.55s (×18.81) | 3.85s (×20.42) | 3.15s (×16.74) | 2.84s (×15.09) | 3.63s (×19.26) | 2.50s (×13.26) | 6.18s (×32.75) | 5.16s (×27.33) | 5.33s (×28.28) | 4.31s (×22.86) | 4.97s (×26.35) | 5.03s (×26.66) | 5.66s (×29.99) | 5.97s (×31.67) | 4.65s (×24.66) | 5.86s (×31.03) | 5.10s (×27.02) | 2.12s (×11.28) | 3.49s (×18.52) | 5.44s (×28.83) | 5.68s (×30.10) | 4.18s (×22.17) | 5.50s (×29.14) | 6.46s (×34.25) | 5.65s (×29.96) | 4.83s (×25.61) | 4.80s (×25.46) | 5.93s (×31.45) | 5.89s (×31.24) | 6.28s (×33.30) | 7.71s (×40.87) | 8.85s (×46.88) | 8.32s (×44.07) | 11.37s (×60.22) | 8.69s (×46.05) | 5.91s (×31.34) | 11.06s (×58.59) | 12.88s (×68.21) | 10.01s (×53.02) | 14.84s (×78.54) | 22.93s (×121.38) | ☠ | 42.58s (×225.35) | ☠ | 156.51s (×828.13) | ☠ | |
| Q17. Query 17: SELECT UserID, SearchPhrase, count() FROM {table} GROUP BY UserID, SearchPhrase LIMIT 10; | 0.19s (×1.23) | 0.23s (×1.45) | 0.23s (×1.45) | 0.15s (×1.00) | 0.22s (×1.39) | 0.24s (×1.56) | 0.27s (×1.70) | 0.23s (×1.48) | 0.37s (×2.36) | 0.31s (×1.98) | 0.30s (×1.90) | 0.24s (×1.53) | 0.50s (×3.14) | 0.30s (×1.92) | 0.33s (×2.07) | 0.32s (×2.04) | 0.24s (×1.52) | 0.23s (×1.47) | 0.30s (×1.89) | 0.35s (×2.20) | 0.32s (×2.02) | 0.37s (×2.36) | 0.23s (×1.48) | 0.32s (×2.01) | 0.41s (×2.60) | 0.66s (×4.10) | 0.42s (×2.64) | 0.31s (×1.94) | 0.44s (×2.75) | 0.47s (×2.96) | 0.42s (×2.66) | 0.36s (×2.26) | 0.58s (×3.64) | 0.41s (×2.60) | 0.42s (×2.63) | 0.51s (×3.16) | 0.51s (×3.16) | 0.32s (×2.00) | 0.47s (×2.97) | 0.46s (×2.87) | 0.44s (×2.74) | 0.38s (×2.37) | 0.45s (×2.83) | 0.34s (×2.15) | 0.38s (×2.37) | 0.41s (×2.58) | 0.59s (×3.69) | 0.46s (×2.90) | 0.45s (×2.80) | 0.34s (×2.14) | 0.88s (×5.47) | 0.41s (×2.59) | 0.43s (×2.68) | 0.58s (×3.63) | 0.63s (×3.90) | 0.54s (×3.39) | 0.62s (×3.86) | 0.63s (×3.94) | 0.89s (×5.55) | 0.66s (×4.09) | 0.68s (×4.20) | 0.52s (×3.26) | 0.82s (×5.11) | 0.64s (×4.00) | 0.61s (×3.81) | 0.83s (×5.17) | 0.74s (×4.63) | 0.89s (×5.50) | 0.74s (×4.58) | 0.76s (×4.71) | 0.50s (×3.14) | 0.61s (×3.81) | 0.96s (×5.93) | 0.90s (×5.55) | 0.85s (×5.27) | 0.87s (×5.40) | 0.86s (×5.33) | 0.91s (×5.63) | 0.99s (×6.16) | 0.93s (×5.75) | 0.93s (×5.75) | 0.99s (×6.12) | 0.91s (×5.64) | 0.96s (×5.96) | 0.74s (×4.58) | 1.04s (×6.44) | 1.40s (×8.63) | 1.77s (×10.94) | 0.91s (×5.62) | 1.35s (×8.37) | 1.50s (×9.23) | 1.18s (×7.32) | 1.04s (×6.46) | 1.46s (×8.99) | 1.46s (×8.99) | 1.16s (×7.18) | 1.38s (×8.54) | 1.79s (×11.04) | 1.58s (×9.73) | 1.53s (×9.47) | 1.56s (×9.64) | 1.35s (×8.33) | 1.73s (×10.65) | 6.99s (×42.95) | 1.90s (×11.71) | 1.70s (×10.52) | 1.83s (×11.30) | 1.67s (×10.28) | 2.06s (×12.73) | 2.27s (×13.99) | 2.92s (×17.98) | 2.39s (×14.73) | 2.20s (×13.56) | 1.66s (×10.21) | 2.29s (×14.13) | 2.02s (×12.43) | 1.53s (×9.43) | 3.85s (×23.71) | 3.19s (×19.63) | 3.19s (×19.62) | 3.02s (×18.56) | 2.73s (×16.81) | 2.97s (×18.27) | 3.40s (×20.90) | 3.44s (×21.14) | 2.83s (×17.44) | 3.53s (×21.72) | 2.99s (×18.43) | 1.61s (×9.97) | 1.97s (×12.12) | 3.68s (×22.63) | 3.36s (×20.65) | 2.76s (×16.97) | 3.35s (×20.64) | 3.76s (×23.11) | 3.40s (×20.95) | 3.13s (×19.27) | 3.11s (×19.12) | 3.98s (×24.51) | 3.62s (×22.26) | 3.55s (×21.85) | 3.82s (×23.49) | 6.12s (×37.58) | 5.99s (×36.82) | 7.72s (×47.42) | 5.22s (×32.12) | 3.59s (×22.08) | 7.76s (×47.68) | 8.06s (×49.48) | 6.56s (×40.28) | 10.04s (×61.63) | 13.99s (×85.90) | ☠ | 28.22s (×173.21) | ☠ | 108.51s (×665.76) | ☠ | |
| Q18. Query 18: SELECT UserID, toMinute(EventTime) AS m, SearchPhrase, count() FROM {table} GROUP BY UserID, m, SearchPhrase ORDER BY count() DESC LIMIT 10; | 0.38s (×1.28) | 0.68s (×2.27) | 0.63s (×2.10) | 0.29s (×1.00) | 0.58s (×1.96) | 0.72s (×2.41) | 0.78s (×2.61) | 0.59s (×1.98) | 1.08s (×3.60) | 0.72s (×2.40) | 0.77s (×2.56) | 0.56s (×1.89) | 1.18s (×3.93) | 1.05s (×3.50) | 1.03s (×3.42) | 1.00s (×3.33) | 0.79s (×2.63) | 0.60s (×2.00) | 1.05s (×3.50) | 1.07s (×3.58) | 1.08s (×3.60) | 1.13s (×3.75) | 0.86s (×2.87) | 1.10s (×3.65) | 1.27s (×4.22) | 2.01s (×6.66) | 1.29s (×4.28) | 0.72s (×2.41) | 1.15s (×3.82) | 1.50s (×4.99) | 0.99s (×3.30) | 1.29s (×4.30) | 2.21s (×7.32) | 1.57s (×5.22) | 1.65s (×5.48) | 1.47s (×4.87) | 1.43s (×4.76) | 1.08s (×3.61) | 1.62s (×5.38) | 1.33s (×4.42) | 0.94s (×3.12) | 1.04s (×3.47) | 1.40s (×4.64) | 1.23s (×4.10) | 1.27s (×4.21) | 0.87s (×2.89) | 1.64s (×5.45) | 1.39s (×4.60) | 1.49s (×4.94) | 1.31s (×4.36) | 2.82s (×9.35) | 1.38s (×4.58) | 1.14s (×3.79) | 1.79s (×5.95) | 1.80s (×5.98) | 1.45s (×4.81) | 1.79s (×5.93) | 1.77s (×5.88) | 2.95s (×9.78) | 2.26s (×7.50) | 2.05s (×6.80) | 1.32s (×4.38) | 2.44s (×8.09) | 2.37s (×7.85) | 2.44s (×8.08) | 2.18s (×7.23) | 2.72s (×9.02) | 2.07s (×6.86) | 2.54s (×8.43) | 3.25s (×10.76) | 1.28s (×4.25) | 2.35s (×7.79) | 4.37s (×14.46) | 3.83s (×12.69) | 2.87s (×9.50) | 3.84s (×12.72) | 2.88s (×9.53) | 3.60s (×11.91) | 3.31s (×10.97) | 4.09s (×13.52) | 4.19s (×13.85) | 3.65s (×12.07) | 3.41s (×11.29) | 4.15s (×13.73) | 3.74s (×12.37) | 3.60s (×11.93) | 4.13s (×13.67) | 5.80s (×19.17) | 3.51s (×11.61) | 3.97s (×13.15) | 5.00s (×16.53) | 4.37s (×14.47) | 4.28s (×14.16) | 4.70s (×15.55) | 4.70s (×15.55) | 4.24s (×14.02) | 4.26s (×14.08) | 5.88s (×19.45) | 5.04s (×16.67) | 4.93s (×16.30) | 5.57s (×18.42) | 6.43s (×21.26) | 6.46s (×21.34) | 6.53s (×21.58) | 5.96s (×19.72) | 4.79s (×15.85) | 6.24s (×20.61) | 4.95s (×16.38) | 6.11s (×20.20) | 7.02s (×23.21) | 8.68s (×28.69) | 7.40s (×24.44) | 7.20s (×23.78) | 6.21s (×20.51) | 5.76s (×19.06) | 6.19s (×20.45) | 5.17s (×17.08) | 14.56s (×48.09) | 10.56s (×34.89) | 10.13s (×33.45) | 9.42s (×31.13) | 10.40s (×34.35) | 9.70s (×32.03) | 11.55s (×38.16) | 12.57s (×41.52) | 9.09s (×30.02) | 11.78s (×38.91) | 11.19s (×36.97) | 3.88s (×12.83) | 7.62s (×25.17) | 10.92s (×36.08) | 11.70s (×38.65) | 8.33s (×27.52) | 10.22s (×33.78) | 13.70s (×45.23) | 12.89s (×42.58) | 10.40s (×34.34) | 10.57s (×34.93) | 14.90s (×49.21) | 11.76s (×38.86) | 10.76s (×35.55) | 15.84s (×52.31) | 17.79s (×58.75) | 16.06s (×53.03) | 22.78s (×75.22) | 17.37s (×57.37) | ☠ | 22.46s (×74.16) | 26.70s (×88.16) | 19.14s (×63.18) | 25.66s (×84.70) | ☠ | ☠ | ☠ | ☠ | ☠ | ☠ | |
| Q19. Query 19: SELECT UserID FROM {table} WHERE UserID = 12345678901234567890; | 0.02s (×1.37) | 0.01s (×1.00) | 0.02s (×1.47) | 0.02s (×1.37) | 0.02s (×1.47) | 0.01s (×1.26) | 0.01s (×1.16) | 0.02s (×1.42) | 0.03s (×1.84) | 0.02s (×1.68) | 0.03s (×1.89) | 0.01s (×1.32) | 0.02s (×1.58) | 0.03s (×2.00) | 0.02s (×1.58) | 0.03s (×1.89) | 0.02s (×1.79) | 0.02s (×1.74) | 0.02s (×1.53) | 0.05s (×3.21) | 0.03s (×2.26) | 0.03s (×1.89) | 0.03s (×1.84) | 0.02s (×1.79) | 0.03s (×2.05) | 0.03s (×2.00) | 0.03s (×2.16) | 0.07s (×4.26) | 0.02s (×1.68) | 0.03s (×2.00) | 0.07s (×4.26) | 0.02s (×1.68) | 0.02s (×1.47) | 0.03s (×1.89) | 0.03s (×1.89) | 0.02s (×1.47) | 0.03s (×2.32) | 0.05s (×3.37) | 0.02s (×1.79) | 0.04s (×2.37) | 0.04s (×2.79) | 0.04s (×2.63) | 0.04s (×2.53) | 0.06s (×3.58) | 0.13s (×7.16) | 0.07s (×4.00) | 0.02s (×1.79) | 0.11s (×6.42) | 0.03s (×2.21) | 0.02s (×1.58) | 0.02s (×1.68) | 0.05s (×3.37) | 0.08s (×4.68) | 0.03s (×2.16) | 0.03s (×1.84) | 0.06s (×3.89) | 0.03s (×2.11) | 0.03s (×2.11) | 0.06s (×3.84) | 0.03s (×1.95) | 0.03s (×2.11) | 0.08s (×4.79) | 0.03s (×2.26) | 0.03s (×2.05) | 0.06s (×3.63) | 0.03s (×2.26) | 0.03s (×2.21) | 0.04s (×2.42) | 0.03s (×2.05) | 0.03s (×2.16) | 0.03s (×2.00) | 0.04s (×2.63) | 0.03s (×1.95) | 0.03s (×2.26) | 0.03s (×2.32) | 0.03s (×2.16) | 0.04s (×2.74) | 0.03s (×2.26) | 0.04s (×2.58) | 0.04s (×2.63) | 0.03s (×2.11) | 0.04s (×2.63) | 0.04s (×2.47) | 0.04s (×2.42) | 0.05s (×3.37) | 0.06s (×3.68) | 0.04s (×2.47) | 0.04s (×2.47) | 0.05s (×3.00) | 0.05s (×3.05) | 0.03s (×2.11) | 0.04s (×2.79) | 0.07s (×4.26) | 0.05s (×3.00) | 0.05s (×3.00) | 0.05s (×3.37) | 0.05s (×3.11) | 0.05s (×3.05) | 0.05s (×3.21) | 0.06s (×3.42) | 0.06s (×3.79) | 0.05s (×3.26) | 0.06s (×3.53) | 0.05s (×3.26) | 0.06s (×3.42) | 0.07s (×4.42) | 0.07s (×4.05) | 0.06s (×3.53) | 0.07s (×4.16) | 0.07s (×4.00) | 0.08s (×4.58) | 0.09s (×5.37) | 0.07s (×4.11) | 0.10s (×6.05) | 0.10s (×6.05) | 0.08s (×4.79) | 0.11s (×6.11) | 0.10s (×5.58) | 0.09s (×5.26) | 0.17s (×9.26) | 0.09s (×5.21) | 0.07s (×4.47) | 0.10s (×5.79) | 0.12s (×7.05) | 0.08s (×4.53) | 0.12s (×6.74) | 0.12s (×6.89) | 0.11s (×6.53) | 0.10s (×5.95) | 0.17s (×9.37) | 0.13s (×7.47) | 0.09s (×5.32) | 0.07s (×4.37) | 0.11s (×6.21) | 0.10s (×5.79) | 0.12s (×6.74) | 0.10s (×6.05) | 0.10s (×5.84) | 0.12s (×7.05) | 0.10s (×5.89) | 0.13s (×7.58) | 0.13s (×7.58) | 0.19s (×10.74) | 0.16s (×8.74) | 0.24s (×13.05) | 0.18s (×10.11) | 0.12s (×6.84) | 0.26s (×14.16) | 0.18s (×10.16) | 0.21s (×11.53) | 0.67s (×35.74) | 1.31s (×69.53) | 0.89s (×47.21) | 1.85s (×97.68) | 0.50s (×26.84) | 6.39s (×337.11) | ☠ | |
| Q20. Query 20: SELECT count() FROM {table} WHERE URL LIKE '%metrika%'; | 0.10s (×1.10) | 0.16s (×1.67) | 0.20s (×2.07) | 0.09s (×1.00) | 0.13s (×1.38) | 0.17s (×1.74) | 0.17s (×1.72) | 0.14s (×1.42) | 0.28s (×2.79) | 0.20s (×2.05) | 0.14s (×1.42) | 0.13s (×1.32) | 0.29s (×2.91) | 0.26s (×2.64) | 0.23s (×2.40) | 0.32s (×3.22) | 0.15s (×1.59) | 0.19s (×1.99) | 0.16s (×1.70) | 0.20s (×2.02) | 0.19s (×1.99) | 0.27s (×2.75) | 0.19s (×1.97) | 0.21s (×2.15) | 0.28s (×2.84) | 0.38s (×3.82) | 0.27s (×2.75) | 0.27s (×2.75) | 0.37s (×3.73) | 0.31s (×3.11) | 0.19s (×1.96) | 0.26s (×2.68) | 0.35s (×3.54) | 0.26s (×2.69) | 0.25s (×2.56) | 0.25s (×2.59) | 0.25s (×2.53) | 0.32s (×3.19) | 0.26s (×2.63) | 0.27s (×2.70) | 0.17s (×1.75) | 0.36s (×3.61) | 0.26s (×2.63) | 0.31s (×3.17) | 0.37s (×3.74) | 0.31s (×3.17) | 0.38s (×3.83) | 0.37s (×3.71) | 0.29s (×2.91) | 0.24s (×2.47) | 0.31s (×3.13) | 0.29s (×2.99) | 0.36s (×3.61) | 0.34s (×3.47) | 0.40s (×4.04) | 0.39s (×3.87) | 0.44s (×4.44) | 0.46s (×4.63) | 0.29s (×2.93) | 0.34s (×3.47) | 0.43s (×4.30) | 0.43s (×4.29) | 0.68s (×6.77) | 0.37s (×3.76) | 0.33s (×3.31) | 0.65s (×6.47) | 0.49s (×4.94) | 0.31s (×3.16) | 0.54s (×5.38) | 0.50s (×4.96) | 0.61s (×6.07) | 0.37s (×3.74) | 0.31s (×3.11) | 0.55s (×5.46) | 0.48s (×4.78) | 0.52s (×5.23) | 0.68s (×6.74) | 0.52s (×5.19) | 0.74s (×7.37) | 0.54s (×5.37) | 0.53s (×5.26) | 0.62s (×6.20) | 0.57s (×5.69) | 0.61s (×6.07) | 0.51s (×5.13) | 0.83s (×8.25) | 0.45s (×4.51) | 0.64s (×6.36) | 0.60s (×5.99) | 0.79s (×7.79) | 1.27s (×12.51) | 0.65s (×6.50) | 0.73s (×7.25) | 0.92s (×9.14) | 0.92s (×9.14) | 0.65s (×6.48) | 0.85s (×8.39) | 0.82s (×8.13) | 0.82s (×8.19) | 0.95s (×9.42) | 0.95s (×9.42) | 0.71s (×7.11) | 1.13s (×11.21) | 1.14s (×11.28) | 0.99s (×9.79) | 1.22s (×12.10) | 1.03s (×10.20) | 1.05s (×10.38) | 1.36s (×13.45) | 1.08s (×10.65) | 2.37s (×23.37) | 1.74s (×17.15) | 1.06s (×10.52) | 0.98s (×9.67) | 1.54s (×15.25) | 1.30s (×12.80) | 1.30s (×12.86) | 1.85s (×18.20) | 1.48s (×14.58) | 1.70s (×16.77) | 1.72s (×16.97) | 2.28s (×22.41) | 1.87s (×18.43) | 2.29s (×22.54) | 1.37s (×13.55) | 1.85s (×18.22) | 2.16s (×21.29) | 1.90s (×18.75) | 1.48s (×14.60) | 2.26s (×22.23) | 2.15s (×21.20) | 1.55s (×15.30) | 1.56s (×15.36) | 1.84s (×18.18) | 1.70s (×16.75) | 1.81s (×17.82) | 1.93s (×19.04) | 1.96s (×19.31) | 2.71s (×26.67) | 1.87s (×18.41) | 1.77s (×17.45) | 2.12s (×20.83) | 3.42s (×33.59) | 3.37s (×33.17) | 4.09s (×40.18) | 3.53s (×34.68) | 2.44s (×24.03) | 4.04s (×39.70) | 3.56s (×34.99) | 4.02s (×39.54) | 13.73s (×134.67) | 19.48s (×191.11) | 14.75s (×144.69) | 30.73s (×301.32) | 7.21s (×70.76) | 149.66s (×1467.39) | ☠ | |
| Q21. Query 21: SELECT SearchPhrase, any(URL), count() AS c FROM {table} WHERE URL LIKE '%metrika%' AND SearchPhrase != '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10; | 0.12s (×1.07) | 0.16s (×1.44) | 0.24s (×2.08) | 0.11s (×1.00) | 0.14s (×1.31) | 0.16s (×1.42) | 0.19s (×1.67) | 0.14s (×1.24) | 0.29s (×2.51) | 0.20s (×1.81) | 0.13s (×1.22) | 0.12s (×1.11) | 0.29s (×2.55) | 0.21s (×1.86) | 0.26s (×2.29) | 0.37s (×3.24) | 0.16s (×1.47) | 0.19s (×1.70) | 0.18s (×1.60) | 0.18s (×1.59) | 0.20s (×1.78) | 0.21s (×1.87) | 0.15s (×1.39) | 0.19s (×1.70) | 0.25s (×2.19) | 0.42s (×3.68) | 0.26s (×2.25) | 0.22s (×1.97) | 0.35s (×3.07) | 0.30s (×2.62) | 0.19s (×1.69) | 0.26s (×2.25) | 0.35s (×3.09) | 0.26s (×2.30) | 0.27s (×2.33) | 0.28s (×2.48) | 0.28s (×2.42) | 0.29s (×2.55) | 0.30s (×2.64) | 0.25s (×2.19) | 0.18s (×1.64) | 0.34s (×2.97) | 0.31s (×2.71) | 0.31s (×2.73) | 0.32s (×2.81) | 0.23s (×2.04) | 0.39s (×3.37) | 0.47s (×4.06) | 0.35s (×3.03) | 0.25s (×2.19) | 0.36s (×3.10) | 0.34s (×2.99) | 0.32s (×2.82) | 0.41s (×3.52) | 0.42s (×3.62) | 0.41s (×3.52) | 0.46s (×3.99) | 0.47s (×4.03) | 0.35s (×3.03) | 0.38s (×3.32) | 0.50s (×4.31) | 0.40s (×3.43) | 0.70s (×6.05) | 0.39s (×3.35) | 0.39s (×3.37) | 0.71s (×6.14) | 0.57s (×4.93) | 0.37s (×3.25) | 0.56s (×4.82) | 0.56s (×4.81) | 0.71s (×6.09) | 0.45s (×3.90) | 0.41s (×3.54) | 0.53s (×4.59) | 0.59s (×5.13) | 0.60s (×5.16) | 0.73s (×6.24) | 0.59s (×5.12) | 0.75s (×6.46) | 0.67s (×5.72) | 0.61s (×5.24) | 0.65s (×5.58) | 0.65s (×5.56) | 0.67s (×5.75) | 0.57s (×4.91) | 1.02s (×8.69) | 0.76s (×6.54) | 0.81s (×6.98) | 0.85s (×7.26) | 0.89s (×7.64) | 1.66s (×14.18) | 0.71s (×6.11) | 0.88s (×7.54) | 0.99s (×8.47) | 0.99s (×8.47) | 0.68s (×5.81) | 1.10s (×9.44) | 0.94s (×8.03) | 0.93s (×7.99) | 1.03s (×8.80) | 1.22s (×10.44) | 0.79s (×6.79) | 1.29s (×11.03) | 1.31s (×11.19) | 1.24s (×10.58) | 1.33s (×11.38) | 1.30s (×11.07) | 1.11s (×9.48) | 1.39s (×11.85) | 1.28s (×10.90) | 2.12s (×18.04) | 1.84s (×15.71) | 1.20s (×10.24) | 1.20s (×10.21) | 1.69s (×14.38) | 1.50s (×12.82) | 1.29s (×11.02) | 1.68s (×14.29) | 1.73s (×14.78) | 1.99s (×16.92) | 2.08s (×17.69) | 2.73s (×23.24) | 2.17s (×18.49) | 2.25s (×19.18) | 2.24s (×19.05) | 2.20s (×18.75) | 2.25s (×19.16) | 2.04s (×17.33) | 1.64s (×14.01) | 2.52s (×21.42) | 2.37s (×20.14) | 1.99s (×16.91) | 1.91s (×16.28) | 2.23s (×18.96) | 1.94s (×16.55) | 2.07s (×17.60) | 2.34s (×19.92) | 2.30s (×19.55) | 2.77s (×23.57) | 2.17s (×18.48) | 2.24s (×19.08) | 3.07s (×26.09) | 3.77s (×32.06) | 4.05s (×34.42) | 4.21s (×35.81) | 4.01s (×34.08) | 2.60s (×22.14) | 4.23s (×35.96) | 4.26s (×36.22) | 4.64s (×39.37) | 15.68s (×132.92) | 24.16s (×204.82) | 17.89s (×151.69) | 34.02s (×288.35) | 8.40s (×71.29) | 166.38s (×1410.10) | ☠ | |
| Q22. Query 22: SELECT SearchPhrase, any(URL), any(Title), count() AS c, uniq(UserID) FROM {table} WHERE Title LIKE '%Яндекс%' AND URL NOT LIKE '%.yandex.%' AND SearchPhrase != '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10; | 0.32s (×1.00) | 0.47s (×1.45) | 0.53s (×1.65) | 0.42s (×1.31) | 0.35s (×1.10) | 0.47s (×1.47) | 0.46s (×1.43) | 0.70s (×2.16) | 0.64s (×1.97) | 0.42s (×1.31) | 0.60s (×1.86) | 0.60s (×1.84) | 0.62s (×1.91) | 0.49s (×1.52) | 0.67s (×2.08) | 0.88s (×2.69) | 0.49s (×1.52) | 0.42s (×1.31) | 0.63s (×1.93) | 0.70s (×2.17) | 0.61s (×1.90) | 0.64s (×1.98) | 0.59s (×1.83) | 0.65s (×2.00) | 0.56s (×1.73) | 0.83s (×2.54) | 0.58s (×1.80) | 0.78s (×2.41) | 0.90s (×2.75) | 0.80s (×2.45) | 0.70s (×2.17) | 0.67s (×2.08) | 1.12s (×3.42) | 0.64s (×1.96) | 0.62s (×1.91) | 0.69s (×2.12) | 0.69s (×2.13) | 0.66s (×2.04) | 0.73s (×2.25) | 0.64s (×1.97) | 0.74s (×2.27) | 0.64s (×1.96) | 0.75s (×2.32) | 0.65s (×2.02) | 0.70s (×2.15) | 0.67s (×2.07) | 0.97s (×2.98) | 1.05s (×3.23) | 0.90s (×2.77) | 0.65s (×1.99) | 0.94s (×2.88) | 0.82s (×2.53) | 0.75s (×2.30) | 1.10s (×3.38) | 0.99s (×3.03) | 0.92s (×2.83) | 1.06s (×3.26) | 1.07s (×3.29) | 1.80s (×5.50) | 0.88s (×2.70) | 1.15s (×3.53) | 0.88s (×2.70) | 1.47s (×4.50) | 1.15s (×3.51) | 1.79s (×5.47) | 1.48s (×4.52) | 1.30s (×3.99) | 1.08s (×3.31) | 1.22s (×3.74) | 1.39s (×4.25) | 0.88s (×2.71) | 1.06s (×3.26) | 1.54s (×4.73) | 1.31s (×4.02) | 1.36s (×4.17) | 1.43s (×4.37) | 1.60s (×4.89) | 1.44s (×4.39) | 1.67s (×5.11) | 1.65s (×5.03) | 1.45s (×4.43) | 1.57s (×4.81) | 1.50s (×4.57) | 1.77s (×5.40) | 1.53s (×4.70) | 3.47s (×10.59) | 2.38s (×7.26) | 2.12s (×6.48) | 3.15s (×9.59) | 2.04s (×6.24) | 4.88s (×14.88) | 1.83s (×5.58) | 1.81s (×5.53) | 2.39s (×7.29) | 2.39s (×7.29) | 1.70s (×5.20) | 2.22s (×6.79) | 2.30s (×7.01) | 2.19s (×6.69) | 2.45s (×7.48) | 2.77s (×8.45) | 2.16s (×6.59) | 3.18s (×9.68) | 2.92s (×8.90) | 3.28s (×10.00) | 2.94s (×8.96) | 2.83s (×8.64) | 2.38s (×7.27) | 3.10s (×9.47) | 3.04s (×9.28) | 4.58s (×13.94) | 3.85s (×11.74) | 2.90s (×8.86) | 2.80s (×8.54) | 4.38s (×13.34) | 3.56s (×10.86) | 2.95s (×8.98) | 4.14s (×12.61) | 3.96s (×12.05) | 4.62s (×14.08) | 4.39s (×13.39) | 7.45s (×22.67) | 5.10s (×15.53) | 4.70s (×14.31) | 4.91s (×14.96) | 4.91s (×14.95) | 5.44s (×16.58) | 4.63s (×14.09) | 3.17s (×9.67) | 5.71s (×17.38) | 5.43s (×16.53) | 5.32s (×16.20) | 4.35s (×13.26) | 4.90s (×14.93) | 4.70s (×14.31) | 5.08s (×15.47) | 5.26s (×16.02) | 5.33s (×16.22) | 6.15s (×18.73) | 5.25s (×15.97) | 5.13s (×15.62) | 6.86s (×20.87) | 8.64s (×26.29) | 8.30s (×25.27) | 9.47s (×28.81) | 8.97s (×27.31) | 6.05s (×18.43) | 9.47s (×28.83) | 9.99s (×30.38) | 10.57s (×32.16) | 33.20s (×100.95) | 47.25s (×143.65) | 46.91s (×142.61) | 74.60s (×226.77) | ☠ | 355.35s (×1080.12) | ☠ | |
| Q23. Query 23: SELECT * FROM {table} WHERE URL LIKE '%metrika%' ORDER BY EventTime LIMIT 10; | 0.27s (×1.41) | 0.19s (×1.00) | 0.26s (×1.38) | 0.23s (×1.22) | 0.23s (×1.22) | 0.20s (×1.09) | 0.25s (×1.32) | 0.22s (×1.15) | 0.33s (×1.73) | 0.29s (×1.53) | 0.22s (×1.18) | 0.26s (×1.38) | 0.54s (×2.80) | 0.30s (×1.59) | 0.40s (×2.07) | 0.41s (×2.14) | 0.27s (×1.42) | 0.39s (×2.02) | 0.28s (×1.48) | 0.23s (×1.23) | 0.30s (×1.57) | 0.28s (×1.48) | 0.32s (×1.66) | 0.30s (×1.59) | 0.37s (×1.91) | 0.45s (×2.36) | 0.35s (×1.83) | 1.16s (×5.96) | 0.49s (×2.52) | 0.35s (×1.83) | 0.45s (×2.31) | 0.37s (×1.91) | 0.48s (×2.47) | 0.40s (×2.09) | 0.37s (×1.91) | 0.35s (×1.83) | 0.34s (×1.75) | 0.68s (×3.48) | 0.38s (×1.99) | 0.37s (×1.91) | 0.52s (×2.71) | 0.46s (×2.41) | 0.39s (×2.02) | 0.99s (×5.08) | 1.56s (×7.99) | 0.49s (×2.53) | 0.46s (×2.40) | 0.57s (×2.93) | 0.90s (×4.64) | ☠ | 0.40s (×2.09) | 0.44s (×2.30) | 1.50s (×7.66) | 0.51s (×2.63) | 0.53s (×2.75) | 0.48s (×2.47) | 0.55s (×2.83) | 0.56s (×2.90) | 0.39s (×2.02) | 0.44s (×2.26) | 0.56s (×2.90) | 0.56s (×2.92) | 0.77s (×3.94) | 0.50s (×2.60) | 0.47s (×2.45) | 0.73s (×3.78) | 0.59s (×3.03) | 0.49s (×2.56) | 0.69s (×3.58) | 0.67s (×3.43) | 1.62s (×8.29) | 0.51s (×2.62) | 0.56s (×2.89) | 0.70s (×3.60) | 0.68s (×3.48) | 0.65s (×3.37) | 0.82s (×4.21) | 0.65s (×3.34) | 0.91s (×4.69) | 0.79s (×4.06) | 0.68s (×3.48) | 0.91s (×4.65) | 0.76s (×3.93) | 0.82s (×4.20) | 0.83s (×4.28) | 0.98s (×5.02) | 0.73s (×3.77) | 0.72s (×3.69) | 0.88s (×4.50) | 0.95s (×4.87) | 1.41s (×7.20) | 0.94s (×4.82) | 1.11s (×5.71) | 1.03s (×5.30) | 1.03s (×5.30) | 0.90s (×4.61) | 1.04s (×5.32) | 0.99s (×5.09) | 0.96s (×4.90) | 1.14s (×5.83) | 1.20s (×6.12) | 0.84s (×4.30) | 1.18s (×6.04) | 1.40s (×7.16) | 0.99s (×5.10) | 1.40s (×7.18) | 1.28s (×6.53) | 1.24s (×6.35) | 1.65s (×8.44) | 1.29s (×6.62) | 2.62s (×13.33) | 2.20s (×11.23) | 1.34s (×6.86) | 1.32s (×6.74) | 1.76s (×8.99) | 1.71s (×8.74) | 1.57s (×8.00) | 2.08s (×10.59) | 1.77s (×9.06) | 2.13s (×10.87) | 1.95s (×9.95) | 2.61s (×13.28) | 2.54s (×12.94) | 2.30s (×11.73) | 1.99s (×10.17) | 2.19s (×11.18) | 2.40s (×12.25) | 2.50s (×12.76) | 2.07s (×10.56) | 2.16s (×10.99) | 2.75s (×14.04) | 2.32s (×11.84) | ☠ | 2.28s (×11.61) | 2.12s (×10.81) | 2.20s (×11.23) | 2.46s (×12.56) | 2.46s (×12.56) | 3.41s (×17.37) | 2.44s (×12.41) | 2.48s (×12.62) | 2.57s (×13.08) | 3.97s (×20.19) | 3.80s (×19.36) | 4.67s (×23.75) | 4.54s (×23.11) | 2.93s (×14.93) | 5.06s (×25.75) | 4.67s (×23.77) | 4.74s (×24.13) | 15.33s (×77.88) | 24.81s (×126.00) | 23.20s (×117.80) | 36.60s (×185.86) | ☠ | 161.06s (×817.63) | ☠ | |
| Q24. Query 24: SELECT SearchPhrase FROM {table} WHERE SearchPhrase != '' ORDER BY EventTime LIMIT 10; | 0.04s (×1.20) | 0.05s (×1.24) | 0.05s (×1.30) | 0.04s (×1.00) | 0.04s (×1.20) | 0.05s (×1.26) | 0.05s (×1.35) | 0.04s (×1.13) | 0.07s (×1.72) | 0.06s (×1.52) | 0.05s (×1.26) | 0.05s (×1.30) | 0.10s (×2.33) | 0.06s (×1.54) | 0.08s (×1.93) | 0.07s (×1.78) | 0.06s (×1.46) | 0.06s (×1.54) | 0.06s (×1.61) | 0.06s (×1.46) | 0.07s (×1.74) | 0.07s (×1.67) | 0.07s (×1.63) | 0.07s (×1.70) | 0.08s (×2.00) | 0.11s (×2.63) | 0.08s (×1.93) | 0.11s (×2.65) | 0.10s (×2.41) | 0.09s (×2.20) | 0.08s (×1.93) | 0.08s (×1.98) | 0.10s (×2.46) | 0.08s (×1.93) | 0.09s (×2.09) | 0.10s (×2.28) | 0.10s (×2.30) | 0.09s (×2.07) | 0.10s (×2.46) | 0.09s (×2.24) | 0.08s (×1.87) | 0.14s (×3.22) | 0.09s (×2.26) | 0.10s (×2.30) | 0.09s (×2.22) | 0.13s (×2.93) | 0.11s (×2.63) | 0.12s (×2.83) | 0.10s (×2.39) | 0.10s (×2.37) | 0.10s (×2.37) | 0.12s (×2.74) | 0.09s (×2.26) | 0.13s (×2.93) | 0.12s (×2.87) | 0.12s (×2.91) | 0.13s (×3.09) | 0.14s (×3.20) | 0.10s (×2.28) | 0.11s (×2.59) | 0.15s (×3.52) | 0.12s (×2.74) | 0.17s (×3.98) | 0.13s (×3.00) | 0.12s (×2.89) | 0.20s (×4.59) | 0.15s (×3.52) | 0.11s (×2.65) | 0.16s (×3.78) | 0.17s (×3.93) | 0.15s (×3.50) | 0.14s (×3.30) | 0.14s (×3.30) | 0.18s (×4.22) | 0.16s (×3.67) | 0.20s (×4.59) | 0.22s (×5.02) | 0.20s (×4.63) | 0.22s (×4.98) | 0.18s (×4.24) | 0.21s (×4.83) | 0.22s (×5.09) | 0.19s (×4.41) | 0.22s (×4.93) | 0.18s (×4.22) | 0.18s (×4.24) | 0.23s (×5.17) | 0.21s (×4.80) | 0.23s (×5.15) | 0.27s (×6.02) | 0.29s (×6.63) | 0.24s (×5.37) | 0.21s (×4.76) | 0.25s (×5.72) | 0.25s (×5.72) | 0.27s (×6.02) | 0.30s (×6.85) | 0.26s (×5.87) | 0.26s (×5.96) | 0.32s (×7.13) | 0.33s (×7.28) | 0.23s (×5.20) | 0.32s (×7.07) | 0.34s (×7.54) | 0.29s (×6.57) | 0.41s (×9.20) | 0.41s (×9.02) | 0.34s (×7.61) | 0.41s (×9.17) | 0.34s (×7.63) | 0.48s (×10.57) | 0.47s (×10.41) | 0.37s (×8.20) | 0.33s (×7.43) | 0.41s (×9.22) | 0.40s (×8.98) | 0.46s (×10.24) | 0.44s (×9.85) | 0.52s (×11.59) | 0.53s (×11.76) | 0.73s (×16.13) | 0.46s (×10.24) | 0.56s (×12.39) | 0.60s (×13.35) | 0.71s (×15.61) | 0.70s (×15.35) | 0.50s (×11.09) | 0.57s (×12.54) | 0.56s (×12.37) | 0.58s (×12.76) | 0.65s (×14.26) | 0.70s (×15.41) | 0.62s (×13.61) | 0.67s (×14.85) | 0.66s (×14.57) | 0.61s (×13.50) | 0.87s (×19.04) | 0.86s (×19.02) | 0.75s (×16.46) | 0.68s (×15.00) | 0.68s (×14.91) | 0.72s (×15.93) | 0.96s (×21.20) | 1.28s (×28.02) | 1.12s (×24.59) | 1.19s (×26.00) | 0.81s (×17.85) | 1.12s (×24.61) | 1.25s (×27.37) | 1.36s (×29.74) | 4.02s (×87.52) | 4.82s (×105.09) | 4.89s (×106.54) | 7.81s (×170.04) | 1.89s (×41.33) | 35.35s (×768.72) | ☠ | |
| Q25. Query 25: SELECT SearchPhrase FROM {table} WHERE SearchPhrase != '' ORDER BY SearchPhrase LIMIT 10; | 0.03s (×1.00) | 0.04s (×1.25) | 0.04s (×1.30) | 0.03s (×1.02) | 0.04s (×1.20) | 0.04s (×1.23) | 0.04s (×1.38) | 0.04s (×1.13) | 0.06s (×1.68) | 0.05s (×1.48) | 0.04s (×1.35) | 0.05s (×1.40) | 0.07s (×2.10) | 0.05s (×1.55) | 0.06s (×1.80) | 0.06s (×1.77) | 0.05s (×1.50) | 0.06s (×1.63) | 0.06s (×1.63) | 0.05s (×1.50) | 0.06s (×1.65) | 0.07s (×2.02) | 0.06s (×1.68) | 0.05s (×1.55) | 0.07s (×1.93) | 0.10s (×2.67) | 0.07s (×2.07) | 0.06s (×1.75) | 0.08s (×2.15) | 0.08s (×2.17) | 0.07s (×2.00) | 0.07s (×1.88) | 0.08s (×2.32) | 0.07s (×2.00) | 0.08s (×2.27) | 0.08s (×2.32) | 0.09s (×2.38) | 0.08s (×2.17) | 0.08s (×2.20) | 0.08s (×2.32) | 0.06s (×1.75) | 0.11s (×2.97) | 0.09s (×2.60) | 0.09s (×2.47) | 0.09s (×2.45) | 0.11s (×2.97) | 0.10s (×2.65) | 0.10s (×2.77) | 0.08s (×2.30) | 0.07s (×1.98) | 0.09s (×2.50) | 0.10s (×2.77) | 0.09s (×2.50) | 0.10s (×2.82) | 0.10s (×2.87) | 0.11s (×2.92) | 0.11s (×3.05) | 0.12s (×3.15) | 0.07s (×2.10) | 0.09s (×2.52) | 0.13s (×3.43) | 0.10s (×2.75) | 0.15s (×3.90) | 0.12s (×3.27) | 0.11s (×2.95) | 0.17s (×4.55) | 0.14s (×3.68) | 0.10s (×2.73) | 0.14s (×3.75) | 0.16s (×4.20) | 0.13s (×3.55) | 0.12s (×3.30) | 0.11s (×3.05) | 0.16s (×4.20) | 0.13s (×3.58) | 0.17s (×4.55) | 0.20s (×5.13) | 0.17s (×4.55) | 0.19s (×4.92) | 0.16s (×4.15) | 0.17s (×4.63) | 0.19s (×4.92) | 0.16s (×4.20) | 0.18s (×4.65) | 0.17s (×4.48) | 0.16s (×4.20) | 0.17s (×4.60) | 0.19s (×4.98) | 0.18s (×4.78) | 0.23s (×5.95) | 0.24s (×6.22) | 0.19s (×4.90) | 0.21s (×5.53) | 0.23s (×5.90) | 0.23s (×5.90) | 0.21s (×5.60) | 0.27s (×6.98) | 0.21s (×5.58) | 0.24s (×6.27) | 0.27s (×7.08) | 0.27s (×6.93) | 0.21s (×5.53) | 0.28s (×7.18) | 0.29s (×7.42) | 0.25s (×6.60) | 0.36s (×9.20) | 0.36s (×9.30) | 0.28s (×7.30) | 0.34s (×8.88) | 0.29s (×7.42) | 0.41s (×10.42) | 0.33s (×8.55) | 0.31s (×8.10) | 0.27s (×6.98) | 0.38s (×9.75) | 0.37s (×9.60) | 0.38s (×9.70) | 0.39s (×10.00) | 0.44s (×11.20) | 0.44s (×11.15) | 0.61s (×15.40) | 0.49s (×12.57) | 0.49s (×12.55) | 0.51s (×12.93) | 0.57s (×14.45) | 0.59s (×15.05) | 0.44s (×11.15) | 0.49s (×12.47) | 0.52s (×13.13) | 0.48s (×12.15) | 0.54s (×13.75) | 0.58s (×14.82) | 0.54s (×13.78) | 0.58s (×14.70) | 0.51s (×12.88) | 0.53s (×13.48) | 0.67s (×16.88) | 0.65s (×16.57) | 0.57s (×14.62) | 0.54s (×13.80) | 0.57s (×14.45) | 0.62s (×15.82) | 0.84s (×21.22) | 1.17s (×29.53) | 0.97s (×24.55) | 0.93s (×23.57) | 0.68s (×17.28) | 0.96s (×24.17) | 0.99s (×25.05) | 1.13s (×28.50) | 3.42s (×85.63) | 4.03s (×100.88) | 3.94s (×98.75) | 6.20s (×155.32) | 1.61s (×40.42) | 30.01s (×750.60) | ☠ | |
| Q26. Query 26: SELECT SearchPhrase FROM {table} WHERE SearchPhrase != '' ORDER BY EventTime, SearchPhrase LIMIT 10; | 0.04s (×1.00) | 0.05s (×1.14) | 0.05s (×1.22) | 0.04s (×1.06) | 0.05s (×1.12) | 0.05s (×1.22) | 0.05s (×1.24) | 0.05s (×1.12) | 0.07s (×1.57) | 0.06s (×1.37) | 0.05s (×1.18) | 0.05s (×1.20) | 0.10s (×2.14) | 0.06s (×1.41) | 0.07s (×1.61) | 0.07s (×1.63) | 0.06s (×1.39) | 0.06s (×1.35) | 0.06s (×1.43) | 0.06s (×1.39) | 0.07s (×1.49) | 0.08s (×1.76) | 0.07s (×1.49) | 0.06s (×1.45) | 0.08s (×1.76) | 0.12s (×2.63) | 0.08s (×1.76) | 0.10s (×2.22) | 0.10s (×2.06) | 0.10s (×2.06) | 0.08s (×1.76) | 0.08s (×1.80) | 0.10s (×2.22) | 0.09s (×1.88) | 0.11s (×2.27) | 0.10s (×2.14) | 0.10s (×2.18) | 0.09s (×1.88) | 0.11s (×2.33) | 0.10s (×2.06) | 0.07s (×1.67) | 0.12s (×2.49) | 0.10s (×2.06) | 0.10s (×2.22) | 0.10s (×2.06) | 0.12s (×2.51) | 0.11s (×2.43) | 0.13s (×2.71) | 0.10s (×2.14) | 0.09s (×2.04) | 0.10s (×2.08) | 0.11s (×2.41) | 0.10s (×2.14) | 0.12s (×2.53) | 0.12s (×2.63) | 0.13s (×2.67) | 0.13s (×2.78) | 0.13s (×2.80) | 0.10s (×2.20) | 0.13s (×2.78) | 0.15s (×3.16) | 0.13s (×2.78) | 0.18s (×3.67) | 0.13s (×2.69) | 0.12s (×2.59) | 0.20s (×4.14) | 0.16s (×3.27) | 0.11s (×2.43) | 0.17s (×3.51) | 0.18s (×3.67) | 0.15s (×3.10) | 0.16s (×3.31) | 0.15s (×3.06) | 0.19s (×3.90) | 0.15s (×3.18) | 0.21s (×4.24) | 0.22s (×4.57) | 0.21s (×4.24) | 0.23s (×4.61) | 0.19s (×3.92) | 0.22s (×4.43) | 0.21s (×4.41) | 0.20s (×4.20) | 0.21s (×4.39) | 0.18s (×3.76) | 0.18s (×3.78) | 0.23s (×4.65) | 0.22s (×4.55) | 0.23s (×4.75) | 0.27s (×5.45) | 0.29s (×5.88) | 0.26s (×5.27) | 0.23s (×4.76) | 0.25s (×5.08) | 0.25s (×5.08) | 0.27s (×5.57) | 0.31s (×6.33) | 0.26s (×5.22) | 0.27s (×5.53) | 0.32s (×6.43) | 0.34s (×6.80) | 0.23s (×4.61) | 0.32s (×6.45) | 0.34s (×6.88) | 0.29s (×5.88) | 0.42s (×8.37) | 0.43s (×8.57) | 0.35s (×7.04) | 0.42s (×8.43) | 0.34s (×6.82) | 0.49s (×9.86) | 0.47s (×9.39) | 0.36s (×7.18) | 0.33s (×6.75) | 0.42s (×8.47) | 0.42s (×8.39) | 0.45s (×8.98) | 0.45s (×8.92) | 0.55s (×10.88) | 0.56s (×11.16) | 0.69s (×13.67) | 0.52s (×10.39) | 0.57s (×11.33) | 0.63s (×12.45) | 0.72s (×14.29) | 0.71s (×14.10) | 0.50s (×10.04) | 0.56s (×11.22) | 0.56s (×11.24) | 0.58s (×11.51) | 0.66s (×13.06) | 0.72s (×14.37) | 0.62s (×12.39) | 0.71s (×14.20) | 0.63s (×12.49) | 0.59s (×11.80) | 0.90s (×17.90) | 0.90s (×17.82) | 0.72s (×14.33) | 0.67s (×13.37) | 0.69s (×13.76) | 0.72s (×14.25) | 0.97s (×19.29) | 1.30s (×25.61) | 1.13s (×22.39) | 1.19s (×23.57) | 0.82s (×16.22) | 1.14s (×22.45) | 1.30s (×25.78) | 1.39s (×27.53) | 4.05s (×79.59) | 4.91s (×96.49) | 4.62s (×90.69) | 8.07s (×158.45) | 1.88s (×37.00) | 36.03s (×706.65) | ☠ | |
| Q27. Query 27: SELECT CounterID, avg(length(URL)) AS l, count() AS c FROM {table} WHERE URL != '' GROUP BY CounterID HAVING c > 100000 ORDER BY l DESC LIMIT 25; | 0.17s (×1.00) | 0.19s (×1.15) | 0.24s (×1.41) | 0.18s (×1.10) | 0.17s (×1.01) | 0.20s (×1.19) | 0.21s (×1.25) | 0.24s (×1.43) | 0.26s (×1.52) | 0.19s (×1.16) | 0.29s (×1.72) | 0.29s (×1.70) | 0.27s (×1.62) | 0.24s (×1.42) | 0.28s (×1.68) | 0.38s (×2.23) | 0.24s (×1.42) | 0.23s (×1.39) | 0.25s (×1.51) | 0.24s (×1.45) | 0.27s (×1.59) | 0.26s (×1.54) | 0.29s (×1.71) | 0.26s (×1.53) | 0.25s (×1.50) | 0.37s (×2.15) | 0.26s (×1.53) | 0.24s (×1.46) | 0.37s (×2.18) | 0.30s (×1.79) | 0.28s (×1.66) | 0.33s (×1.91) | 0.44s (×2.56) | 0.27s (×1.61) | 0.26s (×1.51) | 0.30s (×1.77) | 0.30s (×1.75) | 0.35s (×2.03) | 0.32s (×1.87) | 0.32s (×1.90) | 0.34s (×2.03) | 0.33s (×1.94) | 0.31s (×1.83) | 0.33s (×1.97) | 0.35s (×2.05) | 0.31s (×1.83) | 0.42s (×2.48) | 0.54s (×3.15) | 0.40s (×2.37) | 0.31s (×1.82) | 0.32s (×1.87) | 0.35s (×2.08) | 0.36s (×2.13) | 0.50s (×2.89) | 0.41s (×2.38) | 0.37s (×2.15) | 0.43s (×2.53) | 0.43s (×2.54) | 0.42s (×2.44) | 0.35s (×2.06) | 0.45s (×2.62) | 0.41s (×2.38) | 0.64s (×3.72) | 0.49s (×2.89) | 0.58s (×3.40) | 0.60s (×3.47) | 0.51s (×2.99) | 0.47s (×2.74) | 0.51s (×2.94) | 0.52s (×3.03) | 0.70s (×4.06) | 0.44s (×2.57) | 0.55s (×3.17) | 0.53s (×3.08) | 0.61s (×3.53) | 0.53s (×3.11) | 0.63s (×3.65) | 0.54s (×3.15) | 0.66s (×3.82) | 0.61s (×3.55) | 0.57s (×3.30) | 0.70s (×4.08) | 0.59s (×3.43) | 0.69s (×3.99) | 0.62s (×3.58) | 0.78s (×4.50) | 0.96s (×5.53) | 0.82s (×4.75) | 1.01s (×5.84) | 0.80s (×4.64) | 1.67s (×9.61) | 0.68s (×3.92) | 0.76s (×4.39) | 0.97s (×5.63) | 0.97s (×5.63) | 0.81s (×4.66) | 0.95s (×5.49) | 0.78s (×4.50) | 0.82s (×4.77) | 0.95s (×5.47) | 1.13s (×6.54) | 0.88s (×5.06) | 1.29s (×7.41) | 1.14s (×6.58) | 1.39s (×7.98) | 1.12s (×6.45) | 1.06s (×6.11) | 0.84s (×4.87) | 1.17s (×6.71) | 1.18s (×6.77) | 1.85s (×10.65) | 1.50s (×8.64) | 1.18s (×6.81) | 1.17s (×6.71) | 1.76s (×10.14) | 1.47s (×8.48) | 1.15s (×6.61) | 1.55s (×8.92) | 1.40s (×8.07) | 1.63s (×9.36) | 1.81s (×10.43) | 2.79s (×16.02) | 2.06s (×11.82) | 1.66s (×9.52) | 1.58s (×9.09) | 1.95s (×11.19) | 2.25s (×12.92) | 1.89s (×10.83) | 1.53s (×8.79) | 2.52s (×14.46) | 2.01s (×11.56) | 1.92s (×11.01) | 1.53s (×8.83) | 1.78s (×10.25) | 1.65s (×9.49) | 1.97s (×11.31) | 1.89s (×10.83) | 1.90s (×10.90) | 2.39s (×13.73) | 1.81s (×10.41) | 1.90s (×10.90) | 2.90s (×16.65) | 3.26s (×18.71) | 3.25s (×18.61) | 3.47s (×19.90) | 3.24s (×18.57) | 2.09s (×12.00) | 3.44s (×19.73) | 3.23s (×18.51) | 4.13s (×23.65) | 13.39s (×76.57) | 23.92s (×136.72) | 16.41s (×93.83) | 31.39s (×179.41) | 7.65s (×43.76) | 160.73s (×918.53) | ☠ | |
| Q28. Query 28: SELECT domainWithoutWWW(Referer) AS key, avg(length(Referer)) AS l, count() AS c, any(Referer) FROM {table} WHERE Referer != '' GROUP BY key HAVING c > 100000 ORDER BY l DESC LIMIT 25; | 0.16s (×1.00) | 0.27s (×1.63) | 0.30s (×1.81) | 0.17s (×1.08) | 0.19s (×1.18) | 0.27s (×1.63) | 0.24s (×1.47) | 0.41s (×2.43) | 0.37s (×2.20) | 0.25s (×1.54) | 0.31s (×1.85) | 0.21s (×1.27) | 0.36s (×2.16) | 0.26s (×1.58) | 0.33s (×1.98) | 0.47s (×2.78) | 0.22s (×1.37) | 0.24s (×1.44) | 0.27s (×1.64) | 0.25s (×1.53) | 0.30s (×1.82) | 0.32s (×1.92) | 0.26s (×1.59) | 0.29s (×1.77) | 0.34s (×2.04) | 0.55s (×3.30) | 0.36s (×2.18) | 0.28s (×1.73) | 0.44s (×2.65) | 0.46s (×2.72) | 0.26s (×1.57) | 0.37s (×2.25) | 0.64s (×3.78) | 0.36s (×2.16) | 0.33s (×2.00) | 0.39s (×2.35) | 0.40s (×2.37) | 0.40s (×2.39) | 0.41s (×2.44) | 0.41s (×2.47) | 0.32s (×1.92) | 0.35s (×2.11) | 0.45s (×2.66) | 0.40s (×2.39) | 0.41s (×2.47) | 0.31s (×1.86) | 0.61s (×3.63) | 0.55s (×3.30) | 0.50s (×2.97) | 0.35s (×2.13) | 0.46s (×2.77) | 0.45s (×2.67) | 0.41s (×2.48) | 0.72s (×4.26) | 0.62s (×3.68) | 0.55s (×3.25) | 0.66s (×3.91) | 0.67s (×3.96) | 0.46s (×2.76) | 0.48s (×2.87) | 0.66s (×3.89) | 0.49s (×2.93) | 0.86s (×5.12) | 0.69s (×4.06) | 0.57s (×3.38) | 0.88s (×5.20) | 0.80s (×4.72) | 0.58s (×3.47) | 0.77s (×4.58) | 0.75s (×4.46) | 1.56s (×9.17) | 0.72s (×4.27) | 0.75s (×4.45) | 0.79s (×4.67) | 0.79s (×4.66) | 0.81s (×4.79) | 0.96s (×5.65) | 0.80s (×4.74) | 1.06s (×6.27) | 0.89s (×5.23) | 0.80s (×4.74) | 0.99s (×5.88) | 0.87s (×5.15) | 1.11s (×6.54) | 0.78s (×4.61) | 1.03s (×6.11) | 1.27s (×7.49) | 1.28s (×7.56) | 1.24s (×7.33) | 1.39s (×8.19) | 2.12s (×12.47) | 1.01s (×5.95) | 1.07s (×6.32) | 1.49s (×8.74) | 1.49s (×8.74) | 1.06s (×6.27) | 1.43s (×8.40) | 1.28s (×7.56) | 1.27s (×7.49) | 1.45s (×8.54) | 1.64s (×9.67) | 1.16s (×6.84) | 1.93s (×11.32) | 1.59s (×9.36) | 1.90s (×11.17) | 1.75s (×10.27) | 1.67s (×9.80) | 1.54s (×9.04) | 1.96s (×11.50) | 1.93s (×11.35) | 2.61s (×15.34) | 1.97s (×11.56) | 1.75s (×10.27) | 1.72s (×10.11) | 2.27s (×13.35) | 2.15s (×12.61) | 1.69s (×9.96) | 2.63s (×15.44) | 2.42s (×14.23) | 2.58s (×15.14) | 3.02s (×17.72) | 3.32s (×19.45) | 2.96s (×17.35) | 3.08s (×18.04) | 2.67s (×15.64) | 3.04s (×17.85) | 3.03s (×17.80) | 3.27s (×19.16) | 2.31s (×13.57) | 2.93s (×17.17) | 2.90s (×16.99) | 3.25s (×19.05) | 2.43s (×14.27) | 2.71s (×15.88) | 2.82s (×16.56) | 3.18s (×18.65) | 3.21s (×18.85) | 3.19s (×18.73) | 3.51s (×20.59) | 3.09s (×18.11) | 5.40s (×31.64) | 4.52s (×26.48) | 5.13s (×30.08) | 5.21s (×30.50) | 5.41s (×31.67) | 5.17s (×30.29) | 3.83s (×22.43) | 5.39s (×31.56) | 5.26s (×30.84) | 7.38s (×43.21) | 17.05s (×99.78) | 25.92s (×151.65) | 22.17s (×129.72) | 30.30s (×177.23) | ☠ | 184.84s (×1081.00) | ☠ | |
| Q29. Query 29: SELECT sum(ResolutionWidth), sum(ResolutionWidth + 1), sum(ResolutionWidth + 2), sum(ResolutionWidth + 3), sum(ResolutionWidth + 4), sum(ResolutionWidth + 5), sum(ResolutionWidth + 6), sum(ResolutionWidth + 7), sum(ResolutionWidth + 8), sum(ResolutionWidth + 9), sum(ResolutionWidth + 10), sum(ResolutionWidth + 11), sum(ResolutionWidth + 12), sum(ResolutionWidth + 13), sum(ResolutionWidth + 14), sum(ResolutionWidth + 15), sum(ResolutionWidth + 16), sum(ResolutionWidth + 17), sum(ResolutionWidth + 18), sum(ResolutionWidth + 19), sum(ResolutionWidth + 20), sum(ResolutionWidth + 21), sum(ResolutionWidth + 22), sum(ResolutionWidth + 23), sum(ResolutionWidth + 24), sum(ResolutionWidth + 25), sum(ResolutionWidth + 26), sum(ResolutionWidth + 27), sum(ResolutionWidth + 28), sum(ResolutionWidth + 29), sum(ResolutionWidth + 30), sum(ResolutionWidth + 31), sum(ResolutionWidth + 32), sum(ResolutionWidth + 33), sum(ResolutionWidth + 34), sum(ResolutionWidth + 35), sum(ResolutionWidth + 36), sum(ResolutionWidth + 37), sum(ResolutionWidth + 38), sum(ResolutionWidth + 39), sum(ResolutionWidth + 40), sum(ResolutionWidth + 41), sum(ResolutionWidth + 42), sum(ResolutionWidth + 43), sum(ResolutionWidth + 44), sum(ResolutionWidth + 45), sum(ResolutionWidth + 46), sum(ResolutionWidth + 47), sum(ResolutionWidth + 48), sum(ResolutionWidth + 49), sum(ResolutionWidth + 50), sum(ResolutionWidth + 51), sum(ResolutionWidth + 52), sum(ResolutionWidth + 53), sum(ResolutionWidth + 54), sum(ResolutionWidth + 55), sum(ResolutionWidth + 56), sum(ResolutionWidth + 57), sum(ResolutionWidth + 58), sum(ResolutionWidth + 59), sum(ResolutionWidth + 60), sum(ResolutionWidth + 61), sum(ResolutionWidth + 62), sum(ResolutionWidth + 63), sum(ResolutionWidth + 64), sum(ResolutionWidth + 65), sum(ResolutionWidth + 66), sum(ResolutionWidth + 67), sum(ResolutionWidth + 68), sum(ResolutionWidth + 69), sum(ResolutionWidth + 70), sum(ResolutionWidth + 71), sum(ResolutionWidth + 72), sum(ResolutionWidth + 73), sum(ResolutionWidth + 74), sum(ResolutionWidth + 75), sum(ResolutionWidth + 76), sum(ResolutionWidth + 77), sum(ResolutionWidth + 78), sum(ResolutionWidth + 79), sum(ResolutionWidth + 80), sum(ResolutionWidth + 81), sum(ResolutionWidth + 82), sum(ResolutionWidth + 83), sum(ResolutionWidth + 84), sum(ResolutionWidth + 85), sum(ResolutionWidth + 86), sum(ResolutionWidth + 87), sum(ResolutionWidth + 88), sum(ResolutionWidth + 89) FROM {table}; | 0.07s (×2.41) | 0.41s (×13.19) | 0.33s (×10.56) | 0.23s (×7.56) | 0.32s (×10.44) | 0.40s (×12.69) | 0.36s (×11.50) | 0.41s (×13.06) | 0.02s (×1.03) | 0.03s (×1.34) | 0.40s (×12.81) | 0.41s (×13.00) | 0.03s (×1.19) | 0.41s (×13.06) | 0.52s (×16.41) | 0.53s (×16.81) | 0.51s (×16.09) | 0.55s (×17.47) | 0.45s (×14.38) | 0.83s (×26.16) | 0.56s (×17.75) | 0.87s (×27.59) | 0.64s (×20.28) | 0.62s (×19.69) | 0.87s (×27.38) | 0.02s (×1.00) | 0.87s (×27.50) | 0.84s (×26.47) | 0.62s (×19.72) | 0.70s (×22.13) | 0.61s (×19.41) | 1.05s (×33.09) | 0.04s (×1.47) | 0.71s (×22.44) | 0.70s (×22.25) | 1.05s (×33.28) | 1.05s (×33.28) | 1.39s (×43.69) | 0.88s (×27.81) | 0.75s (×23.69) | 0.97s (×30.75) | 0.43s (×13.78) | 0.83s (×26.41) | 1.22s (×38.56) | 0.86s (×27.28) | 0.49s (×15.69) | 1.09s (×34.31) | 0.10s (×3.47) | 0.66s (×21.06) | 0.99s (×31.28) | 2.06s (×64.62) | 0.85s (×26.78) | 1.02s (×32.19) | 1.47s (×46.16) | 1.09s (×34.50) | 0.55s (×17.56) | 1.02s (×32.28) | 1.03s (×32.47) | 2.28s (×71.69) | 0.95s (×30.09) | 1.07s (×33.81) | 0.59s (×18.91) | 0.58s (×18.47) | 0.97s (×30.75) | 2.06s (×64.78) | 0.55s (×17.34) | 1.07s (×33.84) | 1.00s (×31.53) | 1.07s (×33.81) | 0.74s (×23.50) | 0.09s (×3.25) | 1.26s (×39.66) | 3.52s (×110.19) | 0.99s (×31.31) | 1.24s (×39.13) | 1.33s (×41.91) | 0.51s (×16.09) | 1.32s (×41.66) | 1.18s (×37.19) | 2.03s (×63.78) | 1.30s (×40.94) | 1.84s (×57.75) | 1.95s (×61.31) | 1.81s (×56.88) | 1.74s (×54.59) | 1.45s (×45.59) | 3.76s (×117.87) | 3.57s (×111.97) | 2.27s (×71.25) | 1.34s (×42.25) | 4.02s (×126.06) | 1.44s (×45.28) | 1.72s (×54.09) | 3.44s (×107.91) | 3.44s (×107.91) | 1.87s (×58.75) | 1.60s (×50.31) | 3.60s (×112.91) | 1.40s (×44.03) | 1.21s (×38.00) | 3.13s (×98.28) | 3.39s (×106.19) | 3.64s (×114.12) | 1.64s (×51.69) | 3.35s (×105.06) | 0.65s (×20.66) | 2.31s (×72.56) | 1.82s (×57.28) | 1.77s (×55.63) | 3.63s (×113.59) | 2.08s (×65.37) | 1.60s (×50.22) | 2.95s (×92.41) | 3.12s (×97.69) | 3.64s (×114.19) | 4.21s (×131.81) | 2.20s (×69.03) | 2.52s (×79.19) | 2.16s (×67.94) | 2.44s (×76.59) | 1.69s (×53.13) | 4.95s (×155.12) | 5.01s (×156.78) | 2.44s (×76.72) | 5.56s (×174.06) | 1.44s (×45.22) | 3.61s (×113.00) | 3.54s (×110.97) | 3.24s (×101.53) | 3.19s (×99.87) | 2.90s (×90.91) | 4.08s (×127.75) | 2.54s (×79.75) | 2.70s (×84.78) | 4.04s (×126.47) | 3.88s (×121.44) | 4.98s (×156.00) | 4.97s (×155.50) | 2.52s (×78.91) | 3.59s (×112.59) | 4.37s (×136.91) | 11.59s (×362.47) | 3.60s (×112.81) | 2.18s (×68.53) | 4.74s (×148.50) | 6.19s (×193.78) | 3.56s (×111.56) | 4.69s (×146.75) | 6.18s (×193.41) | 6.83s (×213.72) | 8.54s (×267.34) | 23.54s (×735.81) | 16.34s (×510.84) | 32.17s (×1005.72) | 9.60s (×300.38) | 203.40s (×6356.50) | ☠ | |
| Q30. Query 30: SELECT SearchEngineID, ClientIP, count() AS c, sum(Refresh), avg(ResolutionWidth) FROM {table} WHERE SearchPhrase != '' GROUP BY SearchEngineID, ClientIP ORDER BY c DESC LIMIT 10; | 0.08s (×1.00) | 0.10s (×1.28) | 0.11s (×1.35) | 0.09s (×1.10) | 0.10s (×1.22) | 0.10s (×1.31) | 0.11s (×1.34) | 0.11s (×1.34) | 0.14s (×1.76) | 0.13s (×1.55) | 0.11s (×1.41) | 0.11s (×1.36) | 0.18s (×2.16) | 0.14s (×1.69) | 0.15s (×1.80) | 0.16s (×1.95) | 0.13s (×1.57) | 0.15s (×1.86) | 0.17s (×2.07) | 0.12s (×1.42) | 0.19s (×2.23) | 0.13s (×1.64) | 0.15s (×1.82) | 0.18s (×2.11) | 0.15s (×1.86) | 0.25s (×2.92) | 0.17s (×2.01) | 0.14s (×1.73) | 0.19s (×2.26) | 0.20s (×2.39) | 0.17s (×2.02) | 0.19s (×2.26) | 0.28s (×3.34) | 0.25s (×2.91) | 0.27s (×3.16) | 0.25s (×2.95) | 0.25s (×2.94) | 0.18s (×2.14) | 0.27s (×3.23) | 0.22s (×2.65) | 0.20s (×2.34) | 0.19s (×2.32) | 0.23s (×2.73) | 0.20s (×2.44) | 0.20s (×2.39) | 0.21s (×2.52) | 0.28s (×3.33) | 0.21s (×2.53) | 0.22s (×2.66) | 0.20s (×2.44) | 0.28s (×3.33) | 0.24s (×2.90) | 0.21s (×2.49) | 0.32s (×3.77) | 0.30s (×3.53) | 0.25s (×2.95) | 0.31s (×3.65) | 0.31s (×3.61) | 0.26s (×3.06) | 0.36s (×4.17) | 0.33s (×3.86) | 0.21s (×2.49) | 0.36s (×4.16) | 0.36s (×4.22) | 0.28s (×3.32) | 0.37s (×4.33) | 0.39s (×4.51) | 0.31s (×3.65) | 0.39s (×4.57) | 0.42s (×4.90) | 0.28s (×3.24) | 0.40s (×4.67) | 0.46s (×5.30) | 0.55s (×6.31) | 0.47s (×5.41) | 0.54s (×6.20) | 0.46s (×5.34) | 0.55s (×6.36) | 0.57s (×6.61) | 0.53s (×6.08) | 0.65s (×7.45) | 0.55s (×6.32) | 0.57s (×6.55) | 0.55s (×6.33) | 0.37s (×4.33) | 0.45s (×5.25) | 0.66s (×7.56) | 0.69s (×8.01) | 0.59s (×6.84) | 0.61s (×7.08) | 0.81s (×9.27) | 0.71s (×8.22) | 0.64s (×7.40) | 0.65s (×7.55) | 0.65s (×7.55) | 0.68s (×7.81) | 0.68s (×7.83) | 0.64s (×7.42) | 0.68s (×7.81) | 0.71s (×8.24) | 0.86s (×9.86) | 0.63s (×7.25) | 0.81s (×9.35) | 0.75s (×8.64) | 0.82s (×9.39) | 0.82s (×9.40) | 0.99s (×11.40) | 0.83s (×9.57) | 1.03s (×11.85) | 0.78s (×8.94) | 0.99s (×11.40) | 0.93s (×10.69) | 0.81s (×9.38) | 0.90s (×10.35) | 0.88s (×10.15) | 1.04s (×11.93) | 0.94s (×10.84) | 1.23s (×14.14) | 1.60s (×18.25) | 1.17s (×13.35) | 1.21s (×13.81) | 1.11s (×12.74) | 1.19s (×13.61) | 1.44s (×16.49) | 1.54s (×17.65) | 1.36s (×15.59) | 1.20s (×13.80) | 1.37s (×15.72) | 0.90s (×10.38) | 1.21s (×13.85) | 1.30s (×14.88) | 1.74s (×19.90) | 1.43s (×16.32) | 1.57s (×17.93) | 1.78s (×20.30) | 1.32s (×15.10) | 1.87s (×21.32) | 1.87s (×21.36) | 1.53s (×17.47) | 1.77s (×20.20) | 1.35s (×15.44) | 2.07s (×23.66) | 2.12s (×24.15) | 2.24s (×25.59) | 2.43s (×27.74) | 2.82s (×32.13) | 1.82s (×20.83) | 2.53s (×28.88) | 3.52s (×40.16) | 3.24s (×36.93) | 6.49s (×73.88) | 8.69s (×98.83) | 9.01s (×102.45) | 10.73s (×122.02) | 4.05s (×46.13) | 54.32s (×617.41) | ☠ | |
| Q31. Query 31: SELECT WatchID, ClientIP, count() AS c, sum(Refresh), avg(ResolutionWidth) FROM {table} WHERE SearchPhrase != '' GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10; | 0.09s (×1.00) | 0.14s (×1.43) | 0.14s (×1.47) | 0.10s (×1.10) | 0.14s (×1.42) | 0.14s (×1.48) | 0.17s (×1.72) | 0.15s (×1.54) | 0.17s (×1.75) | 0.16s (×1.61) | 0.18s (×1.86) | 0.16s (×1.65) | 0.25s (×2.48) | 0.20s (×2.06) | 0.20s (×2.01) | 0.23s (×2.31) | 0.20s (×2.01) | 0.17s (×1.76) | 0.27s (×2.71) | 0.21s (×2.15) | 0.29s (×2.91) | 0.21s (×2.13) | 0.23s (×2.32) | 0.28s (×2.80) | 0.22s (×2.24) | 0.30s (×2.94) | 0.23s (×2.34) | 0.21s (×2.15) | 0.27s (×2.72) | 0.24s (×2.42) | 0.27s (×2.68) | 0.32s (×3.16) | 0.37s (×3.68) | 0.38s (×3.79) | 0.37s (×3.69) | 0.34s (×3.37) | 0.34s (×3.38) | 0.29s (×2.88) | 0.39s (×3.81) | 0.33s (×3.26) | 0.27s (×2.65) | 0.26s (×2.61) | 0.34s (×3.37) | 0.32s (×3.13) | 0.31s (×3.12) | 0.33s (×3.23) | 0.43s (×4.22) | 0.27s (×2.73) | 0.41s (×4.02) | 0.30s (×3.03) | 0.54s (×5.26) | 0.34s (×3.39) | 0.34s (×3.32) | 0.51s (×4.95) | 0.45s (×4.39) | 0.36s (×3.53) | 0.44s (×4.31) | 0.45s (×4.40) | 0.50s (×4.93) | 0.49s (×4.86) | 0.44s (×4.34) | 0.27s (×2.73) | 0.50s (×4.89) | 0.58s (×5.67) | 0.49s (×4.84) | 0.49s (×4.81) | 0.53s (×5.21) | 0.71s (×6.94) | 0.60s (×5.87) | 0.54s (×5.29) | 0.41s (×4.03) | 0.62s (×6.03) | 0.96s (×9.32) | 0.79s (×7.68) | 0.65s (×6.32) | 0.76s (×7.41) | 0.64s (×6.27) | 0.80s (×7.80) | 0.80s (×7.79) | 0.92s (×8.90) | 0.81s (×7.88) | 0.83s (×8.12) | 0.82s (×8.01) | 0.88s (×8.55) | 0.74s (×7.18) | 0.66s (×6.42) | 1.01s (×9.80) | 1.22s (×11.80) | 0.95s (×9.19) | 0.74s (×7.22) | 1.39s (×13.41) | 1.06s (×10.32) | 0.98s (×9.49) | 1.05s (×10.22) | 1.05s (×10.22) | 1.02s (×9.89) | 0.95s (×9.25) | 1.03s (×10.03) | 0.83s (×8.10) | 0.91s (×8.85) | 1.45s (×14.00) | 1.11s (×10.79) | 1.53s (×14.85) | 1.01s (×9.82) | 1.38s (×13.35) | 1.09s (×10.56) | 1.52s (×14.74) | 1.13s (×10.99) | 1.45s (×14.05) | 1.38s (×13.38) | 1.32s (×12.76) | 1.42s (×13.70) | 1.11s (×10.75) | 1.28s (×12.45) | 1.38s (×13.33) | 1.50s (×14.48) | 1.28s (×12.39) | 1.66s (×16.05) | 2.47s (×23.81) | 1.80s (×17.43) | 1.52s (×14.69) | 2.13s (×20.53) | 1.95s (×18.88) | 2.07s (×19.97) | 2.74s (×26.47) | 1.94s (×18.75) | 1.73s (×16.69) | 2.08s (×20.11) | 1.27s (×12.31) | 1.91s (×18.49) | 1.92s (×18.51) | 2.69s (×25.97) | 2.23s (×21.51) | 2.45s (×23.64) | 2.88s (×27.80) | 1.93s (×18.63) | 2.80s (×27.05) | 2.84s (×27.44) | 1.94s (×18.77) | 2.96s (×28.59) | 1.82s (×17.56) | 3.89s (×37.49) | 2.69s (×25.92) | 2.74s (×26.48) | 3.31s (×31.88) | 4.35s (×41.90) | 2.80s (×26.99) | 3.26s (×31.47) | 5.22s (×50.25) | 4.62s (×44.48) | 9.23s (×88.88) | 14.76s (×141.97) | 17.59s (×169.18) | 17.04s (×163.89) | ☠ | 84.22s (×809.90) | ☠ | |
| Q32. Query 32: SELECT WatchID, ClientIP, count() AS c, sum(Refresh), avg(ResolutionWidth) FROM {table} GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10; | 0.75s (×1.81) | 0.95s (×2.28) | 0.70s (×1.69) | 0.41s (×1.00) | 0.67s (×1.63) | 1.03s (×2.49) | 0.88s (×2.11) | 0.82s (×1.98) | 0.86s (×2.08) | 0.73s (×1.76) | 0.85s (×2.04) | 0.85s (×2.06) | 0.94s (×2.27) | 0.89s (×2.15) | 1.39s (×3.34) | 1.36s (×3.27) | 1.03s (×2.47) | 1.00s (×2.41) | 1.70s (×4.07) | 1.53s (×3.66) | 1.78s (×4.27) | 1.66s (×3.96) | 1.09s (×2.62) | 1.78s (×4.26) | 1.79s (×4.28) | 1.65s (×3.95) | 1.81s (×4.33) | 1.24s (×2.97) | 1.48s (×3.55) | 1.51s (×3.62) | 1.07s (×2.57) | 1.63s (×3.89) | 2.14s (×5.13) | 2.38s (×5.68) | 2.39s (×5.71) | 2.16s (×5.16) | 2.15s (×5.14) | 1.59s (×3.81) | 2.50s (×5.98) | 2.02s (×4.84) | 1.16s (×2.78) | 1.44s (×3.46) | 2.03s (×4.86) | 1.84s (×4.41) | 2.08s (×4.99) | 1.17s (×2.82) | 2.86s (×6.84) | 1.67s (×3.99) | 2.22s (×5.31) | 1.65s (×3.95) | 4.08s (×9.73) | 2.01s (×4.80) | 2.41s (×5.76) | 3.48s (×8.30) | 2.93s (×7.01) | 2.43s (×5.81) | 2.87s (×6.85) | 2.89s (×6.90) | 4.11s (×9.80) | 3.58s (×8.55) | 2.73s (×6.53) | 1.70s (×4.06) | 3.06s (×7.31) | 4.24s (×10.12) | 3.74s (×8.92) | 2.66s (×6.35) | 2.73s (×6.52) | 2.77s (×6.62) | 3.37s (×8.05) | 2.85s (×6.80) | 1.78s (×4.27) | 3.84s (×9.18) | 5.57s (×13.29) | 5.50s (×13.12) | 4.68s (×11.16) | 4.43s (×10.57) | 3.35s (×8.01) | 4.64s (×11.06) | 4.59s (×10.95) | 4.97s (×11.86) | 5.88s (×14.03) | 5.07s (×12.09) | 4.82s (×11.49) | 5.54s (×13.21) | 4.04s (×9.65) | 3.80s (×9.06) | 6.99s (×16.66) | 9.07s (×21.62) | 4.36s (×10.41) | 3.96s (×9.46) | 7.13s (×17.00) | 5.83s (×13.90) | 5.70s (×13.59) | 6.74s (×16.07) | 6.74s (×16.07) | 6.02s (×14.35) | 7.97s (×18.99) | 7.60s (×18.12) | 4.61s (×11.01) | 4.69s (×11.19) | 7.98s (×19.02) | 6.84s (×16.32) | 7.94s (×18.93) | 8.89s (×21.20) | 8.91s (×21.25) | 5.85s (×13.95) | 8.73s (×20.82) | ☠ | 8.83s (×21.04) | 10.22s (×24.36) | 8.18s (×19.51) | 6.24s (×14.89) | 7.69s (×18.33) | 64.49s (×153.57) | 9.14s (×21.78) | 8.96s (×21.37) | 7.13s (×16.99) | 12.62s (×30.07) | 16.56s (×39.46) | 13.70s (×32.64) | 8.94s (×21.32) | 11.17s (×26.61) | 10.86s (×25.87) | 11.11s (×26.48) | 19.21s (×45.77) | 10.34s (×24.63) | 11.71s (×27.91) | 10.76s (×25.65) | 5.32s (×12.69) | 10.41s (×24.81) | 10.39s (×24.77) | 18.85s (×44.91) | ☠ | 15.01s (×35.77) | 20.85s (×49.68) | 11.64s (×27.75) | 17.15s (×40.87) | 16.59s (×39.53) | ☠ | ☠ | 13.41s (×31.94) | 21.42s (×51.02) | 16.91s (×40.28) | 13.96s (×33.25) | 20.75s (×49.42) | 27.31s (×65.06) | ☠ | 20.41s (×48.62) | 41.11s (×97.90) | 29.95s (×71.32) | 39.55s (×94.20) | ☠ | ☠ | ☠ | ☠ | ☠ | ☠ | |
| Q33. Query 33: SELECT URL, count() AS c FROM {table} GROUP BY URL ORDER BY c DESC LIMIT 10; | 0.37s (×1.04) | 0.63s (×1.75) | 0.62s (×1.72) | 0.36s (×1.00) | 0.52s (×1.44) | 0.72s (×1.99) | 0.63s (×1.74) | 0.74s (×2.05) | 0.87s (×2.41) | 0.58s (×1.60) | 0.65s (×1.80) | 0.60s (×1.66) | 0.86s (×2.36) | 0.72s (×2.00) | 0.87s (×2.40) | 1.04s (×2.85) | 0.64s (×1.77) | 0.77s (×2.14) | 0.93s (×2.55) | 1.03s (×2.83) | 0.98s (×2.69) | 1.13s (×3.09) | 0.80s (×2.20) | 0.99s (×2.72) | 1.02s (×2.80) | 1.45s (×3.98) | 1.06s (×2.92) | 0.78s (×2.15) | 1.08s (×2.98) | 1.30s (×3.57) | 0.96s (×2.63) | 1.20s (×3.30) | 1.99s (×5.46) | 1.12s (×3.08) | 1.13s (×3.12) | 1.27s (×3.48) | 1.26s (×3.46) | 1.01s (×2.77) | 1.31s (×3.60) | 0.92s (×2.54) | 0.97s (×2.68) | 0.80s (×2.20) | 1.00s (×2.75) | 1.07s (×2.94) | 1.04s (×2.85) | 0.90s (×2.47) | 1.55s (×4.26) | 1.42s (×3.90) | 1.23s (×3.37) | 1.13s (×3.11) | 2.51s (×6.87) | 1.14s (×3.12) | 1.17s (×3.22) | 1.82s (×4.98) | 1.57s (×4.31) | 1.27s (×3.48) | 1.59s (×4.36) | 1.59s (×4.35) | 2.82s (×7.72) | 1.86s (×5.11) | 1.76s (×4.81) | 1.26s (×3.47) | 2.19s (×5.98) | 2.22s (×6.09) | 2.50s (×6.83) | 2.15s (×5.87) | 1.95s (×5.35) | 2.03s (×5.57) | 1.98s (×5.42) | 2.02s (×5.54) | 1.62s (×4.45) | 1.95s (×5.34) | 3.40s (×9.29) | 2.33s (×6.37) | 2.63s (×7.19) | 2.29s (×6.26) | 2.29s (×6.26) | 2.34s (×6.40) | 2.70s (×7.38) | 2.74s (×7.50) | 2.67s (×7.29) | 2.65s (×7.26) | 2.66s (×7.28) | 3.03s (×8.29) | 2.52s (×6.90) | 3.24s (×8.85) | 4.07s (×11.11) | 5.70s (×15.56) | 3.86s (×10.54) | 3.00s (×8.20) | 5.53s (×15.09) | 2.80s (×7.65) | 3.08s (×8.41) | 4.66s (×12.71) | 4.66s (×12.71) | 3.29s (×9.00) | 4.05s (×11.06) | 4.51s (×12.32) | 3.40s (×9.28) | 3.45s (×9.42) | 4.28s (×11.68) | 4.96s (×13.53) | 5.17s (×14.11) | 7.37s (×20.11) | 4.92s (×13.43) | 4.01s (×10.95) | 4.32s (×11.80) | 3.83s (×10.46) | 4.96s (×13.54) | 5.94s (×16.22) | 6.41s (×17.50) | 5.06s (×13.81) | 5.80s (×15.84) | 4.74s (×12.95) | 5.50s (×15.03) | 5.22s (×14.26) | 4.59s (×12.55) | 9.23s (×25.17) | 6.94s (×18.95) | 7.18s (×19.60) | 5.83s (×15.90) | 8.57s (×23.38) | 7.83s (×21.37) | 7.92s (×21.59) | 8.30s (×22.65) | 6.74s (×18.38) | 9.12s (×24.88) | 7.63s (×20.82) | 3.11s (×8.50) | 7.40s (×20.20) | 8.10s (×22.09) | 8.48s (×23.12) | 6.37s (×17.38) | 7.70s (×21.01) | 8.62s (×23.52) | 9.15s (×24.96) | 7.68s (×20.95) | 7.74s (×21.11) | 11.54s (×31.46) | 8.50s (×23.19) | 9.46s (×25.82) | 12.50s (×34.09) | 12.81s (×34.93) | 10.63s (×29.00) | 15.24s (×41.56) | 14.07s (×38.35) | ☠ | 14.77s (×40.26) | 16.55s (×45.11) | 14.13s (×38.52) | 29.57s (×80.60) | 74.10s (×201.94) | ☠ | 67.56s (×184.10) | ☠ | 403.72s (×1100.08) | ☠ | |
| Q34. Query 34: SELECT 1, URL, count() AS c FROM {table} GROUP BY 1, URL ORDER BY c DESC LIMIT 10; | 0.36s (×1.00) | 0.64s (×1.74) | 0.63s (×1.70) | 0.42s (×1.15) | 0.54s (×1.47) | 0.68s (×1.83) | 0.62s (×1.68) | 0.70s (×1.89) | 0.89s (×2.39) | 0.57s (×1.55) | 0.65s (×1.75) | 0.60s (×1.64) | 0.87s (×2.36) | 0.68s (×1.84) | 0.89s (×2.39) | 1.03s (×2.77) | 0.65s (×1.75) | 0.84s (×2.27) | 0.96s (×2.59) | 0.98s (×2.64) | 0.99s (×2.67) | 1.17s (×3.15) | 0.81s (×2.18) | 0.98s (×2.65) | 1.02s (×2.75) | 1.43s (×3.84) | 1.05s (×2.83) | 0.79s (×2.14) | 1.08s (×2.91) | 1.29s (×3.46) | 0.89s (×2.41) | 1.19s (×3.19) | 1.94s (×5.21) | 1.22s (×3.27) | 1.15s (×3.08) | 1.29s (×3.46) | 1.25s (×3.37) | 1.01s (×2.73) | 1.33s (×3.58) | 0.96s (×2.58) | 0.96s (×2.58) | 0.82s (×2.23) | 1.14s (×3.06) | 1.07s (×2.89) | 1.05s (×2.82) | 0.92s (×2.47) | 1.54s (×4.14) | 1.37s (×3.69) | 1.22s (×3.27) | 1.11s (×3.00) | 2.54s (×6.79) | 1.07s (×2.88) | 1.21s (×3.24) | 1.81s (×4.86) | 1.57s (×4.22) | 1.28s (×3.45) | 1.57s (×4.22) | 1.59s (×4.27) | 2.84s (×7.61) | 1.93s (×5.18) | 1.73s (×4.65) | 1.18s (×3.16) | 2.18s (×5.84) | 2.11s (×5.66) | 2.54s (×6.81) | 2.14s (×5.73) | 1.90s (×5.10) | 2.02s (×5.41) | 1.99s (×5.34) | 1.83s (×4.91) | 1.64s (×4.40) | 1.93s (×5.17) | 3.43s (×9.17) | 2.65s (×7.10) | 2.56s (×6.85) | 2.26s (×6.05) | 2.27s (×6.09) | 2.43s (×6.51) | 2.71s (×7.25) | 2.77s (×7.42) | 2.79s (×7.48) | 2.68s (×7.18) | 2.69s (×7.19) | 3.02s (×8.07) | 2.48s (×6.65) | 3.03s (×8.10) | 4.03s (×10.78) | 5.79s (×15.46) | 3.96s (×10.59) | 3.05s (×8.16) | 5.53s (×14.76) | 2.85s (×7.62) | 2.96s (×7.92) | 4.67s (×12.48) | 4.67s (×12.48) | 3.41s (×9.12) | 3.97s (×10.62) | 4.69s (×12.52) | 3.48s (×9.30) | 3.43s (×9.17) | 4.30s (×11.49) | 4.97s (×13.29) | 5.25s (×14.02) | 7.24s (×19.32) | 4.96s (×13.24) | 4.01s (×10.73) | 4.30s (×11.49) | 3.98s (×10.64) | 5.08s (×13.57) | 5.92s (×15.81) | 6.45s (×17.22) | 5.05s (×13.51) | 5.77s (×15.42) | 4.66s (×12.45) | 5.47s (×14.63) | 5.35s (×14.30) | 4.61s (×12.33) | 9.28s (×24.78) | 6.96s (×18.58) | 7.78s (×20.76) | 6.34s (×16.93) | 8.61s (×22.98) | 7.87s (×21.02) | 8.12s (×21.69) | 8.28s (×22.10) | 6.68s (×17.83) | 9.21s (×24.59) | 7.59s (×20.27) | 3.13s (×8.38) | 7.46s (×19.92) | 8.05s (×21.49) | 8.41s (×22.44) | 6.39s (×17.07) | 7.70s (×20.56) | 8.76s (×23.38) | 9.18s (×24.51) | 7.78s (×20.77) | 7.69s (×20.54) | 11.02s (×29.42) | 8.53s (×22.78) | 8.46s (×22.59) | 12.62s (×33.69) | 12.73s (×33.97) | 10.57s (×28.22) | 15.22s (×40.61) | 13.87s (×37.01) | ☠ | 14.84s (×39.59) | 16.22s (×43.28) | 14.00s (×37.35) | 29.56s (×78.85) | 59.37s (×158.34) | ☠ | 67.62s (×180.35) | ☠ | 397.25s (×1059.37) | ☠ | |
| Q35. Query 35: SELECT ClientIP AS x, x - 1, x - 2, x - 3, count() AS c FROM {table} GROUP BY x, x - 1, x - 2, x - 3 ORDER BY c DESC LIMIT 10; | 0.06s (×1.00) | 0.17s (×2.60) | 0.18s (×2.78) | 0.12s (×1.96) | 0.18s (×2.76) | 0.17s (×2.68) | 0.21s (×3.29) | 0.17s (×2.60) | 0.29s (×4.37) | 0.10s (×1.56) | 0.22s (×3.43) | 0.21s (×3.19) | 0.14s (×2.25) | 0.24s (×3.74) | 0.29s (×4.44) | 0.27s (×4.13) | 0.22s (×3.41) | 0.25s (×3.78) | 0.28s (×4.34) | 0.36s (×5.51) | 0.30s (×4.56) | 0.27s (×4.10) | 0.28s (×4.19) | 0.29s (×4.47) | 0.33s (×5.01) | 0.59s (×8.87) | 0.33s (×4.99) | 0.29s (×4.47) | 0.46s (×6.88) | 0.38s (×5.72) | 0.29s (×4.38) | 0.38s (×5.76) | 0.21s (×3.29) | 0.47s (×7.10) | 0.46s (×6.87) | 0.39s (×5.91) | 0.39s (×5.88) | 0.32s (×4.90) | 0.45s (×6.75) | 0.36s (×5.44) | 0.30s (×4.63) | 0.35s (×5.25) | 0.42s (×6.40) | 0.33s (×4.99) | 0.33s (×4.93) | 0.31s (×4.72) | 0.54s (×8.12) | 0.21s (×3.29) | 0.43s (×6.49) | 0.38s (×5.78) | 0.73s (×10.91) | 0.36s (×5.40) | 0.42s (×6.34) | 0.60s (×9.01) | 0.73s (×10.93) | 0.53s (×7.94) | 0.71s (×10.60) | 0.70s (×10.49) | 0.70s (×10.38) | 0.79s (×11.69) | 0.70s (×10.40) | 0.47s (×7.06) | 0.69s (×10.31) | 0.89s (×13.24) | 0.65s (×9.65) | 0.63s (×9.43) | 0.77s (×11.41) | 0.62s (×9.21) | 0.82s (×12.16) | 0.74s (×10.97) | 0.21s (×3.28) | 0.85s (×12.62) | 1.17s (×17.28) | 0.95s (×14.19) | 0.70s (×10.46) | 0.89s (×13.21) | 0.72s (×10.69) | 0.90s (×13.31) | 1.05s (×15.56) | 1.05s (×15.60) | 1.01s (×15.01) | 1.07s (×15.91) | 1.00s (×14.84) | 1.09s (×16.12) | 0.98s (×14.59) | 1.00s (×14.81) | 1.78s (×26.40) | 1.95s (×28.76) | 1.12s (×16.57) | 1.09s (×16.13) | 1.44s (×21.31) | 1.26s (×18.62) | 1.28s (×19.04) | 1.34s (×19.87) | 1.34s (×19.87) | 1.31s (×19.38) | 1.20s (×17.85) | 1.49s (×22.09) | 1.27s (×18.88) | 1.25s (×18.47) | 1.75s (×25.87) | 1.57s (×23.25) | 2.04s (×30.15) | 1.15s (×17.06) | 1.74s (×25.78) | 1.19s (×17.71) | 1.76s (×26.01) | 1.41s (×20.82) | 1.80s (×26.62) | 1.76s (×25.97) | 2.16s (×31.94) | 1.87s (×27.62) | 1.64s (×24.25) | 1.53s (×22.60) | 1.93s (×28.57) | 1.91s (×28.24) | 1.63s (×24.12) | 2.94s (×43.35) | 2.99s (×44.13) | 2.20s (×32.44) | 2.28s (×33.74) | 2.89s (×42.63) | 2.78s (×40.99) | 3.04s (×44.79) | 3.24s (×47.84) | 2.28s (×33.65) | 2.95s (×43.54) | 3.04s (×44.88) | 1.14s (×16.91) | 2.22s (×32.81) | 2.68s (×39.53) | 3.40s (×50.10) | 2.32s (×34.21) | 2.55s (×37.63) | 3.84s (×56.57) | 2.81s (×41.50) | 3.50s (×51.63) | 3.43s (×50.53) | 3.17s (×46.72) | 3.48s (×51.28) | 2.81s (×41.51) | 5.45s (×80.25) | 3.89s (×57.32) | 4.09s (×60.24) | 5.37s (×79.15) | 5.11s (×75.25) | 3.40s (×50.10) | 5.24s (×77.13) | 6.26s (×92.15) | 5.41s (×79.68) | 8.34s (×122.75) | 14.81s (×217.90) | ☠ | 18.47s (×271.81) | ☠ | 79.60s (×1170.79) | ☠ | |
| Q36. Query 36: SELECT URL, count() AS PageViews FROM {table} WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT DontCountHits AND NOT Refresh AND notEmpty(URL) GROUP BY URL ORDER BY PageViews DESC LIMIT 10; | 0.04s (×1.18) | 0.06s (×1.77) | 0.03s (×1.00) | 0.04s (×1.26) | 0.04s (×1.18) | 0.06s (×1.74) | 0.03s (×1.05) | 0.03s (×1.10) | 0.03s (×1.00) | 0.04s (×1.15) | 0.07s (×1.95) | 0.14s (×3.92) | 0.04s (×1.15) | 0.13s (×3.64) | 0.04s (×1.18) | 0.04s (×1.36) | 0.13s (×3.69) | 0.14s (×3.87) | 0.13s (×3.49) | 0.06s (×1.85) | 0.13s (×3.56) | 0.05s (×1.56) | 0.17s (×4.56) | 0.14s (×3.72) | 0.15s (×4.08) | 0.03s (×1.03) | 0.16s (×4.44) | 0.14s (×3.92) | 0.08s (×2.31) | 0.08s (×2.21) | 0.17s (×4.69) | 0.16s (×4.36) | 0.05s (×1.51) | 0.19s (×5.05) | 0.18s (×4.92) | 0.16s (×4.33) | 0.16s (×4.46) | 0.20s (×5.36) | 0.17s (×4.59) | 0.15s (×4.23) | 0.18s (×4.95) | 0.13s (×3.46) | 0.17s (×4.74) | 0.21s (×5.77) | 0.22s (×5.85) | 0.24s (×6.31) | 0.14s (×3.85) | 0.09s (×2.62) | 0.23s (×6.08) | 0.15s (×4.05) | 0.08s (×2.36) | 0.16s (×4.28) | 0.20s (×5.44) | 0.15s (×4.13) | 0.14s (×3.97) | 0.23s (×6.23) | 0.14s (×3.85) | 0.14s (×3.92) | 0.09s (×2.64) | 0.21s (×5.77) | 0.17s (×4.64) | 0.09s (×2.56) | 0.06s (×1.67) | 0.22s (×5.85) | 0.07s (×2.13) | 0.11s (×3.03) | 0.17s (×4.64) | 0.23s (×6.28) | 0.15s (×4.21) | 0.19s (×5.21) | 0.06s (×1.85) | 0.22s (×5.92) | 0.12s (×3.44) | 0.16s (×4.46) | 0.29s (×7.79) | 0.20s (×5.44) | 0.22s (×5.95) | 0.21s (×5.54) | 0.15s (×4.10) | 0.20s (×5.49) | 0.21s (×5.69) | 0.18s (×4.85) | 0.22s (×5.92) | 0.17s (×4.59) | 0.25s (×6.62) | 0.13s (×3.56) | 0.13s (×3.54) | 0.10s (×2.95) | 0.22s (×5.79) | 0.17s (×4.56) | 0.07s (×2.00) | 0.28s (×7.44) | 0.24s (×6.54) | 0.12s (×3.33) | 0.12s (×3.33) | 0.21s (×5.77) | 0.12s (×3.31) | 0.13s (×3.62) | 0.25s (×6.62) | 0.20s (×5.36) | 0.14s (×3.90) | 0.27s (×7.15) | 0.12s (×3.31) | 0.12s (×3.28) | 0.15s (×4.21) | 0.21s (×5.59) | 0.16s (×4.36) | 0.20s (×5.46) | 0.17s (×4.54) | 0.22s (×5.79) | 0.07s (×2.10) | 0.09s (×2.49) | 0.25s (×6.74) | 0.28s (×7.56) | 0.16s (×4.28) | 0.32s (×8.56) | 0.42s (×11.03) | 0.11s (×3.10) | 0.16s (×4.41) | 0.23s (×6.05) | 0.18s (×4.92) | 0.12s (×3.21) | 0.17s (×4.51) | 0.20s (×5.49) | 0.17s (×4.59) | 0.18s (×4.90) | 0.16s (×4.28) | 0.31s (×8.15) | 0.70s (×18.31) | 0.41s (×10.67) | 0.22s (×5.82) | 0.21s (×5.64) | 0.15s (×4.23) | 0.25s (×6.64) | 0.25s (×6.59) | 0.23s (×6.05) | 0.26s (×7.00) | 0.25s (×6.72) | 0.12s (×3.44) | 0.24s (×6.38) | 0.39s (×10.28) | 0.28s (×7.44) | 0.18s (×4.77) | 0.16s (×4.33) | 0.21s (×5.72) | 0.27s (×7.23) | 0.18s (×4.92) | 0.22s (×5.82) | 0.24s (×6.33) | 0.22s (×5.82) | 0.91s (×23.64) | 0.80s (×20.87) | 1.34s (×34.67) | 0.96s (×24.90) | ☠ | 3.44s (×88.49) | ☠ | |
| Q37. Query 37: SELECT Title, count() AS PageViews FROM {table} WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT DontCountHits AND NOT Refresh AND notEmpty(Title) GROUP BY Title ORDER BY PageViews DESC LIMIT 10; | 0.03s (×1.23) | 0.03s (×1.20) | 0.02s (×1.13) | 0.03s (×1.30) | 0.02s (×1.10) | 0.03s (×1.33) | 0.02s (×1.00) | 0.02s (×1.10) | 0.03s (×1.33) | 0.03s (×1.17) | 0.03s (×1.30) | 0.06s (×2.33) | 0.02s (×1.13) | 0.06s (×2.17) | 0.02s (×1.13) | 0.03s (×1.27) | 0.06s (×2.33) | 0.07s (×2.53) | 0.05s (×1.97) | 0.03s (×1.20) | 0.05s (×2.13) | 0.04s (×1.60) | 0.07s (×2.67) | 0.06s (×2.17) | 0.06s (×2.37) | 0.02s (×1.00) | 0.07s (×2.63) | 0.07s (×2.53) | 0.04s (×1.57) | 0.04s (×1.77) | 0.07s (×2.60) | 0.06s (×2.27) | 0.03s (×1.40) | 0.07s (×2.63) | 0.07s (×2.67) | 0.07s (×2.53) | 0.07s (×2.63) | 0.09s (×3.37) | 0.06s (×2.37) | 0.07s (×2.70) | 0.07s (×2.53) | 0.06s (×2.20) | 0.08s (×3.03) | 0.10s (×3.67) | 0.09s (×3.33) | 0.10s (×3.60) | 0.06s (×2.27) | 0.06s (×2.47) | 0.10s (×3.67) | 0.06s (×2.40) | 0.04s (×1.50) | 0.08s (×2.87) | 0.09s (×3.37) | 0.06s (×2.27) | 0.05s (×2.10) | 0.10s (×3.60) | 0.06s (×2.20) | 0.06s (×2.20) | 0.06s (×2.23) | 0.07s (×2.70) | 0.07s (×2.50) | 0.04s (×1.83) | 0.03s (×1.27) | 0.08s (×2.90) | 0.06s (×2.27) | 0.05s (×2.07) | 0.06s (×2.43) | 0.09s (×3.20) | 0.06s (×2.27) | 0.08s (×2.93) | 0.05s (×1.93) | 0.09s (×3.20) | 0.05s (×2.07) | 0.07s (×2.50) | 0.14s (×4.90) | 0.08s (×3.07) | 0.10s (×3.63) | 0.08s (×3.03) | 0.06s (×2.23) | 0.07s (×2.80) | 0.08s (×3.03) | 0.09s (×3.23) | 0.09s (×3.20) | 0.07s (×2.73) | 0.14s (×5.17) | 0.06s (×2.40) | 0.05s (×2.03) | 0.04s (×1.67) | 0.08s (×3.07) | 0.07s (×2.50) | 0.02s (×1.13) | 0.10s (×3.67) | 0.08s (×3.07) | 0.05s (×1.90) | 0.05s (×1.90) | 0.09s (×3.23) | 0.06s (×2.20) | 0.06s (×2.20) | 0.10s (×3.53) | 0.07s (×2.67) | 0.05s (×1.90) | 0.10s (×3.70) | 0.05s (×1.93) | 0.05s (×2.10) | 0.06s (×2.17) | 0.09s (×3.40) | 0.06s (×2.37) | 0.08s (×3.13) | 0.06s (×2.27) | 0.09s (×3.17) | 0.03s (×1.30) | 0.04s (×1.77) | 0.11s (×3.90) | 0.10s (×3.57) | 0.07s (×2.83) | 0.12s (×4.47) | 0.19s (×6.77) | 0.04s (×1.70) | 0.06s (×2.43) | 0.07s (×2.67) | 0.07s (×2.63) | 0.05s (×1.97) | 0.06s (×2.47) | 0.09s (×3.30) | 0.07s (×2.53) | 0.09s (×3.17) | 0.07s (×2.50) | 0.12s (×4.20) | 0.38s (×13.00) | 0.18s (×6.43) | 0.08s (×3.07) | 0.07s (×2.70) | 0.06s (×2.43) | 0.10s (×3.63) | 0.09s (×3.33) | 0.10s (×3.50) | 0.09s (×3.47) | 0.09s (×3.43) | 0.05s (×1.93) | 0.08s (×3.13) | 0.19s (×6.80) | 0.10s (×3.57) | 0.07s (×2.57) | 0.07s (×2.63) | 0.09s (×3.17) | 0.09s (×3.47) | 0.07s (×2.53) | 0.09s (×3.47) | 0.08s (×2.90) | 0.09s (×3.47) | 0.51s (×17.23) | 0.32s (×11.00) | 0.35s (×12.10) | 0.46s (×15.67) | 0.34s (×11.80) | 1.55s (×51.87) | ☠ | |
| Q38. Query 38: SELECT URL, count() AS PageViews FROM {table} WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT Refresh AND IsLink AND NOT IsDownload GROUP BY URL ORDER BY PageViews DESC LIMIT 1000; | 0.02s (×1.28) | 0.02s (×1.36) | 0.02s (×1.04) | 0.03s (×1.48) | 0.02s (×1.24) | 0.03s (×1.52) | 0.02s (×1.20) | 0.02s (×1.32) | 0.02s (×1.20) | 0.02s (×1.28) | 0.03s (×1.52) | 0.05s (×2.52) | 0.02s (×1.16) | 0.05s (×2.52) | 0.02s (×1.20) | 0.02s (×1.24) | 0.04s (×1.80) | 0.05s (×2.52) | 0.03s (×1.56) | 0.03s (×1.60) | 0.03s (×1.56) | 0.02s (×1.28) | 0.06s (×2.76) | 0.03s (×1.56) | 0.06s (×2.60) | 0.01s (×1.00) | 0.06s (×2.76) | 0.06s (×2.96) | 0.04s (×1.80) | 0.04s (×1.80) | 0.06s (×2.80) | 0.05s (×2.52) | 0.02s (×1.24) | 0.06s (×2.88) | 0.06s (×2.92) | 0.06s (×2.84) | 0.06s (×2.88) | 0.08s (×3.56) | 0.06s (×2.64) | 0.05s (×2.36) | 0.06s (×2.88) | 0.08s (×3.52) | 0.07s (×3.40) | 0.08s (×3.64) | 0.08s (×3.56) | 0.08s (×3.76) | 0.03s (×1.76) | 0.07s (×3.08) | 0.09s (×3.84) | 0.05s (×2.48) | 0.03s (×1.76) | 0.04s (×2.12) | 0.10s (×4.20) | 0.03s (×1.76) | 0.04s (×1.80) | 0.09s (×3.96) | 0.04s (×1.88) | 0.04s (×1.80) | 0.04s (×2.12) | 0.07s (×3.00) | 0.06s (×2.88) | 0.04s (×2.04) | 0.02s (×1.36) | 0.07s (×3.12) | 0.07s (×3.12) | 0.04s (×2.08) | 0.06s (×2.76) | 0.07s (×3.32) | 0.04s (×1.92) | 0.07s (×3.24) | 0.04s (×1.96) | 0.08s (×3.52) | 0.05s (×2.32) | 0.04s (×1.88) | 0.08s (×3.68) | 0.07s (×3.36) | 0.08s (×3.76) | 0.07s (×3.40) | 0.04s (×1.80) | 0.07s (×3.04) | 0.07s (×3.40) | 0.04s (×1.92) | 0.07s (×3.40) | 0.04s (×1.88) | 0.13s (×5.76) | 0.05s (×2.40) | 0.05s (×2.28) | 0.04s (×1.92) | 0.07s (×3.20) | 0.06s (×2.60) | 0.02s (×1.24) | 0.08s (×3.68) | 0.08s (×3.44) | 0.04s (×2.12) | 0.04s (×2.12) | 0.07s (×3.36) | 0.04s (×2.12) | 0.05s (×2.32) | 0.09s (×4.00) | 0.06s (×2.92) | 0.04s (×2.04) | 0.09s (×4.08) | 0.04s (×2.16) | 0.04s (×2.12) | 0.05s (×2.48) | 0.08s (×3.76) | 0.06s (×2.84) | 0.07s (×3.36) | 0.04s (×1.88) | 0.07s (×3.36) | 0.03s (×1.44) | 0.04s (×2.00) | 0.08s (×3.68) | 0.08s (×3.52) | 0.07s (×3.12) | 0.10s (×4.60) | 0.16s (×6.92) | 0.04s (×1.88) | 0.06s (×2.64) | 0.06s (×2.92) | 0.06s (×2.92) | 0.04s (×2.20) | 0.06s (×2.72) | 0.06s (×2.80) | 0.05s (×2.52) | 0.07s (×3.12) | 0.06s (×2.88) | 0.10s (×4.24) | 0.33s (×13.48) | 0.14s (×6.16) | 0.07s (×3.28) | 0.07s (×3.04) | 0.05s (×2.52) | 0.08s (×3.60) | 0.07s (×3.16) | 0.07s (×3.24) | 0.08s (×3.76) | 0.09s (×3.84) | 0.05s (×2.32) | 0.07s (×3.32) | 0.14s (×6.20) | 0.09s (×4.12) | 0.06s (×2.96) | 0.06s (×2.88) | 0.08s (×3.56) | 0.09s (×3.96) | 0.06s (×2.76) | 0.09s (×3.80) | 0.07s (×3.36) | 0.08s (×3.76) | 0.45s (×18.32) | 0.27s (×11.00) | 0.35s (×14.24) | 0.47s (×19.28) | 0.31s (×12.88) | 1.73s (×69.48) | ☠ | |
| Q39. Query 39: SELECT TraficSourceID, SearchEngineID, AdvEngineID, ((SearchEngineID = 0 AND AdvEngineID = 0) ? Referer : '') AS Src, URL AS Dst, count() AS PageViews FROM {table} WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT Refresh GROUP BY TraficSourceID, SearchEngineID, AdvEngineID, Src, Dst ORDER BY PageViews DESC LIMIT 1000; | 0.05s (×1.08) | 0.13s (×2.31) | 0.06s (×1.15) | 0.08s (×1.46) | 0.06s (×1.22) | 0.15s (×2.64) | 0.06s (×1.25) | 0.07s (×1.31) | 0.05s (×1.07) | 0.06s (×1.15) | 0.17s (×3.02) | 0.32s (×5.56) | 0.06s (×1.22) | 0.31s (×5.46) | 0.08s (×1.53) | 0.08s (×1.46) | 0.31s (×5.42) | 0.36s (×6.20) | 0.30s (×5.32) | 0.14s (×2.46) | 0.26s (×4.63) | 0.07s (×1.41) | 0.40s (×6.92) | 0.32s (×5.51) | 0.34s (×5.97) | 0.05s (×1.00) | 0.37s (×6.37) | 0.37s (×6.47) | 0.16s (×2.93) | 0.18s (×3.15) | 0.38s (×6.64) | 0.34s (×5.95) | 0.07s (×1.41) | 0.41s (×7.05) | 0.40s (×6.93) | 0.33s (×5.75) | 0.34s (×6.00) | 0.41s (×7.03) | 0.36s (×6.36) | 0.32s (×5.53) | 0.35s (×6.15) | 0.26s (×4.61) | 0.35s (×6.12) | 0.45s (×7.76) | 0.47s (×8.10) | 0.52s (×8.98) | 0.34s (×5.97) | 0.14s (×2.59) | 0.48s (×8.24) | 0.34s (×5.86) | 0.22s (×3.86) | 0.34s (×5.98) | 0.44s (×7.69) | 0.38s (×6.54) | 0.32s (×5.63) | 0.47s (×8.15) | 0.31s (×5.42) | 0.32s (×5.59) | 0.13s (×2.34) | 0.43s (×7.49) | 0.39s (×6.80) | 0.19s (×3.39) | 0.12s (×2.19) | 0.44s (×7.59) | 0.11s (×2.02) | 0.23s (×4.03) | 0.35s (×6.17) | 0.45s (×7.85) | 0.33s (×5.75) | 0.42s (×7.32) | 0.09s (×1.75) | 0.40s (×7.00) | 0.27s (×4.66) | 0.38s (×6.66) | 0.55s (×9.53) | 0.44s (×7.63) | 0.45s (×7.73) | 0.49s (×8.56) | 0.32s (×5.66) | 0.44s (×7.59) | 0.45s (×7.73) | 0.39s (×6.80) | 0.43s (×7.49) | 0.34s (×6.02) | 0.48s (×8.27) | 0.28s (×4.95) | 0.28s (×4.88) | 0.23s (×4.08) | 0.43s (×7.54) | 0.37s (×6.51) | 0.13s (×2.44) | 0.53s (×9.20) | 0.42s (×7.22) | 0.25s (×4.41) | 0.25s (×4.41) | 0.42s (×7.27) | 0.25s (×4.36) | 0.30s (×5.22) | 0.55s (×9.49) | 0.41s (×7.14) | 0.24s (×4.32) | 0.51s (×8.85) | 0.24s (×4.24) | 0.24s (×4.29) | 0.31s (×5.41) | 0.44s (×7.61) | 0.32s (×5.59) | 0.45s (×7.76) | 0.35s (×6.17) | 0.45s (×7.71) | 0.15s (×2.80) | 0.17s (×3.14) | 0.46s (×7.98) | 0.51s (×8.83) | 0.34s (×5.98) | 0.56s (×9.71) | 0.79s (×13.54) | 0.27s (×4.68) | 0.33s (×5.78) | 0.40s (×7.02) | 0.38s (×6.64) | 0.28s (×4.86) | 0.38s (×6.58) | 0.45s (×7.71) | 0.32s (×5.66) | 0.37s (×6.51) | 0.27s (×4.73) | 0.53s (×9.15) | 1.50s (×25.64) | 0.81s (×13.92) | 0.47s (×8.19) | 0.40s (×6.88) | 0.31s (×5.49) | 0.53s (×9.07) | 0.47s (×8.12) | 0.45s (×7.75) | 0.48s (×8.31) | 0.50s (×8.58) | 0.27s (×4.71) | 0.47s (×8.15) | 0.90s (×15.34) | 0.46s (×8.03) | 0.40s (×6.93) | 0.38s (×6.53) | 0.55s (×9.47) | 0.58s (×10.03) | 0.38s (×6.64) | 0.55s (×9.44) | 0.49s (×8.51) | 0.46s (×7.95) | 1.82s (×30.97) | 1.71s (×29.15) | 1.88s (×32.00) | 1.93s (×32.86) | 1.62s (×27.58) | 7.27s (×123.39) | ☠ | |
| Q40. Query 40: SELECT URLHash, EventDate, count() AS PageViews FROM {table} WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT Refresh AND TraficSourceID IN (-1, 6) AND RefererHash = halfMD5('http://example.ru/') GROUP BY URLHash, EventDate ORDER BY PageViews DESC LIMIT 100; | 0.01s (×1.41) | 0.01s (×1.12) | 0.01s (×1.06) | 0.01s (×1.47) | 0.01s (×1.29) | 0.01s (×1.12) | 0.01s (×1.18) | 0.01s (×1.29) | 0.01s (×1.12) | 0.01s (×1.35) | 0.02s (×1.65) | 0.02s (×1.76) | 0.01s (×1.06) | 0.01s (×1.47) | 0.01s (×1.00) | 0.01s (×1.18) | 0.03s (×2.06) | 0.03s (×2.41) | 0.01s (×1.47) | 0.01s (×1.41) | 0.02s (×1.59) | 0.01s (×1.24) | 0.03s (×2.47) | 0.02s (×1.82) | 0.03s (×2.06) | 0.01s (×1.00) | 0.03s (×2.06) | 0.03s (×2.35) | 0.01s (×1.47) | 0.02s (×1.65) | 0.02s (×1.71) | 0.02s (×1.88) | 0.01s (×1.24) | 0.03s (×2.18) | 0.03s (×2.18) | 0.02s (×1.76) | 0.02s (×1.82) | 0.02s (×1.88) | 0.02s (×1.88) | 0.03s (×2.12) | 0.03s (×2.24) | 0.03s (×2.53) | 0.05s (×3.35) | 0.03s (×2.12) | 0.03s (×2.06) | 0.03s (×2.24) | 0.01s (×1.35) | 0.03s (×2.06) | 0.03s (×2.24) | 0.03s (×2.06) | 0.01s (×1.41) | 0.03s (×2.47) | 0.04s (×2.76) | 0.01s (×1.47) | 0.01s (×1.29) | 0.03s (×2.06) | 0.01s (×1.41) | 0.01s (×1.41) | 0.01s (×1.12) | 0.03s (×2.06) | 0.02s (×1.76) | 0.05s (×3.41) | 0.01s (×1.06) | 0.03s (×2.06) | 0.02s (×1.71) | 0.01s (×1.29) | 0.02s (×1.88) | 0.03s (×2.59) | 0.01s (×1.29) | 0.02s (×2.00) | 0.04s (×2.88) | 0.04s (×3.00) | 0.02s (×2.00) | 0.02s (×1.71) | 0.03s (×2.06) | 0.02s (×2.00) | 0.03s (×2.06) | 0.02s (×2.00) | 0.01s (×1.47) | 0.02s (×2.00) | 0.03s (×2.41) | 0.01s (×1.47) | 0.03s (×2.29) | 0.01s (×1.47) | 0.05s (×3.35) | 0.02s (×2.00) | 0.02s (×2.00) | 0.01s (×1.35) | 0.03s (×2.12) | 0.02s (×1.76) | 0.01s (×1.06) | 0.03s (×2.18) | 0.03s (×2.53) | 0.02s (×1.65) | 0.02s (×1.65) | 0.03s (×2.35) | 0.01s (×1.35) | 0.02s (×1.88) | 0.03s (×2.24) | 0.02s (×2.00) | 0.02s (×1.53) | 0.04s (×2.88) | 0.01s (×1.41) | 0.01s (×1.29) | 0.02s (×1.94) | 0.03s (×2.06) | 0.03s (×2.06) | 0.03s (×2.18) | 0.01s (×1.35) | 0.03s (×2.06) | 0.01s (×1.24) | 0.01s (×1.41) | 0.04s (×2.65) | 0.04s (×2.88) | 0.03s (×2.06) | 0.04s (×2.94) | 0.06s (×4.00) | 0.01s (×1.47) | 0.03s (×2.06) | 0.02s (×2.00) | 0.02s (×1.88) | 0.03s (×2.06) | 0.03s (×2.06) | 0.02s (×1.88) | 0.02s (×1.65) | 0.02s (×1.59) | 0.02s (×1.94) | 0.02s (×2.00) | 0.13s (×8.24) | 0.04s (×3.00) | 0.03s (×2.06) | 0.03s (×2.29) | 0.02s (×1.76) | 0.03s (×2.18) | 0.03s (×2.12) | 0.03s (×2.18) | 0.03s (×2.41) | 0.03s (×2.53) | 0.02s (×1.53) | 0.03s (×2.06) | 0.06s (×3.94) | 0.04s (×2.71) | 0.02s (×1.82) | 0.02s (×1.82) | 0.02s (×1.94) | 0.04s (×2.71) | 0.02s (×1.82) | 0.04s (×2.65) | 0.03s (×2.24) | 0.04s (×2.65) | 0.12s (×7.47) | 0.08s (×5.41) | 0.10s (×6.29) | 0.15s (×9.29) | 0.13s (×8.47) | 0.43s (×26.18) | ☠ | |
| Q41. Query 41: SELECT WindowClientWidth, WindowClientHeight, count() AS PageViews FROM {table} WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND NOT Refresh AND NOT DontCountHits AND URLHash = halfMD5('http://example.ru/') GROUP BY WindowClientWidth, WindowClientHeight ORDER BY PageViews DESC LIMIT 10000; | 0.01s (×1.44) | 0.01s (×1.06) | 0.01s (×1.19) | 0.01s (×1.50) | 0.01s (×1.25) | 0.01s (×1.19) | 0.01s (×1.06) | 0.02s (×1.69) | 0.01s (×1.06) | 0.01s (×1.50) | 0.01s (×1.56) | 0.01s (×1.56) | 0.01s (×1.06) | 0.01s (×1.38) | 0.01s (×1.13) | 0.01s (×1.25) | 0.02s (×1.63) | 0.02s (×2.00) | 0.02s (×1.88) | 0.01s (×1.25) | 0.01s (×1.31) | 0.02s (×1.75) | 0.03s (×2.19) | 0.01s (×1.56) | 0.01s (×1.50) | 0.01s (×1.19) | 0.01s (×1.50) | 0.03s (×2.38) | 0.01s (×1.56) | 0.02s (×1.63) | 0.01s (×1.56) | 0.02s (×1.75) | 0.01s (×1.38) | 0.02s (×1.94) | 0.02s (×1.81) | 0.02s (×1.75) | 0.02s (×1.69) | 0.02s (×1.75) | 0.02s (×1.81) | 0.02s (×1.88) | 0.03s (×2.31) | 0.03s (×2.19) | 0.03s (×2.75) | 0.02s (×1.81) | 0.02s (×1.88) | 0.02s (×2.00) | 0.01s (×1.25) | 0.03s (×2.63) | 0.02s (×2.06) | 0.02s (×1.69) | 0.01s (×1.25) | 0.03s (×2.69) | 0.03s (×2.69) | 0.01s (×1.25) | 0.01s (×1.19) | 0.02s (×1.88) | 0.01s (×1.25) | 0.01s (×1.31) | 0.01s (×1.31) | 0.02s (×1.75) | 0.01s (×1.50) | 0.03s (×2.25) | 0.01s (×1.00) | 0.02s (×1.94) | 0.02s (×1.63) | 0.01s (×1.25) | 0.01s (×1.56) | 0.02s (×2.06) | 0.01s (×1.31) | 0.02s (×1.69) | 0.03s (×2.56) | 0.03s (×2.75) | 0.02s (×1.81) | 0.01s (×1.31) | 0.02s (×2.00) | 0.02s (×1.88) | 0.02s (×1.88) | 0.03s (×2.38) | 0.01s (×1.25) | 0.02s (×1.88) | 0.02s (×2.00) | 0.01s (×1.38) | 0.02s (×2.00) | 0.01s (×1.25) | 0.04s (×3.38) | 0.03s (×2.75) | 0.01s (×1.56) | 0.01s (×1.31) | 0.02s (×1.94) | 0.01s (×1.56) | 0.01s (×1.06) | 0.02s (×2.00) | 0.02s (×2.00) | 0.01s (×1.56) | 0.01s (×1.56) | 0.03s (×2.63) | 0.01s (×1.31) | 0.01s (×1.31) | 0.02s (×1.94) | 0.02s (×1.88) | 0.01s (×1.44) | 0.03s (×2.19) | 0.01s (×1.50) | 0.01s (×1.25) | 0.01s (×1.56) | 0.02s (×1.81) | 0.02s (×1.63) | 0.02s (×1.75) | 0.01s (×1.25) | 0.02s (×1.81) | 0.01s (×1.13) | 0.01s (×1.56) | 0.03s (×2.19) | 0.03s (×2.44) | 0.02s (×1.69) | 0.03s (×2.63) | 0.04s (×3.19) | 0.01s (×1.44) | 0.03s (×2.25) | 0.02s (×1.75) | 0.02s (×1.75) | 0.02s (×1.94) | 0.01s (×1.56) | 0.02s (×1.63) | 0.01s (×1.56) | 0.01s (×1.50) | 0.02s (×1.88) | 0.02s (×1.81) | 0.12s (×8.31) | 0.03s (×2.63) | 0.02s (×1.81) | 0.02s (×1.94) | 0.01s (×1.44) | 0.02s (×2.06) | 0.02s (×1.94) | 0.03s (×2.44) | 0.03s (×2.38) | 0.03s (×2.31) | 0.01s (×1.44) | 0.02s (×1.75) | 0.04s (×3.44) | 0.03s (×2.31) | 0.01s (×1.56) | 0.02s (×1.63) | 0.02s (×1.88) | 0.03s (×2.25) | 0.01s (×1.56) | 0.03s (×2.69) | 0.02s (×1.94) | 0.03s (×2.63) | 0.09s (×6.37) | 0.07s (×5.00) | 0.08s (×5.75) | 0.14s (×9.38) | 0.10s (×6.75) | 0.34s (×21.88) | ☠ | |
| Q42. Query 42: SELECT toStartOfMinute(EventTime) AS Minute, count() AS PageViews FROM {table} WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-02' AND NOT Refresh AND NOT DontCountHits GROUP BY Minute ORDER BY Minute; | 0.01s (×1.75) | 0.00s (×1.08) | 0.01s (×1.50) | 0.02s (×2.17) | 0.01s (×1.75) | 0.01s (×1.50) | 0.01s (×1.25) | 0.01s (×1.42) | 0.00s (×1.17) | 0.01s (×1.58) | 0.01s (×1.42) | 0.00s (×1.17) | 0.00s (×1.17) | 0.00s (×1.00) | 0.01s (×1.25) | 0.01s (×1.33) | 0.01s (×1.42) | 0.01s (×1.33) | 0.01s (×1.25) | 0.01s (×1.25) | 0.01s (×1.25) | 0.01s (×2.00) | 0.01s (×1.42) | 0.01s (×1.25) | 0.00s (×1.08) | 0.00s (×1.17) | 0.00s (×1.17) | 0.00s (×1.17) | 0.00s (×1.08) | 0.01s (×1.33) | 0.01s (×1.58) | 0.01s (×1.25) | 0.01s (×1.33) | 0.01s (×1.33) | 0.01s (×1.33) | 0.01s (×1.33) | 0.01s (×1.33) | 0.01s (×1.42) | 0.01s (×1.25) | 0.01s (×1.58) | 0.01s (×1.42) | 0.01s (×1.58) | 0.01s (×1.50) | 0.01s (×1.42) | 0.00s (×1.17) | 0.01s (×1.25) | 0.01s (×1.25) | 0.02s (×2.50) | 0.01s (×1.25) | 0.00s (×1.17) | 0.00s (×1.08) | 0.01s (×1.67) | 0.01s (×1.25) | 0.01s (×1.25) | 0.01s (×1.25) | 0.00s (×1.17) | 0.01s (×1.25) | 0.01s (×1.33) | 0.00s (×1.17) | 0.00s (×1.17) | 0.00s (×1.08) | 0.01s (×1.58) | 0.00s (×1.08) | 0.00s (×1.17) | 0.01s (×2.00) | 0.00s (×1.08) | 0.00s (×1.08) | 0.01s (×1.42) | 0.01s (×1.25) | 0.00s (×1.08) | 0.03s (×3.33) | 0.01s (×1.67) | 0.01s (×1.25) | 0.01s (×1.25) | 0.01s (×1.42) | 0.01s (×1.25) | 0.01s (×1.67) | 0.00s (×1.17) | 0.01s (×1.25) | 0.01s (×1.33) | 0.01s (×1.25) | 0.01s (×1.33) | 0.01s (×1.42) | 0.01s (×1.33) | 0.01s (×1.75) | 0.01s (×1.92) | 0.01s (×1.33) | 0.00s (×1.00) | 0.01s (×1.33) | 0.01s (×1.33) | 0.00s (×1.08) | 0.01s (×1.42) | 0.01s (×1.92) | 0.00s (×1.08) | 0.00s (×1.08) | 0.01s (×1.67) | 0.01s (×1.58) | 0.00s (×1.00) | 0.01s (×1.25) | 0.01s (×1.25) | 0.00s (×1.17) | 0.01s (×1.83) | 0.00s (×1.00) | 0.00s (×1.00) | 0.01s (×1.92) | 0.00s (×1.17) | 0.01s (×1.33) | 0.01s (×1.25) | 0.01s (×1.33) | 0.01s (×1.25) | 0.00s (×1.08) | 0.01s (×1.33) | 0.01s (×1.75) | 0.01s (×1.75) | 0.01s (×1.42) | 0.01s (×1.67) | 0.01s (×2.08) | 0.01s (×1.25) | 0.01s (×1.33) | 0.01s (×1.42) | 0.00s (×1.17) | 0.01s (×1.67) | 0.01s (×1.33) | 0.00s (×1.17) | 0.01s (×1.42) | 0.00s (×1.17) | 0.01s (×1.50) | 0.01s (×1.67) | 0.03s (×3.17) | 0.01s (×1.83) | 0.00s (×1.17) | 0.01s (×1.33) | 0.01s (×1.33) | 0.01s (×1.50) | 0.01s (×1.33) | 0.01s (×2.00) | 0.01s (×1.58) | 0.01s (×1.58) | 0.01s (×1.25) | 0.01s (×1.33) | 0.01s (×1.83) | 0.01s (×1.75) | 0.00s (×1.08) | 0.00s (×1.17) | 0.00s (×1.17) | 0.01s (×1.33) | 0.01s (×1.42) | 0.01s (×2.00) | 0.01s (×1.25) | 0.01s (×1.67) | 0.01s (×2.00) | 0.02s (×2.58) | 0.02s (×2.17) | 0.03s (×3.67) | 0.03s (×3.58) | 0.07s (×6.67) | ☠ |
Submit your own results: https://clickhouse.com/docs/en/operations/performance-test/
Results for Lenovo B580 Laptop are from Ragıp Ünal. 16GB RAM 1600 GHz, 240GB SSD, Intel(R) Core(TM) i5-3210M CPU @ 2.50GHz (2 Core / 4 HT)
Results for Time4vps.eu are from Ragıp Ünal.
Results for Dell PowerEdge R640, R641 (in Hetzner) are from Dmirty Titov.
Results for Dell PowerEdge R730 are from Amos Bird.
Results for Dell R530 are from Yuriy Zolkin.
Results for Xeon 2176G are from Sergey Golod.
Results for Azure DS3v2 are from Boris Granveaud.
Results for AWS are from Wolf Kreuzerkrieg.
Results for Huawei Taishan are from Peng Gao in sina.com.
Results for Huawei Taishan (2) are from Kurmaev Roman at Huawei.
Results for Selectel and AMD EPYC 7402P are from Andrey Dudin.
Results for ProLiant are from Denis Ustinov.
Results for AMD EPYC 7502P 128GiB are from Kostiantyn Velychkovskyi.
Results for AMD EPYC 7502P 512GiB are from Sergey Zakharov.
Results for Pinebook Pro are from Aleksey R. @kITerE.
Results for AMD Ryzen are from Alexey Milovidov. Firefox was running in background.
Results for Azure E32s are from Piotr Maśko.
Results for MacBook Pro are from Denis Glazachev. MacOS Catalina Version 10.15.4 (19E266). For "drop caches", the "Free Up RAM" in CleanMyMac is used.
Results for AMD EPYC 7702 are from Peng Gao in sina.com.
Results for Intel NUC are from Alexander Zaitsev, Altinity.
Xeon Gold 6230 server is using 4 x SAMSUNG datacenter class SSD in RAID-10.
Results for Yandex Managed ClickHouse for "cold cache" are biased and should not be compared, because cache was not flushed for every next query.
Results for AWS Lightsail is from Vamsi Krishna B.
Results for Dell XPS laptop and Google Pixel phone is from Alexander Kuzmenkov.
Results for Android phones for "cold cache" are done without cache flushing, so they are not "cold" and cannot be compared.
Results for Digital Ocean are from Zimin Aleksey.
Results for 2x EPYC 7642 w/ 512 GB RAM (192 Cores) + 12X 1TB SSD (RAID6) are from Yiğit Konur and Metehan Çetinkaya of seo.do.
Results for Raspberry Pi and Digital Ocean CPU-optimized are from Fritz Wijaya.
Results for Digitalocean (Storage-intesinve VMs) + (CPU/GP) are from Yiğit Konur and Metehan Çetinkaya of seo.do.
Results for 2x AMD EPYC 7F72 3.2 Ghz (Total 96 Cores, IBM Cloud's Bare Metal Service) from Yiğit Konur and Metehan Çetinkaya of seo.do.
Results for 2x AMD EPYC 7742 (128 physical cores, 1 TB DDR4-3200 RAM) from Yedige Davletgaliyev and Nikita Zhavoronkov of blockchair.com.
Results for ASUS A15 (Ryzen laptop) are from Kimmo Linna.
Results for MacBook Air M1 are from Denis Glazachev.
Results for Xeon Gold 6140 are from Shiv Iyer (ChistaDATA Labs).
Comparison of EBS and EFS is from Ramazan Polat.
Results for Hetzner and Scaleway are from Anthony Najjar Simon (Panelbear).
Results for GCP are from Vy Nguyen Tan.
Results for ThinkPad P15 are from Mikhail Shiryaev.
Results for RockPi4 are from Kirill Zholnay.
Results for Xeon 6266C are from David in Shanghai.
Results for SSDNodes and Cavium are from Lorenzo QXIP.
Results for AMD EPYC 7662 64-Core Processor are from Evgeniy Kuts.
Results for scaleway GP1-S 8x x86 64bit 32GB ram 300gb NVMe are from Dag Vilmar Tveit.
Results for scaleway GP1-M 16x x86 64bit 64GB ram 600gb NVMe are from Dag Vilmar Tveit.
Results for Intel(R) Core(TM) i5-4440 CPU @ 3.10GHz are from Peter, Chun-Sheng, Li.
Results for MacBook Pro M1 are from Filatenkov Arthur.
Results for AWS instance type im4gn.4xlarge are from Ananth Gundabattula (Darwinium).
Results for AWS instance type im4gn.8xlarge are from Ananth Gundabattula (Darwinium).
Results for AWS instance type im4gn.16xlarge are from Ananth Gundabattula (Darwinium).
Results for AWS instance type i3.2xlarge are from Ananth Gundabattula (Darwinium).
Results for 2x EPYC 7702 on ZFS mirror NVME are from Alibek A.
Results for Intel 11th Gen Core i9-11900KF are from Tim Xian.
Results for AWS instance type m5a.4xlarge are from Daniel Chimeno.
Results for Huawei Taishan 920 are from Yu ZiChange at EioTek.
Results for Macbook Pro Intel Core i7 (2014) are from Vladislav.
Results for Hetzner EX62-NVME are from Talles Airan.
Results for AMD Ryzen 9 5950X are from Stefan.
Results for ScaleFlux CSD 3000 are from Cliicy Luo of ScaleFlux.
Results for Equinix metal n3.xlarge.x84 are from Dave Cottlehuber. Results for Dell PowerEdge R740xd are from Yu ZiChange at EioTek.
Results for RISC-V are from Aleksandr Razumov.
Results for 7950x are from Enrico.
Results for Steam Deck are from Chashnikov Alexander.
Results also contributed by Jing Xu, Alan Paul Kwan, Dan Roscigno, Includeno, J Wng.
Results for scaleway GP1-L 132x x86 64bit 128GB ram 50gb Block Storage are from Alexandre Becquet.
Results for Ampere Altra Q64-22 are from Vladimir Smirnov.