Re: What happens between end of explain analyze and end of query execution ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Apr 5, 2013 at 9:55 AM, Franck Routier <franck.routier@xxxxxxxxx> 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?

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux