RE: Monitoring multixact members growth

2022-08-19 Thread Vido Vlahinic
Hello everyone, Is there a way to monitor multixact members growth per table ? There is this query: SELECT relname, relminmxid, mxid_age(relminmxid) AS age FROM pg_class WHERE relkind = 'r' AND relnamespace::regnamespace::text = 'public' ORDER BY 3 DESC However it is not quite clear to me how I

Monitoring multixact members growth

2022-08-19 Thread Vido Vlahinic
Hello everyone, Is there a way to monitor multixact members growth per table ? There is this query: SELECT relname, relminmxid, mxid_age(relminmxid) AS age FROM pg_class WHERE relkind = 'r' AND relnamespace::regnamespace::text = 'public' ORDER BY 3 DESC However it is not quite clear to me how