Expose queryid in pg_stat_activity and log_line_prefix

Edit

ID 2069

Title Expose queryid in pg_stat_activity and log_line_prefix

Topic Monitoring & Control

Created 2019-03-22 22:26:58

Last modified 2021-04-08 08:34:24 (3 years, 7 months ago)

Latest email 2021-04-08 15:17:00 (3 years, 7 months ago)

Status

2021-03: Committed

2021-01: Moved to next CF

2020-11: Moved to next CF

2020-09: Moved to next CF

2020-07: Moved to next CF

2020-03: Moved to next CF

2020-01: Moved to next CF

2019-11: Moved to next CF

2019-09: Moved to next CF

2019-07: Moved to next CF

Target version

Authors Julien Rouhaud (rjuju)

Reviewers atsushi torikoshi (atorik), Evgeny Efimkin (efimkine), Nitin Jadhav (nitinjadhav11)Become reviewer

Committer Bruce Momjian (bmomjian)

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2069
git checkout commitfest/cf/2069

Emails

Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?: First at 2019-03-15 21:54:19 by Yun Li <liyunjuanyong at gmail.com>
Latest at 2021-04-08 15:17:00 by Bruce Momjian <bruce at momjian.us>
Latest attachment (v4-0001-Ignore-parallel-workers-in-pg_stat_statements.patch) at 2021-04-08 13:31:27 from Julien Rouhaud <rjuju123 at gmail.com>
    Attachment (v4-0001-Ignore-parallel-workers-in-pg_stat_statements.patch) at 2021-04-08 13:31:27 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Ignore-parallel-workers-in-pg_stat_statements.patch) at 2021-04-08 12:27:20 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Ignore-parallel-workers-in-pg_stat_statements.patch) at 2021-04-08 12:12:54 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (csv.diff) at 2021-04-08 00:54:02 from Bruce Momjian <bruce at momjian.us> (Patch: Yes)
    Attachment (csv.diff) at 2021-04-07 23:38:35 from Bruce Momjian <bruce at momjian.us> (Patch: Yes)
    Attachment (csv.diff) at 2021-04-07 22:38:40 from Bruce Momjian <bruce at momjian.us> (Patch: Yes)
    Attachment (v1-fix_pgss.diff) at 2021-04-07 21:56:25 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v24-0001-Move-pg_stat_statements-query-jumbling-to-core.patch) at 2021-04-07 12:57:26 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Move-pg_stat_statements-query-jumbling-to-core.patch) at 2021-04-04 14:18:50 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Move-pg_stat_statements-query-jumbling-to-core.patch) at 2021-04-02 05:33:28 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Move-pg_stat_statements-query-jumbling-to-core.patch) at 2021-04-01 15:30:15 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Move-pg_stat_statements-query-jumbling-to-core.patch) at 2021-03-24 15:20:49 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (qid-01-jumble_over_master.diff) at 2021-03-22 21:55:54 from Bruce Momjian <bruce at momjian.us> (Patch: Yes)
    Attachment (v19-0001-Move-pg_stat_statements-query-jumbling-to-core.patch) at 2021-03-20 06:12:34 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Move-pg_stat_statements-query-jumbling-to-core.patch) at 2021-03-14 08:06:45 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v17-0003-Expose-query-identifier-in-verbose-explain.patch) at 2021-03-02 03:43:31 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (regression.diffs) at 2021-01-19 23:58:22 from Tatsuro Yamada <tatsuro.yamada.tf at nttcom.co.jp> (Patch: Yes)
    Attachment (v16-0002-Expose-queryid-in-pg_stat_activity-and-log_line_.patch) at 2021-01-19 16:43:25 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v15-0003-Expose-query-identifier-in-verbose-explain.patch) at 2021-01-07 17:07:19 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v14-0002-Expose-queryid-in-pg_stat_activity-and-log_line_.patch) at 2020-10-18 08:12:48 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v13-0002-Expose-queryid-in-pg_stat_activity-and-log_line_.patch) at 2020-10-14 12:25:00 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v12-0003-Expose-query-identifier-in-verbose-explain.patch) at 2020-10-14 09:43:33 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Expose-queryid-in-pg_stat_activity-and-log_line_.patch) at 2020-08-19 14:19:30 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Expose-queryid-in-pg_stat_activity-and-log_line_.patch) at 2020-07-14 11:24:53 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Expose-queryid-in-pg_stat_activity-and-log_line_p.patch) at 2020-04-02 13:25:06 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Expose-queryid-in-pg_stat_activity-and-log_line_p.patch) at 2020-03-16 14:43:12 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Expose-queryid-in-pg_stat_activity-and-log_line_p.patch) at 2020-03-14 17:53:51 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (queryid_exposure-v6.diff) at 2020-03-03 15:24:59 from Julien Rouhaud <julien.rouhaud at free.fr> (Patch: Yes)
    Attachment (queryid_exposure-v5.diff) at 2020-02-07 10:12:50 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (queryid_exposure_v4.diff) at 2019-08-03 21:58:13 from Julien Rouhaud <julien.rouhaud at free.fr> (Patch: Yes)
    Attachment (queryid_exposure-v3.diff) at 2019-06-28 15:46:24 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (queryid_exposure-v2.diff) at 2019-06-28 14:39:15 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (queryid_exposure-v1.diff) at 2019-03-19 14:51:37 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)

History

When	Who	What
2021-04-08 08:34:24	Magnus Hagander (mha)	Closed in commitfest 2021-03 with status: Committed
2021-04-06 16:09:40	Nitin Jadhav (nitinjadhav11)	Added nitinjadhav11 as reviewer
2021-03-22 17:07:37	Bruce Momjian (bmomjian)	Added bmomjian as committer
2021-02-01 12:26:01	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-01 09:12:58	Georgios Kokolatos (gkokolatos)	Closed in commitfest 2020-11 with status: Moved to next CF
2020-11-04 05:50:55	Justin Pryzby (justinpryzby)	Changed name to Expose queryid in pg_stat_activity and log_line_prefix
2020-10-13 18:14:24	Bruce Momjian (bmomjian)	Removed bmomjian from committers
2020-10-05 20:39:07	Bruce Momjian (bmomjian)	Added bmomjian as committer
2020-09-30 07:47:45	Julien Rouhaud (rjuju)	Closed in commitfest 2020-09 with status: Moved to next CF
2020-08-03 07:50:11	Michael Paquier (michael-kun)	Closed in commitfest 2020-07 with status: Moved to next CF
2020-06-03 06:21:50	atsushi torikoshi (atorik)	Added atorik as reviewer
2020-04-08 16:05:32	David Steele (dsteele)	Changed targetversion to None
2020-04-08 14:36:01	Julien Rouhaud (rjuju)	Closed in commitfest 2020-03 with status: Moved to next CF
2020-02-01 11:27:41	Tomas Vondra (fuzzycz)	Closed in commitfest 2020-01 with status: Moved to next CF
2020-02-01 11:27:34	Tomas Vondra (fuzzycz)	New status: Needs review
2019-11-29 06:21:04	Michael Paquier (michael-kun)	New status: Waiting on Author
2019-11-29 06:19:56	Michael Paquier (michael-kun)	Closed in commitfest 2019-11 with status: Moved to next CF
2019-09-30 18:55:04	Álvaro Herrera (alvherre)	Closed in commitfest 2019-09 with status: Moved to next CF
2019-08-07 09:03:21	Evgeny Efimkin (efimkine)	Posted review with messageid <156516860141.18864.14200401842491641374.pgcf@coridan.postgresql.org>
2019-08-07 09:03:21	Evgeny Efimkin (efimkine)	New status: Ready for Committer
2019-08-01 11:24:58	Thomas Munro (macdice)	Closed in commitfest 2019-07 with status: Moved to next CF
2019-08-01 11:24:54	Thomas Munro (macdice)	New status: Needs review
2019-07-31 08:54:24	Evgeny Efimkin (efimkine)	New status: Waiting on Author
2019-07-31 08:54:18	Evgeny Efimkin (efimkine)	Posted comment with messageid <156456325840.1401.4726441619340285592.pgcf@coridan.postgresql.org>
2019-07-31 07:38:29	Evgeny Efimkin (efimkine)	Added efimkine as reviewer
2019-03-22 22:27:24	Julien Rouhaud (rjuju)	Changed authors to Julien Rouhaud (rjuju)
2019-03-22 22:27:24	Julien Rouhaud (rjuju)	Changed targetversion to 13
2019-03-22 22:26:59	Julien Rouhaud (rjuju)	Attached mail thread CA+8PKvQnMfOE-c3YLRwxOsCYXQDyP8VXs6CDtMZp1V4=D4LuFA@mail.gmail.com
2019-03-22 22:26:59	Julien Rouhaud (rjuju)	Created patch record

Edit