On Fri, Apr 28, 2017 at 10:46 AM, Joshua D. Drake <j...@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.
pg_stat_all_indexes.sh
Description: Bourne shell script
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general