How to get Last Good Epoch data and time?

Moderator: NorbertKrupa

Post Reply
maskh09
Newbie
Newbie
Posts: 2
Joined: Wed Mar 06, 2013 9:10 pm

How to get Last Good Epoch data and time?

Post by maskh09 » Mon Mar 10, 2014 5:13 pm

Hi,

Is there any command / log to verify the Last Good Epoch with date and time?

I'm using the following, but it doesn't show the date and time.

select last_good_epoch from system;

last_good_epoch
-----------------
117263

Thanks,

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: How to get Last Good Epoch data and time?

Post by JimKnicely » Mon Mar 10, 2014 7:32 pm

Hi!

I believe you can use the epoch and v_monitor.system table. Like this:

Code: Select all

dbadmin=> SELECT epoch_number, epoch_close_time 
dbadmin->   FROM v_monitor.system
dbadmin->   JOIN epochs
dbadmin->     ON epoch_number = last_good_epoch;
 epoch_number |       epoch_close_time        
--------------+-------------------------------
        79245 | 2014-03-10 14:31:02.379092-04
(1 row)
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

vlindem25
Newbie
Newbie
Posts: 4
Joined: Wed Nov 18, 2015 3:39 pm

Re: How to get Last Good Epoch data and time?

Post by vlindem25 » Thu Nov 19, 2015 3:17 pm

You should also be able to do:
SELECT * FROM v_catalog.EPOCHS

=> SELECT * FROM epochs;
epoch_close_time | epoch_number
-------------------------------+--------------
2012-11-14 09:26:10.696296-05 | 0
2012-11-14 10:04:55.668457-05 | 1
2012-11-14 10:08:05.963606-05 | 2
(3 rows)
I work for Vertica.

Post Reply

Return to “General”