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

From Michael Paquier
Subject Re: explain format json, unit for serialize and memory are different.
Date
Msg-id ZkL5G7UmMMwbyyVl@paquier.xyz
Whole thread Raw
In response to Re: explain format json, unit for serialize and memory are different.  (Daniel Gustafsson <daniel@yesql.se>)
Responses Re: explain format json, unit for serialize and memory are different.
List pgsql-hackers
On Mon, May 13, 2024 at 11:22:08AM +0200, Daniel Gustafsson wrote:
> Since json (and yaml/xml) is intended to be machine-readable I think we use a
> single unit for all values, and document this fact.

Agreed with the documentation gap.  Another thing that could be worth
considering is to add the units aside with the numerical values, say:
"Memory Used": {"value": 23432, "units": "bytes"}

That would require changing ExplainProperty() so as the units are
showed in some shape, while still being readable when parsed.  I
wouldn't recommend doing that in v17, but perhaps v18 could do better?

Units are also ignored for the XML and yaml outputs.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: SQL:2011 application time
Next
From: jian he
Date:
Subject: Bibliography section, some references cannot be found