Postgres Pro
Downloads
Home   >   mailing lists

Aggregate leads to superfluous projection from the scan - Mailing list pgsql-hackers

From Zhihong Yu
Subject Aggregate leads to superfluous projection from the scan
Date
Msg-id CALNJ-vTbeo5GN67tm_Wz89LrpnBXuh-KZQ8EeqNVpV0QL05WCw@mail.gmail.com
Whole thread Raw
Responses Re: Aggregate leads to superfluous projection from the scan
List pgsql-hackers
Tree view
Hi,
Here is the query which involves aggregate on a single column:


As you can see from `Output:`, there are many columns added which are not needed by the query executor.

I wonder if someone has noticed this in the past.
If so, what was the discussion around this topic ?

Thanks

pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: pg_walcleaner - new tool to detect, archive and delete the unneeded wal files (was Re: pg_archivecleanup - add the ability to detect, archive and delete the unneeded wal files on the primary)
Next
From: Alvaro Herrera
Date:
Subject: Re: Add last_vacuum_index_scans in pg_stat_all_tables