s":[{"expr":"col(\"l_returnflag\")","descending":false,"nulls_last":false},{"expr":"col(\"l_linestatus\")","descending":false,"nulls_last":false}],"slice":null,"multithreaded":true,"maintain_order":false,"limit":null},"metrics":{"total_time_ns":474086,"total_polls":69,"total_stolen_polls":36,"total_poll_time_ns":129050,"max_poll_time_ns":9947,"total_state_updates":8,"total_state_update_time_ns":345036,"max_state_update_time_ns":341467,"rows_received":4,"rows_sent":4,"morsels_received":5,"morsels_sent":4,"largest_morsel_received":1,"largest_morsel_sent":1,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967301,"kind":"SimpleProjection","role":"projection","inputs":[4294967300],"properties":{"type":"SimpleProjection","columns":["_POLARS_TMP_1","_POLARS_TMP_2","_POLARS_TMP_4","_POLARS_TMP_6","_POLARS_TMP_8","_POLARS_TMP_10","_POLARS_TMP_11","_POLARS_TMP_12","_POLARS_TMP_14","_POLARS_TMP_15"]},"metrics":{"total_time_ns":60431,"total_polls":53,"total_stolen_polls":24,"total_poll_time_ns":59678,"max_poll_time_ns":11849,"total_state_updates":8,"total_state_update_time_ns":753,"max_state_update_time_ns":270,"rows_received":4,"rows_sent":4,"morsels_received":5,"morsels_sent":5,"largest_morsel_received":1,"largest_morsel_sent":1,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967300,"kind":"GroupBy","role":"aggregation","inputs":[4294967299],"properties":{"type":"GroupBy","num_inputs":1,"key_per_input":[["col(\"_POLARS_TMP_1\")","col(\"_POLARS_TMP_2\")"]],"aggs_per_input":[["col(\"_POLARS_TMP_3\").sum().alias(\"_POLARS_TMP_4\")","col(\"_POLARS_TMP_5\").sum().alias(\"_POLARS_TMP_6\")","col(\"_POLARS_TMP_7\").sum().alias(\"_POLARS_TMP_8\")","col(\"_POLARS_TMP_9\").sum().alias(\"_POLARS_TMP_10\")","col(\"_POLARS_TMP_3\").mean().alias(\"_POLARS_TMP_11\")","col(\"_POLARS_TMP_5\").mean().alias(\"_POLARS_TMP_12\")","col(\"_POLARS_TMP_13\").mean().alias(\"_POLARS_TMP_14\")","len().alias(\"_POLARS_TMP_15\")"]]},"metrics":{"total_time_ns":840927221,"total_polls":245,"total_stolen_polls":48,"total_poll_time_ns":840176338,"max_poll_time_ns":22502630,"total_state_updates":8,"total_state_update_time_ns":750883,"max_state_update_time_ns":744001,"rows_received":5916591,"rows_sent":4,"morsels_received":84,"morsels_sent":5,"largest_morsel_received":84357,"largest_morsel_sent":1,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967299,"kind":"Select","role":"projection","inputs":[4294967298],"properties":{"type":"Select","selectors":["col(\"l_returnflag\").alias(\"_POLARS_TMP_1\")","col(\"l_linestatus\").alias(\"_POLARS_TMP_2\")","col(\"l_quantity\").alias(\"_POLARS_TMP_3\")","col(\"l_extendedprice\").alias(\"_POLARS_TMP_5\")","(col(\"l_extendedprice\") * (1.0 - col(\"l_discount\"))).alias(\"_POLARS_TMP_7\")","((col(\"l_extendedprice\") * (1.0 - col(\"l_discount\"))) * (1.0 + col(\"l_tax\"))).alias(\"_POLARS_TMP_9\")","col(\"l_discount\").alias(\"_POLARS_TMP_13\")"],"extend_original":false},"metrics":{"total_time_ns":139396169,"total_polls":108,"total_stolen_polls":12,"total_poll_time_ns":139395092,"max_poll_time_ns":6667006,"total_state_updates":8,"total_state_update_time_ns":1077,"max_state_update_time_ns":286,"rows_received":5916591,"rows_sent":5916591,"morsels_received":84,"morsels_sent":84,"largest_morsel_received":84357,"largest_morsel_sent":84357,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967298,"kind":"SimpleProjection","role":"projection","inputs":[4294967297],"properties":{"type":"SimpleProjection","columns":["l_returnflag","l_linestatus","l_quantity","l_extendedprice","l_discount","l_tax"]},"metrics":{"total_time_ns":705152,"total_polls":108,"total_stolen_polls":12,"total_poll_time_ns":704730,"max_poll_time_ns":22699,"total_state_updates":8,"total_state_update_time_ns":422,"max_state_update_time_ns":95,"rows_received":5916591,"rows_sent":5916591,"morsels_received":84,"morsels_sent":84,"largest_morsel_received":84357,"largest_morsel_sent":84357,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967297,"kind":"MultiScan","role":"scan","inputs":[],"properties":{"type":"MultiScan","scan_type":"parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/lineitem.parquet","projected_file_columns":["l_quantity","l_extendedprice","l_discount","l_tax","l_returnflag","l_linestatus","l_shipdate"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":"col(\"l_shipdate\") <= 1998-09-02","predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"deletion_files_type":null,"hive_columns":null},"metrics":{"total_time_ns":175238,"total_polls":3,"total_stolen_polls":2,"total_poll_time_ns":61979,"max_poll_time_ns":56188,"total_state_updates":6,"total_state_update_time_ns":113259,"max_state_update_time_ns":60234,"rows_received":0,"rows_sent":5916591,"morsels_received":0,"morsels_sent":84,"largest_morsel_received":0,"largest_morsel_sent":84357,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}}],"logical":[{"id":7,"kind":"Sink","role":"sink","inputs":[3],"properties":{"type":"Sink","dest":"Memory"}},{"id":3,"kind":"Sort","role":"sort","inputs":[2],"properties":{"type":"Sort","sort_columns":[{"expr":"col(\"l_returnflag\")","descending":false,"nulls_last":false},{"expr":"col(\"l_linestatus\")","descending":false,"nulls_last":false}],"slice":null,"maintain_order":false,"limit":null}},{"id":2,"kind":"GroupBy","role":"aggregation","inputs":[5],"properties":{"type":"GroupBy","keys":["col(\"l_returnflag\")","col(\"l_linestatus\")"],"aggs":["col(\"l_quantity\").sum().alias(\"sum_qty\")","col(\"l_extendedprice\").sum().alias(\"sum_base_price\")","(col(\"l_extendedprice\") * (1.0 - col(\"l_discount\"))).sum().alias(\"sum_disc_price\")","((col(\"l_extendedprice\") * (1.0 - col(\"l_discount\"))) * (1.0 + col(\"l_tax\"))).sum().alias(\"sum_charge\")","col(\"l_quantity\").mean().alias(\"avg_qty\")","col(\"l_extendedprice\").mean().alias(\"avg_price\")","col(\"l_discount\").mean().alias(\"avg_disc\")","len().alias(\"count_order\")"],"maintain_order":false,"slice":null}},{"id":5,"kind":"SimpleProjection","role":"projection","inputs":[1],"properties":{"type":"SimpleProjection","columns":["l_returnflag","l_linestatus","l_quantity","l_extendedprice","l_discount","l_tax"]}},{"id":1,"kind":"Scan","role":"scan","inputs":[],"properties":{"type":"Scan","scan_type":"Parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/lineitem.parquet","file_columns":["l_orderkey","l_partkey","l_suppkey","l_linenumber","l_quantity","l_extendedprice","l_discount","l_tax","l_returnflag","l_linestatus","l_shipdate","l_commitdate","l_receiptdate","l_shipinstruct","l_shipmode","comments"],"projection":["l_returnflag","l_linestatus","l_quantity","l_extendedprice","l_discount","l_tax","l_shipdate"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":["col(\"l_shipdate\") <= 1998-09-02"],"predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"column_mapping_type":null,"hive_columns":null}}]}}{"schema":"polars-telemetry/profile@1","polars_version":"1.44.2","polars_telemetry_version":"0.4.0","query_id":"01a10215-8bcf-7000-916b-ecfb2e933b51","label":"tpch/q9","fingerprint":"9544d147c360","started_unix_ns":1791036328911254240,"wall_ms":249.7966,"cpu_ms":86.635,"result_rows":175,"call_site":{"filepath":"/srv/polars-telemetry-tpch/run.py","lineno":113,"function":"main"},"failed":null,"redacted":null,"diagnostics":{"parallel_efficiency":0.028901867231178352,"cpu_count":12,"join_amplification":7.487903225806452,"projection_efficiency":0.34,"morsel_skew":5.9733683420855215,"predicate_pushed":true,"has_table_statistics":false,"incomplete_nodes":0},"plan":{"physical":[{"id":4294967318,"kind":"InMemorySink","role":"sink","inputs":[4294967317],"properties":{"type":"InMemorySink"},"metrics":{"total_time_ns":42476,"total_polls":36,"total_stolen_polls":12,"total_poll_time_ns":24404,"max_poll_time_ns":4729,"total_state_updates":83,"total_state_update_time_ns":18072,"max_state_update_time_ns":897,"rows_received":175,"rows_sent":0,"morsels_received":12,"morsels_sent":0,"largest_morsel_received":15,"largest_morsel_sent":0,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967317,"kind":"Sort","role":"sort","inputs":[4294967316],"properties":{"type":"Sort","sort_columns":[{"expr":"col(\"nation\")","descending":false,"nulls_last":false},{"expr":"col(\"o_year\")","descending":true,"nulls_last":false}],"slice":null,"multithreaded":true,"maintain_order":false,"limit":null},"metrics":{"total_time_ns":331201,"total_polls":85,"total_stolen_polls":36,"total_poll_time_ns":90543,"max_poll_time_ns":5481,"total_state_updates":84,"total_state_update_time_ns":240658,"max_state_update_time_ns":219725,"rows_received":175,"rows_sent":175,"morsels_received":13,"morsels_sent":12,"largest_morsel_received":15,"largest_morsel_sent":15,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967316,"kind":"Select","role":"projection","inputs":[4294967315],"properties":{"type":"Select","selectors":["col(\"_POLARS_TMP_139\").alias(\"nation\")","col(\"_POLARS_TMP_140\").alias(\"o_year\")","col(\"_POLARS_TMP_142\").alias(\"amount\").round().alias(\"sum_profit\")"],"extend_original":false},"metrics":{"total_time_ns":141347,"total_polls":61,"total_stolen_polls":24,"total_poll_time_ns":127451,"max_poll_time_ns":16017,"total_state_updates":84,"total_state_update_time_ns":13896,"max_state_update_time_ns":702,"rows_received":175,"rows_sent":175,"morsels_received":13,"morsels_sent":13,"largest_morsel_received":15,"largest_morsel_sent":15,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967315,"kind":"GroupBy","role":"aggregation","inputs":[4294967314],"properties":{"type":"GroupBy","num_inputs":1,"key_per_input":[["col(\"_POLARS_TMP_139\")","col(\"_POLARS_TMP_140\")"]],"aggs_per_input":[["col(\"_POLARS_TMP_141\").sum().alias(\"_POLARS_TMP_142\")"]]},"metrics":{"total_time_ns":25280163,"total_polls":114,"total_stolen_polls":48,"total_poll_time_ns":24801044,"max_poll_time_ns":3940891,"total_state_updates":84,"total_state_update_time_ns":479119,"max_state_update_time_ns":445305,"rows_received":319404,"rows_sent":175,"morsels_received":30,"morsels_sent":13,"largest_morsel_received":18030,"largest_morsel_sent":15,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967314,"kind":"SimpleProjection","role":"projection","inputs":[4294967313],"properties":{"type":"SimpleProjection","columns":["nation","o_year","amount"]},"metrics":{"total_time_ns":134149,"total_polls":42,"total_stolen_polls":12,"total_poll_time_ns":127067,"max_poll_time_ns":15725,"total_state_updates":84,"total_state_update_time_ns":7082,"max_state_update_time_ns":338,"rows_received":319404,"rows_sent":319404,"morsels_received":30,"morsels_sent":30,"largest_morsel_received":18030,"largest_morsel_sent":18030,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967313,"kind":"Select","role":"projection","inputs":[4294967312],"properties":{"type":"Select","selectors":["col(\"n_name\").alias(\"nation\")","col(\"o_orderdate\").dt.year().alias(\"o_year\")","col(\"l_extendedprice\").fms([1.0 - col(\"l_discount\"), col(\"ps_supplycost\") * col(\"l_quantity\").cast(Float64)]).alias(\"amount\")"],"extend_original":false},"metrics":{"total_time_ns":16149201,"total_polls":42,"total_stolen_polls":14,"total_poll_time_ns":16143792,"max_poll_time_ns":2728811,"total_state_updates":84,"total_state_update_time_ns":5409,"max_state_update_time_ns":308,"rows_received":319404,"rows_sent":319404,"morsels_received":30,"morsels_sent":30,"largest_morsel_received":18030,"largest_morsel_sent":18030,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967312,"kind":"SimpleProjection","role":"projection","inputs":[4294967311],"properties":{"type":"SimpleProjection","columns":["n_name","o_orderdate","l_extendedprice","l_discount","ps_supplycost","l_quantity"]},"metrics":{"total_time_ns":135120,"total_polls":43,"total_stolen_polls":13,"total_poll_time_ns":129596,"max_poll_time_ns":17794,"total_state_updates":84,"total_state_update_time_ns":5524,"max_state_update_time_ns":393,"rows_received":319404,"rows_sent":319404,"morsels_received":30,"morsels_sent":30,"largest_morsel_received":18030,"largest_morsel_sent":18030,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967311,"kind":"EquiJoin","role":"join","inputs":[4294967309,4294967310],"properties":{"type":"EquiJoin","how":"INNER","left_on":["col(\"s_nationkey\")"],"right_on":["col(\"n_nationkey\")"],"nulls_equal":false,"coalesce":"JoinSpecific","maintain_order":"none","validation":"ManyToMany","suffix":"_right"},"metrics":{"total_time_ns":578502,"total_polls":91,"total_stolen_polls":22,"total_poll_time_ns":65573,"max_poll_time_ns":4697,"total_state_updates":86,"total_state_update_time_ns":512929,"max_state_update_time_ns":339511,"rows_received":319429,"rows_sent":319404,"morsels_received":39,"morsels_sent":30,"largest_morsel_received":18030,"largest_morsel_sent":18030,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967309,"kind":"SimpleProjection","role":"projection","inputs":[4294967308],"properties":{"type":"SimpleProjection","columns":["ps_supplycost","l_quantity","l_extendedprice","l_discount","o_orderdate","s_nationkey"]},"metrics":{"total_time_ns":147408,"total_polls":47,"total_stolen_polls":29,"total_poll_time_ns":141674,"max_poll_time_ns":20351,"total_state_updates":84,"total_state_update_time_ns":5734,"max_state_update_time_ns":505,"rows_received":319404,"rows_sent":319404,"morsels_received":30,"morsels_sent":30,"largest_morsel_received":18030,"largest_morsel_sent":18030,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967310,"kind":"MultiScan","role":"scan","inputs":[],"properties":{"type":"MultiScan","scan_type":"parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/nation.parquet","projected_file_columns":["n_nationkey","n_name"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":null,"predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"deletion_files_type":null,"hive_columns":null},"metrics":{"total_time_ns":143992,"total_polls":10,"total_stolen_polls":10,"total_poll_time_ns":25267,"max_poll_time_ns":13462,"total_state_updates":82,"total_state_update_time_ns":118725,"max_state_update_time_ns":36483,"rows_received":0,"rows_sent":25,"morsels_received":0,"morsels_sent":9,"largest_morsel_received":0,"largest_morsel_sent":3,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967308,"kind":"EquiJoin","role":"join","inputs":[4294967306,4294967307],"properties":{"type":"EquiJoin","how":"INNER","left_on":["col(\"l_orderkey\")"],"right_on":["col(\"o_orderkey\")"],"nulls_equal":false,"coalesce":"JoinSpecific","maintain_order":"none","validation":"ManyToMany","suffix":"_right"},"metrics":{"total_time_ns":7493026,"total_polls":178,"total_stolen_polls":36,"total_poll_time_ns":122391,"max_poll_time_ns":9660,"total_state_updates":86,"total_state_update_time_ns":7370635,"max_state_update_time_ns":6604597,"rows_received":1819404,"rows_sent":319404,"morsels_received":114,"morsels_sent":30,"largest_morsel_received":84880,"largest_morsel_sent":18030,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967306,"kind":"SimpleProjection","role":"projection","inputs":[4294967305],"properties":{"type":"SimpleProjection","columns":["ps_supplycost","s_nationkey","l_quantity","l_extendedprice","l_discount","l_orderkey"]},"metrics":{"total_time_ns":773307,"total_polls":108,"total_stolen_polls":21,"total_poll_time_ns":767760,"max_poll_time_ns":25451,"total_state_updates":84,"total_state_update_time_ns":5547,"max_state_update_time_ns":370,"rows_received":319404,"rows_sent":319404,"morsels_received":84,"morsels_sent":84,"largest_morsel_received":4625,"largest_morsel_sent":4625,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967307,"kind":"MultiScan","role":"scan","inputs":[],"properties":{"type":"MultiScan","scan_type":"parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/orders.parquet","projected_file_columns":["o_orderkey","o_orderdate"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":null,"predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"deletion_files_type":null,"hive_columns":null},"metrics":{"total_time_ns":476322,"total_polls":33,"total_stolen_polls":32,"total_poll_time_ns":36339,"max_poll_time_ns":6536,"total_state_updates":82,"total_state_update_time_ns":439983,"max_state_update_time_ns":88454,"rows_received":0,"rows_sent":1500000,"morsels_received":0,"morsels_sent":30,"largest_morsel_received":0,"largest_morsel_sent":84880,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967305,"kind":"EquiJoin","role":"join","inputs":[4294967303,4294967304],"properties":{"type":"EquiJoin","how":"INNER","left_on":["col(\"p_partkey\")","col(\"ps_suppkey\")"],"right_on":["col(\"l_partkey\")","col(\"l_suppkey\")"],"nulls_equal":false,"coalesce":"JoinSpecific","maintain_order":"none","validation":"ManyToMany","suffix":"_right"},"metrics":{"total_time_ns":1873237,"total_polls":247,"total_stolen_polls":57,"total_poll_time_ns":694341,"max_poll_time_ns":173288,"total_state_updates":86,"total_state_update_time_ns":1178896,"max_state_update_time_ns":961010,"rows_received":6043871,"rows_sent":319404,"morsels_received":105,"morsels_sent":84,"largest_morsel_received":85634,"largest_morsel_sent":4625,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967303,"kind":"SimpleProjection","role":"projection","inputs":[4294967302],"properties":{"type":"SimpleProjection","columns":["ps_supplycost","s_nationkey","p_partkey","ps_suppkey"]},"metrics":{"total_time_ns":43965,"total_polls":36,"total_stolen_polls":27,"total_poll_time_ns":36668,"max_poll_time_ns":9899,"total_state_updates":84,"total_state_update_time_ns":7297,"max_state_update_time_ns":496,"rows_received":42656,"rows_sent":42656,"morsels_received":21,"morsels_sent":21,"largest_morsel_received":4748,"largest_morsel_sent":4748,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967304,"kind":"MultiScan","role":"scan","inputs":[],"properties":{"type":"MultiScan","scan_type":"parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/lineitem.parquet","projected_file_columns":["l_orderkey","l_partkey","l_suppkey","l_quantity","l_extendedprice","l_discount"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":null,"predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"deletion_files_type":null,"hive_columns":null},"metrics":{"total_time_ns":8334829,"total_polls":87,"total_stolen_polls":86,"total_poll_time_ns":396481,"max_poll_time_ns":92568,"total_state_updates":82,"total_state_update_time_ns":7938348,"max_state_update_time_ns":5273511,"rows_received":0,"rows_sent":6001215,"morsels_received":0,"morsels_sent":84,"largest_morsel_received":0,"largest_morsel_sent":85634,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967302,"kind":"EquiJoin","role":"join","inputs":[4294967300,4294967301],"properties":{"type":"EquiJoin","how":"INNER","left_on":["col(\"ps_suppkey\")"],"right_on":["col(\"s_suppkey\")"],"nulls_equal":false,"coalesce":"JoinSpecific","maintain_order":"none","validation":"ManyToMany","suffix":"_right"},"metrics":{"total_time_ns":570648,"total_polls":79,"total_stolen_polls":21,"total_poll_time_ns":61529,"max_poll_time_ns":8574,"total_state_updates":86,"total_state_update_time_ns":509119,"max_state_update_time_ns":337066,"rows_received":52656,"rows_sent":42656,"morsels_received":33,"morsels_sent":21,"largest_morsel_received":4748,"largest_morsel_sent":4748,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967300,"kind":"EquiJoin","role":"join","inputs":[4294967298,4294967299],"properties":{"type":"EquiJoin","how":"INNER","left_on":["col(\"p_partkey\")"],"right_on":["col(\"ps_partkey\")"],"nulls_equal":false,"coalesce":"JoinSpecific","maintain_order":"none","validation":"ManyToMany","suffix":"_right"},"metrics":{"total_time_ns":569788,"total_polls":78,"total_stolen_polls":15,"total_poll_time_ns":45005,"max_poll_time_ns":2890,"total_state_updates":86,"total_state_update_time_ns":524783,"max_state_update_time_ns":375215,"rows_received":810664,"rows_sent":42656,"morsels_received":35,"morsels_sent":21,"largest_morsel_received":84909,"largest_morsel_sent":4748,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967301,"kind":"MultiScan","role":"scan","inputs":[],"properties":{"type":"MultiScan","scan_type":"parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/supplier.parquet","projected_file_columns":["s_suppkey","s_nationkey"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":null,"predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"deletion_files_type":null,"hive_columns":null},"metrics":{"total_time_ns":17512308,"total_polls":15,"total_stolen_polls":14,"total_poll_time_ns":36520,"max_poll_time_ns":13335,"total_state_updates":82,"total_state_update_time_ns":17475788,"max_state_update_time_ns":10101035,"rows_received":0,"rows_sent":10000,"morsels_received":0,"morsels_sent":12,"largest_morsel_received":0,"largest_morsel_sent":834,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967298,"kind":"SimpleProjection","role":"projection","inputs":[4294967297],"properties":{"type":"SimpleProjection","columns":["p_partkey"]},"metrics":{"total_time_ns":88907,"total_polls":38,"total_stolen_polls":12,"total_poll_time_ns":80764,"max_poll_time_ns":17727,"total_state_updates":84,"total_state_update_time_ns":8143,"max_state_update_time_ns":610,"rows_received":10664,"rows_sent":10664,"morsels_received":14,"morsels_sent":14,"largest_morsel_received":4550,"largest_morsel_sent":4550,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967299,"kind":"MultiScan","role":"scan","inputs":[],"properties":{"type":"MultiScan","scan_type":"parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/partsupp.parquet","projected_file_columns":["ps_partkey","ps_suppkey","ps_supplycost"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":null,"predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"deletion_files_type":null,"hive_columns":null},"metrics":{"total_time_ns":3271774,"total_polls":3,"total_stolen_polls":2,"total_poll_time_ns":31061,"max_poll_time_ns":28301,"total_state_updates":82,"total_state_update_time_ns":3240713,"max_state_update_time_ns":1992263,"rows_received":0,"rows_sent":800000,"morsels_received":0,"morsels_sent":21,"largest_morsel_received":0,"largest_morsel_sent":84909,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}},{"id":4294967297,"kind":"MultiScan","role":"scan","inputs":[],"properties":{"type":"MultiScan","scan_type":"parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/part.parquet","projected_file_columns":["p_partkey","p_name"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":"col(\"p_name\").str.contains([\"green\"])","predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"deletion_files_type":null,"hive_columns":null},"metrics":{"total_time_ns":2543379,"total_polls":3,"total_stolen_polls":2,"total_poll_time_ns":20133,"max_poll_time_ns":17097,"total_state_updates":82,"total_state_update_time_ns":2523246,"max_state_update_time_ns":1289743,"rows_received":0,"rows_sent":10664,"morsels_received":0,"morsels_sent":14,"largest_morsel_received":0,"largest_morsel_sent":4550,"io_total_active_ns":0,"io_total_bytes_received":0,"io_total_bytes_requested":0,"io_total_bytes_sent":0,"done":true}}],"logical":[{"id":22,"kind":"Sink","role":"sink","inputs":[14],"properties":{"type":"Sink","dest":"Memory"}},{"id":14,"kind":"Sort","role":"sort","inputs":[13],"properties":{"type":"Sort","sort_columns":[{"expr":"col(\"nation\")","descending":false,"nulls_last":false},{"expr":"col(\"o_year\")","descending":true,"nulls_last":false}],"slice":null,"maintain_order":false,"limit":null}},{"id":13,"kind":"GroupBy","role":"aggregation","inputs":[12],"properties":{"type":"GroupBy","keys":["col(\"nation\")","col(\"o_year\")"],"aggs":["col(\"amount\").sum().round().alias(\"sum_profit\")"],"maintain_order":false,"slice":null}},{"id":12,"kind":"Select","role":"projection","inputs":[16],"properties":{"type":"Select","exprs":["col(\"n_name\").alias(\"nation\")","col(\"o_orderdate\").dt.year().alias(\"o_year\")","col(\"l_extendedprice\").fms([1.0 - col(\"l_discount\"), col(\"ps_supplycost\") * col(\"l_quantity\").cast(Float64)]).alias(\"amount\")"]}},{"id":16,"kind":"SimpleProjection","role":"projection","inputs":[11],"properties":{"type":"SimpleProjection","columns":["n_name","o_orderdate","l_extendedprice","l_discount","ps_supplycost","l_quantity"]}},{"id":11,"kind":"Join","role":"join","inputs":[17,9],"properties":{"type":"Join","how":"INNER","left_on":["col(\"s_nationkey\")"],"right_on":["col(\"n_nationkey\")"],"nulls_equal":false,"coalesce":"JoinSpecific","maintain_order":"none","validation":"ManyToMany","suffix":"_right","slice":null}},{"id":17,"kind":"SimpleProjection","role":"projection","inputs":[8],"properties":{"type":"SimpleProjection","columns":["ps_supplycost","l_quantity","l_extendedprice","l_discount","o_orderdate","s_nationkey"]}},{"id":9,"kind":"Scan","role":"scan","inputs":[],"properties":{"type":"Scan","scan_type":"Parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/nation.parquet","file_columns":["n_nationkey","n_name","n_regionkey","n_comment"],"projection":["n_name","n_nationkey"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":null,"predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"column_mapping_type":null,"hive_columns":null}},{"id":8,"kind":"Join","role":"join","inputs":[18,7],"properties":{"type":"Join","how":"INNER","left_on":["col(\"l_orderkey\")"],"right_on":["col(\"o_orderkey\")"],"nulls_equal":false,"coalesce":"JoinSpecific","maintain_order":"none","validation":"ManyToMany","suffix":"_right","slice":null}},{"id":18,"kind":"SimpleProjection","role":"projection","inputs":[6],"properties":{"type":"SimpleProjection","columns":["ps_supplycost","s_nationkey","l_quantity","l_extendedprice","l_discount","l_orderkey"]}},{"id":7,"kind":"Scan","role":"scan","inputs":[],"properties":{"type":"Scan","scan_type":"Parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/orders.parquet","file_columns":["o_orderkey","o_custkey","o_orderstatus","o_totalprice","o_orderdate","o_orderpriority","o_clerk","o_shippriority","o_comment"],"projection":["o_orderdate","o_orderkey"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":null,"predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"column_mapping_type":null,"hive_columns":null}},{"id":6,"kind":"Join","role":"join","inputs":[19,5],"properties":{"type":"Join","how":"INNER","left_on":["col(\"p_partkey\")","col(\"ps_suppkey\")"],"right_on":["col(\"l_partkey\")","col(\"l_suppkey\")"],"nulls_equal":false,"coalesce":"JoinSpecific","maintain_order":"none","validation":"ManyToMany","suffix":"_right","slice":null}},{"id":19,"kind":"SimpleProjection","role":"projection","inputs":[4],"properties":{"type":"SimpleProjection","columns":["ps_supplycost","s_nationkey","p_partkey","ps_suppkey"]}},{"id":5,"kind":"Scan","role":"scan","inputs":[],"properties":{"type":"Scan","scan_type":"Parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/lineitem.parquet","file_columns":["l_orderkey","l_partkey","l_suppkey","l_linenumber","l_quantity","l_extendedprice","l_discount","l_tax","l_returnflag","l_linestatus","l_shipdate","l_commitdate","l_receiptdate","l_shipinstruct","l_shipmode","comments"],"projection":["l_orderkey","l_quantity","l_extendedprice","l_discount","l_partkey","l_suppkey"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":null,"predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"column_mapping_type":null,"hive_columns":null}},{"id":4,"kind":"Join","role":"join","inputs":[2,3],"properties":{"type":"Join","how":"INNER","left_on":["col(\"ps_suppkey\")"],"right_on":["col(\"s_suppkey\")"],"nulls_equal":false,"coalesce":"JoinSpecific","maintain_order":"none","validation":"ManyToMany","suffix":"_right","slice":null}},{"id":2,"kind":"Join","role":"join","inputs":[20,1],"properties":{"type":"Join","how":"INNER","left_on":["col(\"p_partkey\")"],"right_on":["col(\"ps_partkey\")"],"nulls_equal":false,"coalesce":"JoinSpecific","maintain_order":"none","validation":"ManyToMany","suffix":"_right","slice":null}},{"id":3,"kind":"Scan","role":"scan","inputs":[],"properties":{"type":"Scan","scan_type":"Parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/supplier.parquet","file_columns":["s_suppkey","s_name","s_address","s_nationkey","s_phone","s_acctbal","s_comment"],"projection":["s_nationkey","s_suppkey"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":null,"predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"column_mapping_type":null,"hive_columns":null}},{"id":20,"kind":"SimpleProjection","role":"projection","inputs":[0],"properties":{"type":"SimpleProjection","columns":["p_partkey"]}},{"id":1,"kind":"Scan","role":"scan","inputs":[],"properties":{"type":"Scan","scan_type":"Parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/partsupp.parquet","file_columns":["ps_partkey","ps_suppkey","ps_availqty","ps_supplycost","ps_comment"],"projection":["ps_suppkey","ps_supplycost","ps_partkey"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":null,"predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"column_mapping_type":null,"hive_columns":null}},{"id":0,"kind":"Scan","role":"scan","inputs":[],"properties":{"type":"Scan","scan_type":"Parquet","num_sources":1,"first_source":"/srv/polars-telemetry-tpch/data/tables/scale-1.0/part.parquet","file_columns":["p_partkey","p_name","p_mfgr","p_brand","p_type","p_size","p_container","p_retailprice","p_comment"],"projection":["p_partkey","p_name"],"row_index_name":null,"row_index_offset":null,"pre_slice":null,"predicate":["col(\"p_name\").str.contains([\"green\"])"],"predicate_file_skip_applied":null,"has_table_statistics":false,"include_file_paths":null,"column_mapping_type":null,"hive_columns":null}}]}}