Skip site navigation (1) Skip section navigation (2)


From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Date: 2010-01-28 16:09:25
Message-ID: 1264694965.1000.2.camel@nycwxp2622 (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I am looking into the PostgreSQL dictionary. The view pg_stat_activity
is the PgSQL version of v$session. There are interesting views named
pg_stat_database and pg_stat_user_tables. What is the starting point for
those stat views? Is that since the database and table, in case of the
latter view, was created? Is it since the last restart of the instance?
I was unable to find that in the documentation.
Here is the description of the view in question:

View "pg_catalog.pg_stat_database"
    Column     |  Type   | Modifiers 
 datid         | oid     | 
 datname       | name    | 
 numbackends   | integer | 
 xact_commit   | bigint  | 
 xact_rollback | bigint  | 
 blks_read     | bigint  | 
 blks_hit      | bigint  | 
 tup_returned  | bigint  | 
 tup_fetched   | bigint  | 
 tup_inserted  | bigint  | 
 tup_updated   | bigint  | 
 tup_deleted   | bigint  | 

Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251 

The Leader in Integrated Media
Intelligence Solutions


pgsql-novice by date

Next:From: Tom LaneDate: 2010-01-28 16:10:50
Subject: Re: SSL Connection help, pls...
Previous:From: Edi StojicevicDate: 2010-01-28 08:51:02
Subject: Re: PpgSQL Autovacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group