- 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)
- 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,
- (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)
- 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,
- (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)
- 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,
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)
18. dc_rebalance_projection_sizes (Tables added) - (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)
Vertica Data Collector Table Changes
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Vertica Data Collector Table Changes
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:
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.