output for postgres config & stats

SELECT name, current_setting(name), source
  FROM pg_settings
  WHERE source NOT IN ('default', 'override');

name                       | current_setting    | source
--------------------------------------------------------------------
client_encoding            | UTF8               | client
cpu_tuple_cost             | 0.03               | configuration file
DateStyle                  | ISO, MDY           | client
default_text_search_config | pg_catalog.english | configuration file
effective_cache_size       | 8400MB             | configuration file
extra_float_digits         | 3                  | session
lc_messages                | en_US.UTF-8        | configuration file
lc_monetary                | en_US.UTF-8        | configuration file
lc_numeric                 | en_US.UTF-8        | configuration file
lc_time                    | en_US.UTF-8        | configuration file
listen_addresses           | *                  | configuration file
log_destination            | stderr             | configuration file
log_rotation_age           | 1d                 | configuration file
log_rotation_size          | 0                  | configuration file
log_timezone               | US/Central         | configuration file
log_truncate_on_rotation   | on                 | configuration file
logging_collector          | on                 | configuration file
maintenance_work_mem       | 512MB              | configuration file
max_connections            | 100                | configuration file
max_stack_depth            | 2MB                | environment variable
port                       | 5432               | command line
random_page_cost           | 1                  | configuration file
seq_page_cost              | 0.1                | configuration file
shared_buffers             | 3GB                | configuration file
TimeZone                   | America/Chicago    | client
work_mem                   | 30MB               | configuration file

======================================================================


SELECT oid, relname, relpages, reltuples FROM pg_class
  WHERE relname = 'contact';

oid     | relname | relpages | reltuples
----------------------------------------
1462757 | contact | 13775    | 574,942

======================================================================

(Note: these restults are transposed)
SELECT * FROM pg_stat_user_tables WHERE relname = 'contact';

column_name       | value
----------------------------------------------
relid             | 1462757
schemaname        | oss
relname           | contact
seq_scan          | 5800
seq_tup_read      | 3148890743
idx_scan          | 36739947
idx_tup_fetch     | 72094265
n_tup_ins         | 23
n_tup_upd         | 31
n_tup_del         | 0
n_tup_hot_upd     | 21
n_live_tup        | 574945
n_dead_tup        | 2
last_vacuum       | 2013-02-22 15:22:26.378331
last_autovacuum   | <null>
last_analyze      | 2013-02-22 15:22:27.732734
last_autoanalyze  | <null>
vacuum_count      | 1
autovacuum_count  | 0
analyze_count     | 2
autoanalyze_count | 0