关于PostgreSQL数据库中客户端连接产生的backend进程的解释

前端之家收集整理的这篇文章主要介绍了关于PostgreSQL数据库中客户端连接产生的backend进程的解释前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
  1. [postgres@pgserver ~]$ ps -ef |grep postgres
  2. root 1070 1054 0 18:38 tty1 00:00:00 su - postgres
  3. postgres 1071 1070 0 18:38 tty1 00:00:00 -bash
  4. postgres 1252 1 0 19:09 ? 00:00:00 /usr/local/pgsql/bin/postgres
  5. postgres 1254 1252 0 19:09 ? 00:00:00 postgres: checkpointer process
  6. postgres 1255 1252 0 19:09 ? 00:00:00 postgres: writer process
  7. postgres 1256 1252 0 19:09 ? 00:00:00 postgres: wal writer process
  8. postgres 1257 1252 0 19:09 ? 00:00:00 postgres: autovacuum launcher process
  9. postgres 1258 1252 0 19:09 ? 00:00:00 postgres: stats collector process
  10. postgres 1259 1252 0 19:09 ? 00:00:00 postgres: bgworker: logical replication launcher
  11. root 1521 1489 0 21:39 pts/1 00:00:00 su - postgres
  12. postgres 1522 1521 0 21:39 pts/1 00:00:00 -bash
  13. postgres 1561 1252 0 21:49 ? 00:00:00 postgres: u_nasa db_nasa 192.168.80.1(65137) idle
  14. postgres 1562 1252 0 21:49 ? 00:00:00 postgres: u_nasa db_nasa 192.168.80.1(65138) idle
  15. 固定值postgres: user db 客户端IP(客户端应用程序使用的端口)动作
  16. postgres 1566 1522 0 21:50 pts/1 00:00:00 ps -ef
  17. postgres 1567 1522 0 21:50 pts/1 00:00:00 grep --color=auto postgres
  18. [postgres@pgserver ~]$

参考:https://www.postgresql.org/docs/current/static/monitoring-ps.html

http://www.jb51.cc/article/p-rdseetia-bqt.html

猜你在找的Postgre SQL相关文章