Postgres Pro
Downloads
Home   >   mailing lists

Issue with query scanning through all data even with indexes - Mailing list pgsql-performance

From Kai Sellgren
Subject Issue with query scanning through all data even with indexes
Date
Msg-id CANyR-3cyvy95XufRNd9kq4yfuKOskaA0v-8AT7GDBUvRRDKXjQ@mail.gmail.com
Whole thread Raw
Responses Re: Issue with query scanning through all data even with indexes
List pgsql-performance
Tree view
Hi,

I have a query that has each field used in conditions + sort indexed, but it scans through all data.

The query in question looks like:

http://pastie.org/8618562

I have each of those condition fields indexed:

NewsArticle.groupId
NewsArticle.sharedToCommunityIds
NewsArticle.sourceFilterIds
CommunityGroupLink.communityId
CommunityGroupLink.groupId
SourceFilter.groupId
SourceFilter.communityId

This is the data output for explain http://d.pr/i/VGT3

And in visual http://d.pr/i/mqiN

Line 7 says rows=99173 which makes it real slow (it can take up to a minute to run).

Do you have any ideas? All of them are appreciated!

Cheers,

--
Yours sincerely,
Kai Sellgren

pgsql-performance by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: COMMIT stuck for days after bulk delete
Next
From: ambilalmca
Date:
Subject: PostgreSQL query for cache performance counters?