{
  "Query Text": "-- SP QPROC2 #21(скГрафикПлатежей(срез последних)) [1] time_us=207\r\nINSERT INTO pg_temp.tt32 (_Q_001_F_000_TYPE, _Q_001_F_000_RTRef, _Q_001_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._Fld44327_TYPE = '\\\\010'::bytea AND T4._Fld44327_RTRef \n= '\\\\000\\\\000\\\\004\\\\313'::bytea) AND EXISTS(SELECT\n1\nFROM pg_temp.tt28 T7\nWHERE (T4._Fld44327_TYPE = T7._Q_001_F_000_TYPE AND T4._Fld44327_RTRef \n= T7._Q_001_F_000_RTRef AND T4._Fld44327_RRRef = T7._Q_001_F_000_RRRef)) AND ((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.\n_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._Fld44327_TYPE = '\\\\010'::bytea AND T5._Fld44327_RTRef \n= '\\\\000\\\\000\\\\004\\\\313'::bytea) AND EXISTS(SELECT\n1\nFROM pg_temp.tt28 T7\nWHERE (T5._Fld44327_TYPE = T7._Q_001_F_000_TYPE AND T5._Fld44327_RTRef \n= T7._Q_001_F_000_RTRef AND T5._Fld44327_RRRef = T7._Q_001_F_000_RRRef)) AND ((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\n GROUP BY T1.Fld44327_TYPE,\nT1.Fld44327_RTRef,\nT1.Fld44327_RRRef;CoMmIt;",
  "Plan": {
    "Node Type": "ModifyTable",
    "Operation": "Insert",
    "Parallel Aware": false,
    "Async Capable": false,
    "Relation Name": "tt32",
    "Schema": "pg_temp",
    "Alias": "tt32",
    "Startup Cost": 15336879.23,
    "Total Cost": 15336879.24,
    "Plan Rows": 0,
    "Plan Width": 0,
    "Actual Startup Time": 19188.876,
    "Actual Total Time": 19188.891,
    "Actual Rows": 0,
    "Actual Loops": 1,
    "Shared Hit Blocks": 5981060,
    "Shared Read Blocks": 7796,
    "Shared Dirtied Blocks": 0,
    "Shared Written Blocks": 0,
    "Local Hit Blocks": 38372,
    "Local Read Blocks": 2,
    "Local Dirtied Blocks": 238,
    "Local Written Blocks": 237,
    "Temp Read Blocks": 0,
    "Temp Written Blocks": 0,
    "Plans": [
      {
        "Node Type": "Group",
        "Parent Relationship": "Outer",
        "Parallel Aware": false,
        "Async Capable": false,
        "Startup Cost": 15336879.23,
        "Total Cost": 15336879.23,
        "Plan Rows": 1,
        "Plan Width": 30,
        "Actual Startup Time": 19075.397,
        "Actual Total Time": 19176.260,
        "Actual Rows": 36827,
        "Actual Loops": 1,
        "Output": ["t6._fld44327_type", "t6._fld44327_rtref", "t6._fld44327_rrref"],
        "Group Key": ["t6._fld44327_type", "t6._fld44327_rtref", "t6._fld44327_rrref"],
        "Shared Hit Blocks": 5981060,
        "Shared Read Blocks": 7796,
        "Shared Dirtied Blocks": 0,
        "Shared Written Blocks": 0,
        "Local Hit Blocks": 1076,
        "Local Read Blocks": 0,
        "Local Dirtied Blocks": 0,
        "Local Written Blocks": 0,
        "Temp Read Blocks": 0,
        "Temp Written Blocks": 0,
        "Plans": [
          {
            "Node Type": "Sort",
            "Parent Relationship": "Outer",
            "Parallel Aware": false,
            "Async Capable": false,
            "Startup Cost": 15336879.23,
            "Total Cost": 15336879.23,
            "Plan Rows": 1,
            "Plan Width": 30,
            "Actual Startup Time": 19075.392,
            "Actual Total Time": 19101.492,
            "Actual Rows": 556757,
            "Actual Loops": 1,
            "Output": ["t6._fld44327_type", "t6._fld44327_rtref", "t6._fld44327_rrref"],
            "Sort Key": ["t6._fld44327_type", "t6._fld44327_rtref", "t6._fld44327_rrref"],
            "Sort Method": "quicksort",
            "Sort Space Used": 59374,
            "Sort Space Type": "Memory",
            "Shared Hit Blocks": 5981060,
            "Shared Read Blocks": 7796,
            "Shared Dirtied Blocks": 0,
            "Shared Written Blocks": 0,
            "Local Hit Blocks": 1076,
            "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": 15336877.04,
                "Total Cost": 15336879.21,
                "Plan Rows": 1,
                "Plan Width": 30,
                "Actual Startup Time": 13433.799,
                "Actual Total Time": 18903.088,
                "Actual Rows": 556757,
                "Actual Loops": 1,
                "Output": ["t6._fld44327_type", "t6._fld44327_rtref", "t6._fld44327_rrref"],
                "Inner Unique": false,
                "Shared Hit Blocks": 5981060,
                "Shared Read Blocks": 7796,
                "Shared Dirtied Blocks": 0,
                "Shared Written Blocks": 0,
                "Local Hit Blocks": 1076,
                "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": 15336876.76,
                    "Total Cost": 15336876.88,
                    "Plan Rows": 1,
                    "Plan Width": 172,
                    "Actual Startup Time": 13433.757,
                    "Actual Total Time": 14370.445,
                    "Actual Rows": 556757,
                    "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))"],
                    "Shared Hit Blocks": 3096258,
                    "Shared Read Blocks": 7796,
                    "Shared Dirtied Blocks": 0,
                    "Shared Written Blocks": 0,
                    "Local Hit Blocks": 1076,
                    "Local Read Blocks": 0,
                    "Local Dirtied Blocks": 0,
                    "Local Written Blocks": 0,
                    "Temp Read Blocks": 0,
                    "Temp Written Blocks": 0,
                    "Plans": [
                      {
                        "Node Type": "Sort",
                        "Parent Relationship": "Outer",
                        "Parallel Aware": false,
                        "Async Capable": false,
                        "Startup Cost": 15336876.76,
                        "Total Cost": 15336876.76,
                        "Plan Rows": 1,
                        "Plan Width": 134,
                        "Actual Startup Time": 13433.706,
                        "Actual Total Time": 13583.110,
                        "Actual Rows": 556805,
                        "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"],
                        "Sort Key": ["t4._fld44327_rrref", "t4._fld44328rref", "t4._fld44329", "t4._fld44330", "t4._fld44331rref", "t4._fld44332rref", "(max(t4._period))"],
                        "Sort Method": "quicksort",
                        "Sort Space Used": 115927,
                        "Sort Space Type": "Memory",
                        "Shared Hit Blocks": 3096258,
                        "Shared Read Blocks": 7796,
                        "Shared Dirtied Blocks": 0,
                        "Shared Written Blocks": 0,
                        "Local Hit Blocks": 1076,
                        "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": 8204425.57,
                            "Total Cost": 15336876.74,
                            "Plan Rows": 1,
                            "Plan Width": 134,
                            "Actual Startup Time": 5670.136,
                            "Actual Total Time": 12427.558,
                            "Actual Rows": 556805,
                            "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": 3096258,
                            "Shared Read Blocks": 7796,
                            "Shared Dirtied Blocks": 0,
                            "Shared Written Blocks": 0,
                            "Local Hit Blocks": 1076,
                            "Local Read Blocks": 0,
                            "Local Dirtied Blocks": 0,
                            "Local Written Blocks": 0,
                            "Temp Read Blocks": 0,
                            "Temp Written Blocks": 0,
                            "Plans": [
                              {
                                "Node Type": "Hash Join",
                                "Parent Relationship": "Outer",
                                "Parallel Aware": false,
                                "Async Capable": false,
                                "Join Type": "Inner",
                                "Startup Cost": 8204425.29,
                                "Total Cost": 8908941.53,
                                "Plan Rows": 11182798,
                                "Plan Width": 132,
                                "Actual Startup Time": 5670.105,
                                "Actual Total Time": 6385.769,
                                "Actual Rows": 556757,
                                "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))", "t7._q_001_f_000_type", "t7._q_001_f_000_rtref", "t7._q_001_f_000_rrref"],
                                "Inner Unique": false,
                                "Hash Cond": "(t4._fld44327_rrref = t7._q_001_f_000_rrref)",
                                "Shared Hit Blocks": 205191,
                                "Shared Read Blocks": 7782,
                                "Shared Dirtied Blocks": 0,
                                "Shared Written Blocks": 0,
                                "Local Hit Blocks": 1076,
                                "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": 8202507.72,
                                    "Total Cost": 8426163.67,
                                    "Plan Rows": 22365595,
                                    "Plan Width": 108,
                                    "Actual Startup Time": 5640.972,
                                    "Actual Total Time": 6062.324,
                                    "Actual Rows": 556757,
                                    "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"],
                                    "Planned Partitions": 0,
                                    "HashAgg Batches": 1,
                                    "Peak Memory Usage": 884761,
                                    "Disk Usage": 0,
                                    "Shared Hit Blocks": 205191,
                                    "Shared Read Blocks": 7782,
                                    "Shared Dirtied Blocks": 0,
                                    "Shared Written Blocks": 0,
                                    "Local Hit Blocks": 538,
                                    "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": 1144.48,
                                        "Total Cost": 6954205.15,
                                        "Plan Rows": 138700285,
                                        "Plan Width": 108,
                                        "Actual Startup Time": 21.066,
                                        "Actual Total Time": 5117.607,
                                        "Actual Rows": 710573,
                                        "Actual Loops": 1,
                                        "Output": ["t4._fld44327_type", "t4._fld44327_rtref", "t4._fld44327_rrref", "t4._fld44328rref", "t4._fld44329", "t4._fld44330", "t4._fld44331rref", "t4._fld44332rref", "t4._period"],
                                        "Inner Unique": false,
                                        "Shared Hit Blocks": 205191,
                                        "Shared Read Blocks": 7782,
                                        "Shared Dirtied Blocks": 0,
                                        "Shared Written Blocks": 0,
                                        "Local Hit Blocks": 538,
                                        "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": 1144.21,
                                            "Total Cost": 1512.48,
                                            "Plan Rows": 36827,
                                            "Plan Width": 24,
                                            "Actual Startup Time": 17.441,
                                            "Actual Total Time": 31.402,
                                            "Actual Rows": 36827,
                                            "Actual Loops": 1,
                                            "Output": ["t7_1._q_001_f_000_type", "t7_1._q_001_f_000_rtref", "t7_1._q_001_f_000_rrref"],
                                            "Group Key": ["t7_1._q_001_f_000_type", "t7_1._q_001_f_000_rtref", "t7_1._q_001_f_000_rrref"],
                                            "Planned Partitions": 0,
                                            "HashAgg Batches": 1,
                                            "Peak Memory Usage": 5649,
                                            "Disk Usage": 0,
                                            "Shared Hit Blocks": 0,
                                            "Shared Read Blocks": 0,
                                            "Shared Dirtied Blocks": 0,
                                            "Shared Written Blocks": 0,
                                            "Local Hit Blocks": 538,
                                            "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": "tt28",
                                                "Schema": "pg_temp",
                                                "Alias": "t7_1",
                                                "Startup Cost": 0.00,
                                                "Total Cost": 1033.72,
                                                "Plan Rows": 36827,
                                                "Plan Width": 24,
                                                "Actual Startup Time": 0.013,
                                                "Actual Total Time": 5.398,
                                                "Actual Rows": 36827,
                                                "Actual Loops": 1,
                                                "Output": ["t7_1._q_001_f_000_type", "t7_1._q_001_f_000_rtref", "t7_1._q_001_f_000_rrref", "t7_1._q_001_f_001", "t7_1._q_001_f_002rref", "t7_1._q_001_f_003", "t7_1._q_001_f_004", "t7_1._q_001_f_005rref", "t7_1._q_001_f_006"],
                                                "Filter": "((t7_1._q_001_f_000_type = '\\\\x08'::bytea) AND (t7_1._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": 538,
                                                "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": "t4",
                                            "Startup Cost": 0.28,
                                            "Total Cost": 151.13,
                                            "Plan Rows": 3766,
                                            "Plan Width": 108,
                                            "Actual Startup Time": 0.078,
                                            "Actual Total Time": 0.136,
                                            "Actual Rows": 19,
                                            "Actual Loops": 36827,
                                            "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._fld44327_rrref = t7_1._q_001_f_000_rrref) AND (t4._active = true))",
                                            "Rows Removed by Index Recheck": 0,
                                            "Heap Fetches": 100957,
                                            "Shared Hit Blocks": 205191,
                                            "Shared Read Blocks": 7782,
                                            "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": 1512.48,
                                    "Total Cost": 1512.48,
                                    "Plan Rows": 36827,
                                    "Plan Width": 24,
                                    "Actual Startup Time": 29.042,
                                    "Actual Total Time": 29.043,
                                    "Actual Rows": 36827,
                                    "Actual Loops": 1,
                                    "Output": ["t7._q_001_f_000_type", "t7._q_001_f_000_rtref", "t7._q_001_f_000_rrref"],
                                    "Hash Buckets": 65536,
                                    "Original Hash Buckets": 65536,
                                    "Hash Batches": 1,
                                    "Original Hash Batches": 1,
                                    "Peak Memory Usage": 2526,
                                    "Shared Hit Blocks": 0,
                                    "Shared Read Blocks": 0,
                                    "Shared Dirtied Blocks": 0,
                                    "Shared Written Blocks": 0,
                                    "Local Hit Blocks": 538,
                                    "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": 1144.21,
                                        "Total Cost": 1512.48,
                                        "Plan Rows": 36827,
                                        "Plan Width": 24,
                                        "Actual Startup Time": 16.553,
                                        "Actual Total Time": 22.859,
                                        "Actual Rows": 36827,
                                        "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": 5649,
                                        "Disk Usage": 0,
                                        "Shared Hit Blocks": 0,
                                        "Shared Read Blocks": 0,
                                        "Shared Dirtied Blocks": 0,
                                        "Shared Written Blocks": 0,
                                        "Local Hit Blocks": 538,
                                        "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": "tt28",
                                            "Schema": "pg_temp",
                                            "Alias": "t7",
                                            "Startup Cost": 0.00,
                                            "Total Cost": 1033.72,
                                            "Plan Rows": 36827,
                                            "Plan Width": 24,
                                            "Actual Startup Time": 0.018,
                                            "Actual Total Time": 7.034,
                                            "Actual Rows": 36827,
                                            "Actual Loops": 1,
                                            "Output": ["t7._q_001_f_000_type", "t7._q_001_f_000_rtref", "t7._q_001_f_000_rrref"],
                                            "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": 538,
                                            "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": 134,
                                "Actual Startup Time": 0.010,
                                "Actual Total Time": 0.010,
                                "Actual Rows": 1,
                                "Actual Loops": 556757,
                                "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": 100957,
                                "Shared Hit Blocks": 2891067,
                                "Shared Read Blocks": 14,
                                "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": "t6",
                    "Startup Cost": 0.28,
                    "Total Cost": 2.30,
                    "Plan Rows": 1,
                    "Plan Width": 134,
                    "Actual Startup Time": 0.007,
                    "Actual Total Time": 0.008,
                    "Actual Rows": 1,
                    "Actual Loops": 556757,
                    "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 = t4._fld44327_type) AND (t6._fld44327_rtref = t4._fld44327_rtref) AND (t6._fld44327_rrref = t4._fld44327_rrref) AND (t6._fld44328rref = t4._fld44328rref) AND (t6._fld44329 = t4._fld44329) AND (t6._fld44330 = t4._fld44330) AND (t6._fld44331rref = t4._fld44331rref) AND (t6._fld44332rref = t4._fld44332rref) AND (t6._period = (max(t4._period))) AND (t6._recordertref = (substr(max((t5._recordertref || t5._recorderrref)), 1, 4))) AND (t6._recorderrref = (substr(max((t5._recordertref || t5._recorderrref)), 5, 16))))",
                    "Rows Removed by Index Recheck": 0,
                    "Heap Fetches": 100957,
                    "Shared Hit Blocks": 2884802,
                    "Shared Read Blocks": 0,
                    "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": "3GB"
  }
}