pg_stat_activity存储postgresql当前连接个数

Posted on 2013-07-30 10:44  JasmineLiu  阅读(2068)  评论(0)    收藏  举报

postgres=# \d pg_stat_activity
视观表 "pg_catalog.pg_stat_activity"
栏位 | 型别 | 修饰词
------------------+--------------------------+--------
datid | oid |
datname | name |
pid | integer |
usesysid | oid |
usename | name |
application_name | text |
client_addr | inet |
client_hostname | text |
client_port | integer |
backend_start | timestamp with time zone |
xact_start | timestamp with time zone |
query_start | timestamp with time zone |
state_change | timestamp with time zone |
waiting | boolean |
state | text |
query | text |

博客园  ©  2004-2025
浙公网安备 33010602011771号 浙ICP备2021040463号-3