Re: RFC: pg_stat_logmsg

On 6/30/23 23:20, Pavel Stehule wrote:
> so 1. 7. 2023 v 1:57 odesílatel Joe Conway <mail(at)joeconway(dot)com
> <mailto:mail(at)joeconway(dot)com>> napsal:
> Part of the thinking is that people with fleets of postgres instances
> can use this to scan for various errors that they care about.
> Additionally it would be useful to look for "should not happen" errors.
>
> I will register this in the July CF and will appreciate feedback.
>
> This can be a very interesting feature. I like it.

Thanks!

FWIW, I just modified it to provide the localized text of the elevel
rather than the internal number. I also localized the message format string:

8<------------------------------
psql (16beta2)
Type "help" for help.

test=# \x
Expanded display is on.
test=# select * from pg_stat_logmsg where elevel = 'ERROR' and
sqlerrcode = 'XX000' and count > 1;
-[ RECORD 1 ]---------------------------------------------
filename | tablecmds.c
lineno | 10908
elevel | ERROR
funcname | ATExecAlterConstraint
sqlerrcode | XX000
message | cannot alter constraint "%s" on relation "%s"
count | 2
-[ RECORD 2 ]---------------------------------------------
filename | user.c
lineno | 2130
elevel | ERROR
funcname | check_role_membership_authorization
sqlerrcode | XX000
message | role "%s" cannot have explicit members
count | 2

test=# set lc_messages ='sv_SE.UTF8';
SET
test=# select * from pg_stat_logmsg where elevel = 'FEL' and sqlerrcode
= 'XX000' and count > 1;
-[ RECORD 1 ]---------------------------------------------
filename | tablecmds.c
lineno | 10908
elevel | FEL
funcname | ATExecAlterConstraint
sqlerrcode | XX000
message | kan inte ändra villkoret "%s" i relation "%s"
count | 2
-[ RECORD 2 ]---------------------------------------------
filename | user.c
lineno | 2130
elevel | FEL
funcname | check_role_membership_authorization
sqlerrcode | XX000
message | rollen "%s" kan inte ha explicita medlemmar
count | 2
8<------------------------------

New tarball attached.

--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com