安装

其他安装命令

macOS

Homebrew已验证 · 100%

brew install pg_top

local Homebrew formula metadata

Linux

Alpine Linux apk已验证 · 92%

sudo apk add pg_top

Alpine Linux edge package indexes · pg_top · 来源: dl-cdn.alpinelinux.org

Fedora dnf已验证 · 92%

sudo dnf install pg_top

Fedora Rawhide package metadata · pg_top · 来源: dl.fedoraproject.org

Nix已验证 · 92%

nix profile install nixpkgs#pg_top

nixpkgs package indexes · pkgs/by-name/pg/pg_top/package.nix · 来源: api.github.com

openSUSE zypper已验证 · 92%

sudo zypper install pg_top

openSUSE Tumbleweed package metadata · pg_top · 来源: download.opensuse.org

概览

软件包摘要

Monitor PostgreSQL processes

项目链接

命令和别名

pg_top

历史

项目历史与用法

pg_top is an interactive top-like monitor for PostgreSQL processes, queries, locks, I/O, and replication activity.

项目历史

pg_top was derived from Unix top to display PostgreSQL activity in a familiar full-screen terminal interface. The project was originally known as ptop and was renamed pg_top around the 3.6.2 release cycle in 2008.

Development later moved to the current PostgreSQL-community GitLab project. The 4.x line modernized the utility while preserving its core process view and adding views for SQL statements, query plans, locks, per-process I/O, and replication.

采用历史

pg_top became a PostgreSQL community project and is distributed by multiple Unix-like package ecosystems. Its familiar top-style interface makes it useful to database administrators who want interactive process and query inspection without deploying a larger monitoring stack.

使用方式

Administrators run pg_top in a terminal to inspect PostgreSQL processes and active SQL, view query plans and locks, and examine I/O or replication statistics. Monitoring a remote database's operating-system process details requires the pg_proctab extension on the target database.

为什么软件包爱好者会关心

pg_top is part of the Unix tradition of small, interactive observability tools adapted to a particular subsystem. Its lineage from Unix top, long release history, terminal interface, and availability across package managers make it a recognizable PostgreSQL administration utility.

时间线

2008: The project was renamed from ptop to pg_top during the 3.6.2 release cycle.
2013: Version 3.7.0 was released.
2020: Version 4.0.0 was released.
2025: Version 4.1.3 was released.

Related projects

Unix top
PostgreSQL
pg_proctab
pg_systat

来源

安全态势

风险级别：blue

broad file, network, media, or database tool signal.

风险分类器

blue 风险 · 中置信度 · tool

原因

broad file, network, media, or database tool signal

信号

text:sql

安装行为

formula 元数据中未记录 Homebrew post-install 钩子。
Homebrew bottle 元数据适用于 12 个平台目标。
安装时包含 1 个运行时依赖。
构建元数据列出 3 个构建依赖。

建议审查

在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。

可执行文件

已安装的可执行文件

命令	类型	暴露范围	备注
`pg_top`	cli	全局可执行文件

新鲜度

版本和新鲜度

这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。

页面生成时间2026-09-19

管理器版本3.7.0

管理器更新时间2026-09-16

本地数据OK

上游not checked

检测到的最新版本未检测到

https://pg_top.gitlab.io

信息Release/tag comparison is only available for GitHub repositories.https://pg_top.gitlab.ionone 置信度

安装元数据

软件包元数据

软件包键	brew:pg_top
版本	3.7.0
软件包管理器	Homebrew
软件包管理器页面	https://formulae.brew.sh/formula/pg_top
主页	https://pg_top.gitlab.io
上游文档	https://pg_top.gitlab.io
许可证	BSD-3-Clause
源码归档	https://ftp.postgresql.org/pub/projects/pgFoundry/ptop/pg_top/3.7.0/pg_top-3.7.0.tar.bz2
最后更新	2026-09-16T14:00:33Z
Pulse	updated
依赖	libpq
构建依赖	autoconf, automake, libtool
macOS 提供的库	ncurses
Bottle	可用 (于 arm64_big_sur, arm64_linux, arm64_monterey, arm64_sequoia, arm64_sonoma, arm64_tahoe, arm64_ventura, big_sur, monterey, sonoma, ventura, x86_64_linux)
Homebrew post-install	未定义
服务	未声明

注册表事实

源数据库详情

Source Database	Homebrew formula API
Tap	homebrew/core
Full Name	pg_top
Version Scheme	0
Revision	4
Bottle Stable Root URL	https://ghcr.io/v2/homebrew/core
Deprecated	no
Disabled	no
Keg Only	no
URL Keys	stable

源数据库匹配

其他软件包管理器记录

匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。

Nix95%

pg_top

nix profile install nixpkgs#pg_top

normalized package name match
匹配方式：Pg Top

nixpkgs package indexes · api.github.com · nixpkgs package indexes: pkgs/by-name/pg/pg_top/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1

apk95%

pg_top 4.1.3-r0

由仓库数据生成

此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。

Combined YAML source

View the package source record on GitHub.

combined/pg_top.yml

使用的来源

Geiger risk classifier
cross-ecosystem install command graph
curated package history
external package-manager database matches
package relationship graph
package version freshness
package-page enrichment
pkg.so package database
pkgdb category and tag curation

使用 Homebrew, apk, dnf, Nix, zypper 安装 pg_top