Re: [GENERAL] Help on analyzing performance problem.

2000-08-26 Thread Tom Lane
"Travis Bauer" <[EMAIL PROTECTED]> writes: > I have a problem with a _very_ slow query. I'm not sure how to understand > the explain output. There's some basic info about EXPLAIN in the "understanding performance" section of the user manual (at least today, it's at http://www.postgresql.org/docs

[GENERAL] Help on analyzing performance problem.

2000-08-26 Thread Travis Bauer
I have a problem with a _very_ slow query. I'm not sure how to understand the explain output. Can anyone tell from the following where I might look for a bottleneck in the system? Thank, Travis psql:test.sql:1: NOTICE: QUERY PLAN: Nested Loop (cost=3.03..240.90 rows=4 width=124) -> Neste