Expose queryid in pg_stat_activity and log_line_prefix

2069

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Tags

Monitoring

Created

2019-03-22 22:26:58

Last modified

2021-04-08 08:34:24 (5 years ago)

Latest email

2021-04-08 15:17:00 (5 years ago)

Status

2021-03 (2021-03-01 – 2021-03-31): Committed

2021-01 (2021-01-01 – 2021-01-31): Moved to different CF

2020-11 (2020-11-01 – 2020-11-30): Moved to different CF

2020-09 (2020-09-01 – 2020-09-30): Moved to different CF

2020-07 (2020-07-01 – 2020-07-31): Moved to different CF

2020-03 (2020-03-01 – 2020-03-31): Moved to different CF

2020-01 (2020-01-01 – 2020-01-31): Moved to different CF

2019-11 (2019-11-01 – 2019-11-30): Moved to different CF

2019-09 (2019-09-01 – 2019-09-30): Moved to different CF

2019-07 (2019-07-01 – 2019-07-31): Moved to different CF

Target version

Authors

Julien Rouhaud (rjuju)

Reviewers

atsushi torikoshi (atorik), Evgeny Efimkin (efimkine), Nitin Jadhav (nitinjadhav11) Log in to 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