Avoid fetching unnecessary columns, especially wide rows.
Section: High-value Query Performance Patterns
Select needed columns
sql
sql
SELECT order_id, customer_id, total_amount FROM orders WHERE status = 'open';Explanation
See summary for usage details.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing High-value Query Performance Patterns
Keyset pagination
Prefer keyset pagination over deep OFFSET scans for large result sets.
Covering index with INCLUDE
Use included columns to support index-only reads for certain queries.
Batch updates
Chunk large writes into batches to reduce contention and WAL spikes.
Create range-partitioned table
Partition large time-series tables by range.