Re: Optimizing projections containing unused columns

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Optimizing projections containing unused columns
Date: 2008-10-16 19:29:43
Message-ID: 9DD2E011713C4190910C04D534571178@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> gj=# explain select count(*) from smartarse where v is null;
>----------------------------------------------------------------
> Aggregate (cost=21.62..21.63 rows=1 width=0)
< -> Seq Scan on smartarse (cost=0.00..21.60 rows=6 width=0)

Thread question and sample was about using nested queries.
Your sample does not use nested queries but it shows (width=0) that all
columns are excluded.

So I do'nt understand how this applies to topic.

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2008-10-16 19:33:28 Re: Optimizing projections containing unused columns
Previous Message Grzegorz Jaśkiewicz 2008-10-16 17:51:06 Re: Optimizing projections containing unused columns