Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow query when the select list is big - Mailing list pgsql-general

From David G. Johnston
Subject Re: Slow query when the select list is big
Date
Msg-id CAKFQuwYOCLqojT9Grv=prbN7_N0eQcgmtOrZs9X6DFa0BCDA=A@mail.gmail.com
Whole thread Raw
In response to Re: Slow query when the select list is big  ("Sterpu Victor" <victor@caido.ro>)
Responses Re: Slow query when the select list is big
List pgsql-general
Tree view
On Sunday, May 8, 2016, Sterpu Victor <victor@caido.ro> wrote:
Yes but it is very big.
I don't understand why the select list is influencing the CPU usage.
I was expecting that only the join and where clauses would influence CPU.


PostgreSQL is smart enough to optimize away stuff that it knows doesn't impact the final query result.

David J.
 

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Slow query when the select list is big
Next
From: David Rowley
Date:
Subject: Re: Slow query when the select list is big