[GENERAL] How can i monitor exactly what (partition) tables are accessed by a query?

I'm experiencing a problem with queries apparently not using the check constraints of my partition tables (tried constraint_exclusion =partition and =on with same results) and explain isn't sufficient to diagnose the issue because the value for the check constraint in the query comes from a join

Re: [GENERAL] How can i monitor exactly what (partition) tables are accessed by a query?

Jov blog: http:amutu.com/blog http://amutu.com/blog 2014-09-19 2:44 GMT+08:00 Robert Nix rob...@urban4m.com: I'm experiencing a problem with queries apparently not using the check constraints of my partition tables (tried constraint_exclusion =partition and =on with same results) and explain

Re: [GENERAL] How can i monitor exactly what (partition) tables are accessed by a query?

Joy, The explain plan shows that all partitions will be scanned but i believe that plan isn't valid because the check constraint that dictates which partition to access can't be known until the query is executed due to the value being a join. You can see what i mean using the SQL below. I have