On 26 Nov 2010, at 6:04, Leif Jensen wrote:
Looking at your query, I'm kind of wondering why you're not letting the
database do the time-zone calculations?
But, that's not what your question was about:
> I have concentrate my effort on the (double) 'Seq Scan':
>
>
om: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Leif Jensen
Sent: Freitag, 26. November 2010 06:04
To: pgsql-general
Subject: [GENERAL] Help on explain analyze
Hi guys,
I have a rather complex view that sometimes takes an awful long time to
execute. I
Hi guys,
I have a rather complex view that sometimes takes an awful long time to
execute. I have tried to do an 'explain analyze' on it. My intention was to try
to optimize the tables involved by creating some indexes to help the lookup. I
looked for the "Seq Scan's and created appropriat
