Re: Strange code in EXPLAIN for queryid

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Bruce Momjian <bruce(at)momjian(dot)us>
Subject: Re: Strange code in EXPLAIN for queryid
Date: 2021-08-08 14:06:32
Message-ID: 20210808140632.biah4samuhvbokgc@nol
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Aug 08, 2021 at 11:56:41PM +1200, David Rowley wrote:
>
> On looking a little closer I also saw that plannedstmt->queryId is a
> uint64. I guess that we're showing this as an int64 so that it
> matches the queryid column in the pg_stat_statements view?

The only reason we display it as an int64 rather than a uint64 is because
the SQL standard doesn't define such a type, and using numeric would add
useless overhead.

> Any objection to applying the attached to pg14 and master?

No objection.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2021-08-08 16:31:53 Re: Assert triggered during RE_compile_and_cache
Previous Message Pavel Stehule 2021-08-08 13:33:14 Re: very long record lines in expanded psql output