You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Since PG15, the pg_stat_user_tables includes partitioned tables (relkind 'p'). The age(relfrozenxid) of this tables is always 2147483647, which results in a red-flagged "Max. table FREEZE age" in Health check dashboard. It would make sense to exclude partitioned tables from this metric, as it conceales real data metrics. The partitions each act as a normal table (relkind 'r') and are properly monitored.
Same behavior is noticed with PgWatch2 V1.10.0 and PgWatch2-postgres V1.12.0, even after updating metric definitions.
PG14:
select s.relname, relkind, age(relfrozenxid) from pg_class p , pg_stat_user_tables s where p.relname=s.relname and s.relname like 'analytics_cycle_analytics_issue%' order by age(relfrozenxid) desc, s.relname;
relname | relkind | age
-------------------------------------------------+---------+------------
analytics_cycle_analytics_issue_stage_events_00 | r | 321
analytics_cycle_analytics_issue_stage_events_01 | r | 321
analytics_cycle_analytics_issue_stage_events_02 | r | 321
PG15:
select s.relname, relkind, age(relfrozenxid) from pg_class p , pg_stat_user_tables s where p.relname=s.relname and s.relname like 'analytics_cycle_analytics_issue%' order by age(relfrozenxid) desc, s.relname;
relname | relkind | age
-------------------------------------------------+---------+------------
analytics_cycle_analytics_issue_stage_events | p | 2147483647
analytics_cycle_analytics_issue_stage_events_00 | r | 321
analytics_cycle_analytics_issue_stage_events_01 | r | 321
analytics_cycle_analytics_issue_stage_events_02 | r | 321
The text was updated successfully, but these errors were encountered:
Since PG15, the pg_stat_user_tables includes partitioned tables (relkind 'p'). The age(relfrozenxid) of this tables is always 2147483647, which results in a red-flagged "Max. table FREEZE age" in Health check dashboard. It would make sense to exclude partitioned tables from this metric, as it conceales real data metrics. The partitions each act as a normal table (relkind 'r') and are properly monitored.
Same behavior is noticed with PgWatch2 V1.10.0 and PgWatch2-postgres V1.12.0, even after updating metric definitions.
PG14:
select s.relname, relkind, age(relfrozenxid) from pg_class p , pg_stat_user_tables s where p.relname=s.relname and s.relname like 'analytics_cycle_analytics_issue%' order by age(relfrozenxid) desc, s.relname;
relname | relkind | age
-------------------------------------------------+---------+------------
analytics_cycle_analytics_issue_stage_events_00 | r | 321
analytics_cycle_analytics_issue_stage_events_01 | r | 321
analytics_cycle_analytics_issue_stage_events_02 | r | 321
PG15:
select s.relname, relkind, age(relfrozenxid) from pg_class p , pg_stat_user_tables s where p.relname=s.relname and s.relname like 'analytics_cycle_analytics_issue%' order by age(relfrozenxid) desc, s.relname;
relname | relkind | age
-------------------------------------------------+---------+------------
analytics_cycle_analytics_issue_stage_events | p | 2147483647
analytics_cycle_analytics_issue_stage_events_00 | r | 321
analytics_cycle_analytics_issue_stage_events_01 | r | 321
analytics_cycle_analytics_issue_stage_events_02 | r | 321
The text was updated successfully, but these errors were encountered: