ueberdb_insert_or_update always idle

[wilkis3]

Hi there,

When I get the output of all postgres activities (select * from pg_stat_activity;) the database shows me at any time SELECT ueberdb_insert_or_update($1,$2);.

Full excerpt:

 13531631 | etherpad_fzs               | 2498453 | 13531630 | etherpad_fzs               |                  | 127.0.0.1   |                 |       45712 | 2022-03-28 11:00:43.710786+02 |                               | 2022-03-28 11:33:43.462268+02 | 2022-03-28 11:33:44.036209+02 | Client          | ClientRead          | idle   |             |              | SELECT ueberdb_insert_or_update($1,$2)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | client backend

When I terminate the process, it restarts.

Is this proceed normal?

[rhansen]

I believe that is normal. According to the PostgreSQL docs, if the state column is idle (as it is here), then the query column shows the last query that was executed.