Top AI Repos — open-source AI, indexed and scored
Top AI Repos tracks AI repositories on GitHub and answers two different questions about each one: is it moving right now, and would you bet a product on it.
Top AI Repos tracks AI repositories on GitHub and answers two different questions about each one: is it moving right now, and would you bet a product on it.
pg_activity is a top like application for PostgreSQL server activity monitoring.
| Date | Stars |
|---|---|
| 2026-07-24 | 3033 |
| 2026-07-25 | 3033 |
| 2026-07-28 | 3033 |
| 2026-07-30 | 3033 |
| 2026-08-06 | 3033 |
Today
— stars today
This week
— stars this week
This month
— stars this month
Momentum
15.0
growth rate 0.00%/day
Command line tool for PostgreSQL server activity monitoring.
[](https://pypi.python.org/pypi/pg_activity)
[](https://github.com/dalibo/pg_activity/actions/workflows/lint.yml)
[](https://github.com/dalibo/pg_activity/actions/workflows/tests.yml)
# Installation
## From distribution packages
The simplest way to install pg\_activity is through the package manager of your
Linux distribution, if it ships with a package. E.g., on Debian-based
distributions (e.g. Debian, Ubuntu, Mint...):
$ sudo apt install pg-activity
(on Debian bullseye, the current stable version, a backport is available: `apt
install pg-activity/bullseye-backports`).
The PostgreSQL Global Development Group (PGDG) also provides packages for
RPM-based (https://yum.postgresql.org/) and Debian-based distributions
(https://wiki.postgresql.org/wiki/Apt).
**Note:** distribution packages may not be up to date with the latest
pg\_activity releases. Before submitting a bug report here:
- check the package version, compare that to our latest release and then
review the [change log][changelog] to see if the bug has been fixed;
- if the issue is about packaging, e.g. missing dependencies, reach out
the package maintainer (or PGDG) first.
## From PyPI
pg\_activity can be installed using pip along with psycopg:
$ python3 -m pip install "pg_activity[psycopg]"
Alternatively, [pipx](https://pypi.org/project/pipx/) can be used to install
and run pg\_activity in an isolated environment:
$ pipx install "pg_activity[psycopg]"
In case your `$PATH` does not already contain it, the full path is:
$ ~/.local/bin/pg_activity
## From source, using git
This is only necessary to test development versions. First, clone the repository:
$ git clone https://github.com/dalibo/pg_activity.git
Change the branch if necessary. Then create a dedicated environment,
and install pg\_activity with the psycopg database driver:
$ cd pg_activity
$ python3 -m venv .venv
$ . .venv/bin/activate
(.venv) $ pip install ".[psycopg]"
(.venv) $ pg_activity
To quit this env and destroy it:
$ deactivate
$ rm -r .venv
# Usage
`pg_activity` works locally or remotely. In local execution context, to obtain
sufficient rights to display system information, the system user running
`pg_activity` must be the same user running postgresql server (`postgres` by
default), or have more rights like `root`. The PostgreSQL user used to connect
to the database must be super-user in order to get as much data as possible.
Otherwise, `pg_activity` can fall back to a degraded mode where some data like
system information or temporary file data are not displayed.
ex:
sudo -u postgres pg_activity -U postgres
## Options
pg_activity [options] [connection string]
Configuration:
-P, --profile PROFILE
Configuration profile matching a PROFILE.conf file in
${XDG_CONFIG_HOME:~/.config}/pg_activity/ or
/etc/pg_activity/, or a built-in profile.
Options:
--blocksize BLOCKSIZE
Filesystem blocksize (default: 4096).
--rds Enable support for AWS RDS (implies --no-tempfiles and
filters out the rdsadmin database from space
calculation).
--output FILEPATH Store running queries as CSV.
--db-size, --no-db-size
Enable/disable total size of DB.
--tempfiles, --no-tempfiles
Excerpt of 17,190 characters
Read on GitHub
Denis Laxalde · France
646
Julien Tachoires
179
100
18
Fabrízio de Royes Mello · Senior Software Engineer · Brazil
5
5
5
5
4
Vincent Maugé · United States
4
damien clochard · DALIBO
3
3
2
Ang · Malaysia
2
Julien Rouhaud · @niledatabase
2
2
2
Mikel Olasagasti Uranga
2
Nick LaMuro · Mongolia
2
SEINLET Nicolas · OpenERP s.a. · Belgium
2
Would you bet a product on this? Bounded 0–100 and slow moving.
matched fp:a05e25a29e4c1aed, topic:monitoring