info_ha_queries.sql

info_ha_queries.sql

\pset pager off
\set ECHO all
\set ON_ERROR_STOP 0

select version();
\dx
select now()

\x off
select * from _prom_catalog.ha_leases
order by cluster_name, lease_start desc;

\x off
select * from _prom_catalog.ha_leases_logs
order by cluster_name, lease_start desc;

\x off
select time_bucket('10 min', time) from prom_data.up group by 1 order by 1;

\x on
SHOW ALL;