Skip to content

Instantly share code, notes, and snippets.

@georgewfraser
Created September 9, 2022 16:13
Show Gist options
  • Save georgewfraser/eb3663de2f367a611293b58b69fcc7f0 to your computer and use it in GitHub Desktop.
Save georgewfraser/eb3663de2f367a611293b58b69fcc7f0 to your computer and use it in GitHub Desktop.
Benchmark Histogram
{
"$schema": "https://vega.github.io/schema/vega-lite/v5.json",
"data": {
"values": [
{"BinLeft": 0.25, "BinRight": 0.5, "Warehouse": "BigQuery", "Count": 0},
{"BinLeft": 0.25, "BinRight": 0.5, "Warehouse": "Snowflake", "Count": 1},
{"BinLeft": 0.25, "BinRight": 0.5, "Warehouse": "Redshift", "Count": 2},
{"BinLeft": 0.25, "BinRight": 0.5, "Warehouse": "Databricks", "Count": 0},
{"BinLeft": 0.25, "BinRight": 0.5, "Warehouse": "Azure", "Count": 0},
{"BinLeft": 0.5, "BinRight": 1, "Warehouse": "BigQuery", "Count": 0},
{"BinLeft": 0.5, "BinRight": 1, "Warehouse": "Snowflake", "Count": 1},
{"BinLeft": 0.5, "BinRight": 1, "Warehouse": "Redshift", "Count": 3},
{"BinLeft": 0.5, "BinRight": 1, "Warehouse": "Databricks", "Count": 0},
{"BinLeft": 0.5, "BinRight": 1, "Warehouse": "Azure", "Count": 0},
{"BinLeft": 1, "BinRight": 2, "Warehouse": "BigQuery", "Count": 1},
{"BinLeft": 1, "BinRight": 2, "Warehouse": "Snowflake", "Count": 5},
{"BinLeft": 1, "BinRight": 2, "Warehouse": "Redshift", "Count": 9},
{"BinLeft": 1, "BinRight": 2, "Warehouse": "Databricks", "Count": 5},
{"BinLeft": 1, "BinRight": 2, "Warehouse": "Azure", "Count": 3},
{"BinLeft": 2, "BinRight": 4, "Warehouse": "BigQuery", "Count": 19},
{"BinLeft": 2, "BinRight": 4, "Warehouse": "Snowflake", "Count": 20},
{"BinLeft": 2, "BinRight": 4, "Warehouse": "Redshift", "Count": 12},
{"BinLeft": 2, "BinRight": 4, "Warehouse": "Databricks", "Count": 16},
{"BinLeft": 2, "BinRight": 4, "Warehouse": "Azure", "Count": 17},
{"BinLeft": 4, "BinRight": 8, "Warehouse": "BigQuery", "Count": 31},
{"BinLeft": 4, "BinRight": 8, "Warehouse": "Snowflake", "Count": 27},
{"BinLeft": 4, "BinRight": 8, "Warehouse": "Redshift", "Count": 21},
{"BinLeft": 4, "BinRight": 8, "Warehouse": "Databricks", "Count": 25},
{"BinLeft": 4, "BinRight": 8, "Warehouse": "Azure", "Count": 22},
{"BinLeft": 8, "BinRight": 16, "Warehouse": "BigQuery", "Count": 22},
{"BinLeft": 8, "BinRight": 16, "Warehouse": "Snowflake", "Count": 26},
{"BinLeft": 8, "BinRight": 16, "Warehouse": "Redshift", "Count": 29},
{"BinLeft": 8, "BinRight": 16, "Warehouse": "Databricks", "Count": 35},
{"BinLeft": 8, "BinRight": 16, "Warehouse": "Azure", "Count": 23},
{"BinLeft": 16, "BinRight": 32, "Warehouse": "BigQuery", "Count": 19},
{"BinLeft": 16, "BinRight": 32, "Warehouse": "Snowflake", "Count": 13},
{"BinLeft": 16, "BinRight": 32, "Warehouse": "Redshift", "Count": 12},
{"BinLeft": 16, "BinRight": 32, "Warehouse": "Databricks", "Count": 9},
{"BinLeft": 16, "BinRight": 32, "Warehouse": "Azure", "Count": 17},
{"BinLeft": 32, "BinRight": 64, "Warehouse": "BigQuery", "Count": 2},
{"BinLeft": 32, "BinRight": 64, "Warehouse": "Snowflake", "Count": 4},
{"BinLeft": 32, "BinRight": 64, "Warehouse": "Redshift", "Count": 5},
{"BinLeft": 32, "BinRight": 64, "Warehouse": "Databricks", "Count": 7},
{"BinLeft": 32, "BinRight": 64, "Warehouse": "Azure", "Count": 11},
{"BinLeft": 64, "BinRight": 128, "Warehouse": "BigQuery", "Count": 3},
{"BinLeft": 64, "BinRight": 128, "Warehouse": "Snowflake", "Count": 1},
{"BinLeft": 64, "BinRight": 128, "Warehouse": "Redshift", "Count": 6},
{"BinLeft": 64, "BinRight": 128, "Warehouse": "Databricks", "Count": 1},
{"BinLeft": 64, "BinRight": 128, "Warehouse": "Azure", "Count": 4},
{"BinLeft": 128, "BinRight": 256, "Warehouse": "BigQuery", "Count": 1},
{"BinLeft": 128, "BinRight": 256, "Warehouse": "Snowflake", "Count": 1},
{"BinLeft": 128, "BinRight": 256, "Warehouse": "Redshift", "Count": 0},
{"BinLeft": 128, "BinRight": 256, "Warehouse": "Databricks", "Count": 1},
{"BinLeft": 128, "BinRight": 256, "Warehouse": "Azure", "Count": 1},
{"BinLeft": 256, "BinRight": 512, "Warehouse": "BigQuery", "Count": 1},
{"BinLeft": 256, "BinRight": 512, "Warehouse": "Snowflake", "Count": 0},
{"BinLeft": 256, "BinRight": 512, "Warehouse": "Redshift", "Count": 0},
{"BinLeft": 256, "BinRight": 512, "Warehouse": "Databricks", "Count": 0},
{"BinLeft": 256, "BinRight": 512, "Warehouse": "Azure", "Count": 0}
]
},
"mark": "bar",
"encoding": {
"row": {"field": "Warehouse"},
"x": {
"field": "BinLeft",
"bin": {"binned": true},
"scale": {"type": "log", "base": 10, "domain": [0.125, 1000]},
"title": "Geomean Time"
},
"x2": {"field": "BinRight"},
"y": {
"field": "Count",
"type": "quantitative",
"title": null,
"axis": {"ticks": false, "domain": false, "labels": false}
},
"detail": {"field": "Warehouse"}
},
"height": 50
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment