Re: explain format json, unit for serialize and memory are different. - Mailing list pgsql-hackers

From jian he
Subject Re: explain format json, unit for serialize and memory are different.
Date
Msg-id CACJufxHymp4=CCfnMRx5e2U47P3aCo45XN7QOamQ9zBo=JhaRA@mail.gmail.com
Whole thread Raw
In response to Re: explain format json, unit for serialize and memory are different.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: explain format json, unit for serialize and memory are different.
List pgsql-hackers
explain (format json, analyze, wal, buffers, memory, serialize) insert
into tenk1 select * from tenk1 limit 1;
                  QUERY PLAN
-----------------------------------------------
 [
   {
     "Plan": {
       "Node Type": "ModifyTable",
       "Operation": "Insert",
       "Parallel Aware": false,
       "Async Capable": false,
       "Relation Name": "tenk1",
       "Alias": "tenk1",
       "Startup Cost": 0.00,
       "Total Cost": 0.04,
       "Plan Rows": 0,
       "Plan Width": 0,
       "Actual Startup Time": 0.030,
       "Actual Total Time": 0.030,
       "Actual Rows": 0,
       "Actual Loops": 1,
       "Shared Hit Blocks": 3,
       "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,
       "WAL Records": 1,
       "WAL FPI": 0,
       "WAL Bytes": 299,
       "Plans": [
         {
           "Node Type": "Limit",
           "Parent Relationship": "Outer",
           "Parallel Aware": false,
           "Async Capable": false,
           "Startup Cost": 0.00,
           "Total Cost": 0.04,
           "Plan Rows": 1,
           "Plan Width": 244,
           "Actual Startup Time": 0.011,
           "Actual Total Time": 0.011,
           "Actual Rows": 1,
           "Actual Loops": 1,
           "Shared Hit Blocks": 2,
           "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,
           "WAL Records": 0,
           "WAL FPI": 0,
           "WAL Bytes": 0,
           "Plans": [
             {
               "Node Type": "Seq Scan",
               "Parent Relationship": "Outer",
               "Parallel Aware": false,
               "Async Capable": false,
               "Relation Name": "tenk1",
               "Alias": "tenk1_1",
               "Startup Cost": 0.00,
               "Total Cost": 445.00,
               "Plan Rows": 10000,
               "Plan Width": 244,
               "Actual Startup Time": 0.009,
               "Actual Total Time": 0.009,
               "Actual Rows": 1,
               "Actual Loops": 1,
               "Shared Hit Blocks": 2,
               "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,
               "WAL Records": 0,
               "WAL FPI": 0,
               "WAL Bytes": 0
             }
           ]
         }
       ]
     },
     "Planning": {
       "Shared Hit Blocks": 0,
       "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,
       "Memory Used": 68080,
       "Memory Allocated": 131072
     },
     "Planning Time": 0.659,
     "Triggers": [
     ],
     "Serialization": {
       "Time": 0.000,
       "Output Volume": 0,
       "Format": "text",
       "Shared Hit Blocks": 0,
       "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
     },
     "Execution Time": 0.065
   }
 ]

-------
       "Shared Hit Blocks": 0,
       "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

these information duplicated for json key "Serialization" and json key
"Planning"
i am not sure this is intended?



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: cataloguing NOT NULL constraints
Next
From: Bruce Momjian
Date:
Subject: Re: First draft of PG 17 release notes