Steve Atkins wrote:
> On Fri, Sep 09, 2005 at 12:39:14PM -0700, Jeff Davis wrote:
>
>
>>I'm aware of log_statement_stats, but as far as profiling goes, it's a
>>bit crude.
>>
>>Is there an easier way to determine, for example, all the queries that
>>take longer than 0.5 seconds? I'd like to do this on a production
>>system, so I'd like to avoid anything that would crush performance or
>>cause any kind of downtime.
>>
>>I could probably make log_statement_stats work, I'm just looking for an
>>easier way.
>
>
> log_min_duration_statement may be what you're looking for.
>
Thanks, I think that's exactly what I'm looking for. I'll try it out.
Regards,
Jeff Davis
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
