Add system view tracking shared buffer actions

Edit
Comment/Review
Change Status
ID 3272
Title Add system view tracking shared buffer actions
Topic Monitoring & Control
Created 2021-08-02 22:27:08
Last modified 2023-02-12 17:27:15 (1 year, 9 months ago)
Latest email 2023-04-05 00:41:09 (1 year, 7 months ago)
Status
2023-03: Committed
2023-01: Moved to next CF
2022-11: Moved to next CF
2022-09: Moved to next CF
2022-07: Moved to next CF
2022-03: Moved to next CF
2022-01: Moved to next CF
2021-11: Moved to next CF
2021-09: Moved to next CF
Target version 16
Authors Melanie Plageman (melanieplageman)
Reviewers Justin Pryzby (justinpryzby)Become reviewer
Committer Andres Freund (andresfreund)
Links CFbot results (CirrusCI) CFbot GitHub
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/3272
git checkout commitfest/cf/3272
Emails
pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)
First at 2020-01-24 19:52:26 by Andres Freund <andres at anarazel.de>
Latest at 2023-04-05 00:41:09 by Melanie Plageman <melanieplageman at gmail.com>
Latest attachment (v1-0001-Document-standalone-backend-type-in-pg_stat_activ.patch) at 2023-04-03 20:50:43 from Melanie Plageman <melanieplageman at gmail.com>
    Attachment (v1-0001-Document-standalone-backend-type-in-pg_stat_activ.patch) at 2023-04-03 20:50:43 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (Stabilize-pg_stat_io-writes-test.patch) at 2023-03-10 19:51:13 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-flakey-pg_stat_io-test.patch) at 2023-03-06 20:21:14 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (fix_stats_test.diff) at 2023-03-06 06:48:43 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (Change-IO-stats-enum-loop-variables-to-ints.patch) at 2023-02-27 19:03:16 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Remove-potentially-misleading-_FIRST-macros.patch) at 2023-02-27 14:24:01 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v51-0005-pg_stat_io-documentation.patch) at 2023-01-20 02:15:34 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v50-0001-Create-regress_tblspc-in-test_setup.patch) at 2023-01-19 21:28:59 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v49-0001-pgstat-Infrastructure-to-track-IO-operations.patch) at 2023-01-17 22:00:34 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v48-0002-pgstat-Count-IO-for-relations.patch) at 2023-01-17 17:22:14 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v47-0003-pgstat-Count-IO-for-relations.patch) at 2023-01-13 18:38:15 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v46-0001-pgindent-and-some-manual-cleanup-in-pgstat-relat.patch) at 2023-01-13 02:19:36 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v45-0002-pgstat-Infrastructure-to-track-IO-operations.patch) at 2023-01-09 21:10:47 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v44-0004-Add-system-view-tracking-IO-ops-per-backend-type.patch) at 2023-01-04 22:56:07 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v43-0001-pgindent-and-some-manual-cleanup-in-pgstat-relat.patch) at 2023-01-03 01:15:54 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v42-0004-Add-system-view-tracking-IO-ops-per-backend-type.patch) at 2023-01-02 22:46:22 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v40-0002-Track-IO-operation-statistics-locally.patch) at 2022-12-06 01:49:20 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v39-0003-Aggregate-IO-operation-stats-per-BackendType.patch) at 2022-11-30 01:12:47 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v38-0001-Remove-BufferAccessStrategyData-current_was_in_r.patch) at 2022-11-29 02:05:33 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v37-pg_stat_io-delta.diff) at 2022-11-07 18:26:06 from Maciek Sakrejda <m.sakrejda at gmail.com> (Patch: Yes)
    Attachment (v37-0002-Track-IO-operation-statistics-locally.patch) at 2022-11-03 17:00:24 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v36-0003-Aggregate-IO-operation-stats-per-BackendType.patch) at 2022-10-26 17:54:44 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v35-0001-Remove-BufferAccessStrategyData-current_was_in_r.patch) at 2022-10-26 03:15:06 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v34-0001-Remove-BufferAccessStrategyData-current_was_in_r.patch) at 2022-10-19 19:26:51 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v33-0002-Aggregate-IO-operation-stats-per-BackendType.patch) at 2022-10-10 18:48:49 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v32-0002-Aggregate-IO-operation-stats-per-BackendType.patch) at 2022-10-06 22:23:53 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v31-0002-Aggregate-IO-operation-stats-per-BackendType.patch) at 2022-10-06 17:42:09 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v30-0003-Add-system-view-tracking-IO-ops-per-backend-type.patch) at 2022-09-27 18:20:44 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v29-0003-Add-system-view-tracking-IO-ops-per-backend-type.patch) at 2022-08-26 19:34:06 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v28-0003-Track-IO-operation-statistics-locally.patch) at 2022-08-22 17:15:18 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v27-0003-Track-IO-operation-statistics.patch) at 2022-08-11 23:53:09 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v26-0003-Track-IO-operation-statistics.patch) at 2022-07-14 22:44:48 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Add-BackendType-for-standalone-backends.patch) at 2022-07-13 17:14:52 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v24-0001-Add-BackendType-for-standalone-backends.patch) at 2022-07-12 16:19:06 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Add-BackendType-for-standalone-backends.patch) at 2022-07-12 02:22:28 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v22-0002-Track-IO-operation-statistics.patch) at 2022-07-05 17:24:55 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (0001-Read-only-atomic-backend-write-function.patch) at 2022-04-06 16:16:44 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v21-0008-small-comment-correction.patch) at 2022-02-19 16:06:18 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v20-0006-Add-system-view-tracking-IO-ops-per-backend-type.patch) at 2022-01-04 01:39:56 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v19-0007-Remove-superfluous-bgwriter-stats.patch) at 2021-12-22 01:32:44 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v18-0008-small-comment-correction.patch) at 2021-12-15 21:40:27 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v17-0007-small-comment-correction.patch) at 2021-12-03 20:02:24 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v16-0006-Remove-superfluous-bgwriter-stats.patch) at 2021-12-01 22:00:14 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v15-0007-small-comment-correction.patch) at 2021-11-24 21:19:20 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v14-0002-Read-only-atomic-backend-write-function.patch) at 2021-11-02 19:26:52 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (0002-updates.patch) at 2021-10-11 20:48:01 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v13-0004-Remove-superfluous-bgwriter-stats.patch) at 2021-10-01 20:05:31 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v12-0004-Remove-superfluous-bgwriter-stats.patch) at 2021-09-30 21:16:34 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v11-0003-Remove-superfluous-bgwriter-stats.patch) at 2021-09-29 20:46:07 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v10-0003-Remove-superfluous-bgwriter-stats.patch) at 2021-09-27 18:58:53 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v9-0003-Remove-superfluous-bgwriter-stats.patch) at 2021-09-24 21:58:48 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v8-0002-Remove-superfluous-bgwriter-stats.patch) at 2021-09-23 21:05:07 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Add-system-view-tracking-shared-buffer-actions.patch) at 2021-09-13 21:46:02 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (capture_checkpointer_buffer_actions.patch) at 2021-09-09 01:28:38 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v6-0002-Remove-superfluous-bgwriter-stats.patch) at 2021-09-07 20:16:28 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Add-system-view-tracking-shared-buffer-actions.patch) at 2021-08-11 22:00:40 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-system-view-tracking-shared-buffer-actions.patch) at 2021-08-11 20:11:34 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Add-system-view-tracking-shared-buffer-actions.patch) at 2021-08-02 22:25:56 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Add-system-view-tracking-shared-buffer-actions.patch) at 2021-06-04 21:12:43 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-system-view-tracking-shared-buffers-written.patch) at 2021-04-13 02:49:36 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
History
When Who What
2023-02-12 17:27:15 Andres Freund (andresfreund) Closed in commitfest 2023-03 with status: Committed
2023-02-12 17:27:15 Andres Freund (andresfreund) Changed committer to andresfreund
2023-01-31 16:14:06 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2022-12-13 23:42:41 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
2022-10-20 04:28:34 Justin Pryzby (justinpryzby) New status: Needs review
2022-10-12 06:05:05 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-02 17:24:12 Andres Freund (andresfreund) New status: Waiting on Author
2022-08-01 18:20:35 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-08-01 18:20:28 Jacob Champion (jchampion) New status: Needs review
2022-04-09 02:16:15 Justin Pryzby (justinpryzby) Changed targetversion to 16
2022-04-08 12:57:41 Greg Stark (stark) Closed in commitfest 2022-03 with status: Moved to next CF
2022-03-22 00:15:03 Andres Freund (andresfreund) New status: Waiting on Author
2022-02-02 16:23:52 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2021-12-03 23:49:49 Justin Pryzby (justinpryzby) New status: Needs review
2021-12-02 12:06:32 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2021-11 with status: Moved to next CF
2021-11-27 01:41:13 Justin Pryzby (justinpryzby) New status: Waiting on Author
2021-11-25 01:16:13 Justin Pryzby (justinpryzby) Added justinpryzby as reviewer
2021-10-04 07:30:23 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-08-02 22:27:28 Melanie Plageman (melanieplageman) Changed authors to Melanie Plageman (melanieplageman)
2021-08-02 22:27:28 Melanie Plageman (melanieplageman) Changed targetversion to 15
2021-08-02 22:27:08 Melanie Plageman (melanieplageman) Attached mail thread 20200124195226.lth52iydq2n2uilq@alap3.anarazel.de
2021-08-02 22:27:08 Melanie Plageman (melanieplageman) Created patch record
Edit
Comment/Review
Change Status