From: bogdan@expeditor.com (Bogdan)
Newsgroups: comp.databases.postgresql.questions
Subject: help with I/O statistics in 7.3.1
NNTP-Posting-Host: 12.98.224.90
Message-ID: <7a0f9e74.0301270519.24d69b04@posting.google.com>
I can't make configuration to get "filesystem blocks in/out"
to show valid data.
Im only getting "0/0" all the time.
Is that functionality available in postgres 7.3.1 ???
Regards, Bogdan
------------------------
test4=# explain analyze select * from patients;
LOG: query: explain analyze select * from patients;
LOG: duration: 0.603887 sec
LOG: QUERY STATISTICS
! system usage stats:
! 0.624269 elapsed 0.458985 user 0.123047 system sec
! [0.468750 user 0.125000 sys total]
! 0/0 [0/0] filesystem blocks in/out
! 7/4 [310/158] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [0/0] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 2742 read, 0 written, buffer hit
rate = 3.59%
! Local blocks: 0 read, 0 written, buffer hit
rate = 0.00%
! Direct blocks: 0 read, 0 written QUERY PLAN
-----------------------------------------------------------------Seq Scan on patients (cost=0.00..4048.60 rows=131960
width=172)
(actual time=0.04..562.97 rows=133886 loops=1)Total runtime: 602.42 msec
(2 rows)
test4=#
test4=# show all;
australian_timezones | offauthentication_timeout | 60autocommit |
oncheckpoint_segments | 3checkpoint_timeout | 300client_encoding |
SQL_ASCIIclient_min_messages | noticecommit_delay | 0commit_siblings |
5cpu_index_tuple_cost | 0.001cpu_operator_cost | 0.0025cpu_tuple_cost |
0.01DateStyle | ISO with US (NonEuropean)
conventionsdb_user_namespace | offdeadlock_timeout | 1000debug_assertions |
ondebug_pretty_print | ondebug_print_parse | offdebug_print_plan |
offdebug_print_rewritten | offdefault_statistics_target | 10default_transaction_isolation | read
committeddynamic_library_path | $libdireffective_cache_size | 1000enable_hashjoin |
onenable_indexscan | onenable_mergejoin | onenable_nestloop |
onenable_seqscan | onenable_sort | onenable_tidscan |
onexplain_pretty_print | onfixbtree | onfsync | offgeqo
| ongeqo_effort | 1geqo_generations | 0geqo_pool_size
|0geqo_random_seed | -1geqo_selection_bias | 2geqo_threshold |
11hostname_lookup | offkrb_server_keyfile | unsetlc_messages |
Clc_monetary | Clc_numeric | Clc_time | Clog_connections
| offlog_duration | onlog_min_error_statement | paniclog_pid
| offlog_statement | onlog_timestamp | offmax_connections |
32max_expr_depth | 10000max_files_per_process | 1000max_fsm_pages |
10000max_fsm_relations | 100max_locks_per_transaction | 64password_encryption | onport
| 5432pre_auth_delay | 0random_page_cost | 4search_path
| $user,publicserver_encoding | SQL_ASCIIserver_min_messages | noticeshared_buffers
| 64show_executor_stats | offshow_parser_stats | offshow_planner_stats |
offshow_source_port | offshow_statement_stats | onsilent_mode | offsort_mem
| 1024sql_inheritance | onssl | offstatement_timeout
| 0stats_block_level | offstats_command_string | offstats_reset_on_server_start |
onstats_row_level | offstats_start_collector | onsuperuser_reserved_connections | 2syslog
| 0syslog_facility | LOCAL0syslog_ident | postgrestcpip_socket
| onTimeZone | unknowntrace_notify | offTRANSACTION ISOLATION LEVEL
|READ COMMITTEDtransform_null_equals | offunix_socket_directory | unsetunix_socket_group
|unsetunix_socket_permissions | 511vacuum_mem | 8192virtual_host |
unsetwal_buffers | 8wal_debug | 8wal_sync_method | fsync
(99 rows)
---------------------------------------------------
Regards, Bogdan