July Release of VerticaKit


The July 2014 release of the VerticaKit has the following changes:

  • Fixes calculation on nodes with less than recommended disk space
  • Fixes tables without primary keys to exclude system tables
  • Adds 3 diagnostic views
    • Configuration Information View
    • Diagnostic Information View
    • Resource Information View

Configuration View

Sample output from the Configuration View:

Diagnostic View

Sample output from the Diagnostic View:

Resource View

Sample output from the Resource View:


This and all future releases are available through GitHub.

Release Information

In addition to the 3 views, the core diagnostic query list contains 33 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 (13)
    • 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
  • 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: