April Release of VerticaKit


The April 2015 release has the following changes:

  • Updated unused projection query to exclude system tables
  • Adds diagnostic query
    • Cluster query distribution to identify potential load balancing issues


This and all future releases are available through GitHub.

Release Information

In addition to the 3 views, the core diagnostic query list contains 35 queries over 5 sections and covers the following:

  • Configuration Information (6)
    • Product Version
    • License and Compliance Status
    • Data Collector Status
    • Changed Configuration Parameters
    • Configuration Change History
    • Fault Tolerance
  • Resource Information (5)
    • Disk Space Utilization by Host
    • Processor Information by Host
    • Memory Information by Host
    • Compressed and Raw Estimate Data Space Usage by Schema
    • Disk Space Warning
  • Diagnostic Information (15)
    • Distribution of Query Request Times
    • Proactively Examining Query Events
    • Overview of Query Event Types
    • Spill to Disk Events
    • Resegmented Query Events
    • Load Events with Rejected Rows
    • Query Requests with Errors
    • Service Intervals and Last Run
    • Workload Analyzer Tuning Rules
    • Possible Missing Primary Keys
    • Deleted Database Date
    • Denied Resource Requests
    • Mergeout Activity
    • Open Sessions
    • Request Distribution
  • Projection Specific (5)
    • Outdated Column Statistics
    • Columns Requiring Statistics Updates
    • Data Skew in Segmented Projections
    • Outdated and Un-refreshed Projections
    • Unused Projections
  • Query Profiling Information (4)
    • Profiling Configuration
    • Clearing Profile Data
    • Query, Session and EE Profiling
    • Examining Query Profiles

Feedback and any ideas for future releases is certainly appreciated.

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

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: