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 stats, so I can't tell which query was
extreemly slow.
Is there a solution to this problem ?
My configuration:
- Postgresql 7.1.3
- Linux 2.2.19
- Distribution: Debian
Yours,
Ferdinand Smit