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 "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
