Empty processes in the queue - Postgresql

Asked

Viewed 42 times

0

Hello.

This week we started to have a problem of empty processes in the Postgresql queue, but unlike other processes, these are locked. This is causing quite slowness in the system.

inserir a descrição da imagem aqui

I would like to know what these processes are about and whether there is any way to ensure that this happens.

Thank you.

postgresql process

1 answer

1

Those empty cases may be operations carried out from a ROLE other than the one used to make your query. That is, you do not have privileges to view the operations performed by others users of the system.

The suggestion is to use a ROLE superuser to do this kind of query, which will give you full power to know what is happening.

  • I’ll see and warn you.

Browser other questions tagged postgresql process

You are not signed in. Login or sign up in order to post.