Re: Strange code in EXPLAIN for queryid - Mailing list pgsql-hackers

From Julien Rouhaud
Subject Re: Strange code in EXPLAIN for queryid
Date
Msg-id 20210808140632.biah4samuhvbokgc@nol
Whole thread Raw
In response to Strange code in EXPLAIN for queryid  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Strange code in EXPLAIN for queryid  (David Rowley <dgrowleyml@gmail.com>)
List 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.



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: very long record lines in expanded psql output
Next
From: Tom Lane
Date:
Subject: Re: Assert triggered during RE_compile_and_cache