Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: legrand legrand <legrand_legrand(at)hotmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?
Date: 2019-06-28 18:49:53
Message-ID: CAH2-WzmDsNL-vjsBJQ5NRrULyDWBx8YTofr3ZmRfy7As13gQ7A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Mar 19, 2019 at 12:38 PM legrand legrand
<legrand_legrand(at)hotmail(dot)com> wrote:
> Would it make sense to add it in auto explain ?
> I don't know for explain itself, but maybe ...

I think that it should appear in EXPLAIN. pg_stat_statements already
cannot have a query hash of zero, so it might be okay to display it
only when its value is non-zero.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-06-28 19:03:19 Re: Avoid full GIN index scan when possible
Previous Message Julien Rouhaud 2019-06-28 18:47:33 Re: Superfluous libpq-be.h include in GSSAPI code