== Unoptimized Logical Plan ==

* Project: col(patient_id) as count
|
* Aggregation: count(col(patient_id), All)
|   Output schema = patient_id#UInt64
|
* Filter: [[[col(lab_test) == lit("GLUCOSE,PANEL")] & [col(result_datetime)
|     >= lit(2016-12-01)]] & [col(result_datetime) <= lit(2017-01-01)]] &
|     [[col(result_value) > col(range_high)] | [col(result_value) < col(range_low)]]
|
* PythonScanOperator: DeltaLakeScanOperator(None)
|   File schema = patient_id#Utf8, lab_test#Utf8,
|     result_datetime#Timestamp(Microseconds, Some("UTC")),
|     result_value#Decimal128(38, 5), result_unit#Utf8, range_low#Decimal128(38, 5),
|     range_high#Decimal128(38, 5)
|   Partitioning keys = []
|   Output schema = patient_id#Utf8, lab_test#Utf8,
|     result_datetime#Timestamp(Microseconds, Some("UTC")),
|     result_value#Decimal128(38, 5), result_unit#Utf8, range_low#Decimal128(38, 5),
|     range_high#Decimal128(38, 5)


== Optimized Logical Plan ==

* Project: col(patient_id) as count
|   Stats = { Lower bound rows = 0, Upper bound rows = 1, Lower bound bytes =
|     545736211, Upper bound bytes = 4 }
|
* Aggregation: count(col(patient_id), All)
|   Output schema = patient_id#UInt64
|   Stats = { Lower bound rows = 0, Upper bound rows = 1, Lower bound bytes =
|     545736211, Upper bound bytes = 4 }
|
* Num Scan Tasks = 67
|   File schema = patient_id#Utf8, lab_test#Utf8,
|     result_datetime#Timestamp(Microseconds, Some("UTC")),
|     result_value#Decimal128(38, 5), result_unit#Utf8, range_low#Decimal128(38, 5),
|     range_high#Decimal128(38, 5)
|   Partitioning keys = []
|   Projection pushdown = [patient_id]
|   Filter pushdown = [[[col(lab_test) == lit("GLUCOSE,PANEL")] &
|     [col(result_datetime) >= lit(2016-12-01)]] & [col(result_datetime) <= lit(2017-
|     01-01)]] & [[col(result_value) > col(range_high)] | [col(result_value) <
|     col(range_low)]]
|   Output schema = patient_id#Utf8
|   Stats = { Lower bound rows = 0, Upper bound rows = 135586644, Lower bound bytes
|     = 545736211, Upper bound bytes = 545736211 }