Skip to content

Instantly share code, notes, and snippets.

@sashapodgoreanu

sashapodgoreanu/spec.json

Last active April 24, 2025 08:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sashapodgoreanu/3d272deb41466117da5cd7c60f5020a9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sashapodgoreanu/3d272deb41466117da5cd7c60f5020a9 to your computer and use it in GitHub Desktop.
Download ZIP
cloud_1_tb
Raw
spec.json
{
"config": {
"view": {
"continuousWidth": 300,
"continuousHeight": 300,
"strokeOpacity": 0
},
"axis": {"labelFontSize": 12, "titleFontSize": 15, "titleFontWeight": 400},
"scale": {"bandPaddingInner": 0.1, "bandWithNestedOffsetPaddingInner": 0.4},
"title": {"fontSize": 22.5, "fontWeight": 400}
},
"vconcat": [
{
"mark": {"type": "bar"},
"encoding": {
"color": {
"field": "library",
"legend": {
"direction": "horizontal",
"labelFontSize": 15,
"orient": "top",
"title": null,
"titleAnchor": "start",
"titleFontSize": 15
},
"scale": {
"domain": ["Dask", "DuckDB", "Polars", "PySpark"],
"range": ["#F08AAE", "#FFF100", "#5ec962", "#4698B2"]
},
"type": "nominal"
},
"opacity": {
"condition": {"param": "param_4", "value": 1},
"value": 0.3
},
"tooltip": [
{"field": "library", "title": "Library"},
{"field": "duration", "format": ".2f", "title": "Runtime"}
],
"x": {
"axis": {"labelAngle": 0},
"field": "query",
"scale": {
"domain": [
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12,
13,
14,
15,
16,
17,
18,
19,
20,
21,
22
]
},
"title": "Query",
"type": "ordinal"
},
"xOffset": {"field": "library", "type": "nominal"},
"y": {
"field": "duration",
"title": "Runtime (s)",
"type": "quantitative"
}
},
"name": "view_4",
"width": 660
},
{
"mark": {"type": "rect"},
"encoding": {
"color": {
"field": "completion",
"legend": {
"direction": "horizontal",
"labelFontSize": 15,
"orient": "top",
"title": null,
"titleAnchor": "start",
"titleFontSize": 15
},
"scale": {
"domain": ["Success", "Failure / Timeout", "Not Available"],
"range": ["#bbc", "#f676a3", "#ddd"]
},
"type": "nominal"
},
"x": {"field": "query", "title": "Query"},
"y": {"field": "library", "title": "Library"}
},
"width": 660
}
],
"data": {"name": "data-45c0d03d085e44839c8020d35a3b50e2"},
"datasets": {
"data-45c0d03d085e44839c8020d35a3b50e2": [
{
"completion": "Success",
"duration": 29.75949216,
"library": "Dask",
"num_cpus": 128,
"query": 1
},
{
"completion": "Success",
"duration": 39.30828714,
"library": "Dask",
"num_cpus": 128,
"query": 2
},
{
"completion": "Success",
"duration": 58.97342896,
"library": "Dask",
"num_cpus": 128,
"query": 3
},
{
"completion": "Success",
"duration": 41.72662759,
"library": "Dask",
"num_cpus": 128,
"query": 4
},
{
"completion": "Success",
"duration": 94.1947875,
"library": "Dask",
"num_cpus": 128,
"query": 5
},
{
"completion": "Success",
"duration": 8.280158997,
"library": "Dask",
"num_cpus": 128,
"query": 6
},
{
"completion": "Success",
"duration": 97.14927673,
"library": "Dask",
"num_cpus": 128,
"query": 7
},
{
"completion": "Success",
"duration": 120.9598186,
"library": "Dask",
"num_cpus": 128,
"query": 8
},
{
"completion": "Success",
"duration": 163.0944493,
"library": "Dask",
"num_cpus": 128,
"query": 9
},
{
"completion": "Success",
"duration": 65.59146667,
"library": "Dask",
"num_cpus": 128,
"query": 10
},
{
"completion": "Success",
"duration": 16.60672617,
"library": "Dask",
"num_cpus": 128,
"query": 11
},
{
"completion": "Success",
"duration": 46.0263226,
"library": "Dask",
"num_cpus": 128,
"query": 12
},
{
"completion": "Success",
"duration": 27.56986189,
"library": "Dask",
"num_cpus": 128,
"query": 13
},
{
"completion": "Success",
"duration": 22.74466801,
"library": "Dask",
"num_cpus": 128,
"query": 14
},
{
"completion": "Success",
"duration": 17.07904959,
"library": "Dask",
"num_cpus": 128,
"query": 15
},
{
"completion": "Success",
"duration": 24.20406914,
"library": "Dask",
"num_cpus": 128,
"query": 16
},
{
"completion": "Success",
"duration": 77.78345537,
"library": "Dask",
"num_cpus": 128,
"query": 17
},
{
"completion": "Success",
"duration": 130.208168,
"library": "Dask",
"num_cpus": 128,
"query": 18
},
{
"completion": "Success",
"duration": 33.90354919,
"library": "Dask",
"num_cpus": 128,
"query": 19
},
{
"completion": "Success",
"duration": 54.9333415,
"library": "Dask",
"num_cpus": 128,
"query": 20
},
{
"completion": "Success",
"duration": 162.1645887,
"library": "Dask",
"num_cpus": 128,
"query": 21
},
{
"completion": "Success",
"duration": 21.92724085,
"library": "Dask",
"num_cpus": 128,
"query": 22
},
{
"completion": "Success",
"duration": 37.63626432,
"library": "DuckDB",
"num_cpus": 128,
"query": 1
},
{
"completion": "Success",
"duration": 21.2910831,
"library": "DuckDB",
"num_cpus": 128,
"query": 2
},
{
"completion": "Success",
"duration": 167.1154599,
"library": "DuckDB",
"num_cpus": 128,
"query": 3
},
{
"completion": "Success",
"duration": 32.81221771,
"library": "DuckDB",
"num_cpus": 128,
"query": 4
},
{
"completion": "Success",
"duration": 44.95286083,
"library": "DuckDB",
"num_cpus": 128,
"query": 5
},
{
"completion": "Success",
"duration": 19.7028451,
"library": "DuckDB",
"num_cpus": 128,
"query": 6
},
{
"completion": "Success",
"duration": 236.7368755,
"library": "DuckDB",
"num_cpus": 128,
"query": 7
},
{
"completion": "Success",
"duration": 56.57871389,
"library": "DuckDB",
"num_cpus": 128,
"query": 8
},
{
"completion": "Success",
"duration": 173.2250803,
"library": "DuckDB",
"num_cpus": 128,
"query": 9
},
{
"completion": "Success",
"duration": 119.1557136,
"library": "DuckDB",
"num_cpus": 128,
"query": 10
},
{
"completion": "Success",
"duration": 17.33489633,
"library": "DuckDB",
"num_cpus": 128,
"query": 11
},
{
"completion": "Success",
"duration": 26.00417137,
"library": "DuckDB",
"num_cpus": 128,
"query": 12
},
{
"completion": "Success",
"duration": 78.27388215,
"library": "DuckDB",
"num_cpus": 128,
"query": 13
},
{
"completion": "Success",
"duration": 44.00732279,
"library": "DuckDB",
"num_cpus": 128,
"query": 14
},
{
"completion": "Success",
"duration": 69.34479427,
"library": "DuckDB",
"num_cpus": 128,
"query": 15
},
{
"completion": "Success",
"duration": 29.36622119,
"library": "DuckDB",
"num_cpus": 128,
"query": 16
},
{
"completion": "Success",
"duration": 37.8093152,
"library": "DuckDB",
"num_cpus": 128,
"query": 17
},
{
"completion": "Failure / Timeout",
"duration": null,
"library": "DuckDB",
"num_cpus": 128,
"query": 18
},
{
"completion": "Success",
"duration": 33.65130925,
"library": "DuckDB",
"num_cpus": 128,
"query": 19
},
{
"completion": "Success",
"duration": 35.96667242,
"library": "DuckDB",
"num_cpus": 128,
"query": 20
},
{
"completion": "Success",
"duration": 106.5192387,
"library": "DuckDB",
"num_cpus": 128,
"query": 21
},
{
"completion": "Success",
"duration": 15.40155816,
"library": "DuckDB",
"num_cpus": 128,
"query": 22
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 1
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 2
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 3
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 4
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 5
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 6
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 7
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 8
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 9
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 10
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 11
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 12
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 13
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 14
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 15
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 16
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 17
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 18
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 19
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 20
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 21
},
{
"completion": "Not Available",
"duration": null,
"library": "Polars",
"num_cpus": 128,
"query": 22
},
{
"completion": "Success",
"duration": 47.26570702,
"library": "PySpark",
"num_cpus": 128,
"query": 1
},
{
"completion": "Success",
"duration": 41.25438881,
"library": "PySpark",
"num_cpus": 128,
"query": 2
},
{
"completion": "Success",
"duration": 66.01771116,
"library": "PySpark",
"num_cpus": 128,
"query": 3
},
{
"completion": "Success",
"duration": 57.52005577,
"library": "PySpark",
"num_cpus": 128,
"query": 4
},
{
"completion": "Success",
"duration": 155.1479619,
"library": "PySpark",
"num_cpus": 128,
"query": 5
},
{
"completion": "Success",
"duration": 19.86647058,
"library": "PySpark",
"num_cpus": 128,
"query": 6
},
{
"completion": "Success",
"duration": 66.81416082,
"library": "PySpark",
"num_cpus": 128,
"query": 7
},
{
"completion": "Success",
"duration": 150.4258046,
"library": "PySpark",
"num_cpus": 128,
"query": 8
},
{
"completion": "Success",
"duration": 192.1831613,
"library": "PySpark",
"num_cpus": 128,
"query": 9
},
{
"completion": "Success",
"duration": 54.85559559,
"library": "PySpark",
"num_cpus": 128,
"query": 10
},
{
"completion": "Success",
"duration": 30.85646725,
"library": "PySpark",
"num_cpus": 128,
"query": 11
},
{
"completion": "Success",
"duration": 39.33754587,
"library": "PySpark",
"num_cpus": 128,
"query": 12
},
{
"completion": "Success",
"duration": 48.68391037,
"library": "PySpark",
"num_cpus": 128,
"query": 13
},
{
"completion": "Success",
"duration": 23.93437481,
"library": "PySpark",
"num_cpus": 128,
"query": 14
},
{
"completion": "Success",
"duration": 41.47582936,
"library": "PySpark",
"num_cpus": 128,
"query": 15
},
{
"completion": "Success",
"duration": 21.09156013,
"library": "PySpark",
"num_cpus": 128,
"query": 16
},
{
"completion": "Success",
"duration": 146.2289822,
"library": "PySpark",
"num_cpus": 128,
"query": 17
},
{
"completion": "Success",
"duration": 147.4659843,
"library": "PySpark",
"num_cpus": 128,
"query": 18
},
{
"completion": "Success",
"duration": 35.36190605,
"library": "PySpark",
"num_cpus": 128,
"query": 19
},
{
"completion": "Success",
"duration": 39.92999053,
"library": "PySpark",
"num_cpus": 128,
"query": 20
},
{
"completion": "Success",
"duration": 224.4968228,
"library": "PySpark",
"num_cpus": 128,
"query": 21
},
{
"completion": "Success",
"duration": 21.77229381,
"library": "PySpark",
"num_cpus": 128,
"query": 22
}
]
},
"params": [
{
"name": "param_4",
"select": {"type": "point", "fields": ["library"], "toggle": "true"},
"bind": "legend",
"value": [{"library": "Dask"}, {"library": "DuckDB"}, {"library": "PySpark"}],
"views": ["view_4"]
}
],
"resolve": {"scale": {"color": "independent"}},
"title": {
"anchor": "middle",
"dy": -18,
"fontSize": 18.5,
"text": "Cloud | Scale: 1 TB | CPUs: 128",
"subtitleColor": "#898e90",
"subtitleFontSize": 18
},
"$schema": "https://vega.github.io/schema/vega-lite/v5.17.0.json"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment