Vertica Uptime...

[hopewell]

Hello,

Is there an easy way to tell how long a Vertica database has been up for the entire cluster. Also, at a more granular level, can I tell how long an individual node has been online?

Thanks!

[JimKnicely]

Hi,

You can query the DATABASES system table to find the START_TIME of a database and calculate the up time.

For example:

Code: Select all

SELECT current_timestamp - start_time AS uptime FROM databases;

For node up times, maybe you can try a query like the following?

Code: Select all

SELECT node_name,
       current_timestamp - MAX(event_timestamp) AS uptime
  FROM node_states
 WHERE node_state = 'UP'
 GROUP
    BY node_name;