Azure Database for PostgreSQL flexible server having high CPU utilization
Ext Timlin Petri
10
Reputation points
Hi, I am having a Azure Database for PostgreSQL flexible server instance and it's cpu utilization was suddenly increasing. This increase was happen after table trigger (before insert) creation. Trigger was tested shortly and after test it was dropped. Not really knowing was this action causing cpu increase but it still in higher level than it was before trigger creation. I can see in the server logs that following lines:
2024-02-29 08:00:07 UTC-65e0397f.5abe-user=azuresu,db=azure_maintenance,session=65e0397f.5abe,sess_time=2024-02-29 07:59:59 UTCLOG: execute _p3: create table if not exists public.lsnmover (single_row_id bool default true, id bigint, update_time timestamp default now(), constraint ensure_one_row CHECK (single_row_id), constraint lsnmover_pk primary key (single_row_id))
2024-02-29 08:00:07 UTC-65e0397f.5abe-user=azuresu,db=azure_maintenance,session=65e0397f.5abe,sess_time=2024-02-29 07:59:59 UTCLOG: execute _p5: insert into public.lsnmover (id, update_time) select 1, now() on conflict on constraint lsnmover_pk do update set id = public.lsnmover.id+1, update_time=now()
are happening 426 times during one hour. Is any clue what is reason for these actions and why cpu load is increased? Br, Petri
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,427 questions
Sign in to answer