| From: | Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Query stats |
| Date: | 2001-10-08 12:49:27 |
| Message-ID: | 200110081259.f98Cx4R18494@server9.telegraafnet.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nick Fankhauser | 2001-10-08 13:47:04 | Re: buffer overflow (I'm getting it too!) |
| Previous Message | Chad R. Larson | 2001-10-07 18:23:36 | Re: Postmaster startup |