monitoring usage count distribution

Поиск
Список
Период
Сортировка
Искать
От
Nathan Bossart
Тема
monitoring usage count distribution
Дата
Msg-id
20230130233040.GA2800702@nathanxps13
Список
Дерево обсуждения
monitoring usage count distribution Nathan Bossart <nathandbossart@gmail.com>
Re: monitoring usage count distribution Robert Haas <robertmhaas@gmail.com>
Re: monitoring usage count distribution Tom Lane <tgl@sss.pgh.pa.us>
Re: monitoring usage count distribution Melanie Plageman <melanieplageman@gmail.com>
Re: monitoring usage count distribution Andres Freund <andres@anarazel.de>
Re: monitoring usage count distribution Robert Haas <robertmhaas@gmail.com>
Re: monitoring usage count distribution Nathan Bossart <nathandbossart@gmail.com>
Re: monitoring usage count distribution Robert Haas <robertmhaas@gmail.com>
Re: monitoring usage count distribution Tom Lane <tgl@sss.pgh.pa.us>
Re: monitoring usage count distribution Nathan Bossart <nathandbossart@gmail.com>
Re: monitoring usage count distribution Andres Freund <andres@anarazel.de>
Re: monitoring usage count distribution Nathan Bossart <nathandbossart@gmail.com>
Re: monitoring usage count distribution Tom Lane <tgl@sss.pgh.pa.us>
Re: monitoring usage count distribution Robert Haas <robertmhaas@gmail.com>
Re: monitoring usage count distribution Tom Lane <tgl@sss.pgh.pa.us>
Re: monitoring usage count distribution Nathan Bossart <nathandbossart@gmail.com>
Re: monitoring usage count distribution Tom Lane <tgl@sss.pgh.pa.us>
Re: monitoring usage count distribution Nathan Bossart <nathandbossart@gmail.com>
Re: monitoring usage count distribution Greg Stark <stark@mit.edu>
Re: monitoring usage count distribution Andres Freund <andres@anarazel.de>
My colleague Jeremy Schneider (CC'd) was recently looking into usage count
distributions for various workloads, and he mentioned that it would be nice
to have an easy way to do $SUBJECT.  I've attached a patch that adds a
pg_buffercache_usage_counts() function.  This function returns a row per
possible usage count with some basic information about the corresponding
buffers.

    postgres=# SELECT * FROM pg_buffercache_usage_counts();
     usage_count | buffers | dirty | pinned
    -------------+---------+-------+--------
               0 |       0 |     0 |      0
               1 |    1436 |   671 |      0
               2 |     102 |    88 |      0
               3 |      23 |    21 |      0
               4 |       9 |     7 |      0
               5 |     164 |   106 |      0
    (6 rows)

This new function provides essentially the same information as
pg_buffercache_summary(), but pg_buffercache_summary() only shows the
average usage count for the buffers in use.  If there is interest in this
idea, another approach to consider could be to alter
pg_buffercache_summary() instead.

Thoughts?

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com
В списке pgsql-hackers по дате отправления
От: Melanie Plageman
Дата:
Сообщение: Re: heapgettup refactoring
От: Andres Freund
Дата:
FAQ