Postgres Pro
Downloads
Home   >   mailing lists

Help with slow query - Pgsql 9.2 - Mailing list pgsql-general

From Patrick B
Subject Help with slow query - Pgsql 9.2
Date
Msg-id CAJNY3itmCUZupsqqgLs1FiQ-T4HRJfVANFXHvvZEQey00hwrmA@mail.gmail.com
Whole thread Raw
Responses Re: Help with slow query - Pgsql 9.2
List pgsql-general
Tree view
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



So it seems the very slow part is into:

              ->  Bitmap Index Scan on "ix_client"  (cost=0.00..5517.96 rows=367593 width=0) (actual time=2668.246..2668.246 rows=356327 loops=1)
                    Index Cond: ("clientid" = 24011)

Am I right? The query is already using an index on that table... how could I improve the performance in a query that is already using an index?

Thanks
Patricl

pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: IDE for function/stored proc development.
Next
From: Greg Fodor
Date:
Subject: Privileges on public schema can't be revoked?