How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL

Under conventional wisdom, pruning can only be achieved when querying by the partition key. However, if your data follows certain patterns, using some clever tricks you can achieve pruning even when filtering by non-partition key columns.