[PERFORM] PostgreSQL query for cache performance counters?

Can any one teel me the query to get value for *Number of cached blocks read, Number of cached index blocks read, Number of cached sequence blocks read* in Postgresql? I just find all other queries, except this. so if you know kindly help me. Thanks in advance. -- View this message in context:

[PERFORM] Slow counting on v9.3

Hi, I'm experiecing slow count performance: SELECT COUNT(*) AS "count" FROM "NewsArticle" Takes 210 ms. I've run analyze and vacuum. I'm on 9.3. Here're the stats http://d.pr/i/6YoB I don't understand why is it that slow. It returns 1 integer, and counts without filters. This performs quickly:

[PERFORM] Issue with query scanning through all data even with indexes

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 C