Re: explain format json, unit for serialize and memory are different.

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: explain format json, unit for serialize and memory are different.
Date: 2024-05-13 09:22:08
Message-ID: C99686F4-23D6-4944-B945-8B53456B9827@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 13 May 2024, at 11:16, jian he <jian(dot)universality(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2024-05-13 09:23:49 Speed up Hash Join by teaching ExprState about hashing
Previous Message Tomas Vondra 2024-05-13 09:19:08 Re: Parallel CREATE INDEX for GIN indexes