########################################################################################################### PGStatspack version 0.3 by frits.hoogland@interaccess.nl ########################################################################################################### Snapshot information Begin snapshot : snapid | ts | description --------+----------------------------+-------------- 3 | 2009-10-18 21:26:13.107562 | index-before (1 row) End snapshot : snapid | ts | description --------+----------------------------+------------- 4 | 2009-10-18 21:26:17.362247 | index-after (1 row) Seconds in snapshot: 4.25468498468399 Database version version -------------------------------------------------------------------------------------------- PostgreSQL 8.3.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.3) (1 row) current_database | dbsize ------------------+-------- fuzzy-new | 790 MB (1 row) Database statistics database | tps | hitrate | lio_ps | pio_ps | rollbk_ps ----------------+------+---------+---------+--------+----------- pgstatspack | 0.47 | 89.00 | 1057.19 | 106.24 | 0.00 postgres | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 template0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 template1 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 (4 rows) Top 20 tables ordered by high table to index read ratio table | system_read_pct | table_read_pct | index_read_pct -------------------------+-----------------+----------------+---------------- pg_catalog.pg_class | 64 | 88 | 11 public.pgstatspack_test | 20 | 0 | 100 pg_catalog.pg_index | 13 | 100 | 0 pg_catalog.pg_namespace | 0 | 100 | 0 pg_catalog.pg_database | 0 | 100 | 0 pg_catalog.pg_attribute | 0 | 0 | 100 (6 rows) Top 20 tables ordered by inserts table | table_inserts --------------------------------------------+--------------- public.pgstatspack_indexes | 168 public.pgstatspack_tables | 129 public.pgstatspack_settings | 33 public.pgstatspack_sequences | 24 public.pgstatspack_database | 11 public.pgstatspack_snap | 1 information_schema.sql_features | 0 information_schema.sql_implementation_info | 0 information_schema.sql_languages | 0 information_schema.sql_packages | 0 information_schema.sql_parts | 0 information_schema.sql_sizing | 0 information_schema.sql_sizing_profiles | 0 pg_catalog.pg_aggregate | 0 pg_catalog.pg_am | 0 pg_catalog.pg_amop | 0 pg_catalog.pg_amproc | 0 pg_catalog.pg_attrdef | 0 pg_catalog.pg_attribute | 0 pg_catalog.pg_authid | 0 (20 rows) Top 20 tables ordered by updates table | table_updates --------------------------------------------+--------------- information_schema.sql_features | 0 information_schema.sql_implementation_info | 0 information_schema.sql_languages | 0 information_schema.sql_packages | 0 information_schema.sql_parts | 0 information_schema.sql_sizing | 0 information_schema.sql_sizing_profiles | 0 pg_catalog.pg_aggregate | 0 pg_catalog.pg_am | 0 pg_catalog.pg_amop | 0 pg_catalog.pg_amproc | 0 pg_catalog.pg_attrdef | 0 pg_catalog.pg_attribute | 0 pg_catalog.pg_authid | 0 pg_catalog.pg_auth_members | 0 pg_catalog.pg_autovacuum | 0 pg_catalog.pg_cast | 0 pg_catalog.pg_class | 0 pg_catalog.pg_constraint | 0 pg_catalog.pg_conversion | 0 (20 rows) Top 20 tables ordered by deletes table | table_deletes --------------------------------------------+--------------- information_schema.sql_features | 0 information_schema.sql_implementation_info | 0 information_schema.sql_languages | 0 information_schema.sql_packages | 0 information_schema.sql_parts | 0 information_schema.sql_sizing | 0 information_schema.sql_sizing_profiles | 0 pg_catalog.pg_aggregate | 0 pg_catalog.pg_am | 0 pg_catalog.pg_amop | 0 pg_catalog.pg_amproc | 0 pg_catalog.pg_attrdef | 0 pg_catalog.pg_attribute | 0 pg_catalog.pg_authid | 0 pg_catalog.pg_auth_members | 0 pg_catalog.pg_autovacuum | 0 pg_catalog.pg_cast | 0 pg_catalog.pg_class | 0 pg_catalog.pg_constraint | 0 pg_catalog.pg_conversion | 0 (20 rows) Tables ordered by percentage of tuples scanned table | rows_read_pct | tab_hitrate | idx_hitrate | tab_read | tab_hit | idx_read | idx_hit -------------------------+---------------+-------------+-------------+----------+---------+----------+--------- pg_catalog.pg_class | 64 | 99 | 99 | 0 | 408 | 0 | 692 public.pgstatspack_test | 20 | 55 | 99 | 447 | 553 | 0 | 2001 pg_catalog.pg_index | 13 | 92 | 0 | 0 | 12 | 0 | 0 pg_catalog.pg_namespace | 0 | 83 | 0 | 0 | 5 | 0 | 0 pg_catalog.pg_attribute | 0 | 75 | 85 | 0 | 3 | 0 | 6 pg_catalog.pg_database | 0 | 50 | 0 | 0 | 1 | 0 | 0 (6 rows) Indexes ordered by scans index | table | scans | tup_read | tup_fetch | idx_blks_read | idx_blks_hit --------------------------------------------+-------------------------+-------+----------+-----------+---------------+-------------- public.pgstatspack_test_idx | public.pgstatspack_test | 1000 | 1000 | 1000 | 0 | 2001 pg_catalog.pg_class_oid_index | pg_catalog.pg_class | 342 | 342 | 342 | 0 | 686 pg_catalog.pg_attribute_relid_attnum_index | pg_catalog.pg_attribute | 3 | 29 | 29 | 0 | 6 pg_catalog.pg_class_relname_nsp_index | pg_catalog.pg_class | 3 | 3 | 3 | 0 | 6 (4 rows) Sequences ordered by blks_read schema | name | blks_read | blks_hit --------+------+-----------+---------- (0 rows) Parameters name | start_setting | stop_setting | source ------------------------------+---------------------------------------------------+---------------------------------------------------+---------------------- autovacuum | on | on | configuration file autovacuum_vacuum_cost_delay | 10 | 10 | configuration file autovacuum_vacuum_cost_limit | 500 | 500 | configuration file checkpoint_segments | 12 | 12 | configuration file config_file | /home/tomas/postgres/8.3.6/data/postgresql.conf | /home/tomas/postgres/8.3.6/data/postgresql.conf | override data_directory | /home/tomas/postgres/8.3.6/data | /home/tomas/postgres/8.3.6/data | override DateStyle | ISO, DMY | ISO, DMY | configuration file default_text_search_config | pg_catalog.simple | pg_catalog.simple | configuration file effective_cache_size | 131072 | 131072 | configuration file hba_file | /home/tomas/postgres/8.3.6/data/pg_hba.conf | /home/tomas/postgres/8.3.6/data/pg_hba.conf | override ident_file | /home/tomas/postgres/8.3.6/data/pg_ident.conf | /home/tomas/postgres/8.3.6/data/pg_ident.conf | override lc_collate | cs_CZ.UTF-8 | cs_CZ.UTF-8 | override lc_ctype | cs_CZ.UTF-8 | cs_CZ.UTF-8 | override lc_messages | cs_CZ.UTF-8 | cs_CZ.UTF-8 | configuration file lc_monetary | cs_CZ.UTF-8 | cs_CZ.UTF-8 | configuration file lc_numeric | cs_CZ.UTF-8 | cs_CZ.UTF-8 | configuration file lc_time | cs_CZ.UTF-8 | cs_CZ.UTF-8 | configuration file log_line_prefix | %t %d | %t %d | configuration file log_statement_stats | on | on | configuration file log_timezone | Europe/Prague | Europe/Prague | command line max_connections | 100 | 100 | configuration file max_fsm_pages | 153600 | 153600 | configuration file max_stack_depth | 2048 | 2048 | environment variable server_encoding | UTF8 | UTF8 | override shared_buffers | 3072 | 3072 | configuration file TimeZone | Europe/Prague | Europe/Prague | command line timezone_abbreviations | Default | Default | command line track_activities | on | on | configuration file track_counts | on | on | configuration file transaction_isolation | read committed | read committed | override transaction_read_only | off | off | override update_process_title | on | on | configuration file wal_buffers | 8 | 8 | configuration file (33 rows)