PhpPgInfo

Connection parameters form 
Login Language
Pass Schema
Server Unix socket
Port Database

Server info PostgreSQL

Full server version  Roll up box
PostgreSQL 7.3.2 on i386-portbld-freebsd4.8, compiled by GCC 2.95.4

Server configuration  Roll up box
Parameter Value
australian_timezones
authentication_timeout 60
autocommit
checkpoint_segments 3
checkpoint_timeout 300
client_encoding SQL_ASCII
client_min_messages notice
commit_delay 0
commit_siblings 5
cpu_index_tuple_cost 0.001
cpu_operator_cost 0.0025
cpu_tuple_cost 0.01
DateStyle ISO with US (NonEuropean) conventions
db_user_namespace
deadlock_timeout 1000
debug_pretty_print
debug_print_parse
debug_print_plan
debug_print_rewritten
default_statistics_target 10
default_transaction_isolation read committed
dynamic_library_path $libdir
effective_cache_size 1000
enable_hashjoin
enable_indexscan
enable_mergejoin
enable_nestloop
enable_seqscan
enable_sort
enable_tidscan
explain_pretty_print
fixbtree
fsync
geqo
geqo_effort 1
geqo_generations 0
geqo_pool_size 0
geqo_random_seed -1
geqo_selection_bias 2
geqo_threshold 11
hostname_lookup
krb_server_keyfile
lc_messages C
lc_monetary C
lc_numeric C
lc_time C
log_connections
log_duration
log_min_error_statement panic
log_pid
log_statement
log_timestamp
max_connections 32
max_expr_depth 10000
max_files_per_process 1000
max_fsm_pages 10000
max_fsm_relations 1000
max_locks_per_transaction 64
password_encryption
port 5432
pre_auth_delay 0
random_page_cost 4
search_path $user,public
server_encoding SQL_ASCII
server_min_messages notice
shared_buffers 64
show_executor_stats
show_parser_stats
show_planner_stats
show_source_port
show_statement_stats
silent_mode
sort_mem 1024
sql_inheritance
ssl
statement_timeout 0
stats_block_level
stats_command_string
stats_reset_on_server_start
stats_row_level
stats_start_collector
superuser_reserved_connections 2
syslog 0
syslog_facility LOCAL0
syslog_ident postgres
tcpip_socket
TimeZone
trace_notify
TRANSACTION ISOLATION LEVEL READ COMMITTED
transform_null_equals
unix_socket_directory
unix_socket_group
unix_socket_permissions 511
vacuum_mem 8192
virtual_host
wal_buffers 8
wal_debug 0
wal_sync_method fsync

Procedural languages  Roll down box

Users  Roll up box
Login Create db Create user Valid until
pgsql
no_rigths
cr_db
cr_users
cr_all
by_cr_users_no_new_users
by_cr_users_all
polls_admin
example

Databases  Roll up box
Database Administrator Template Connectable Access list
template0 pgsql {=,pgsql=CT}
template1 pgsql {=,pgsql=CT}
pgbench pgsql
polls polls_admin
example example


Server stats PostgreSQL

Active connections  Roll up box
No data

Database performance  Roll up box
Database Connections Successful transactions Cache performance
pgbench 0 100% (138/0) [commit/rollback] 17% (45443/209264) [cache/disk]
template1 0 100% (2149/0) [commit/rollback] 77% (151948/44375) [cache/disk]
template0 0 0% (0/0) [commit/rollback] 0% (0/0) [cache/disk]
polls 0 100% (84/0) [commit/rollback] 86% (7460/1154) [cache/disk]
example 0 100% (73/0) [commit/rollback] 85% (6650/1086) [cache/disk]

User tables performance  Roll up box
Table Sequence Index Tuples
branches (1/100) [scan/read] (0/0) [scan/fetch] (0/0/0) [ins/upd/del]
tellers (1/1000) [scan/read] (0/0) [scan/fetch] (0/0/0) [ins/upd/del]
accounts (1/3000) [scan/read] (0/0) [scan/fetch] (0/0/0) [ins/upd/del]
history (0/0) [scan/read] (/) [scan/fetch] (0/0/0) [ins/upd/del]

User tables performance (cache)  Roll up box
Table Heap Index Toast Index toast
branches 50% (1/1) [cache/disk] 0% (0/2) [cache/disk] 0% (/) [cache/disk] 0% (/) [cache/disk]
tellers 53% (7/6) [cache/disk] 0% (0/5) [cache/disk] 0% (/) [cache/disk] 0% (/) [cache/disk]
accounts 16% (35337/177175) [cache/disk] 0% (0/30398) [cache/disk] 0% (/) [cache/disk] 0% (/) [cache/disk]
history 0% (0/0) [cache/disk] 0% (/) [cache/disk] 0% (/) [cache/disk] 0% (/) [cache/disk]

User indexes performance  Roll up box
Table Index Stats
branches branches_pkey (0/0/0) [scan/read/fetch]
tellers tellers_pkey (0/0/0) [scan/read/fetch]
accounts accounts_pkey (0/0/0) [scan/read/fetch]

User indexes performance (cache)  Roll up box
Table Index Stats
branches branches_pkey 0% (0/2) [cache/disk]
tellers tellers_pkey 0% (0/5) [cache/disk]
accounts accounts_pkey 0% (0/30398) [cache/disk]

User sequences performance (cache)  Roll up box
No data


Created by: phpPgInfo-0.8