Postgres Pro
Downloads
Home   >   mailing lists

Re: What happens between end of explain analyze and end of query execution ? - Mailing list pgsql-performance

From Nikolas Everett
Subject Re: What happens between end of explain analyze and end of query execution ?
Date
Msg-id CAPmjWd2q1W1HsKM2GHgbEv82VrsC70nXhzw4ObPFc3pdPOFYLw@mail.gmail.com
Whole thread Raw
In response to Re: What happens between end of explain analyze and end of query execution ?  (Franck Routier <franck.routier@axege.com>)
Responses Re: What happens between end of explain analyze and end of query execution ?
List pgsql-performance
Tree view
On Fri, Apr 5, 2013 at 9:55 AM, Franck Routier <franck.routier@axege.com> wrote:
Le 04/04/2013 21:08, Tom Lane a écrit :
Maybe the statistics tables for sandia and saneds are in a bad shape ? (don't know how to check this).

Regards,

Franck



Could this be caused by system table bloat?

Also, can you check how long it takes to plan:
1.  A query without a table at all (SELECT NOW())
2.  A query with an unrelated table

Again, what version of PostgreSQL is this?

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: What happens between end of explain analyze and end of query execution ?
Next
From: Mark Davidson
Date:
Subject: INDEX Performance Issue