--- pg-stat-kcache-2.1.1.orig/README.rst +++ pg-stat-kcache-2.1.1/README.rst @@ -53,39 +53,39 @@ pg_stat_kcache view ------------------- -+-------------+-------------------+-----------------------------------------------------+ -| Name | Type | Description | -+=============+===================+=====================================================+ -| datname | name | Name of the database | -+-------------+-------------------+-----------------------------------------------------+ -| user_time | double precision | User CPU time used | -+-------------+-------------------+-----------------------------------------------------+ -| system_time | double precision | System CPU time used | -+-------------+-------------------+-----------------------------------------------------+ -| minflts | bigint | Number of page reclaims (soft page faults) | -+-------------+-------------------+-----------------------------------------------------+ -| majflts | bigint | Number of page faults (hard page faults) | -+-------------+-------------------+-----------------------------------------------------+ -| nswaps | bigint | Number of swaps | -+-------------+-------------------+-----------------------------------------------------+ -| reads | bigint | Number of bytes read by the filesystem layer | -+-------------+-------------------+-----------------------------------------------------+ -| reads_blks | bigint | Number of 8K blocks read by the filesystem layer | -+-------------+-------------------+-----------------------------------------------------+ -| writes | bigint | Number of butes written by the filesystem layer | -+-------------+-------------------+-----------------------------------------------------+ -| writes_blks | bigint | Number of 8K blocks written by the filesystem layer | -+-------------+-------------------+-----------------------------------------------------+ -| msgsnds | bigint | Number of IPC messages sent | -+-------------+-------------------+-----------------------------------------------------+ -| msgrcvs | bigint | Number of IPC messages received | -+-------------+-------------------+-----------------------------------------------------+ -| nsignals | bigint | Number of signals received | -+-------------+-------------------+-----------------------------------------------------+ -| nvcsws | bigint | Number of voluntary context switches | -+-------------+-------------------+-----------------------------------------------------+ -| nivcsws | bigint | Number of involuntary context switches | -+-------------+-------------------+-----------------------------------------------------+ ++-------------+-------------------+-------------------------------------------------------------+ +| Name | Type | Description | ++=============+===================+=============================================================+ +| datname | name | Name of the database | ++-------------+-------------------+-------------------------------------------------------------+ +| user_time | double precision | User CPU time used | ++-------------+-------------------+-------------------------------------------------------------+ +| system_time | double precision | System CPU time used | ++-------------+-------------------+-------------------------------------------------------------+ +| minflts | bigint | Number of page reclaims (soft page faults) | ++-------------+-------------------+-------------------------------------------------------------+ +| majflts | bigint | Number of page faults (hard page faults) | ++-------------+-------------------+-------------------------------------------------------------+ +| nswaps | bigint | Number of swaps (unmaintained on GNU/Linux) | ++-------------+-------------------+-------------------------------------------------------------+ +| reads | bigint | Number of bytes read by the filesystem layer | ++-------------+-------------------+-------------------------------------------------------------+ +| reads_blks | bigint | Number of 8K blocks read by the filesystem layer | ++-------------+-------------------+-------------------------------------------------------------+ +| writes | bigint | Number of butes written by the filesystem layer | ++-------------+-------------------+-------------------------------------------------------------+ +| writes_blks | bigint | Number of 8K blocks written by the filesystem layer | ++-------------+-------------------+-------------------------------------------------------------+ +| msgsnds | bigint | Number of IPC messages sent (unmaintained on GNU/Linux) | ++-------------+-------------------+-------------------------------------------------------------+ +| msgrcvs | bigint | Number of IPC messages received (unmaintained on GNU/Linux) | ++-------------+-------------------+-------------------------------------------------------------+ +| nsignals | bigint | Number of signals received (unmaintained on GNU/Linux) | ++-------------+-------------------+-------------------------------------------------------------+ +| nvcsws | bigint | Number of voluntary context switches | ++-------------+-------------------+-------------------------------------------------------------+ +| nivcsws | bigint | Number of involuntary context switches | ++-------------+-------------------+-------------------------------------------------------------+ pg_stat_kcache_detail view -------------------------- --- pg-stat-kcache-2.1.1.orig/debian/changelog +++ pg-stat-kcache-2.1.1/debian/changelog @@ -1,3 +1,15 @@ +pg-stat-kcache (2.1.1-3) unstable; urgency=medium + + * Team upload for PostgreSQL 12. + + -- Christoph Berg Tue, 29 Oct 2019 13:48:37 +0100 + +pg-stat-kcache (2.1.1-2) unstable; urgency=medium + + * Team upload for PostgreSQL 11. + + -- Christoph Berg Fri, 12 Oct 2018 13:17:38 +0200 + pg-stat-kcache (2.1.1-1) unstable; urgency=low * Initial release. --- pg-stat-kcache-2.1.1.orig/debian/control +++ pg-stat-kcache-2.1.1/debian/control @@ -8,43 +8,12 @@ Vcs-Browser: https://github.com/powa-team/pg_stat_kcache Vcs-Git: https://github.com/powa-team/pg_stat_kcache.git -Package: postgresql-9.4-pg-stat-kcache +Package: postgresql-12-pg-stat-kcache Architecture: any -Depends: ${misc:Depends}, ${shlibs:Depends}, postgresql-9.4, - postgresql-contrib-9.4 +Depends: ${misc:Depends}, ${shlibs:Depends}, postgresql-12, + postgresql-contrib-12 Description: PostgreSQL extension to gather per-query kernel statistics. Statistics gathered are reads and writes done out of the operating system cache, user and system CPU usage, context switches and all the other meaningful metrics returned by getrusage(2). All those counters are aggregated per postgres role, database and normalized query identifier. - -Package: postgresql-9.5-pg-stat-kcache -Architecture: any -Depends: ${misc:Depends}, ${shlibs:Depends}, postgresql-9.5, - postgresql-contrib-9.5 -Description: PostgreSQL extension to gather per-query kernel statistics. - Statistics gathered are reads and writes done out of the operating system - cache, user and system CPU usage, context switches and all the other - meaningful metrics returned by getrusage(2). All those counters are - aggregated per postgres role, database and normalized query identifier. - -Package: postgresql-9.6-pg-stat-kcache -Architecture: any -Depends: ${misc:Depends}, ${shlibs:Depends}, postgresql-9.6, - postgresql-contrib-9.6 -Description: PostgreSQL extension to gather per-query kernel statistics. - Statistics gathered are reads and writes done out of the operating system - cache, user and system CPU usage, context switches and all the other - meaningful metrics returned by getrusage(2). All those counters are - aggregated per postgres role, database and normalized query identifier. - -Package: postgresql-10-pg-stat-kcache -Architecture: any -Depends: ${misc:Depends}, ${shlibs:Depends}, postgresql-10, - postgresql-contrib-10 -Description: PostgreSQL extension to gather per-query kernel statistics. - Statistics gathered are reads and writes done out of the operating system - cache, user and system CPU usage, context switches and all the other - meaningful metrics returned by getrusage(2). All those counters are - aggregated per postgres role, database and normalized query identifier. - --- pg-stat-kcache-2.1.1.orig/debian/tests/control +++ pg-stat-kcache-2.1.1/debian/tests/control @@ -1,3 +1,3 @@ -Depends: @, postgresql-contrib-9.4, postgresql-contrib-9.5, postgresql-contrib-9.6, postgresql-contrib-10, postgresql-server-dev-all +Depends: @, postgresql-contrib-12, postgresql-server-dev-all Tests: installcheck Restrictions: allow-stderr --- pg-stat-kcache-2.1.1.orig/pg_stat_kcache.c +++ pg-stat-kcache-2.1.1/pg_stat_kcache.c @@ -89,6 +89,12 @@ * * For platform without getrusage support, we rely on postgres implementation * defined in rusagestub.h, which only supports user and system time. + * + * Note that the following counters are not maintained on GNU/Linux: + * - ru_nswap + * - ru_msgsnd + * - ru_msgrcv + * - ru_nsignals */ typedef struct pgskCounters {