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-04-08 08:34:24 (1 month ago)

Latest email

2021-04-08 15:17:00 (1 month 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

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