ggevay

{
    "explainee": {
        "query": "SELECT\n  int4_one\nFROM\n  constant_folding\nWHERE (abs(int8_max + date_part('decade', time_val_1)) = uint4_null);\n"
    },
    "list": [
        {
            "id": 0,
            "time": 6842,
            "path": "optimize/raw",
            "plan": "Project (#1)\n  Filter (abs((bigint_to_double(#3) + date_partt(\"decade\", #5))) = uint4_to_double(#4))\n    Get materialize.public.constant_folding\n"

ggevay

{
    "explainee": {
        "query": "SELECT *\n  FROM t2 AS a1\n  left JOIN t2 AS a2\n    ON (a1 . f1 = a2 . f1)\n WHERE (a2 .f2 = 1)\n    OR (a1 . f1 = 6 AND a1 .f2 = 3 AND a2 .f2 = 4)\n    OR (a1 . f1 > 0 AND a1 . f1 = 6) ;"
    },
    "list": [
        {
            "id": 0,
            "time": 3308,
            "path": "optimize/raw",
            "plan": "Filter (((#3 = integer_to_double(1)) OR (((#0 = integer_to_double(6)) AND (#1 = integer_to_double(3))) AND (#3 = integer_to_double(4)))) OR ((#0 > integer_to_double(0)) AND (#0 = integer_to_double(6))))\n  LeftOuterJoin (#0 = #2)\n    Get materialize.public.t2\n    Get materialize.public.t2\n"