Access statistics

Here it comes.

    The views created for now are:

    pg_stat_activity

        Current  connections to the entire installation including
        actual querystrings.

    pg_stat_database

        Per database IO summary.

    pg_stat_{all|sys|user}_tables

        Per table scan statistics.

    pg_statio_{all|sys|user}_tables

        Per table buffer cache statistics.

    pg_stat_{all|sys|user}_indexes

        Per index scan statistics.

    pg_statio_{all|sys|user}_indexes

        Per index buffer cache statistics.

    pg_statio_{all|sys|user}_indexes

        Per sequence buffer cache statistics.

    Of course, an initdb  is  required  (this  patch  up  to  now
    doesn't bump catversion).

    The rules regression test is broken due to the new views from
    initdb.

    The existing functionality to reset stats isn't callable yet.
    Should become a utility command someday.

    Collecting   must   be  configurable  per  database  (catalog
    change).

    Due to all the changes that  have  happened  (ever  tried  to
    apply  a  130K patch after a pgindent run?) I must verify all
    this patch touches once more.

    Have fun.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #