Other Resources
Postgres as a Service
Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.
![]() |
![]() |
![]() |
10 Table Partitioning : 10.2 Using Partition Pruning : 10.2.1 Example - Partition Pruning
10.2.1 Example - Partition PruningThe EXPLAIN statement displays the execution plan of a statement. You can use the EXPLAIN statement to confirm that Advanced Server is pruning partitions from the execution plan of a query.Then, perform a constrained query that includes the EXPLAIN statement:The resulting query plan shows that the server will scan only the sales_asia table - the table in which a row with a country value of INDIA would be stored:
10 Table Partitioning : 10.2 Using Partition Pruning : 10.2.1 Example - Partition Pruning
![]() |
![]() |
![]() |