subject:"\[GENERAL\] Help with slow query \- Pgsql 9.2"

Re: [GENERAL] Help with slow query - Pgsql 9.2

2016-09-06 Thread Jeff Janes

On Mon, Sep 5, 2016 at 6:53 PM, Patrick B wrote: > Hi guys, > > I got this query: > >> SELECT id,jobid,description,serialised_data >> FROM logtable >> WHERE log_type = 45 >> AND clientid = 24011 >> ORDER BY gtime desc > > What is really going to help you here is

[GENERAL] Help with slow query - Pgsql 9.2

2016-09-06 Thread Patrick B

Hi guys, I got this query: > SELECT id,jobid,description,serialised_data > FROM logtable > WHERE log_type = 45 > AND clientid = 24011 > ORDER BY gtime desc Explain analyze: https://explain.depesz.com/s/XKtU So it seems the very slow part is into: -> Bitmap Index Scan on