Thread: System tables

Hi !
    I've got trivial question : what are system table names ?
Do system tables store access statistics ?

Regards, Fabian

System tables are all tables starting with pg_. They store everything
about your database installation, such as name of the actual databases,
tables, attribute types, rules, indexes, what-have-you. Access statistics
as in "How many times did table x get accessed since then" are not stored
anywhere, at least not where you could make use of it.

On Mon, 17 Jan 2000 Fabian.Frederick@prov-liege.be wrote:

>
> Hi !
>     I've got trivial question : what are system table names ?
> Do system tables store access statistics ?
>
> Regards, Fabian
>
> ************
>
>

--
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

> System tables are all tables starting with pg_. They store everything
> about your database installation, such as name of the actual databases,
> tables, attribute types, rules, indexes, what-have-you. Access statistics
> as in "How many times did table x get accessed since then" are not stored
> anywhere, at least not where you could make use of it.

psql \dS shows you the system tables.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026