Re: Seeking help with a query that takes too long - Mailing list pgsql-performance

From Nick Fankhauser
Subject Re: Seeking help with a query that takes too long
Date
Msg-id NEBBLAAHGLEEPCGOBHDGCEJHJGAA.nickf@ontko.com
Whole thread Raw
In response to Re: Seeking help with a query that takes too long  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-performance
> >actor_full_name_uppercase on actor  (cost=0.00..6.01 rows=1 width=42)
>                                                       ^^^^^^
> >(actual time=37.62..677.44 rows=3501 loops=1)
>                             ^^^^^^^^^
> Nick, can you find out why this row count estimation is so far off?
^^^^^^^^^

Oops- I read this backward- I see what you mean now. That's a good question.
I'm not sure what part of the stats this estimate might be pulled from. The
average is 357, but the most common frequency may be around 1.

-Nick



pgsql-performance by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: Seeking help with a query that takes too long
Next
From: "scott.marlowe"
Date:
Subject: Re: Value of Quad vs. Dual Processor machine