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!
Vertica Uptime...
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Vertica Uptime...
Hi,
You can query the DATABASES system table to find the START_TIME of a database and calculate the up time.
For example:
For node up times, maybe you can try a query like the following?
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;
Code: Select all
SELECT node_name,
current_timestamp - MAX(event_timestamp) AS uptime
FROM node_states
WHERE node_state = 'UP'
GROUP
BY node_name;
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.