gistfile1.txt

[
  {
    "Plan": {
      "Node Type": "Aggregate",
      "Strategy": "Hashed",
      "Startup Cost": 9272.64,
      "Total Cost": 9272.69,
      "Plan Rows": 6,
      "Plan Width": 226,
      "Actual Startup Time": 145.042,
      "Actual Total Time": 145.044,
      "Actual Rows": 6,
      "Actual Loops": 1,
      "Output": ["spl.supplier_name", "sum(str.quantity)", "spl.supplier_id"],
      "Plans": [
        {
          "Node Type": "Hash Join",
          "Parent Relationship": "Outer",
          "Join Type": "Inner",
          "Startup Cost": 1.14,
          "Total Cost": 8022.64,
          "Plan Rows": 250000,
          "Plan Width": 226,
          "Actual Startup Time": 0.033,
          "Actual Total Time": 99.871,
          "Actual Rows": 250000,
          "Actual Loops": 1,
          "Output": ["str.quantity", "spl.supplier_id", "spl.supplier_name"],
          "Hash Cond": "(str.supplier_id = spl.supplier_id)",
          "Plans": [
            {
              "Node Type": "Seq Scan",
              "Parent Relationship": "Outer",
              "Relation Name": "store",
              "Schema": "xvyhlid",
              "Alias": "str",
              "Startup Cost": 0.00,
              "Total Cost": 4584.00,
              "Plan Rows": 250000,
              "Plan Width": 8,
              "Actual Startup Time": 0.014,
              "Actual Total Time": 30.249,
              "Actual Rows": 250000,
              "Actual Loops": 1,
              "Output": ["str.id", "str.item_id", "str.supplier_id", "str.price", "str.vat", "str.quantity"]
            },
            {
              "Node Type": "Hash",
              "Parent Relationship": "Inner",
              "Startup Cost": 1.06,
              "Total Cost": 1.06,
              "Plan Rows": 6,
              "Plan Width": 222,
              "Actual Startup Time": 0.007,
              "Actual Total Time": 0.007,
              "Actual Rows": 6,
              "Actual Loops": 1,
              "Output": ["spl.supplier_id", "spl.supplier_name"],
              "Hash Buckets": 1024,
              "Hash Batches": 1,
              "Original Hash Batches": 1,
              "Peak Memory Usage": 1,
              "Plans": [
                {
                  "Node Type": "Seq Scan",
                  "Parent Relationship": "Outer",
                  "Relation Name": "supplier",
                  "Schema": "xvyhlid",
                  "Alias": "spl",
                  "Startup Cost": 0.00,
                  "Total Cost": 1.06,
                  "Plan Rows": 6,
                  "Plan Width": 222,
                  "Actual Startup Time": 0.004,
                  "Actual Total Time": 0.005,
                  "Actual Rows": 6,
                  "Actual Loops": 1,
                  "Output": ["spl.supplier_id", "spl.supplier_name"]
                }
              ]
            }
          ]
        }
      ]
    },
    "Triggers": [
    ],
    "Total Runtime": 145.127
  }
]