yes it is show constraint_exclusion partition
and if I explain the same query with an other filter
explain select * from wiki_data_part where category='fr'
| Append (cost=0.00..14010.76 rows=291609 width=48)
| -> Seq Scan on wiki_data_part_f (cost=0.00..9975.04 rows=291339
width=48)
| Filter: ((category)::text = 'fr'::text)
| -> Seq Scan on wiki_data_part_s (cost=0.00..4035.72 rows=270 width=50)
| Filter: ((category)::text = 'fr'::text)
wiki_data_part_s is always chosen in the plan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
