Postgres Pro
Downloads
Home   >   mailing lists

Re: slow query - Mailing list pgsql-performance

From Tom Lane
Subject Re: slow query
Date
Msg-id 2050.1045880439@sss.pgh.pa.us
Whole thread Raw
In response to slow query  (Oleg Lebedev <oleg.lebedev@waterford.org>)
List pgsql-performance
Tree view 
Oleg Lebedev <oleg.lebedev@waterford.org> writes:
> Interestingly the planner statistics for this query are the same on the
> master and replica databases.
> However, query execution on the master database is about 4min. and on
> the replica database is 6 sec.!

What does EXPLAIN ANALYZE show in each case?

            regards, tom lane

pgsql-performance by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: cost and actual time
Next
From: Tom Lane
Date:
Subject: Re: Really bad insert performance: what did I do wrong?