Re: [GENERAL] PostgreSQL Required Monitoring

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: [GENERAL] PostgreSQL Required Monitoring
Дата
Msg-id CANu8FiykZy3BWipPTAfjQEsk80eLhoQ0ecTSwHFumxbEP4eU9g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] PostgreSQL Required Monitoring  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general


On Fri, Apr 28, 2017 at 10:46 AM, Joshua D. Drake <jd@commandprompt.com> wrote:
On 04/28/2017 07:39 AM, Andrew Kerber wrote:
I am a fairly experienced Oracle DBA, and we are starting to move in to
the PostgreSQL world.  I would expect the standard monitoring items are
required for mission critical postgres apps, Ie, disk space, wal log
space, log monitoring, process counts,software running, connection
available on the correct port, CPU usage.

Are there additional PostgreSQL specific items that need to be
monitored?  if so, what items?

Pretty much anything that starts with pg_stat_

JD


--
Command Prompt, Inc.                  http://the.postgres.company/
                        +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

One thing I always monitor is index sizes, usage and status. See attached pg_stat_all_indexes.sh

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [GENERAL] PostgreSQL Required Monitoring
Следующее
От: Jan Keirse
Дата:
Сообщение: Re: [GENERAL] PostgreSQL Required Monitoring