| From: | "Russell Garrett" <rg(at)tcslon(dot)com> |
|---|---|
| To: | "Torsten Schulz" <comic(at)be-a-part(dot)de>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: [Fwd: Re: Optimize] |
| Date: | 2003-11-25 22:27:34 |
| Message-ID: | MKEGJINFADFODDNOKEJCGEJEEJAA.rg@tcslon.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
>>> with this query I see how much queries running, but the field
>>> current_query are free, so i can't see which queries are very slow.
>>
>>
>> You must perform that query with permission of super_user.
>>
> I've made it in root-account with psql -U postgres - but i can't see
> the query
You must have these lines in your postgresql.conf for the query stats to be
collected:
stats_start_collector = true
stats_command_string = true
--------------------------------------------------------------------
Russ Garrett russ(at)last(dot)fm
http://last.fm
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-11-25 23:37:42 | Re: Wierd context-switching issue on Xeon |
| Previous Message | Josh Berkus | 2003-11-25 22:19:36 | Wierd context-switching issue on Xeon |