--- 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,22 @@ +pg-stat-kcache (2.1.1-3.pgdg+1) sid-pgdg; urgency=medium + + * Rebuild for sid-pgdg. + * No source changes. + + -- PostgreSQL on Debian and Ubuntu Tue, 29 Oct 2019 13:48:37 +0100 + +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 @@ -48,3 +48,22 @@ meaningful metrics returned by getrusage(2). All those counters are aggregated per postgres role, database and normalized query identifier. +Package: postgresql-11-pg-stat-kcache +Architecture: any +Depends: ${misc:Depends}, ${shlibs:Depends}, postgresql-11, + postgresql-contrib-11 +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-12-pg-stat-kcache +Architecture: any +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. --- 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-9.4, postgresql-contrib-9.5, postgresql-contrib-9.6, postgresql-contrib-10, postgresql-contrib-11, 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 {