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

From Sterpu Victor
Subject Slow query when the select list is big
Date
Msg-id em5be5fad7-2eaa-4422-bceb-0af6da79973e@victor-pc
Whole thread Raw
Responses Re: Slow query when the select list is big  (Rob Imig <rimig88@gmail.com>)
List pgsql-general
I have a big query that takes about 7 seconds to run(time sending the data to the client is not counted).
Postgres uses 100% of 1 CPU when solving this query. I tried to run the query on a HDD and on a SSD with no difference. HDD show about 10% usage while the query runs.
 
The query has a big "select" list and no "group by" clause. If I delete all selects except one the query runs in under a second(it doesn't matter what field remains selected).
It seems that the query is slow because of the long select, can I do something to make the query faster?
 
Thank you.
 

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Allow disabling folding of unquoted identifiers to lowercase
Next
From: Rob Imig
Date:
Subject: Re: Slow query when the select list is big