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

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.

Daniel Farina-4 wrote
>
> On Tue, Sep 4, 2012 at 12:12 AM, charles_xie <xqwyy163@> wrote:
>> Hi all,
>> i have 5 servers that have been installing postgresql .In order
>> to
>> know the postgresql working status and monitor them ,moreover i don't
>> want
>> to use the monitor tools .I want to use the SQL commands to monitoring
>> postgresql system . please suggest any SQL COMMANDS to work
>> successfully.if
>> you have some good suggestion ,you can email to me
>> (charles.xie@) or sky :xqwbx163
>
> Hello,
>
> You might want to try pgsql-general or the wiki. The right stuff also
> depends on what you are monitoring for.
>
> Basic uptime and information: "SELECT 1" ("can I log in?"), but also
> counting the number of connections (select count(*) from
> pg_stat_activity), the number of contending connections (select
> count(*) from pg_stat_activity where waiting = 't'), the number of
> tables (select count(*) from pg_tables), database size (select
> pg_database_size(<dbnamehere>)), and database version (select
> version()) we find useful. It's so useful we put it into a very
> condensed and cryptic status line (which can optionally have more
> information in more exceptional conditions) like:
>
> [100.5GB:140T:7C], (v9.0.6, --other statuses if they occur--)
>
> The space of queries used for tuning and capacity are much larger, but
> I find these basic chunks of information a useful fingerprint of most
> databases and activity levels in a relatively small amount of space.
>
> --
> fdr
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

--
View this message in context: http://postgresql.1045698.n5.nabble.com/HELP-Need-to-Sql-commands-to-monitoring-Postgresql-tp5722548p5723150.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.