Re: pg_stat_activity doubts
| От | Phil Frost |
|---|---|
| Тема | Re: pg_stat_activity doubts |
| Дата | |
| Msg-id | CAC6ry0LFHv+eMjpde_3jqfSnG9hg2O6s=9VTwLh2jiYydXSqGg@mail.gmail.com обсуждение исходный текст |
| Ответ на | pg_stat_activity doubts (Debraj Manna <subharaj.manna@gmail.com>) |
| Список | pgsql-admin |
On Thu, Mar 22, 2018 at 8:46 AM Debraj Manna <subharaj.manna@gmail.com> wrote:
- Can some let me know what does the state IDLE denotes in the row of pg_stat_activity? Is it like it checks all the open connections to postgres and if the connection is not executing any query then IDLE denotes the last query executed by the connection?
- In the output of select * from pg_stat_activity I am seeing rows with state IDLE and the query_start_date more than 2 days old? What does this signify ? Should I be worried about this?
Each row in pg_stat_activity represents an established connection to the server from a client. "idle" means the client is not currently executing a query nor in a transaction.
If query_start_date is 2 days old, that just means the last query to be executed on that connection was two days ago.
Not really a reason for worry, unless you have so many connections open that it's consuming more RAM than you can afford. It's generally desirable for a connection pool to have a few idle connections so queries don't suffer the latency of establishing a new connection.
В списке pgsql-admin по дате отправления: