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

On Tue, Sep 4, 2012 at 12:12 AM, charles_xie <xqwyy163(at)163(dot)com> 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(dot)xie(at)sanmina-sci(dot)com) 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