Shared-memory based stats collector

Edit
Title Shared-memory based stats collector
Topic Monitoring & Control
Created 2018-06-29 08:36:19
Last modified 2021-10-01 17:20:50 (2 years, 5 months ago)
Latest email 2022-04-08 04:44:43 (1 year, 11 months ago)
Status
2021-09: Returned with feedback
2021-07: Moved to next CF
2021-03: Moved to next CF
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
2019-03: Moved to next CF
2019-01: Moved to next CF
2018-11: Moved to next CF
2018-09: Moved to next CF
2018-07: Moved to next CF
Target version
Authors Kyotaro Horiguchi (horiguti)
Reviewers Tomas Vondra (fuzzycz), Antonin Houska (a.houska)Become reviewer
Committer
Links
Emails
shared-memory based stats collector
First at 2018-06-29 08:34:18 by Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp>
Latest at 2022-04-08 04:44:43 by Kyotaro Horiguchi <horikyota.ntt at gmail.com>
Latest attachment (v70-0001-dsm-allow-use-in-single-user-mode.patch) at 2022-04-06 03:00:08 from Andres Freund <andres at anarazel.de>
    Attachment (v70-0001-dsm-allow-use-in-single-user-mode.patch) at 2022-04-06 03:00:08 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (pgstat-architecture.diff) at 2022-04-05 20:51:12 from "David G. Johnston" <david.g.johnston at gmail.com> (Patch: Yes)
    Attachment (rework-using-enums.diff) at 2022-04-05 15:49:36 from "David G. Johnston" <david.g.johnston at gmail.com> (Patch: Yes)
    Attachment (v69-0001-dsm-allow-use-in-single-user-mode.patch) at 2022-04-05 03:05:06 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v68-0001-pgstat-consistent-function-header-formatting.patch) at 2022-04-04 04:15:16 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (address3fixmes.patch) at 2022-03-24 17:21:33 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (unknown_filename) at 2022-03-23 07:38:33 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (add_more_basic_stats_tests.patch) at 2022-03-23 00:43:29 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (add_subscriber_stats_tests.patch) at 2022-03-21 21:41:48 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v67-0001-pgstat-reorder-pgstat.-ch-contents.patch.gz) at 2022-03-21 21:30:17 from Andres Freund <andres at anarazel.de> (Patch: No)
    Attachment (v2-0001-add-replica-cleanup-tests.patch) at 2022-03-20 20:56:37 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (add_replica_stats_cleanup_tests.patch) at 2022-03-20 16:32:39 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v66-0001-pgstat-run-pgindent-on-pgstat.c-h.patch.gz) at 2022-03-17 07:36:52 from Andres Freund <andres at anarazel.de> (Patch: No)
    Attachment (v65-0001-dshash-Add-sequential-scan-support.patch) at 2022-03-03 02:16:00 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v60-0001-dshash-Add-sequential-scan-support.patch) at 2021-04-05 09:29:14 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v57-0001-sequential-scan-for-dshash.patch) at 2021-03-18 07:56:02 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v1-0001-pgstat.h-doesn-t-need-hsearch.h.patch) at 2021-03-16 02:55:41 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v56-0001-sequential-scan-for-dshash.patch) at 2021-03-16 01:27:55 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v55-0003-Make-archiver-process-an-auxiliary-process_fujii.patch) at 2021-03-12 14:33:05 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v55-0003-Make-archiver-process-an-auxiliary-process.patch) at 2021-03-12 08:24:43 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v54-0003-Make-archiver-process-an-auxiliary-process.patch) at 2021-03-12 04:49:06 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v53-0003-Make-archiver-process-an-auxiliary-process.patch) at 2021-03-12 00:23:12 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v52-0003-Make-archiver-process-an-auxiliary-process_fujii.patch) at 2021-03-10 12:47:51 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (v52-0001-sequential-scan-for-dshash.patch) at 2021-03-10 08:51:37 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v51-0001-sequential-scan-for-dshash.patch) at 2021-03-10 03:10:39 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v50-0001-sequential-scan-for-dshash.patch) at 2021-03-09 09:29:34 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v49-0001-sequential-scan-for-dshash.patch) at 2021-03-09 07:53:11 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v48-0001-sequential-scan-for-dshash.patch) at 2021-03-05 08:18:56 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v47-0001-sequential-scan-for-dshash.patch) at 2021-01-21 03:03:48 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v46-0001-sequential-scan-for-dshash.patch) at 2021-01-14 06:14:25 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v45-0001-sequential-scan-for-dshash.patch) at 2021-01-08 01:24:34 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v44-0001-sequential-scan-for-dshash.patch) at 2020-12-21 08:16:20 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v43-0001-sequential-scan-for-dshash.patch) at 2020-12-11 07:50:03 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v42-0001-sequential-scan-for-dshash.patch) at 2020-11-11 01:07:22 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v41-0001-sequential-scan-for-dshash.patch) at 2020-11-06 00:27:56 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v40-0001-sequential-scan-for-dshash.patch) at 2020-11-04 08:39:10 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v39-100tables.png) at 2020-10-08 07:03:26 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: No)
    Attachment (v39-0001-sequential-scan-for-dshash.patch) at 2020-10-06 01:06:44 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v38-0001-sequential-scan-for-dshash.patch) at 2020-10-01 00:07:22 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v37-0001-sequential-scan-for-dshash.patch) at 2020-09-25 00:27:26 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v36-0001-Use-standard-crash-handler-in-archiver.patch) at 2020-09-08 08:55:57 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v35-0001-Use-standard-crash-handler-in-archiver.patch) at 2020-06-08 08:32:04 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v34-0001-Use-standard-crash-handler-in-archiver.patch) at 2020-06-01 09:00:01 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Use-standard-crash-handler-in-archiver.patch) at 2020-05-15 08:30:36 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Use-standard-crash-handler-in-archiver.patch) at 2020-04-30 04:22:05 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v32-0001-Use-standard-crash-handler-in-archiver.patch) at 2020-04-07 07:38:17 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Use-standard-crash-handler-in-archiver.patch) at 2020-04-03 08:31:17 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: No)
    Attachment (v30-0001-Use-standard-crash-handler-in-archiver.patch) at 2020-04-01 08:37:23 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Use-standard-crash-handler-in-archiver.patch) at 2020-04-01 06:15:11 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v28-0001-Use-standard-crash-handler-in-archiver.patch) at 2020-03-30 00:29:45 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Use-standard-crash-handler-in-archiver.patch) at 2020-03-27 07:31:15 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Use-standard-crash-handler-in-archiver.patch) at 2020-03-19 11:30:04 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Add-sequential-scan-capability-to-dshash.patch) at 2020-03-19 03:51:59 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (0001-sequential-scan-for-dshash.patch) at 2020-03-09 16:21:15 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (0001-sequential-scan-for-dshash.patch) at 2020-01-22 08:24:04 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v24-0001-sequential-scan-for-dshash.patch) at 2019-12-03 08:27:59 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v23-0001-sequential-scan-for-dshash.patch) at 2019-09-27 00:46:47 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v22-0001-sequential-scan-for-dshash.patch) at 2019-09-10 08:58:58 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v21-0001-sequential-scan-for-dshash.patch) at 2019-07-11 07:40:59 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (0001-sequential-scan-for-dshash.patch) at 2019-07-04 10:27:54 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v20-0001-sequential-scan-for-dshash.patch) at 2019-05-17 06:47:20 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v19-0001-sequential-scan-for-dshash.patch) at 2019-05-17 05:27:22 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v18-0001-sequential-scan-for-dshash.patch) at 2019-03-27 07:36:25 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v17-0001-sequential-scan-for-dshash.patch) at 2019-02-25 04:52:14 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v16-0001-sequential-scan-for-dshash.patch) at 2019-02-21 07:05:55 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v15-0001-sequential-scan-for-dshash.patch) at 2019-02-19 12:40:07 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v14-0001-sequential-scan-for-dshash.patch) at 2019-02-18 12:35:31 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v13-0001-sequential-scan-for-dshash.patch) at 2019-02-15 08:29:00 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v12-0001-sequential-scan-for-dshash.patch) at 2019-01-22 06:48:02 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v11-0001-sequential-scan-for-dshash.patch) at 2019-01-21 12:19:07 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (pgstatsock-fix.patch) at 2019-01-01 17:39:12 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (v10-0001-sequential-scan-for-dshash.patch) at 2018-11-27 08:59:49 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (chart.png) at 2018-11-26 01:52:30 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (v9-0007-Documentation-update.patch) at 2018-11-12 11:10:42 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v8-0001-sequential-scan-for-dshash.patch) at 2018-11-09 08:33:15 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v7-0001-sequential-scan-for-dshash.patch) at 2018-11-08 11:46:48 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (valgrind.log) at 2018-10-30 00:49:59 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (v6-0010-Remove-stats-collector-process.patch) at 2018-10-05 08:30:17 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v6-0008-Ultra-PoC-of-full-shared-memory-stats-collector.patch) at 2018-10-02 07:06:51 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v5-0008-Ultra-PoC-of-full-shared-memory-stats-collector.patch) at 2018-09-27 13:00:49 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v4-0001-sequential-scan-for-dshash.patch) at 2018-07-10 12:07:40 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v3-0007-Fix-of-v3-0003-dshash-based-staas-collector.patch) at 2018-07-05 11:33:52 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v3-0001-sequential-scan-for-dshash.patch) at 2018-07-04 08:29:11 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v2-0001-sequential-scan-for-dshash.patch) at 2018-07-03 10:01:44 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v1-0001-Give-dshash-ability-to-make-a-local-snapshot.patch) at 2018-06-29 08:34:18 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
History
When Who What
2021-10-01 17:20:50 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Returned with feedback
2021-08-03 02:43:25 Masahiko Sawada (masahikosawada) New status: Waiting on Author
2021-08-03 02:42:13 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-08-03 02:42:10 Masahiko Sawada (masahikosawada) New status: Needs review
2021-07-19 10:35:13 Ibrar Ahmed (ibrar) New status: Waiting on Author
2021-04-08 15:40:30 David Steele (dsteele) Closed in commitfest 2021-03 with status: Moved to next CF
2021-04-08 14:32:19 David Steele (dsteele) New status: Needs review
2021-04-08 14:30:28 David Steele (dsteele) Changed targetversion to None
2021-03-08 16:55:41 Ibrar Ahmed (ibrar) New status: Waiting on Author
2021-02-01 12:25:38 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-01 09:13:37 Georgios Kokolatos (gkokolatos) Closed in commitfest 2020-11 with status: Moved to next CF
2020-10-30 15:00:55 Georgios Kokolatos (gkokolatos) Posted comment with messageid <160407005554.1204.520371677197659413.pgcf@coridan.postgresql.org>
2020-09-30 06:29:11 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-09-30 06:29:09 Michael Paquier (michael-kun) New status: Needs review
2020-09-07 02:03:51 Michael Paquier (michael-kun) New status: Waiting on Author
2020-08-03 08:44:38 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2020-07 with status: Moved to next CF
2020-04-08 15:24:52 David Steele (dsteele) Closed in commitfest 2020-03 with status: Moved to next CF
2020-03-10 03:29:35 Kyotaro Horiguchi (horiguti) Changed targetversion to 14
2020-02-01 11:26:00 Tomas Vondra (fuzzycz) Closed in commitfest 2020-01 with status: Moved to next CF
2020-02-01 11:25:55 Tomas Vondra (fuzzycz) New status: Needs review
2019-12-01 02:12:41 Michael Paquier (michael-kun) New status: Waiting on Author
2019-12-01 02:12:37 Michael Paquier (michael-kun) Closed in commitfest 2019-11 with status: Moved to next CF
2019-09-30 18:54:58 Álvaro Herrera (alvherre) Closed in commitfest 2019-09 with status: Moved to next CF
2019-09-18 14:55:47 Álvaro Herrera (alvherre) New status: Needs review
2019-09-05 15:58:02 Álvaro Herrera (alvherre) New status: Waiting on Author
2019-08-02 00:02:05 Thomas Munro (macdice) Closed in commitfest 2019-07 with status: Moved to next CF
2019-04-05 22:02:03 Andres Freund (andresfreund) Closed in commitfest 2019-03 with status: Moved to next CF
2019-04-05 22:01:58 Andres Freund (andresfreund) Changed targetversion to 13
2019-03-27 07:53:51 Kyotaro Horiguchi (horiguti) New status: Needs review
2019-03-25 07:29:15 David Steele (dsteele) New status: Waiting on Author
2019-02-22 00:24:47 Kyotaro Horiguchi (horiguti) New status: Needs review
2019-02-07 21:11:28 Andres Freund (andresfreund) New status: Waiting on Author
2019-02-04 02:28:44 Michael Paquier (michael-kun) Closed in commitfest 2019-01 with status: Moved to next CF
2019-02-03 10:40:03 Andres Freund (andresfreund) New status: Needs review
2018-12-01 13:11:28 Dmitry Dolgov (erthalion) New status: Waiting on Author
2018-12-01 13:11:19 Dmitry Dolgov (erthalion) Closed in commitfest 2018-11 with status: Moved to next CF
2018-12-01 13:11:15 Dmitry Dolgov (erthalion) New status: Needs review
2018-11-26 13:16:59 Tomas Vondra (fuzzycz) New status: Waiting on Author
2018-11-25 22:35:41 Tomas Vondra (fuzzycz) Added fuzzycz as reviewer
2018-10-02 01:52:35 Michael Paquier (michael-kun) Closed in commitfest 2018-09 with status: Moved to next CF
2018-10-02 01:52:31 Michael Paquier (michael-kun) New status: Needs review
2018-09-20 10:49:51 Antonin Houska (a.houska) New status: Waiting on Author
2018-09-20 07:57:36 Antonin Houska (a.houska) Added a.houska as reviewer
2018-08-10 22:14:52 Andrew Dunstan (adunstan) Closed in commitfest 2018-07 with status: Moved to next CF
2018-06-29 08:36:43 Kyotaro Horiguchi (horiguti) Changed authors to Kyotaro Horiguchi (horiguti)
2018-06-29 08:36:19 Kyotaro Horiguchi (horiguti) Attached mail thread 20180629.173418.190173462.horiguchi.kyotaro@lab.ntt.co.jp
2018-06-29 08:36:19 Kyotaro Horiguchi (horiguti) Created patch record
Edit