Unknown query running before the actual query against IDs !!!!!!!
Hi,
We have the following query running againt IDs, when they submit the a normal query . The users are not seeing this as being run. But it comes up in query_requests.
This query takes around 90% of time and only after this the actual query runs. But the actual query runs pretty fast .
Could some one please check this and let me know what is this query ??
We use Aqua data studio to run queries in Vertica.
SELECT distinct t.table_schema, t.table_name, t.is_temp_table, t.partition_expression, c.column_name, c.data_type, c.is_nullable, c.column_default, c.is_identity, p.node_name, p.is_segmented, pc.sort_position, pc.encoding_type, pc.access_rank, s.session_cache_count, s.increment_by, s.minimum, pc.column_position=pc.sort_position, c.ordinal_position FROM v_catalog.tables t LEFT JOIN v_catalog.columns c ON t.table_id = c.table_id LEFT JOIN v_catalog.projections p ON (t.table_id = p.anchor_table_id AND t.table_name = p.projection_basename) LEFT JOIN v_catalog.projection_columns pc ON (p.projection_name = pc.projection_name AND c.column_name = pc.projection_column_name AND pc.table_schema = t.table_schema AND pc.table_name = t.table_name) LEFT JOIN v_catalog.sequences s ON t.table_id = s.identity_table_id and c.is_identity = true WHERE t.table_name = 'current_experience' AND t.table_schema = '<schema name>' ORDER BY c.ordinal_position
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.