Re: HELP!!!-----Need to Sql commands to monitoring Postgresql

On Thu, Sep 6, 2012 at 6:50 PM, charles_xie <xqwyy163(at)163(dot)com> wrote:
> Hi，
> Thanks for your advice.i know the basic monitoring skill,because the
> postgresql database is used for the factory production , so I hope they can
> run normal and exert more perfect performance. so i need to be considered
> from the point of view ,eg : threading ,locks and so on.

I think the key structures you are looking for, then, are queries on
pg_stat_activity, pg_locks, the pg_statio table, and also "bloat" of
tables and indexes (the wiki has several slightly different relatively
large queries that help track bloat).

As others have mentioned, there are existing tools with an impressive
number of detailed queries, but knowing about these can help you
informally categorize what you are looking at. check_postgres.pl is
especially useful to copy queries from, if not using it in a Nagios
installation entirely.

--
fdr