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

From Daniel Gustafsson
Subject Re: explain format json, unit for serialize and memory are different.
Date
Msg-id C99686F4-23D6-4944-B945-8B53456B9827@yesql.se
Whole thread Raw
In response to explain format json, unit for serialize and memory are different.  (jian he <jian.universality@gmail.com>)
Responses Re: explain format json, unit for serialize and memory are different.
List pgsql-hackers
> On 13 May 2024, at 11:16, jian he <jian.universality@gmail.com> wrote:

> under format json,  "Output Volume": 1143,
> 1143 is kiB unit, and is not the same as "Memory Used" or "Memory
> Allocated" byte unit.

Nice catch.

> Do we need to convert it to byte for the non-text format option for EXPLAIN?

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.

--
Daniel Gustafsson




pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Parallel CREATE INDEX for GIN indexes
Next
From: David Rowley
Date:
Subject: Speed up Hash Join by teaching ExprState about hashing