Search PostgreSQL documentation

pg_stat_database.sessionsStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseTotal number of sessions established to this database pg_stat_database SELECT sessions FROM pg_catalog.pg_stat_database; View pg_stat_database Field sessions SQL type bigint Units named in … pg_stat_database.sessions_abandonedStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of database sessions to this database that were terminated because connection to the client was lost pg_stat_database SELECT sessions_abandoned FROM pg_catalog.pg_stat_database; View… pg_stat_database.sessions_fatalStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of database sessions to this database that were terminated by fatal errors pg_stat_database SELECT sessions_fatal FROM pg_catalog.pg_stat_database; View pg_stat_database Field sessio… pg_stat_database.sessions_killedStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of database sessions to this database that were terminated by operator intervention pg_stat_database SELECT sessions_killed FROM pg_catalog.pg_stat_database; View pg_stat_database Fi… pg_stat_database.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseTime at which these statistics were last reset pg_stat_database SELECT stats_reset FROM pg_catalog.pg_stat_database; View pg_stat_database Field stats_reset SQL type timestamp with time zon… pg_stat_database.temp_bytesStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseTotal amount of data written to temporary files by queries in this database. All temporary files are counted, regardless of why the temporary file was created, and regardless of the log_temp… pg_stat_database.temp_filesStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of temporary files created by queries in this database. All temporary files are counted, regardless of why the temporary file was created (e.g., sorting or hashing), and regardless of… pg_stat_database.tup_deletedStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of rows deleted by queries in this database pg_stat_database SELECT tup_deleted FROM pg_catalog.pg_stat_database; View pg_stat_database Field tup_deleted SQL type bigint Units named … pg_stat_database.tup_fetchedStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of live rows fetched by index scans in this database pg_stat_database Number of rows fetched by queries in this database SELECT tup_fetched FROM pg_catalog.pg_stat_database; View pg_… pg_stat_database.tup_insertedStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of rows inserted by queries in this database pg_stat_database SELECT tup_inserted FROM pg_catalog.pg_stat_database; View pg_stat_database Field tup_inserted SQL type bigint Units nam… pg_stat_database.tup_returnedStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of live rows fetched by sequential scans and index entries returned by index scans in this database pg_stat_database Number of rows returned by queries in this database SELECT tup_re… pg_stat_database.tup_updatedStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of rows updated by queries in this database pg_stat_database SELECT tup_updated FROM pg_catalog.pg_stat_database; View pg_stat_database Field tup_updated SQL type bigint Units named … pg_stat_database.xact_commitStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of transactions in this database that have been committed pg_stat_database SELECT xact_commit FROM pg_catalog.pg_stat_database; View pg_stat_database Field xact_commit SQL type bigin… pg_stat_database.xact_rollbackStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of transactions in this database that have been rolled back pg_stat_database SELECT xact_rollback FROM pg_catalog.pg_stat_database; View pg_stat_database Field xact_rollback SQL type… pg_stat_database_conflicts.confl_active_logicalslotStatistics & MetricsWikiStatistics & Metrics · pg_stat_database_conflictsNumber of uses of logical slots in this database that have been canceled due to old snapshots or too low a wal_level on the primary pg_stat_database_conflicts SELECT confl_active_logicalslo… pg_stat_database_conflicts.confl_bufferpinStatistics & MetricsWikiStatistics & Metrics · pg_stat_database_conflictsNumber of queries in this database that have been canceled due to pinned buffers pg_stat_database_conflicts SELECT confl_bufferpin FROM pg_catalog.pg_stat_database_conflicts; View pg_stat_d… pg_stat_database_conflicts.confl_deadlockStatistics & MetricsWikiStatistics & Metrics · pg_stat_database_conflictsNumber of queries in this database that have been canceled due to deadlocks pg_stat_database_conflicts SELECT confl_deadlock FROM pg_catalog.pg_stat_database_conflicts; View pg_stat_databas… pg_stat_database_conflicts.confl_lockStatistics & MetricsWikiStatistics & Metrics · pg_stat_database_conflictsNumber of queries in this database that have been canceled due to lock timeouts pg_stat_database_conflicts SELECT confl_lock FROM pg_catalog.pg_stat_database_conflicts; View pg_stat_databas… pg_stat_database_conflicts.confl_snapshotStatistics & MetricsWikiStatistics & Metrics · pg_stat_database_conflictsNumber of queries in this database that have been canceled due to old snapshots pg_stat_database_conflicts SELECT confl_snapshot FROM pg_catalog.pg_stat_database_conflicts; View pg_stat_dat… pg_stat_database_conflicts.confl_tablespaceStatistics & MetricsWikiStatistics & Metrics · pg_stat_database_conflictsNumber of queries in this database that have been canceled due to dropped tablespaces pg_stat_database_conflicts SELECT confl_tablespace FROM pg_catalog.pg_stat_database_conflicts; View pg_… pg_stat_database_conflicts.datidStatistics & MetricsWikiStatistics & Metrics · pg_stat_database_conflictsOID of a database pg_stat_database_conflicts SELECT datid FROM pg_catalog.pg_stat_database_conflicts; View pg_stat_database_conflicts Field datid SQL type oid Units named in the field defin… pg_stat_database_conflicts.datnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_database_conflictsName of this database pg_stat_database_conflicts SELECT datname FROM pg_catalog.pg_stat_database_conflicts; View pg_stat_database_conflicts Field datname SQL type name Units named in the fi… pg_stat_database_conflicts.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_database_conflictsTime at which these statistics were last reset pg_stat_database_conflicts SELECT stats_reset FROM pg_catalog.pg_stat_database_conflicts; View pg_stat_database_conflicts Field stats_reset SQ… pg_stat_gssapi.credentials_delegatedStatistics & MetricsWikiStatistics & Metrics · pg_stat_gssapiTrue if GSSAPI credentials were delegated on this connection. pg_stat_gssapi SELECT credentials_delegated FROM pg_catalog.pg_stat_gssapi; View pg_stat_gssapi Field credentials_delegated SQL… pg_stat_gssapi.encryptedStatistics & MetricsWikiStatistics & Metrics · pg_stat_gssapiTrue if GSSAPI encryption is in use on this connection pg_stat_gssapi SELECT encrypted FROM pg_catalog.pg_stat_gssapi; View pg_stat_gssapi Field encrypted SQL type boolean Units named in th… pg_stat_gssapi.gss_authenticatedStatistics & MetricsWikiStatistics & Metrics · pg_stat_gssapiTrue if GSSAPI authentication was used for this connection pg_stat_gssapi SELECT gss_authenticated FROM pg_catalog.pg_stat_gssapi; View pg_stat_gssapi Field gss_authenticated SQL type boole… pg_stat_gssapi.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_gssapiProcess ID of a backend pg_stat_gssapi SELECT pid FROM pg_catalog.pg_stat_gssapi; View pg_stat_gssapi Field pid SQL type integer Units named in the field definition Not specified Reset obse… pg_stat_gssapi.principalStatistics & MetricsWikiStatistics & Metrics · pg_stat_gssapiPrincipal used to authenticate this connection, or NULL if GSSAPI was not used to authenticate this connection. This field is truncated if the principal is longer than NAMEDATALEN (64 charac… pg_stat_io.backend_typeStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioType of backend (e.g. background worker, autovacuum worker). See pg_stat_activity for more information on backend_types. Some backend_types do not accumulate I/O operation statistics and wil… pg_stat_io.contextStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioThe context of an I/O operation. Possible values are: normal: The default or standard context for a type of I/O operation. For example, by default, relation data is read into and written ou… pg_stat_io.evictionsStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioNumber of times a block has been written out from a shared or local buffer in order to make it available for another use. In context normal, this counts the number of times a block was evic… pg_stat_io.extend_bytesStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioThe total size of relation extend operations in bytes. pg_stat_io SELECT extend_bytes FROM pg_catalog.pg_stat_io; View pg_stat_io Field extend_bytes SQL type numeric Units named in the fiel… pg_stat_io.extend_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioTime spent waiting for extend operations in milliseconds. (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero) pg_st… pg_stat_io.extendsStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioNumber of relation extend operations. pg_stat_io Number of relation extend operations, each of the size specified in op_bytes. SELECT extends FROM pg_catalog.pg_stat_io; View pg_stat_io Fie… pg_stat_io.fsync_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioTime spent waiting for fsync operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero) pg_stat… pg_stat_io.fsyncsStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioNumber of fsync calls. These are only tracked in context normal. pg_stat_io SELECT fsyncs FROM pg_catalog.pg_stat_io; View pg_stat_io Field fsyncs SQL type bigint Units named in the field d… pg_stat_io.hitsStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioThe number of times a desired block was found in a shared buffer. pg_stat_io SELECT hits FROM pg_catalog.pg_stat_io; View pg_stat_io Field hits SQL type bigint Units named in the field defi… pg_stat_io.objectStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioTarget object of an I/O operation. Possible values are: relation: Permanent relations. temp relation: Temporary relations. wal: Write Ahead Logs. pg_stat_io Target object of an I/O operati… pg_stat_io.op_bytesStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioThe number of bytes per unit of I/O read, written, or extended. Relation data reads, writes, and extends are done in block_size units, derived from the build-time parameter BLCKSZ, which is… pg_stat_io.read_bytesStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioThe total size of read operations in bytes. pg_stat_io SELECT read_bytes FROM pg_catalog.pg_stat_io; View pg_stat_io Field read_bytes SQL type numeric Units named in the field definition by…