On Thu, Sep 6, 2012 at 6:50 PM, charles_xie <xqwyy163@xxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
