pgtop - PostgreSQL performance monitoring tool akin to top

Property Value
Distribution Ubuntu 19.04 (Disco Dingo)
Repository Ubuntu Universe amd64
Package filename pgtop_3.7.0-18-gbbf1f12-3_amd64.deb
Package name pgtop
Package version 3.7.0
Package release 18-gbbf1f12-3
Package architecture amd64
Package type deb
Category universe/misc
License -
Maintainer Ubuntu Developers <>
Download size 51.48 KB
Installed size 136.00 KB
pg_top is a console-based tool for monitoring a PostgreSQL database.
With pg_top you can:
* View currently running SQL statement of a process
* View query plan of a currently running SELECT statement
* View locks held by a process
* View user table statistics
* View user index statistics


Package Version Architecture Repository
pgtop_3.7.0-18-gbbf1f12-3_i386.deb 3.7.0 i386 Ubuntu Universe
pgtop - - -


Name Value
libc6 >= 2.14
libpq5 -
libtinfo6 >= 6


Name Value
ptop << 3.7.0-1~


Type URL
Binary Package pgtop_3.7.0-18-gbbf1f12-3_amd64.deb
Source Package pgtop

Install Howto

  1. Update the package index:
    # sudo apt-get update
  2. Install pgtop deb package:
    # sudo apt-get install pgtop




2019-02-07 - Christoph Berg <>
pgtop (3.7.0-18-gbbf1f12-3) unstable; urgency=medium
* Move back to Architecture: linux-any, pgtop needs actual porting to other
* Update PostgreSQL Maintainers address.
2018-05-03 - Christoph Berg <>
pgtop (3.7.0-18-gbbf1f12-2) unstable; urgency=medium
* Architecture: any. The problem with non-linux was just outdated autotools
files. (Closes: #675756)
2018-05-03 - Christoph Berg <>
pgtop (3.7.0-18-gbbf1f12-1) unstable; urgency=medium
* New upstream snapshot.
* Moving package to PostgreSQL team. (Closes: #896693)
* Update to DH 10 for automatic autotools updating.
* Strip debian/rules down to "dh".
* Remove old transitional package ptop. (Closes: #878778)
* Section: database.
* Don't install HISTORY, it is already installed as changelog.gz.
* Update copyright.
2014-02-23 - Bastiaan Franciscus van den Dikkenberg <>
pgtop (3.7.0-2) unstable; urgency=low
* debian/control: changed Architecture from any to linux-any
since pgtop does not run on kfreebsd-* or hurd-i386
* debian/control: Updated VCS URLs in control file to
pgtop instead of ptop
* debian/control: added build dependency to dh-autoreconf
* debian/rules: Fixed W-dpkg-buildflags-missing by adding CPPflags
* debian/rules: Minimized rules file
* debian/rules: using dh_autoreconf in build
* debian/dirs: Renamed dirs to pgtop.dirs so no unneeded directory's
are created for the transitional dummy package
2014-01-07 - Bastiaan Franciscus van den Dikkenberg <>
pgtop (3.7.0-1) unstable; urgency=low
* New upstream release
- ptop is now called pg_top - rename package to pgtop
- ptop is incompatible with PostgreSQL >= 9.2 (closes: #718697)
- removed patches becouse they are now in new upstream release
* debian/control: Provide transitional dummy package
* debian.control: Changed Standards-Version to 3.9.5
* debian/control: Updated VCS urls in control file to instead of
* debian/control: Changed dependency of debhelper to <= 9
* debian/compat: Changed Debhelper compatibility level to 9
* debian/copyright: updated, reformatted to DEP5 format
* debian/watch: update watch file to ignore alpha en beta versions
* Special thanks to Willi Mann <> for helping to get
this package back up to specs
2012-02-04 - Bastiaan Franciscus van den Dikkenberg <>
ptop (3.6.2-5) unstable; urgency=low
* Applyed patch (closes: #594077)
* Adopted packages Bug-Debian: (closes: #654552)
* fixed lintian warnings
* Changed Standards-Version to 3.9.2
* Closes request for sponsorshop Bug-Debian: (closes: #658775)
2010-12-24 - Francois Marier <>
ptop (3.6.2-4) unstable; urgency=low
* Merge with Ubuntu
- Fix FTBFS with ld --as-needed. (closes: #607811)
2010-12-22 - Francois Marier <>
ptop (3.6.2-3) unstable; urgency=low
* Convert the "Recommends" on posgresql to an "Enhances"
(closes: #600102)
* Bump Standards-Version up to 3.9.1
* Bump debhelper compatibility to 8
* Switch to 3.0 (quilt) source package format
* Fix hyphen in manpage
* Drop reference to BSD in /usr/share/common-licenses
2009-10-01 - Francois Marier <>
ptop (3.6.2-2) unstable; urgency=low
* Adopt orphaned package (closes: #547981)
* Bump Standards-Version up to 3.8.3
* Bump debhelper compatibility to 7
* Fix lintian notice in debian/copyright
* Add git vcs fields to debian/control

See Also

Package Description
pgxnclient_1.2.1-6_all.deb command line client for the PostgreSQL Extension Network
phalanx_22+d051004-14_amd64.deb Chess playing program
phamm-ldap-amavis_0.6.5-1ubuntu1_all.deb PHP front-end to manage virtual services on LDAP - back-end files
phamm-ldap-vacation_0.6.5-1ubuntu1_all.deb PHP front-end to manage virtual services on LDAP - back-end files
phamm-ldap_0.6.5-1ubuntu1_all.deb PHP front-end to manage virtual services on LDAP - back-end files
phamm_0.6.5-1ubuntu1_all.deb PHP front-end to manage virtual services on LDAP - main package
phantomjs_2.1.1+dfsg-2_amd64.deb minimalistic headless WebKit-based browser with JavaScript API
phasex_0.14.97-3_amd64.deb Phase Harmonic Advanced Synthesis EXperiment
phast_1.5+dfsg-1_amd64.deb phylogenetic analysis with space/time models
phenny_2~hg28-3_all.deb extensible IRC bot written in Python
phing_2.16.1-1_all.deb PHP5 project build system based on Apache Ant
phipack_0.0.20160614-3_amd64.deb PHI test and other tests of recombination
phlipple-data_0.8.5-4build1_all.deb reduce 3D shapes to a single square - game data
phlipple_0.8.5-4build1_amd64.deb reduce 3D shapes to a single square
phnxdeco_0.33-3build1_amd64.deb Decompress flashfiles equipped with a PHOENIX BIOS