increasing query time after analyze - Mailing list pgsql-performance

From Katharina Koobs
Subject increasing query time after analyze
Date
Msg-id 005e01cf27d0$a52ec3e0$ef8c4ba0$@uni-konstanz.de
Whole thread Raw
Responses Re: increasing query time after analyze  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-performance

Hi,

 

We have still problems with our query time.

After restoring the database the query time is about one minute.

After an analyze the query time is about 70 minutes.

We could discover one table which cause the problem.

After analyzing this table the query time increases.

We have made an explain plan before and after analyzing the table cifx.

 

The plans can be found on

 

After analyze:

explain.depesz.com/s/HuZ

 

Before analyze:

explain.depesz.com/s/XWF

 

Thanks a lot for your help!

 

 

 

 

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Postgres Query Plan Live Lock
Next
From: Pavel Stehule
Date:
Subject: Re: increasing query time after analyze