Expose queryid in pg_stat_activity and log_line_prefix

Edit
ID 2069
Title Expose queryid in pg_stat_activity and log_line_prefix
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Monitoring & Control
Tags
Created 2019-03-22 22:26:58
Last modified 2021-04-08 08:34:24 (4 years ago)
Latest email 2021-04-08 15:17:00 (4 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)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