kazwolfe
PROOP
a month ago
For whatever reason, I cannot load the stats view in the Dashboard. My PG database is running just fine and I'm not noticing any issues, but this seems like a strange edge case. I have not tried restarting the DB host yet since this isn't necessarily worth downtime.
Attachments
2 Replies
Stats are enabled, as is PITR. Non-HA.
Attachments
Full logs:
2026-06-02 01:40:16.587 UTC [861488] ERROR: invalid byte sequence for encoding "UTF8": 0x00
2026-06-02 01:40:16.587 UTC [861488] STATEMENT: /* railway:dataui */ SET statement_timeout = '30s'; /* railway:dataui */ SELECT encode(convert_to(row_to_json(data)::text, 'UTF-8'), 'hex') as json FROM (SELECT (SELECT json_agg(t) FROM (SELECT REPLACE(REPLACE(query, E'\n', ' '), E'\r', ' ') as query, calls, ROUND(total_exec_time::numeric, 2) as total_time, ROUND(mean_exec_time::numeric, 2) as mean_time, ROUND(max_exec_time::numeric, 2) as max_time, rows FROM pg_stat_statements s JOIN pg_database d ON s.dbid = d.oid WHERE d.datname = current_database() AND left(query, 21) != '/* railway:dataui */' AND query != 'SELECT pg_is_in_recovery()' ORDER BY total_exec_time DESC LIMIT 20) t) as queries, (SELECT stats_reset::text FROM pg_stat_statements_info LIMIT 1) as stats_reset) data