Re: slow query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: slow query
Date: 2003-02-22 02:20:39
Message-ID: 2050.1045880439@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)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

In response to

  • slow query at 2003-02-21 16:30:53 from Oleg Lebedev

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-02-22 02:24:39 Re: Really bad insert performance: what did I do wrong?
Previous Message Kevin White 2003-02-21 19:18:12 Re: Really bad insert performance: what did I do wrong?