Re: [GENERAL] Slow Query - Postgres 9.2

2016-03-03 Thread Vitaly Burovoy
On 3/2/16, drum.lu...@gmail.com wrote: > On 3 March 2016 at 10:33, Vitaly Burovoy wrote: >> On 3/2/16, drum.lu...@gmail.com wrote: >> > Hi all... >> > >> > I'm working on a Slow Query. It's faster now (It was 20sec before) but >> > still not good. >> > >> > Can you have a look and see if you can

Re: [GENERAL] Slow Query - Postgres 9.2

2016-03-02 Thread drum.lu...@gmail.com
On 3 March 2016 at 10:33, Vitaly Burovoy wrote: > On 3/2/16, drum.lu...@gmail.com wrote: > > Hi all... > > > > I'm working on a Slow Query. It's faster now (It was 20sec before) but > > still not good. > > > > Can you have a look and see if you can find something? > > Cheers > > > > Query: > > >

Re: [GENERAL] Slow Query - Postgres 9.2

2016-03-02 Thread Vitaly Burovoy
On 3/2/16, drum.lu...@gmail.com wrote: > Hi all... > > I'm working on a Slow Query. It's faster now (It was 20sec before) but > still not good. > > Can you have a look and see if you can find something? > Cheers > > Query: > > WITH jobs AS ( > ... > FROM > jobs AS job > JOIN >