query_requests and dc_requests_issued tables


This post will briefly explain the similarities and differences between the query_requests and dc_requests_issued tables in Vertica.

Both these tables return information about user-issued query requests. The query_requests exists in the v_monitor schema and the dc_requests_issued table (part of the data collector tables) exists in the v_internal schema. They appear to have the same retention policy, which can be confirmed with:

  • node_name
  • session_id
  • transaction_id
  • statement_id
  • user_name
  • start_timestamp / time
  • request
  • request_id
  • request_label / label
  • request_type
  • search_path
query_requests dc_requests_issued
  • error_count
  • end_timestamp
  • request_duration_ms
  • memory_acquired_mb
  • is_executing
  • user_id
  • query_start_epoch
  • is_retry

About the author / 

Norbert Krupa

Norbert is the founder of and a Solutions Engineer at Talend. He is an HP Accredited Solutions Expert for Vertica Big Data Solutions. He has written the Vertica Diagnostic Queries which aim to cover monitoring, diagnostics and performance tuning. The views, opinions, and thoughts expressed here do not represent those of the user's employer.

Leave a Reply

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.


This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.
%d bloggers like this: