Add system view tracking shared buffer actions

Edit

Title

Topic

Monitoring & Control

Created

2021-08-02 22:27:08

Last modified

2023-02-12 17:27:15 (9 months, 3 weeks ago)

Latest email

2023-04-05 00:41:09 (8 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

Authors

Melanie Plageman (melanieplageman)

Reviewers

Justin Pryzby (justinpryzby)Become reviewer

Committer

Andres Freund (andresfreund)

Links

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