{
  "Query Text": "INSERT INTO pg_temp.tt115 (_Q_000_F_000_TYPE, _Q_000_F_000_RTRef, _Q_000_F_000_RRRef) SELECT\nT1.Fld44327_TYPE,\nT1.Fld44327_RTRef,\nT1.Fld44327_RRRef\nFROM (SELECT\nT6._Fld44327_TYPE AS Fld44327_TYPE,\nT6._Fld44327_RTRef AS Fld44327_RTRef,\nT6._Fld44327_RRRef AS Fld44327_RRRef,\nT6._Fld44329 AS Fld44329_\nFROM (SELECT\nT3.Fld44327_TYPE AS Fld44327_TYPE,\nT3.Fld44327_RTRef AS Fld44327_RTRef,\nT3.Fld44327_RRRef AS Fld44327_RRRef,\nT3.Fld44328RRef AS Fld44328RRef,\nT3.Fld44329_ AS Fld44329_,\nT3.Fld44330_ AS Fld44330_,\nT3.Fld44331RRef AS Fld44331RRef,\nT3.Fld44332RRef AS Fld44332RRef,\nT3.MAXPERIOD_ AS MAXPERIOD_,\nSUBSTR(MAX(T5._RecorderTRef || T5._RecorderRRef),1,4) AS MAXRECORDERTRef,\nSUBSTR(MAX(T5._RecorderTRef || T5._RecorderRRef),5,16) AS MAXRECORDERRRef\nFROM (SELECT\nT4._Fld44327_TYPE AS Fld44327_TYPE,\nT4._Fld44327_RTRef AS Fld44327_RTRef,\nT4._Fld44327_RRRef AS Fld44327_RRRef,\nT4._Fld44328RRef AS Fld44328RRef,\nT4._Fld44329 AS Fld44329_,\nT4._Fld44330 AS Fld44330_,\nT4._Fld44331RRef AS Fld44331RRef,\nT4._Fld44332RRef AS Fld44332RRef,\nMAX(T4._Period) AS MAXPERIOD_\nFROM _InfoRg44326 T4\nWHERE ((T4._Fld2507 = CAST(0 AS NUMERIC))) AND (T4._Active = TRUE)\nGROUP BY T4._Fld44327_TYPE,\nT4._Fld44327_RTRef,\nT4._Fld44327_RRRef,\nT4._Fld44328RRef,\nT4._Fld44329,\nT4._Fld44330,\nT4._Fld44331RRef,\nT4._Fld44332RRef) T3\nINNER JOIN _InfoRg44326 T5\nON T3.Fld44327_TYPE = T5._Fld44327_TYPE AND T3.Fld44327_RTRef = T5._Fld44327_RTRef AND T3.Fld44327_RRRef = T5._Fld44327_RRRef AND T3.Fld44328RRef = T5._Fld44328RRef AND T3.Fld44329_ = T5._Fld44329 AND T3.Fld44330_ = T5._Fld44330 AND T3.Fld44331RRef = T5._Fld44331RRef AND T3.Fld44332RRef = T5._Fld44332RRef AND T3.MAXPERIOD_ = T5._Period\nWHERE ((T5._Fld2507 = CAST(0 AS NUMERIC))) AND (T5._Active = TRUE)\nGROUP BY T3.Fld44327_TYPE,\nT3.Fld44327_RTRef,\nT3.Fld44327_RRRef,\nT3.Fld44328RRef,\nT3.Fld44329_,\nT3.Fld44330_,\nT3.Fld44331RRef,\nT3.Fld44332RRef,\nT3.MAXPERIOD_) T2\nINNER JOIN _InfoRg44326 T6\nON T2.Fld44327_TYPE = T6._Fld44327_TYPE AND T2.Fld44327_RTRef = T6._Fld44327_RTRef AND T2.Fld44327_RRRef = T6._Fld44327_RRRef AND T2.Fld44328RRef = T6._Fld44328RRef AND T2.Fld44329_ = T6._Fld44329 AND T2.Fld44330_ = T6._Fld44330 AND T2.Fld44331RRef = T6._Fld44331RRef AND T2.Fld44332RRef = T6._Fld44332RRef AND T2.MAXPERIOD_ = T6._Period AND T2.MAXRECORDERTRef = T6._RecorderTRef AND T2.MAXRECORDERRRef = T6._RecorderRRef\nWHERE (T6._Fld2507 = CAST(0 AS NUMERIC))) T1\nWHERE (T1.Fld44327_TYPE = '\\\\010'::bytea AND T1.Fld44327_RTRef = '\\\\000\\\\000\\\\004\\\\313'::bytea) AND EXISTS(SELECT\n1\nFROM pg_temp.tt135 T7\nWHERE (T1.Fld44327_TYPE = T7._Q_001_F_000_TYPE AND T1.Fld44327_RTRef = T7._Q_001_F_000_RTRef AND T1.Fld44327_RRRef = T7._Q_001_F_000_RRRef))\nGROUP BY T1.Fld44327_TYPE,\nT1.Fld44327_RTRef,\nT1.Fld44327_RRRef",
  "Plan": {
    "Node Type": "ModifyTable",
    "Operation": "Insert",
    "Parallel Aware": false,
    "Async Capable": false,
    "Relation Name": "tt115",
    "Schema": "pg_temp",
    "Alias": "tt115",
    "Startup Cost": 9211825754.06,
    "Total Cost": 9211826933.72,
    "Plan Rows": 0,
    "Plan Width": 0,
    "Actual Startup Time": 2968714.384,
    "Actual Total Time": 2968714.401,
    "Actual Rows": 0,
    "Actual Loops": 1,
    "Shared Hit Blocks": 995226886,
    "Shared Read Blocks": 1011373,
    "Shared Dirtied Blocks": 0,
    "Shared Written Blocks": 0,
    "Local Hit Blocks": 45,
    "Local Read Blocks": 0,
    "Local Dirtied Blocks": 1,
    "Local Written Blocks": 1,
    "Temp Read Blocks": 6241793,
    "Temp Written Blocks": 8776811,
    "Plans": [
      {
        "Node Type": "Aggregate",
        "Strategy": "Hashed",
        "Partial Mode": "Simple",
        "Parent Relationship": "Outer",
        "Parallel Aware": false,
        "Async Capable": false,
        "Startup Cost": 9211825754.06,
        "Total Cost": 9211826343.89,
        "Plan Rows": 58983,
        "Plan Width": 33,
        "Actual Startup Time": 2968713.427,
        "Actual Total Time": 2968713.997,
        "Actual Rows": 32,
        "Actual Loops": 1,
        "Output": ["t6._fld44327_type", "t6._fld44327_rtref", "t6._fld44327_rrref"],
        "Group Key": ["t6._fld44327_type", "t6._fld44327_rtref", "t6._fld44327_rrref"],
        "Planned Partitions": 0,
        "HashAgg Batches": 1,
        "Peak Memory Usage": 1561,
        "Disk Usage": 0,
        "Shared Hit Blocks": 995226886,
        "Shared Read Blocks": 1011373,
        "Shared Dirtied Blocks": 0,
        "Shared Written Blocks": 0,
        "Local Hit Blocks": 13,
        "Local Read Blocks": 0,
        "Local Dirtied Blocks": 0,
        "Local Written Blocks": 0,
        "Temp Read Blocks": 6241793,
        "Temp Written Blocks": 8776811,
        "Plans": [
          {
            "Node Type": "Hash Join",
            "Parent Relationship": "Outer",
            "Parallel Aware": false,
            "Async Capable": false,
            "Join Type": "Inner",
            "Startup Cost": 9201021200.09,
            "Total Cost": 9201099945.21,
            "Plan Rows": 3575269616,
            "Plan Width": 33,
            "Actual Startup Time": 2199171.184,
            "Actual Total Time": 2968709.084,
            "Actual Rows": 844,
            "Actual Loops": 1,
            "Output": ["t6._fld44327_type", "t6._fld44327_rtref", "t6._fld44327_rrref"],
            "Inner Unique": false,
            "Hash Cond": "((t4._fld44327_rrref = t6._fld44327_rrref) AND (t4._fld44328rref = t6._fld44328rref) AND (t4._fld44329 = t6._fld44329) AND (t4._fld44330 = t6._fld44330) AND (t4._fld44331rref = t6._fld44331rref) AND (t4._fld44332rref = t6._fld44332rref) AND ((max(t4._period)) = t6._period) AND ((substr(max((t5._recordertref || t5._recorderrref)), 1, 4)) = t6._recordertref) AND ((substr(max((t5._recordertref || t5._recorderrref)), 5, 16)) = t6._recorderrref))",
            "Shared Hit Blocks": 995226886,
            "Shared Read Blocks": 1011373,
            "Shared Dirtied Blocks": 0,
            "Shared Written Blocks": 0,
            "Local Hit Blocks": 13,
            "Local Read Blocks": 0,
            "Local Dirtied Blocks": 0,
            "Local Written Blocks": 0,
            "Temp Read Blocks": 6241793,
            "Temp Written Blocks": 8776811,
            "Plans": [
              {
                "Node Type": "Aggregate",
                "Strategy": "Hashed",
                "Partial Mode": "Simple",
                "Parent Relationship": "Outer",
                "Parallel Aware": false,
                "Async Capable": false,
                "Startup Cost": 9201012161.59,
                "Total Cost": 9201038779.65,
                "Plan Rows": 2218172,
                "Plan Width": 178,
                "Actual Startup Time": 2198531.028,
                "Actual Total Time": 2900074.559,
                "Actual Rows": 198012775,
                "Actual Loops": 1,
                "Output": ["t4._fld44327_type", "t4._fld44327_rtref", "t4._fld44327_rrref", "t4._fld44328rref", "t4._fld44329", "t4._fld44330", "t4._fld44331rref", "t4._fld44332rref", "(max(t4._period))", "substr(max((t5._recordertref || t5._recorderrref)), 1, 4)", "substr(max((t5._recordertref || t5._recorderrref)), 5, 16)"],
                "Group Key": ["t4._fld44327_type", "t4._fld44327_rtref", "t4._fld44327_rrref", "t4._fld44328rref", "t4._fld44329", "t4._fld44330", "t4._fld44331rref", "t4._fld44332rref", "(max(t4._period))"],
                "Planned Partitions": 0,
                "HashAgg Batches": 61,
                "Peak Memory Usage": 2097313,
                "Disk Usage": 27183120,
                "Shared Hit Blocks": 995226733,
                "Shared Read Blocks": 1011330,
                "Shared Dirtied Blocks": 0,
                "Shared Written Blocks": 0,
                "Local Hit Blocks": 0,
                "Local Read Blocks": 0,
                "Local Dirtied Blocks": 0,
                "Local Written Blocks": 0,
                "Temp Read Blocks": 6241793,
                "Temp Written Blocks": 8776811,
                "Plans": [
                  {
                    "Node Type": "Nested Loop",
                    "Parent Relationship": "Outer",
                    "Parallel Aware": false,
                    "Async Capable": false,
                    "Join Type": "Inner",
                    "Startup Cost": 0.56,
                    "Total Cost": 24955205.92,
                    "Plan Rows": 83418699597,
                    "Plan Width": 142,
                    "Actual Startup Time": 3.090,
                    "Actual Total Time": 1952947.179,
                    "Actual Rows": 198030367,
                    "Actual Loops": 1,
                    "Output": ["t4._fld44327_type", "t4._fld44327_rtref", "t4._fld44327_rrref", "t4._fld44328rref", "t4._fld44329", "t4._fld44330", "t4._fld44331rref", "t4._fld44332rref", "(max(t4._period))", "t5._recordertref", "t5._recorderrref"],
                    "Inner Unique": false,
                    "Shared Hit Blocks": 995226730,
                    "Shared Read Blocks": 1011330,
                    "Shared Dirtied Blocks": 0,
                    "Shared Written Blocks": 0,
                    "Local Hit Blocks": 0,
                    "Local Read Blocks": 0,
                    "Local Dirtied Blocks": 0,
                    "Local Written Blocks": 0,
                    "Temp Read Blocks": 0,
                    "Temp Written Blocks": 0,
                    "Plans": [
                      {
                        "Node Type": "Aggregate",
                        "Strategy": "Sorted",
                        "Partial Mode": "Simple",
                        "Parent Relationship": "Outer",
                        "Parallel Aware": false,
                        "Async Capable": false,
                        "Startup Cost": 0.28,
                        "Total Cost": 12101031.93,
                        "Plan Rows": 22181716,
                        "Plan Width": 114,
                        "Actual Startup Time": 3.063,
                        "Actual Total Time": 267430.873,
                        "Actual Rows": 198012775,
                        "Actual Loops": 1,
                        "Output": ["t4._fld44327_type", "t4._fld44327_rtref", "t4._fld44327_rrref", "t4._fld44328rref", "t4._fld44329", "t4._fld44330", "t4._fld44331rref", "t4._fld44332rref", "max(t4._period)"],
                        "Group Key": ["t4._fld44327_type", "t4._fld44327_rtref", "t4._fld44327_rrref", "t4._fld44328rref", "t4._fld44329", "t4._fld44330", "t4._fld44331rref", "t4._fld44332rref"],
                        "Shared Hit Blocks": 4618101,
                        "Shared Read Blocks": 996062,
                        "Shared Dirtied Blocks": 0,
                        "Shared Written Blocks": 0,
                        "Local Hit Blocks": 0,
                        "Local Read Blocks": 0,
                        "Local Dirtied Blocks": 0,
                        "Local Written Blocks": 0,
                        "Temp Read Blocks": 0,
                        "Temp Written Blocks": 0,
                        "Plans": [
                          {
                            "Node Type": "Index Only Scan",
                            "Parent Relationship": "Outer",
                            "Parallel Aware": false,
                            "Async Capable": false,
                            "Scan Direction": "Forward",
                            "Index Name": "_inforg44326_bydims",
                            "Relation Name": "_inforg44326",
                            "Schema": "public",
                            "Alias": "t4",
                            "Startup Cost": 0.28,
                            "Total Cost": 9882860.37,
                            "Plan Rows": 221817156,
                            "Plan Width": 114,
                            "Actual Startup Time": 3.052,
                            "Actual Total Time": 102096.163,
                            "Actual Rows": 221751467,
                            "Actual Loops": 1,
                            "Output": ["t4._fld2507", "t4._fld44327_type", "t4._fld44327_rtref", "t4._fld44327_rrref", "t4._fld44328rref", "t4._fld44329", "t4._fld44330", "t4._fld44331rref", "t4._fld44332rref", "t4._period", "t4._recordertref", "t4._recorderrref", "t4._lineno", "t4._active"],
                            "Index Cond": "((t4._fld2507 = '0'::numeric) AND (t4._fld44327_type = '\\\\x08'::bytea) AND (t4._fld44327_rtref = '\\\\x000004cb'::bytea) AND (t4._active = true))",
                            "Rows Removed by Index Recheck": 0,
                            "Heap Fetches": 564440,
                            "Shared Hit Blocks": 4618101,
                            "Shared Read Blocks": 996062,
                            "Shared Dirtied Blocks": 0,
                            "Shared Written Blocks": 0,
                            "Local Hit Blocks": 0,
                            "Local Read Blocks": 0,
                            "Local Dirtied Blocks": 0,
                            "Local Written Blocks": 0,
                            "Temp Read Blocks": 0,
                            "Temp Written Blocks": 0
                          }
                        ]
                      },
                      {
                        "Node Type": "Index Only Scan",
                        "Parent Relationship": "Inner",
                        "Parallel Aware": false,
                        "Async Capable": false,
                        "Scan Direction": "Forward",
                        "Index Name": "_inforg44326_bydims",
                        "Relation Name": "_inforg44326",
                        "Schema": "public",
                        "Alias": "t5",
                        "Startup Cost": 0.28,
                        "Total Cost": 0.56,
                        "Plan Rows": 1,
                        "Plan Width": 142,
                        "Actual Startup Time": 0.008,
                        "Actual Total Time": 0.008,
                        "Actual Rows": 1,
                        "Actual Loops": 198012775,
                        "Output": ["t5._fld2507", "t5._fld44327_type", "t5._fld44327_rtref", "t5._fld44327_rrref", "t5._fld44328rref", "t5._fld44329", "t5._fld44330", "t5._fld44331rref", "t5._fld44332rref", "t5._period", "t5._recordertref", "t5._recorderrref", "t5._lineno", "t5._active"],
                        "Index Cond": "((t5._fld2507 = '0'::numeric) AND (t5._fld44327_type = '\\\\x08'::bytea) AND (t5._fld44327_rtref = '\\\\x000004cb'::bytea) AND (t5._fld44327_rrref = t4._fld44327_rrref) AND (t5._fld44328rref = t4._fld44328rref) AND (t5._fld44329 = t4._fld44329) AND (t5._fld44330 = t4._fld44330) AND (t5._fld44331rref = t4._fld44331rref) AND (t5._fld44332rref = t4._fld44332rref) AND (t5._period = (max(t4._period))) AND (t5._active = true))",
                        "Rows Removed by Index Recheck": 0,
                        "Heap Fetches": 559313,
                        "Shared Hit Blocks": 990608629,
                        "Shared Read Blocks": 15268,
                        "Shared Dirtied Blocks": 0,
                        "Shared Written Blocks": 0,
                        "Local Hit Blocks": 0,
                        "Local Read Blocks": 0,
                        "Local Dirtied Blocks": 0,
                        "Local Written Blocks": 0,
                        "Temp Read Blocks": 0,
                        "Temp Written Blocks": 0
                      }
                    ]
                  }
                ]
              },
              {
                "Node Type": "Hash",
                "Parent Relationship": "Inner",
                "Parallel Aware": false,
                "Async Capable": false,
                "Startup Cost": 6752.01,
                "Total Cost": 6752.01,
                "Plan Rows": 120342,
                "Plan Width": 159,
                "Actual Startup Time": 81.107,
                "Actual Total Time": 81.114,
                "Actual Rows": 920,
                "Actual Loops": 1,
                "Output": ["t6._fld44327_type", "t6._fld44327_rtref", "t6._fld44327_rrref", "t6._fld44328rref", "t6._fld44329", "t6._fld44330", "t6._fld44331rref", "t6._fld44332rref", "t6._period", "t6._recordertref", "t6._recorderrref", "t7._q_001_f_000_rrref"],
                "Hash Buckets": 131072,
                "Original Hash Buckets": 131072,
                "Hash Batches": 1,
                "Original Hash Batches": 1,
                "Peak Memory Usage": 1182,
                "Shared Hit Blocks": 153,
                "Shared Read Blocks": 43,
                "Shared Dirtied Blocks": 0,
                "Shared Written Blocks": 0,
                "Local Hit Blocks": 13,
                "Local Read Blocks": 0,
                "Local Dirtied Blocks": 0,
                "Local Written Blocks": 0,
                "Temp Read Blocks": 0,
                "Temp Written Blocks": 0,
                "Plans": [
                  {
                    "Node Type": "Nested Loop",
                    "Parent Relationship": "Outer",
                    "Parallel Aware": false,
                    "Async Capable": false,
                    "Join Type": "Inner",
                    "Startup Cost": 27.24,
                    "Total Cost": 6752.01,
                    "Plan Rows": 120342,
                    "Plan Width": 159,
                    "Actual Startup Time": 0.549,
                    "Actual Total Time": 80.417,
                    "Actual Rows": 920,
                    "Actual Loops": 1,
                    "Output": ["t6._fld44327_type", "t6._fld44327_rtref", "t6._fld44327_rrref", "t6._fld44328rref", "t6._fld44329", "t6._fld44330", "t6._fld44331rref", "t6._fld44332rref", "t6._period", "t6._recordertref", "t6._recorderrref", "t7._q_001_f_000_rrref"],
                    "Inner Unique": false,
                    "Shared Hit Blocks": 153,
                    "Shared Read Blocks": 43,
                    "Shared Dirtied Blocks": 0,
                    "Shared Written Blocks": 0,
                    "Local Hit Blocks": 13,
                    "Local Read Blocks": 0,
                    "Local Dirtied Blocks": 0,
                    "Local Written Blocks": 0,
                    "Temp Read Blocks": 0,
                    "Temp Written Blocks": 0,
                    "Plans": [
                      {
                        "Node Type": "Aggregate",
                        "Strategy": "Hashed",
                        "Partial Mode": "Simple",
                        "Parent Relationship": "Outer",
                        "Parallel Aware": false,
                        "Async Capable": false,
                        "Startup Cost": 26.96,
                        "Total Cost": 27.28,
                        "Plan Rows": 32,
                        "Plan Width": 24,
                        "Actual Startup Time": 0.438,
                        "Actual Total Time": 0.479,
                        "Actual Rows": 32,
                        "Actual Loops": 1,
                        "Output": ["t7._q_001_f_000_type", "t7._q_001_f_000_rtref", "t7._q_001_f_000_rrref"],
                        "Group Key": ["t7._q_001_f_000_type", "t7._q_001_f_000_rtref", "t7._q_001_f_000_rrref"],
                        "Planned Partitions": 0,
                        "HashAgg Batches": 1,
                        "Peak Memory Usage": 24,
                        "Disk Usage": 0,
                        "Shared Hit Blocks": 0,
                        "Shared Read Blocks": 0,
                        "Shared Dirtied Blocks": 0,
                        "Shared Written Blocks": 0,
                        "Local Hit Blocks": 13,
                        "Local Read Blocks": 0,
                        "Local Dirtied Blocks": 0,
                        "Local Written Blocks": 0,
                        "Temp Read Blocks": 0,
                        "Temp Written Blocks": 0,
                        "Plans": [
                          {
                            "Node Type": "Seq Scan",
                            "Parent Relationship": "Outer",
                            "Parallel Aware": false,
                            "Async Capable": false,
                            "Relation Name": "tt135",
                            "Schema": "pg_temp",
                            "Alias": "t7",
                            "Startup Cost": 0.00,
                            "Total Cost": 24.43,
                            "Plan Rows": 844,
                            "Plan Width": 24,
                            "Actual Startup Time": 0.016,
                            "Actual Total Time": 0.173,
                            "Actual Rows": 844,
                            "Actual Loops": 1,
                            "Output": ["t7._q_001_f_000_type", "t7._q_001_f_000_rtref", "t7._q_001_f_000_rrref", "t7._q_001_f_001", "t7._q_001_f_002rref", "t7._q_001_f_003", "t7._q_001_f_004", "t7._q_001_f_005rref", "t7._q_001_f_006"],
                            "Filter": "((t7._q_001_f_000_type = '\\\\x08'::bytea) AND (t7._q_001_f_000_rtref = '\\\\x000004cb'::bytea))",
                            "Rows Removed by Filter": 0,
                            "Shared Hit Blocks": 0,
                            "Shared Read Blocks": 0,
                            "Shared Dirtied Blocks": 0,
                            "Shared Written Blocks": 0,
                            "Local Hit Blocks": 13,
                            "Local Read Blocks": 0,
                            "Local Dirtied Blocks": 0,
                            "Local Written Blocks": 0,
                            "Temp Read Blocks": 0,
                            "Temp Written Blocks": 0
                          }
                        ]
                      },
                      {
                        "Node Type": "Index Only Scan",
                        "Parent Relationship": "Inner",
                        "Parallel Aware": false,
                        "Async Capable": false,
                        "Scan Direction": "Forward",
                        "Index Name": "_inforg44326_bydims",
                        "Relation Name": "_inforg44326",
                        "Schema": "public",
                        "Alias": "t6",
                        "Startup Cost": 0.28,
                        "Total Cost": 172.54,
                        "Plan Rows": 3761,
                        "Plan Width": 142,
                        "Actual Startup Time": 2.206,
                        "Actual Total Time": 2.492,
                        "Actual Rows": 29,
                        "Actual Loops": 32,
                        "Output": ["t6._fld2507", "t6._fld44327_type", "t6._fld44327_rtref", "t6._fld44327_rrref", "t6._fld44328rref", "t6._fld44329", "t6._fld44330", "t6._fld44331rref", "t6._fld44332rref", "t6._period", "t6._recordertref", "t6._recorderrref", "t6._lineno", "t6._active"],
                        "Index Cond": "((t6._fld2507 = '0'::numeric) AND (t6._fld44327_type = '\\\\x08'::bytea) AND (t6._fld44327_rtref = '\\\\x000004cb'::bytea) AND (t6._fld44327_rrref = t7._q_001_f_000_rrref))",
                        "Rows Removed by Index Recheck": 0,
                        "Heap Fetches": 0,
                        "Shared Hit Blocks": 153,
                        "Shared Read Blocks": 43,
                        "Shared Dirtied Blocks": 0,
                        "Shared Written Blocks": 0,
                        "Local Hit Blocks": 0,
                        "Local Read Blocks": 0,
                        "Local Dirtied Blocks": 0,
                        "Local Written Blocks": 0,
                        "Temp Read Blocks": 0,
                        "Temp Written Blocks": 0
                      }
                    ]
                  }
                ]
              }
            ]
          }
        ]
      }
    ]
  },
  "Settings": {
    "cpu_operator_cost": "0.001",
    "effective_cache_size": "384GB",
    "enable_mergejoin": "off",
    "max_parallel_workers": "10",
    "max_parallel_workers_per_gather": "0",
    "random_page_cost": "1",
    "seq_page_cost": "1.1",
    "temp_buffers": "128MB",
    "work_mem": "1GB"
  }
}