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
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