PG_STAT_DATABASE

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: PG_STAT_DATABASE
Date: 2010-01-28 16:09:25
Message-ID: 1264694965.1000.2.camel@nycwxp2622
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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 |

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

The Leader in Integrated Media
Intelligence Solutions

Responses

Browse pgsql-novice by date

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