Re: [Fwd: Re: Optimize]

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Cc: Torsten Schulz <comic(at)be-a-part(dot)de>
Subject: Re: [Fwd: Re: Optimize]
Date: 2003-11-25 19:19:25
Message-ID: 3FC3AB3D.4080708@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Torsten Schulz wrote:
> Hi,
>
>> You can see doing select * from pg_stat_activity the
>> queries that are currently running on your server, and
>> do a explain analize on it to see which one is the
>> bottleneck. If you are running the 7.4 you can see on
>> the log the total ammount for each query.
>
>
>
> 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.

Regards
Gaetano Mendola

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff 2003-11-25 19:23:18 Re: design question: general db performance
Previous Message Josh Berkus 2003-11-25 19:12:47 Re: design question: general db performance