Vertica Data Collector Table Changes

Moderator: NorbertKrupa

Post Reply
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1823
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Vertica Data Collector Table Changes

Post by JimKnicely » Fri Dec 13, 2013 2:21 pm

FYI - Here are the changes that have been made to the dc_x tables in Vertica 7.0.0-0 from 6.1.3-0:
  • 1. dc_block_memory_manager_statistics (Table added)
    2. dc_errors (Dropped design_query_signature)
    3. dc_features_used (Table added)
    4. dc_projection_refreshes_completed (Added transaction_id)
    5. dc_session_starts (Added client_type, client_version and client_os)
    6. dc_block_memory_manager_statistics (Added file_cache_used_up_count and forced_allocation_count)
    7. dc_block_memory_manager_statistics_by_day
    • (Removed hits_min_value, hits_max_value, hits_sample_count, hits_sample_sum, misses_min_value, misses_max_value, misses_sample_count, misses_sample_sum)
      (Added hits_peak_delta, hits_peak_start, hits_peak_end, misses_peak_delta, misses_peak_start, misses_peak_end, file_cache_used_up_count_start_value,
      • file_cache_used_up_count_end_value, file_cache_used_up_count_peak_delta, file_cache_used_up_count_peak_start, file_cache_used_up_count_peak_end,
        forced_allocation_count_start_value, forced_allocation_count_end_value, forced_allocation_count_peak_delta, forced_allocation_count_peak_start and
        forced_allocation_count_peak_end)
    8. dc_block_memory_manager_statistics_by_hour
    • (Removed hits_min_value, hits_max_value, hits_sample_count, hits_sample_sum, misses_min_value, misses_max_value, misses_sample_count, misses_sample_sum)
      (Added hits_peak_delta, hits_peak_start, hits_peak_end, misses_peak_delta, misses_peak_start, misses_peak_end, file_cache_used_up_count_start_value,
      • file_cache_used_up_count_end_value, file_cache_used_up_count_peak_delta, file_cache_used_up_count_peak_start, file_cache_used_up_count_peak_end,
        forced_allocation_count_start_value, forced_allocation_count_end_value, forced_allocation_count_peak_delta, forced_allocation_count_peak_start and
        forced_allocation_count_peak_end)
    9. dc_block_memory_manager_statistics_by_second
    • (Removed hits_min_value, hits_max_value, hits_sample_count, hits_sample_sum, misses_min_value, misses_max_value, misses_sample_count, misses_sample_sum)
      (Added hits_peak_delta, hits_peak_start, hits_peak_end, misses_peak_delta, misses_peak_start, misses_peak_end, file_cache_used_up_count_start_value,
      • file_cache_used_up_count_end_value, file_cache_used_up_count_peak_delta, file_cache_used_up_count_peak_start, file_cache_used_up_count_peak_end,
        forced_allocation_count_start_value, forced_allocation_count_end_value, forced_allocation_count_peak_delta, forced_allocation_count_peak_start and
        forced_allocation_count_peak_end)
    10. dc_catalog_persistence_events (Added is_compressed)
    11. dc_cpu_info (Table removed)
    12. dc_cpu_info_by_day (Table removed)
    13. dc_cpu_info_by_hour (Table removed)
    14. dc_cpu_info_by_minute (Table removed)
    15. dc_cpu_info_by_second (Table removed)
    16. dc_data_channels
    • (Removed transferred_bytes, transferred_frames, start_time and setup_time)
      (Added sent_bytes, sent_frames, sent_messages, recv_bytes, recv_frames, recv_messages, initiate_timestamp, finish_timestamp and local_port)
    17. dc_design_queries (Added design_query_signature)
    18. dc_rebalance_projection_sizes (Tables added)
I think I go 'em all :D
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Premium Edition”