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,
How to get Last Good Epoch data and time?
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: How to get Last Good Epoch data and time?
Hi!
I believe you can use the epoch and v_monitor.system table. Like this:
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
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.
Re: How to get Last Good Epoch data and time?
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)
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.