Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)

From:	Justin Pryzby <pryzby(at)telsasoft(dot)com>
To:	Melanie Plageman <melanieplageman(at)gmail(dot)com>
Cc:	Andres Freund <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-hackers(at)postgresql(dot)org, Lukas Fittl <lukas(at)fittl(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Subject:	Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)
Date:	2022-04-06 16:16:44
Message-ID:	20220406161644.GA9294@telsasoft.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2020-01-24 19:52:26 from Andres Freund <andres(at)anarazel(dot)de>  2020-01-25 14:43:41 from Magnus Hagander <magnus(at)hagander(dot)net>   2020-01-26 00:44:01 from Andres Freund <andres(at)anarazel(dot)de>    2020-01-26 15:20:03 from Magnus Hagander <magnus(at)hagander(dot)net>     2020-01-26 20:22:03 from Andres Freund <andres(at)anarazel(dot)de>      2020-01-27 04:20:09 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>       2021-04-13 02:49:36 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎        2021-04-15 23:59:54 from Andres Freund <andres(at)anarazel(dot)de>         2021-06-04 21:12:43 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎        2021-06-04 21:52:17 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>         2021-08-02 22:25:56 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎          2021-08-03 18:12:58 from Andres Freund <andres(at)anarazel(dot)de>           2021-08-11 20:11:34 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎            2021-08-11 22:00:40 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎            2021-08-13 10:08:11 from Andres Freund <andres(at)anarazel(dot)de>             2021-09-07 20:16:28 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎             2021-09-09 01:28:38 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎              2021-09-10 22:16:28 from Melanie Plageman <melanieplageman(at)gmail(dot)com>               2021-09-13 21:46:02 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                2021-09-15 01:30:02 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                 2021-09-23 21:05:07 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                  2021-09-24 21:58:48 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                   2021-09-27 18:58:53 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                    2021-09-29 20:46:07 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                     2021-09-30 21:16:34 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                      2021-09-30 23:15:13 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                       2021-10-01 20:05:31 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                        2021-10-08 17:56:20 from Andres Freund <andres(at)anarazel(dot)de>                         2021-10-11 20:48:01 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                          2021-10-19 19:29:31 from Andres Freund <andres(at)anarazel(dot)de>                           2021-11-02 19:26:52 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                            2021-11-19 16:49:52 from Andres Freund <andres(at)anarazel(dot)de>                             2021-11-24 21:19:20 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                              2021-11-25 01:15:59 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                               2021-11-26 21:16:36 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                2021-12-01 22:00:14 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                 2021-12-01 23:59:15 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                               2021-12-01 21:59:44 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                2021-12-02 03:31:45 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                2021-12-02 04:06:53 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                 2021-12-03 20:02:24 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                  2021-12-09 19:17:52 from Andres Freund <andres(at)anarazel(dot)de>                                   2021-12-15 21:40:27 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                    2021-12-16 20:18:37 from Andres Freund <andres(at)anarazel(dot)de>                                     2021-12-22 01:32:44 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                      2021-12-30 20:30:50 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                       2022-01-04 01:39:56 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                        2022-02-19 16:06:18 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                         2022-03-22 00:15:05 from Andres Freund <andres(at)anarazel(dot)de>                                          2022-07-05 17:24:55 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                           2022-07-06 19:20:47 from Andres Freund <andres(at)anarazel(dot)de>                                            2022-07-12 02:22:28 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                             2022-07-12 08:06:21 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                              2022-07-12 16:19:06 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                               2022-07-12 17:01:31 from Andres Freund <andres(at)anarazel(dot)de>                                                2022-07-13 17:14:52 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                               2022-07-13 02:00:07 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                2022-07-13 02:18:22 from Andres Freund <andres(at)anarazel(dot)de>                                                 2022-07-13 02:41:40 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                             2022-07-12 17:18:10 from Andres Freund <andres(at)anarazel(dot)de>                                              2022-07-14 22:44:48 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                               2022-07-15 15:59:41 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                2022-07-15 18:52:45 from Andres Freund <andres(at)anarazel(dot)de>                                               2022-07-20 16:50:50 from Andres Freund <andres(at)anarazel(dot)de>                                                2022-07-20 17:40:40 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                2022-08-11 23:53:09 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                 2022-08-22 17:15:18 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                  2022-08-23 03:31:22 from Andres Freund <andres(at)anarazel(dot)de>                                                  2022-08-25 19:15:27 from Andres Freund <andres(at)anarazel(dot)de>                                                   2022-08-26 19:34:06 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                    2022-09-27 18:20:44 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                     2022-09-30 23:17:25 from Lukas Fittl <lukas(at)fittl(dot)com>                                                      2022-10-06 17:42:09 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                       2022-10-06 22:23:53 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                        2022-10-10 18:48:49 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                         2022-10-10 23:42:55 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>                                                          2022-10-13 17:29:32 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                           2022-10-17 05:28:34 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>                                                            2022-10-19 19:26:51 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                             2022-10-20 17:31:01 from Andres Freund <andres(at)anarazel(dot)de>                                                              2022-10-23 22:48:09 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>                                                               2022-10-26 17:54:44 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                2022-10-31 01:08:55 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>                                                                 2022-11-03 17:00:24 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                  2022-11-07 18:26:06 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com> 📎                                                                   2022-11-30 01:12:47 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                    2022-12-04 22:48:43 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>                                                                    2022-12-05 19:32:09 from Andres Freund <andres(at)anarazel(dot)de>                                                                     2022-12-06 01:49:20 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                      2022-12-08 05:09:18 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>                                                                  2022-11-21 00:38:15 from Andres Freund <andres(at)anarazel(dot)de>                                                                   2022-11-29 02:05:33 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                  2022-11-23 05:43:29 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                   2022-11-25 22:46:11 from Andres Freund <andres(at)anarazel(dot)de>                                                                   2022-11-29 02:08:36 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                                    2022-11-30 02:51:13 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                              2022-10-24 18:38:52 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                               2022-10-26 03:15:06 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                               2022-10-26 18:58:08 from Andres Freund <andres(at)anarazel(dot)de>                                                             2022-10-23 22:35:38 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>                                                              2022-10-24 19:39:01 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                       2022-12-28 23:56:13 from Andres Freund <andres(at)anarazel(dot)de>                                                        2023-01-02 22:46:22 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                         2023-01-03 01:15:54 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                          2023-01-04 22:56:07 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                           2023-01-09 21:10:47 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                            2023-01-11 16:32:37 from vignesh C <vignesh21(at)gmail(dot)com>                                                            2023-01-11 21:58:51 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                             2023-01-13 02:19:36 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                              2023-01-13 05:23:05 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                               2023-01-13 18:38:15 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                2023-01-13 23:36:00 from Andres Freund <andres(at)anarazel(dot)de>                                                                 2023-01-17 17:22:14 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                  2023-01-17 19:12:32 from Andres Freund <andres(at)anarazel(dot)de>                                                                   2023-01-17 22:00:34 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                    2023-01-19 11:17:57 from vignesh C <vignesh21(at)gmail(dot)com>                                                                     2023-01-19 21:28:59 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                      2023-01-20 02:15:34 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                       2023-01-24 08:22:03 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                        2023-01-24 08:25:38 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                        2023-01-24 22:35:12 from Andres Freund <andres(at)anarazel(dot)de>                                                                         2023-01-25 07:56:17 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                          2023-02-08 06:38:14 from Andres Freund <andres(at)anarazel(dot)de>                                                                           2023-02-08 07:03:28 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                           2023-02-09 05:03:19 from Andres Freund <andres(at)anarazel(dot)de>                                                                            2023-02-11 18:24:37 from Andres Freund <andres(at)anarazel(dot)de>                                                                             2023-02-14 19:08:12 from Andres Freund <andres(at)anarazel(dot)de>                                                                              2023-02-15 06:35:01 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>                                                                               2023-02-15 07:40:21 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                             2023-02-22 01:50:35 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                              2023-02-22 04:09:37 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                             2023-03-04 23:21:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                              2023-03-06 06:24:25 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                               2023-03-06 06:48:43 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> 📎                                                                                2023-03-06 15:09:24 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                                                 2023-03-06 19:09:19 from Andres Freund <andres(at)anarazel(dot)de>                                                                                  2023-03-06 19:24:09 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                                                   2023-03-06 19:34:04 from Andres Freund <andres(at)anarazel(dot)de>                                                                                    2023-03-06 20:21:14 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                                     2023-03-07 02:55:10 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                                                                                     2023-03-07 18:18:44 from Andres Freund <andres(at)anarazel(dot)de>                                                                                      2023-03-09 12:51:31 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                       2023-03-09 19:43:01 from Andres Freund <andres(at)anarazel(dot)de>                                                                                        2023-03-10 19:51:13 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                                        2023-03-10 20:19:04 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                         2023-03-10 20:33:44 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                                                          2023-04-03 04:13:26 from Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>                                                                                           2023-04-03 20:50:43 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                                            2023-04-04 20:35:13 from Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>                                                                                             2023-04-05 00:41:09 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                                                              2023-04-10 07:41:38 from Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru> 📎                                                                                               2023-04-24 20:53:25 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                                                                2023-04-25 07:16:05 from Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>                                                                            2023-02-26 18:20:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                             2023-02-26 18:52:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                              2023-02-27 14:24:01 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                               2023-02-27 15:30:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                2023-02-27 19:03:16 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎                                                                                 2023-02-27 19:58:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                  2023-02-27 23:18:30 from Andres Freund <andres(at)anarazel(dot)de>                                                                             2023-02-26 19:33:25 from Andres Freund <andres(at)anarazel(dot)de>                                                                              2023-02-26 19:40:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                               2023-02-26 19:53:53 from Andres Freund <andres(at)anarazel(dot)de>                                                                                2023-02-26 20:08:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                 2023-02-26 20:33:03 from Andres Freund <andres(at)anarazel(dot)de>                                                                                  2023-02-26 21:11:45 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                                                   2023-02-26 21:24:40 from Melanie Plageman <melanieplageman(at)gmail(dot)com>                                                                  2023-01-18 06:10:38 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>                                                                2023-01-16 21:41:49 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>                                                     2022-10-02 17:24:04 from Andres Freund <andres(at)anarazel(dot)de>                                    2021-12-16 21:24:44 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                  2021-12-15 22:38:52 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                   2022-04-06 16:16:44 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎
Lists:	pgsql-hackers

Attachment	Content-Type	Size
0001-Read-only-atomic-backend-write-function.patch	text/x-diff	1.7 KB
0002-Move-backend-pgstat-initialization-earlier.patch	text/x-diff	4.6 KB
0003-Add-IO-operation-counters-to-PgBackendStatus.patch	text/x-diff	16.1 KB
0004-Send-IO-operations-to-stats-collector.patch	text/x-diff	10.8 KB
0005-Add-buffers-to-pgstat_reset_shared_counters.patch	text/x-diff	12.3 KB
0006-Add-system-view-tracking-IO-ops-per-backend-type.patch	text/x-diff	18.4 KB
0007-Remove-superfluous-bgwriter-stats-code.patch	text/x-diff	18.0 KB
0008-small-comment-correction.patch	text/x-diff	1.7 KB

In response to

• Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) at 2021-12-15 22:38:52 from Justin Pryzby

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Andres Freund	2022-04-06 16:17:51	Re: shared-memory based stats collector - v70
Previous Message	Mark Dilger	2022-04-06 16:07:15	Re: pg14 psql broke \d datname.nspname.relname