Skip to main content

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

  • December 10, 2014
  • 3 replies
  • 21 views

kannan_1
Forum|alt.badge.img+1

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

3 replies

id10t
Forum|alt.badge.img
  • Participating Frequently
  • December 10, 2014
Hi!

Hearbeat.
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.

Navin_C
Forum|alt.badge.img+2
  • Participating Frequently
  • December 10, 2014
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.
NC

kannan_1
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • December 11, 2014
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.