plan.json

[
  {
    "Plan": {
      "Node Type": "Nested Loop",
      "Parallel Aware": false,
      "Join Type": "Inner",
      "Startup Cost": 0.01,
      "Total Cost": 12522520.01,
      "Plan Rows": 1000000000,
      "Plan Width": 12,
      "Actual Startup Time": 0.027,
      "Actual Total Time": 0.642,
      "Actual Rows": 1000,
      "Actual Loops": 1,
      "Inner Unique": false,
      "Plans": [
        {
          "Node Type": "Function Scan",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Function Name": "generate_series",
          "Alias": "c",
          "Startup Cost": 0.00,
          "Total Cost": 10.00,
          "Plan Rows": 1000,
          "Plan Width": 4,
          "Actual Startup Time": 0.009,
          "Actual Total Time": 0.012,
          "Actual Rows": 10,
          "Actual Loops": 1
        },
        {
          "Node Type": "Materialize",
          "Parent Relationship": "Inner",
          "Parallel Aware": false,
          "Startup Cost": 0.01,
          "Total Cost": 25010.01,
          "Plan Rows": 1000000,
          "Plan Width": 8,
          "Actual Startup Time": 0.001,
          "Actual Total Time": 0.026,
          "Actual Rows": 100,
          "Actual Loops": 10,
          "Plans": [
            {
              "Node Type": "Nested Loop",
              "Parent Relationship": "Outer",
              "Parallel Aware": false,
              "Join Type": "Inner",
              "Startup Cost": 0.01,
              "Total Cost": 20010.01,
              "Plan Rows": 1000000,
              "Plan Width": 8,
              "Actual Startup Time": 0.010,
              "Actual Total Time": 0.107,
              "Actual Rows": 100,
              "Actual Loops": 1,
              "Inner Unique": false,
              "Plans": [
                {
                  "Node Type": "Function Scan",
                  "Parent Relationship": "Outer",
                  "Parallel Aware": false,
                  "Function Name": "generate_series",
                  "Alias": "a",
                  "Startup Cost": 0.00,
                  "Total Cost": 10.00,
                  "Plan Rows": 1000,
                  "Plan Width": 4,
                  "Actual Startup Time": 0.004,
                  "Actual Total Time": 0.005,
                  "Actual Rows": 10,
                  "Actual Loops": 1
                },
                {
                  "Node Type": "Function Scan",
                  "Parent Relationship": "Inner",
                  "Parallel Aware": false,
                  "Function Name": "generate_series",
                  "Alias": "b",
                  "Startup Cost": 0.00,
                  "Total Cost": 10.00,
                  "Plan Rows": 1000,
                  "Plan Width": 4,
                  "Actual Startup Time": 0.000,
                  "Actual Total Time": 0.007,
                  "Actual Rows": 10,
                  "Actual Loops": 10
                }
              ]
            }
          ]
        }
      ]
    },
    "Planning Time": 40.502,
    "Triggers": [
    ],
    "Execution Time": 81.254
  }
]