Comments

• Jim_Knicely - Select Field - Administrator

  July 2019

  Maybe check dc_execution_engine_profiles?

  1
• s_crossman Vertica Employee Employee

  July 2019

  I concur with Jim. The system tables are non persistent and depending on the number of users and complexity of queries things can roll off pretty quickly. The DC (data_collector) tables are a persistent version of many of the key system tables. They have configurable retention policies that allow you to modify how much info they store on either a memory/disk space and/or time based value.

  A good reference in the documentation is in the Administrator's Guide > Monitoring Vertica > Retaining Monitoring Information

  1
• Bryan_H Vertica Employee Administrator

  July 2019

  Also check
  SELECT get_data_collector_policy('ExecutionEngineProfiles');
  to see if there is a retention policy.

  1
• abtsantosbenten ✭

  July 2019

  The records didn't go to dc_execution_engine_profiles.

  I reran the profile and captured the records in v_monitor.execution_engine_profiles while the query was still running.

  0
• abtsantosbenten ✭

  July 2019 edited July 2019

  oh no! I just realized the values in (v_monitor.execution_engine_profiles) are changing as the query is running. Where can I get the final values?

  0