Re: The query plan get all columns but I'm using only one column. - Mailing list pgsql-performance

From Michael Lewis
Subject Re: The query plan get all columns but I'm using only one column.
Date
Msg-id CAHOFxGoem0SAFg54e7njOjfjZWDON03iQcwE6f3Npfmt2HgLqQ@mail.gmail.com
Whole thread Raw
In response to Re: The query plan get all columns but I'm using only one column.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: The query plan get all columns but I'm using only one column.
List pgsql-performance
The example is nonsensical so I expect it is too contrived to be useful for analyzing the actual problem.

Additionally, the total query time is under 1ms and most of it is planning time. Use a prepared statement or do something else to reduce planning time like reducing statistics target if that actually makes sense for your use case.

Else, show us something much closer to the real problem.

pgsql-performance by date:

Previous
From: Arcadio Ortega Reinoso
Date:
Subject: Re: PostgreSQL does not choose my indexes well
Next
From: Jean-Christophe Boggio
Date:
Subject: Recursive query slow on strange conditions