Reshift uses query_group called
"xen_is_up" to executes queries in order to get back in an online state. The following query can be used to determine when the restart happened:
select endtime from stl_utilitytext where text ilike '%xen_is_up.sql%' order by endtime;
Note: ilike match case-insensitive according to the active locale. This is not in the SQL standard but is a PostgreSQL extension.
select endtime from stl_utilitytext where text ilike '%xen_is_up.sql%' order by endtime;
Note: ilike match case-insensitive according to the active locale. This is not in the SQL standard but is a PostgreSQL extension.
No comments:
Post a Comment