Expose queryid in pg_stat_activity and log_line_prefix

Edit

Title

Topic

Monitoring & Control

Created

2019-03-22 22:26:58

Last modified

2021-02-01 12:26:01 (3 weeks, 5 days ago)

Latest email

2021-01-20 02:28:54 (1 month, 1 week ago)

Status

2021-03: Needs review

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)Become reviewer

Committer

Links

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-01-20 02:28:54 by Julien Rouhaud <rjuju123 at gmail.com>
Latest attachment (regression.diffs) at 2021-01-19 23:58:22 from Tatsuro Yamada <tatsuro.yamada.tf at nttcom.co.jp>
    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-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