Confusing panel title "SAGE" in dashboards

[l2dy]

The query is a simple max age in pgsql-databases.json:

pigsty/files/grafana/pgsql/pgsql-databases.json

Lines 797 to 801 in 4a084c3

	"targets":[
	{ "datasource":{"type":"prometheus","uid":"ds-prometheus"},"editorMode":"code","exemplar":false,"expr":"max by (ins) (pg_activity_max_tx_duration{cls=\"$cls\", ins=\"$primary\", state=\"active\"})" , "interval":"","legendFormat":"{{ ins }}\u2b50\ufe0f","range":true,"refId":"A" },
	{ "datasource":{"type":"prometheus","uid":"ds-prometheus"},"editorMode":"code","exemplar":false,"expr":"max by (ins) (pg_activity_max_tx_duration{cls=\"$cls\", ins!=\"$primary\", state=\"active\"})","hide":false,"interval":"","legendFormat":"{{ ins }}" ,"range":true,"refId":"B" }
	],
	"title":"SAGE",

But grouped by state in pgsql-xacts.json:

pigsty/files/grafana/pgsql/pgsql-xacts.json

Lines 463 to 464 in 4a084c3

	"targets":[{"exemplar":false,"expr":"sum by (state) (pg_activity_max_tx_duration{ins=\"$ins\", state!~\"(idle.*|disabled)\"})","interval":"","legendFormat":"{{ state }}","refId":"A"}],
	"title":"SAGE",

What does SAGE mean? Slowest Active (transaction) aGE?

[Vonng]

Good question, it's actually SAGA, long lived transactions, LLTs: https://www.cs.cornell.edu/andru/cs711/2002fa/reading/sagas.pdf

[Vonng]

To avoid confuse, rename SAGE to Long Lived Xact.