On Thu, Apr 8, 2021 at 12:51:06PM -0400, Álvaro Herrera wrote:
> On 2021-Apr-08, Bruce Momjian wrote:
>
> > pg_stat_activity.queryid is new, but I can imagine cases where you would
> > join pg_stat_activity to pg_stat_statements to get an estimate of how
> > long the query will take --- having one using an underscore and another
> > one not seems odd.
>
> OK. So far, you have one vote for queryid (your own) and two votes for
> query_id (mine and Julien's). And even yourself were hesitating about
> it earlier in the thread.
OK, if people are fine with pg_stat_activity.query_id not matching
pg_stat_statements.queryid, I am fine with that. I just don't want
someone to say it was a big mistake later. ;-)
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.