Fixes for query_id feature
authorBruce Momjian <bruce@momjian.us>
Thu, 8 Apr 2021 15:16:01 +0000 (11:16 -0400)
committerBruce Momjian <bruce@momjian.us>
Thu, 8 Apr 2021 15:16:01 +0000 (11:16 -0400)
commit0f61727b75b93915ca9a9f20c996ed7020996a38
treeedde84ea5ff138952c506bbffe93baa848c79fb8
parent5844c23dc50508aefeb8183be45f4ee99e9dec17
Fixes for query_id feature

Ignore parallel workers in pg_stat_statements
  Oversight in 4f0b0966c8 which exposed queryid in parallel workers.
  Counters are aggregated by the main backend process so parallel workers
  would report duplicated activity, and could also report activity for the
  wrong entry as they are only aware of the top level queryid.

Fix thinko in pg_stat_get_activity when retrieving the queryid.

Remove unnecessary call to pgstat_report_queryid().

Reported-by: Amit Kapila, Andres Freund, Thomas Munro
Discussion: https://postgr.es/m/20210408051735.lfbdzun5zdlax5gd@alap3.anarazel.de p634GTSOqnDW86Owrn6qDAVosC5dJjXjp7BMfc5Gz1Q@mail.gmail.com

Author: Julien Rouhaud
contrib/pg_stat_statements/pg_stat_statements.c
src/backend/executor/execParallel.c
src/backend/utils/adt/pgstatfuncs.c