###########################################################################################################
PGStatspack version 0.3 by frits.hoogland@interaccess.nl
###########################################################################################################

Snapshot information
Begin snapshot : 
 snapid |             ts             | description 
--------+----------------------------+-------------
      2 | 2008-04-14 13:17:35.828089 | 
(1 row)

End snapshot   :
 snapid |             ts             | description 
--------+----------------------------+-------------
      4 | 2008-04-14 14:09:39.939789 | 
(1 row)

Seconds in snapshot:  3124.11169999838


Database version
                                             version                                             
-------------------------------------------------------------------------------------------------
 PostgreSQL 8.1.4 on i386-unknown-freebsd6.0, compiled by GCC gcc (GCC) 3.4.4 [FreeBSD] 20050518
(1 row)

 current_database | dbsize  
------------------+---------
 pgsql            | 2627 MB
(1 row)


Database statistics
  database   |  tps  | hitrate | lio_ps | pio_ps | rollbk_ps 
-------------+-------+---------+--------+--------+-----------
 pgsql       | 32.07 |   68.00 | 170.99 |  54.29 |      0.00
 postgres    |  0.00 |    0.00 |   0.00 |   0.00 |      0.00
 pgstatspack |  0.00 |    0.00 |   0.00 |   0.00 |      0.00
 template1   |  0.00 |    0.00 |   0.00 |   0.00 |      0.00
 template0   |  0.00 |    0.00 |   0.00 |   0.00 |      0.00
(5 rows)


Tables ordered by percentage of tuples scanned
     table     | rows_read_pct | tab_hitrate | idx_hitrate | tab_read | tab_hit | idx_read | idx_hit 
---------------+---------------+-------------+-------------+----------+---------+----------+---------
 accounts      |            79 |           7 |          80 |    92031 |    7969 |    77112 |  323091
 pg_class      |             6 |          97 |          98 |       15 |     683 |       19 |    1514
 pg_operator   |             6 |          99 |          98 |       26 |    5367 |       23 |    1801
 pg_cast       |             1 |          99 |          99 |        4 |    1418 |        4 |    6564
 pg_type       |             1 |          99 |          99 |        5 |    2002 |       14 |    4033
 pg_opclass    |             1 |          98 |          96 |        4 |     300 |        8 |     272
 pg_attribute  |             1 |          97 |          99 |       12 |     597 |       10 |    1745
 pg_language   |             0 |          50 |          66 |        0 |       1 |        0 |       2
 pg_rewrite    |             0 |          77 |          82 |        1 |       7 |        2 |      14
 pg_amop       |             0 |          98 |          96 |        4 |     318 |        8 |     290
 pg_namespace  |             0 |          97 |          98 |        2 |     103 |        4 |     344
 pg_aggregate  |             0 |          69 |          72 |        3 |       9 |        6 |      18
 pg_statistic  |             0 |          66 |          99 |        5 |      12 |        7 |    2015
 pg_trigger    |             0 |          98 |          99 |        2 |     250 |        4 |     500
 pg_am         |             0 |          50 |           0 |        1 |       2 |        0 |       0
 branches      |             0 |           0 |          48 |       47 |       0 |       30 |      29
 pg_proc       |             0 |          93 |          97 |       31 |     454 |       30 |    1308
 pg_toast_2618 |             0 |          83 |          88 |        0 |       5 |        0 |       8
 pg_database   |             0 |          96 |          98 |        2 |      73 |        2 |     148
 pg_index      |             0 |          90 |          87 |        3 |      39 |        4 |      34
 pg_amproc     |             0 |          97 |          97 |        2 |     102 |        4 |     204
 pg_authid     |             0 |          97 |          98 |        2 |     143 |        4 |     296
(22 rows)


Indexes ordered by scans
              index              |     table     | scans  | tup_read | tup_fetch | idx_blks_read | idx_blks_hit 
---------------------------------+---------------+--------+----------+-----------+---------------+--------------
 accounts_pkey                   | accounts      | 100000 |   100000 |    100000 |         77112 |       323091
 pg_cast_source_target_index     | pg_cast       |   3284 |     1422 |      1422 |             4 |         6564
 pg_type_oid_index               | pg_type       |   1995 |     1995 |      1995 |             4 |         3986
 pg_statistic_relid_att_index    | pg_statistic  |    674 |       17 |        17 |             7 |         2015
 pg_attribute_relid_attnum_index | pg_attribute  |    585 |     1276 |      1276 |            10 |         1745
 pg_proc_oid_index               | pg_proc       |    399 |      399 |       399 |            12 |         1185
 pg_operator_oid_index           | pg_operator   |    380 |      380 |       380 |             8 |         1132
 pg_class_oid_index              | pg_class      |    285 |      285 |       285 |             7 |          848
 pg_trigger_tgrelid_tgname_index | pg_trigger    |    252 |      252 |       252 |             4 |          500
 pg_class_relname_nsp_index      | pg_class      |    226 |      100 |       100 |            12 |          666
 pg_operator_oprname_l_r_n_index | pg_operator   |    181 |     7455 |      7455 |            15 |          669
 pg_namespace_nspname_index      | pg_namespace  |    173 |       93 |        93 |             4 |          342
 pg_amproc_opc_proc_index        | pg_amproc     |    104 |      104 |       104 |             4 |          204
 pg_amop_opr_opc_index           | pg_amop       |    103 |      276 |       276 |             4 |          202
 pg_opclass_oid_index            | pg_opclass    |     99 |       99 |        99 |             4 |          194
 pg_database_datname_index       | pg_database   |     75 |       75 |        75 |             2 |          148
 pg_authid_oid_index             | pg_authid     |     75 |       75 |        75 |             2 |          148
 pg_authid_rolname_index         | pg_authid     |     75 |       75 |        75 |             2 |          148
 pg_proc_proname_args_nsp_index  | pg_proc       |     47 |      208 |       206 |            18 |          123
 pg_amop_opc_strat_index         | pg_amop       |     46 |       66 |        66 |             4 |           88
 pg_opclass_am_name_nsp_index    | pg_opclass    |     41 |     1435 |      1435 |             4 |           78
 pg_type_typname_nsp_index       | pg_type       |     19 |       12 |        12 |            10 |           47
 pg_aggregate_fnoid_index        | pg_aggregate  |     12 |       12 |        12 |             6 |           18
 pg_index_indrelid_index         | pg_index      |     11 |       17 |        17 |             2 |           20
 pg_rewrite_rel_rulename_index   | pg_rewrite    |      8 |       10 |        10 |             2 |           14
 pg_index_indexrelid_index       | pg_index      |      8 |        8 |         8 |             2 |           14
 pg_toast_2618_index             | pg_toast_2618 |      4 |        9 |         9 |             0 |            8
 pg_namespace_oid_index          | pg_namespace  |      1 |        1 |         1 |             0 |            2
 pg_language_oid_index           | pg_language   |      1 |        1 |         1 |             0 |            2
 branches_pkey                   | branches      |      0 |        0 |         0 |            30 |           29
 tellers_pkey                    | tellers       |      0 |        0 |         0 |            33 |           32
(31 rows)


Sequences ordered by blks_read
 schema |     name      | blks_read | blks_hit 
--------+---------------+-----------+----------
 public | pgstatspackid |         0 |        1
(1 row)


Parameters
         name          |             start_setting             |             stop_setting              |       source       
-----------------------+---------------------------------------+---------------------------------------+--------------------
 config_file           | /usr/local/pgsql/data/postgresql.conf | /usr/local/pgsql/data/postgresql.conf | override
 data_directory        | /usr/local/pgsql/data                 | /usr/local/pgsql/data                 | override
 hba_file              | /usr/local/pgsql/data/pg_hba.conf     | /usr/local/pgsql/data/pg_hba.conf     | override
 ident_file            | /usr/local/pgsql/data/pg_ident.conf   | /usr/local/pgsql/data/pg_ident.conf   | override
 lc_collate            | C                                     | C                                     | override
 lc_ctype              | C                                     | C                                     | override
 lc_messages           | C                                     | C                                     | configuration file
 lc_monetary           | C                                     | C                                     | configuration file
 lc_numeric            | C                                     | C                                     | configuration file
 lc_time               | C                                     | C                                     | configuration file
 max_connections       | 40                                    | 40                                    | configuration file
 server_encoding       | SQL_ASCII                             | SQL_ASCII                             | override
 shared_buffers        | 16384                                 | 16384                                 | configuration file
 stats_block_level     | on                                    | on                                    | configuration file
 stats_row_level       | on                                    | on                                    | configuration file
 stats_start_collector | on                                    | on                                    | configuration file
 TimeZone              | Europe/Amsterdam                      | Europe/Amsterdam                      | command line
 transaction_isolation | read committed                        | read committed                        | override
 transaction_read_only | off                                   | off                                   | override
(19 rows)

