Could You please tell me what else should be done to view queries in system tables such as Query_profiles, Query_Events. I would like analyze my queries execution in details like PARTITION_ELIMINATED etc...). EXPLAIN doesn't provide these information but as I've read I can find these in system tables. My problem is as I wrote before I cannot force vertica to log my queries in those tables.
I've used PROFILE keyword before select statement
I've enabled query profiling by execute SELECT ENABLE_PROFILING('query');
and still nothing.