pg_stat_activity doubts
| От | Debraj Manna |
|---|---|
| Тема | pg_stat_activity doubts |
| Дата | |
| Msg-id | CAF6DVKPf6-d3mn7t+N2bvHTB_zi2hWrDOL83FFj8xPrRWiXDqg@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: pg_stat_activity doubts
Re: pg_stat_activity doubts |
| Список | pgsql-admin |
Hi
Can someone resolve my below doubts about pg_stat_activity :-
- Can someone let me know how pg_stat_activity is populated? If I am executing a query like `Select * from pg_stat_activity` does it produce the details from some snapshot maintained by postgres or it checks the current connections open in postgres to provide the details?
- 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?
В списке pgsql-admin по дате отправления: