pg_stat_activity存储postgresql当前连接个数

Posted on 2013-07-30 10:44  JasmineLiu  阅读(2058)  评论(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 |

Copyright © 2024 JasmineLiu
Powered by .NET 8.0 on Kubernetes