Hi, To improve the database preformence, I tried to monitor all the query's and the system usage by using the settings debug_print_query and show_query_stats in the /etc/postgres/postgres.conf. The only problem is that I can't find a relationship between the query and the statistics, so I can't tell which query was extreemly slow.
my postgres.log: 2001-10-26 04:00:03 [11839] DEBUG: query: select datname from pg_database order by datname <ZIP> QUERY STATISTICS ! system usage stats: ! 0.046908 elapsed 0.000000 user 0.000000 system sec ! [0.030000 user 0.010000 sys total] ! 0/0 [0/0] filesystem blocks in/out ! 34/8 [340/160] 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 ! postgres usage stats: ! Shared blocks: 7 read, 0 written, buffer hit rate = 91.67% ! Local blocks: 0 read, 0 written, buffer hit rate = 0.00% ! Direct blocks: 0 read, 0 written The query is logd at the start, and the statistics at the and. So all the querys and statistics will be mixed up. Is there a solution for this "problem". Please help !! Yours, Ferdinand ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
