Add system view tracking shared buffer actions

Edit

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