Unknown query running before the actual query against IDs !!!!!!!


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


  • Options

    Its AcuaStudio checks connectivity to database and catalog updates.
    Say you deleted a table, you will want to see it in a client, so AStudio periodically checks connectivity and catalog updates.
  • Options
    Navin_CNavin_C Vertica Customer
    Agree with id10t

    Lot of SQL IDE do this.

    Check the source of this query in sessions table. It should be something coming from JDBC client. Basically to always update the Catalog / database explorer in your IDE's.

    Hope this helps.
  • Options
    Hi Guys,

    Thanks for replies.

    The query was generated by Aqua data for the auto completion of column names.

    We unchecked the auto complete feature in Aqua data(File -->Options---> SQL Editor---> Auto Completion and unchecked Auto pop up option  and it solved the issue. 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file