linux - What is postgresql select process?

Question

we are using postgresql for our application. after a time, idle CPU was less than 20%. we understood select and idle process caused it, but we don't understand what does mean select process. can anyone help we?

question from:https://stackoverflow.com/questions/65856086/what-is-postgresql-select-process

Answer 1

PostgreSQL updates the process title to give a clue about what that backend is doing. "SELECT" means it is currently working on an SQL SELECT statement. If you want the details, log into PostgreSQL and look into the pg_stat_activity view.

The ones that are "idle" should not be consuming CPU at that moment. The fact that they show up in top suggests that they have not been idle for long, but rather are rapidly cycling between some other state (probably SELECT) and idle.