Re: Query taking long time

On Thu, Mar 20, 2014 at 9:17 PM, acanada <acanada(at)cnio(dot)es> wrote:

> Hello,
>
> New server postgres version is 9.3. I'm not sure if I collected latest
> statistics after migration, if you mean if the current_settings or analyze
> queries that I posted were collected after migration... yes (notice that
> there are analyze query before migration and after migration, maybe I
> didn't illustrate right)
> Sorry for that. Reading the statistics collector manual, I see there are
> plenty of parameters, and I'm not sure which one of them are you interested
> in, or if there's a query to collect them...
>

Hi Andres,

If we do not have statistics, its hard to arrive at any conclusion
regarding performance. The cost numbers we get without statistics are not
accurate.

Also, you have migrated across 5 major versions since 8.3. It is very
important to have latest statistics in place.

Please perform VACUUM FULL and ANALYZE of the database.

Please post the EXPLAIN plan after that.

Thanks & Regards,

Venkata Balaji N
Fujitsu Australia