Search This Blog

Wednesday, August 24, 2016

How to know when Amazon Redshift database restarted

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.