<row>

<entry><structname>pg_stat_database</><indexterm><primary>pg_stat_database</primary></indexterm></entry>

<entry>One row per database, showing databasewide statistics. See

<entry>One row per database, showing database-wide statistics. See

<xref linkend="pg-stat-database-view"> for more details.

</entry>

</row>

<row>

<entry><structname>pg_stat_database_conflicts</><indexterm><primary>pg_stat_database_conflicts</primary></indexterm></entry>

<entry>

One row per database showing databasewide statistics about

One row per database showing database-wide statistics about

query cancels due to conflict with recovery on standby servers.

Will only contain information on standby servers, since

conflicts do not occur on master servers.

queries that use the same underlying statistics access functions as

these standard views do. These functions are listed in <xref

linkend="monitoring-stats-funcs-table">. The per-database access

functions take a database OID as argument to identify which

functions take a database OID asanargument to identify which

database to report on. The per-table and per-index functions take

a table or index OID. The functions for function-call statistics

take a function OID. (Note that only tables, indexes, and functions

<row>

<entry>datid</entry>

<entry><type>oid</></entry>

<entry>Theoid of the database the backend is connected to.

<entry>TheOID of the database the backend is connected to.

This value can also be returned by directly calling

the <function>pg_stat_get_backend_dbid</function>.</entry>

the <function>pg_stat_get_backend_dbid</function> function.</entry>

</row>

<row>

<entry>datname</entry>

<row>

<entry>datid</entry>

<entry><type>oid</></entry>

<entry>Theoid of the database</entry>

<entry>TheOID of the database</entry>

</row>

<row>

<entry>datname</entry>

<row>

<entry>xact_commit</entry>

<entry><type>bigint</></entry>

<entry>The number of transactions in this database thathas committed.

This value can also be returned by directly calling

<entry>The number of transactions in this database thathave been

committed.This value can also be returned by directly calling

the <function>pg_stat_get_db_xact_commit</function> function.</entry>

</row>

<row>

<entry>xact_rollback</entry>

<entry><type>bigint</></entry>

<entry>The number of transactions in this database thathas rolled back.

This value can also be returned by directly calling

<entry>The number of transactions in this database thathave been

rolled back.This value can also be returned by directly calling

the <function>pg_stat_get_db_xact_rollback</function> function.</entry>

</row>

<row>

<para>

The <structname>pg_stat_database</structname> view will contain one row

for each database in the cluster showing databasewide statistics.

for each database in the cluster showing database-wide statistics.

</para>

<table id="pg-stat-database-conflicts-view" xreflabel="pg_stat_database_conflicts">

<row>

<entry>datid</entry>

<entry><type>oid</></entry>

<entry>Theoid of the database</entry>

<entry>TheOID of the database</entry>

</row>

<row>

<entry>datname</entry>

<para>

The <structname>pg_stat_database_conflicts</structname> view will contain

one row per database showing databasewide statistics about

one row per database showing database-wide statistics about

query cancels due to conflict with recovery on standby servers.

Will only contain information on standby servers, since

conflicts do not occur on master servers.

<row>

<entry>usesysid</entry>

<entry><type>oid</></entry>

<entry>Theoid of the user logged into this WAL sender process</entry>

<entry>TheOID of the user logged into this WAL sender process</entry>

</row>

<row>

<entry>usename</entry>

<entry><type>integer</></entry>

<entry>

The remote TCP port that the client is using for communication

to the, or <symbol>NULL</> if a unix socket is used.

to the, or <symbol>NULL</> if a unix socket is used.

</entry>

</row>

<row>

<row>

<entry>relid</entry>

<entry><type>oid</></entry>

<entry>The OID of the table this row</entry>

<entry>The OID of the table</entry>

</row>

<row>

<entry>schemaname</entry>