On Thu, Feb 24, 2011 at 16:14, Dave Johansen wrote:
> You'll notice that the subquery version is doing the full join and then the
> filtering, but the explicitly listed version pushing the filtering into the
> plan before the join. Is there a way to make the subquery version perform
> the same op
On Thu, Feb 24, 2011 at 20:56, Dave Johansen wrote:
> On Thu, Feb 24, 2011 at 12:33 PM, Vik Reykja wrote:
>
>> On Thu, Feb 24, 2011 at 16:14, Dave Johansen wrote:
>>
>>> You'll notice that the subquery version is doing the full join and then
>>> the fil
On Wed, Feb 8, 2012 at 20:22, Ofer Israeli wrote:
> Andy Colson wrote:
> > Oh, I knew I'd seen index usage stats someplace.
> >
> > give this a run:
> >
> > select * from pg_stat_user_indexes where relname = 'SuperBigTable';
> >
> > http://www.postgresql.org/docs/current/static/monitoring-stats.h
