Benchmarking ClickHouse Performance –\u00a0Amazon EC2\u00a0 Table of Contents Amazon EC2 infrastructure used for benchmarking ClickHouse:Benchmarking Dataset \u00a0– New York Taxi dataDownloading the prepared partitionsQuery performance BenchmarkingQuery 1:Query 2:Query 3:Query 4:References Amazon EC2 infrastructure used for […]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46,57,1347,47,77,48,45],"tags":[],"yoast_head":"\nClickHouse Performance Benchmarking on Amazon EC2<\/title>\n<meta name=\"description\" content=\"ClickHouse Performance Benchmarking, Capacity Planning and Sizing on Amazon EC2 - ClickHouse Performance - MinervaDB ClickHouse Support\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Benchmarking ClickHouse Performance on Amazon EC2\" \/>\n<meta property=\"og:description\" content=\"ClickHouse Performance Benchmarking, Capacity Planning and Sizing on Amazon EC2 - ClickHouse Performance - MinervaDB ClickHouse Support\" \/>\n<meta property=\"og:url\" content=\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/\" \/>\n<meta property=\"og:site_name\" content=\"The WebScale Database Infrastructure Operations Experts\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/WebScaleDBA\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/TheWebScaleDBA\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-20T19:50:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-10T14:28:42+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/minervadb.com\/wp-content\/uploads\/2020\/02\/Screenshot-2020-02-09-at-12.10.30-AM-1024x174.png\" \/>\n<meta name=\"author\" content=\"Shiv Iyer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@http:\/\/twitter.com\/thewebscaledba\" \/>\n<meta name=\"twitter:site\" content=\"@webscaledba\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shiv Iyer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/\"},\"author\":{\"name\":\"Shiv Iyer\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618\"},\"headline\":\"Benchmarking ClickHouse Performance on Amazon EC2\",\"datePublished\":\"2019-11-20T19:50:12+00:00\",\"dateModified\":\"2020-03-10T14:28:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/\"},\"wordCount\":224,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/minervadb.com\/wp-content\/uploads\/2020\/02\/Screenshot-2020-02-09-at-12.10.30-AM-1024x174.png\",\"articleSection\":[\"ClickHouse\",\"ClickHouse Benchmarking\",\"ClickHouse Performance\",\"ClickHouse Performance Benchmarking\",\"ClickHouse Support\",\"Columnar Database System\",\"Data Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/\",\"url\":\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/\",\"name\":\"ClickHouse Performance Benchmarking on Amazon EC2\",\"isPartOf\":{\"@id\":\"https:\/\/minervadb.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/minervadb.com\/wp-content\/uploads\/2020\/02\/Screenshot-2020-02-09-at-12.10.30-AM-1024x174.png\",\"datePublished\":\"2019-11-20T19:50:12+00:00\",\"dateModified\":\"2020-03-10T14:28:42+00:00\",\"description\":\"ClickHouse Performance Benchmarking, Capacity Planning and Sizing on Amazon EC2 - ClickHouse Performance - MinervaDB ClickHouse Support\",\"breadcrumb\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#primaryimage\",\"url\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2020\/02\/Screenshot-2020-02-09-at-12.10.30-AM.png\",\"contentUrl\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2020\/02\/Screenshot-2020-02-09-at-12.10.30-AM.png\",\"width\":2690,\"height\":458},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/minervadb.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Benchmarking ClickHouse Performance on Amazon EC2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/minervadb.com\/#website\",\"url\":\"https:\/\/minervadb.com\/\",\"name\":\"The WebScale Database Infrastructure Operations Experts\",\"description\":\"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations\",\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/minervadb.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/minervadb.com\/#organization\",\"name\":\"MinervaDB\",\"url\":\"https:\/\/minervadb.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"contentUrl\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"width\":200,\"height\":200,\"caption\":\"MinervaDB\"},\"image\":{\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/WebScaleDBA\/\",\"https:\/\/x.com\/webscaledba\",\"https:\/\/www.linkedin.com\/company\/minervadb\/\",\"https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618\",\"name\":\"Shiv Iyer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g\",\"caption\":\"Shiv Iyer\"},\"description\":\"WebScale Database Infrastructure Operations Expert in MySQL, MariaDB, PostgreSQL and ClickHouse with core interests in performance, scalability, high availability and database reliability engineering. Shiv currently is the Founder and Principal of MinervaDB, an independent and vendor neutral Consulting, 24*7 Support and Remote DBA Services provider for MySQL, MariaDB, PostgreSQL and ClickHouse serving approximately 300 customers globally.\",\"sameAs\":[\"http:\/\/minervadb.com\",\"https:\/\/www.facebook.com\/TheWebScaleDBA\",\"https:\/\/x.com\/http:\/\/twitter.com\/thewebscaledba\"],\"url\":\"https:\/\/minervadb.com\/index.php\/author\/shiv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ClickHouse Performance Benchmarking on Amazon EC2","description":"ClickHouse Performance Benchmarking, Capacity Planning and Sizing on Amazon EC2 - ClickHouse Performance - MinervaDB ClickHouse Support","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/","og_locale":"en_US","og_type":"article","og_title":"Benchmarking ClickHouse Performance on Amazon EC2","og_description":"ClickHouse Performance Benchmarking, Capacity Planning and Sizing on Amazon EC2 - ClickHouse Performance - MinervaDB ClickHouse Support","og_url":"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/","og_site_name":"The WebScale Database Infrastructure Operations Experts","article_publisher":"https:\/\/www.facebook.com\/WebScaleDBA\/","article_author":"https:\/\/www.facebook.com\/TheWebScaleDBA","article_published_time":"2019-11-20T19:50:12+00:00","article_modified_time":"2020-03-10T14:28:42+00:00","og_image":[{"url":"http:\/\/minervadb.com\/wp-content\/uploads\/2020\/02\/Screenshot-2020-02-09-at-12.10.30-AM-1024x174.png"}],"author":"Shiv Iyer","twitter_card":"summary_large_image","twitter_creator":"@http:\/\/twitter.com\/thewebscaledba","twitter_site":"@webscaledba","twitter_misc":{"Written by":"Shiv Iyer","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#article","isPartOf":{"@id":"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/"},"author":{"name":"Shiv Iyer","@id":"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618"},"headline":"Benchmarking ClickHouse Performance on Amazon EC2","datePublished":"2019-11-20T19:50:12+00:00","dateModified":"2020-03-10T14:28:42+00:00","mainEntityOfPage":{"@id":"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/"},"wordCount":224,"commentCount":0,"publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"image":{"@id":"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#primaryimage"},"thumbnailUrl":"http:\/\/minervadb.com\/wp-content\/uploads\/2020\/02\/Screenshot-2020-02-09-at-12.10.30-AM-1024x174.png","articleSection":["ClickHouse","ClickHouse Benchmarking","ClickHouse Performance","ClickHouse Performance Benchmarking","ClickHouse Support","Columnar Database System","Data Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/","url":"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/","name":"ClickHouse Performance Benchmarking on Amazon EC2","isPartOf":{"@id":"https:\/\/minervadb.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#primaryimage"},"image":{"@id":"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#primaryimage"},"thumbnailUrl":"http:\/\/minervadb.com\/wp-content\/uploads\/2020\/02\/Screenshot-2020-02-09-at-12.10.30-AM-1024x174.png","datePublished":"2019-11-20T19:50:12+00:00","dateModified":"2020-03-10T14:28:42+00:00","description":"ClickHouse Performance Benchmarking, Capacity Planning and Sizing on Amazon EC2 - ClickHouse Performance - MinervaDB ClickHouse Support","breadcrumb":{"@id":"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#primaryimage","url":"https:\/\/minervadb.com\/wp-content\/uploads\/2020\/02\/Screenshot-2020-02-09-at-12.10.30-AM.png","contentUrl":"https:\/\/minervadb.com\/wp-content\/uploads\/2020\/02\/Screenshot-2020-02-09-at-12.10.30-AM.png","width":2690,"height":458},{"@type":"BreadcrumbList","@id":"https:\/\/minervadb.com\/index.php\/2019\/11\/20\/benchmarking-clickhouse-performance-on-amazon-ec2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/minervadb.com\/"},{"@type":"ListItem","position":2,"name":"Benchmarking ClickHouse Performance on Amazon EC2"}]},{"@type":"WebSite","@id":"https:\/\/minervadb.com\/#website","url":"https:\/\/minervadb.com\/","name":"The WebScale Database Infrastructure Operations Experts","description":"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations","publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/minervadb.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/minervadb.com\/#organization","name":"MinervaDB","url":"https:\/\/minervadb.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/","url":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","contentUrl":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","width":200,"height":200,"caption":"MinervaDB"},"image":{"@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/WebScaleDBA\/","https:\/\/x.com\/webscaledba","https:\/\/www.linkedin.com\/company\/minervadb\/","https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber"]},{"@type":"Person","@id":"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618","name":"Shiv Iyer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g","caption":"Shiv Iyer"},"description":"WebScale Database Infrastructure Operations Expert in MySQL, MariaDB, PostgreSQL and ClickHouse with core interests in performance, scalability, high availability and database reliability engineering. Shiv currently is the Founder and Principal of MinervaDB, an independent and vendor neutral Consulting, 24*7 Support and Remote DBA Services provider for MySQL, MariaDB, PostgreSQL and ClickHouse serving approximately 300 customers globally.","sameAs":["http:\/\/minervadb.com","https:\/\/www.facebook.com\/TheWebScaleDBA","https:\/\/x.com\/http:\/\/twitter.com\/thewebscaledba"],"url":"https:\/\/minervadb.com\/index.php\/author\/shiv\/"}]}},"_links":{"self":[{"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/2793"}],"collection":[{"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/comments?post=2793"}],"version-history":[{"count":11,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/2793\/revisions"}],"predecessor-version":[{"id":3340,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/2793\/revisions\/3340"}],"wp:attachment":[{"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/media?parent=2793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/categories?post=2793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/tags?post=2793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}