[Solved] You wrote this query on a partitioned table orders partitioned by order_date:SELECT * FROM orders WHERE EXTRACT(YEAR FROM order_date) = 2023;Why might partition pruning NOT occur? | PostgreSQL

PostgreSQL - Table Partitioning

You wrote this query on a partitioned table orders partitioned by order_date:

SELECT * FROM orders WHERE EXTRACT(YEAR FROM order_date) = 2023;

Why might partition pruning NOT occur?

APartition pruning only works with numeric columns

BUsing a function on the partition key disables pruning

CThe query syntax is invalid

DPartition pruning requires an index on order_date

Step-by-Step Solution

Solution:

Step 1: Identify pruning limitation
Partition pruning requires direct use of the partition key in filters without wrapping functions.
Step 2: Analyze the query
The query uses EXTRACT(YEAR FROM order_date), a function on the partition key, preventing pruning.
Final Answer:
Using a function on the partition key disables pruning -> Option B
Quick Check:
Functions on partition keys disable pruning [OK]

Quick Trick: Avoid functions on partition keys for pruning [OK]

Common Mistakes:

Master "Table Partitioning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

You wrote this query on a partitioned table orders partitioned by order_date: