Shared memory based stats collector

Edit
Comment/Review
Change Status
ID 3589
Title Shared memory based stats collector
Topic Monitoring & Control
Created 2022-03-09 20:37:56
Last modified 2022-04-08 04:36:50 (2 years, 7 months ago)
Latest email 2022-04-08 04:44:43 (2 years, 7 months ago)
Status
2022-03: Committed
Target version 15
Authors Andres Freund (andresfreund), Kyotaro Horiguchi (horiguti)
Reviewers Become reviewer
Committer Andres Freund (andresfreund)
Links CFbot results (CirrusCI) CFbot GitHub Git
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run: 
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/3589
git checkout commitfest/cf/3589
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
2022-04-08 04:36:50 Andres Freund (andresfreund) Closed in commitfest 2022-03 with status: Committed
2022-04-08 04:36:50 Andres Freund (andresfreund) Changed committer to andresfreund
2022-04-07 23:11:25 Greg Stark (stark) New status: Ready for Committer
2022-03-09 20:39:34 Andres Freund (andresfreund) Changed authors to Andres Freund (andresfreund), Kyotaro Horiguchi (horiguti)
2022-03-09 20:39:34 Andres Freund (andresfreund) Changed targetversion to 15
2022-03-09 20:39:34 Andres Freund (andresfreund) Changed gitlink to https://github.com/anarazel/postgres/tree/shmstat
2022-03-09 20:37:57 Andres Freund (andresfreund) Attached mail thread 20180629.173418.190173462.horiguchi.kyotaro@lab.ntt.co.jp
2022-03-09 20:37:56 Andres Freund (andresfreund) Created patch record
Edit
Comment/Review
Change Status