pg_stat_database.session_time

Description

Time spent by database sessions in this database, in milliseconds (note that statistics are only updated when the state of a session changes, so if sessions have been idle for a long time, this idle time won't be included)

View

pg_stat_database

Field

session_time

SQL type

double precision

Units named in the field definition

milliseconds

Reset observation

Time at which these statistics were last reset

Usage

SELECT session_time FROM pg_catalog.pg_stat_database;

View semantics

The pg_stat_database view will contain one row for each database in the cluster, plus one for shared objects, showing database-wide statistics.

Collection and reset context

Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name.

Inspect this field

Example query; no execution result or measured value is asserted.

SELECT session_time FROM pg_catalog.pg_stat_database;

Related entries

• pg_stat_database columns
• Statistics collection and reset functions

Documentation and source

• PostgreSQL 18 English manual

Compare versions

PostgreSQL 13 → 14: added.

--- PostgreSQL 13
+++ PostgreSQL 14
@@ -1 +1,8 @@
-Not recorded in this version
+{
+  "field": "session_time",
+  "sql_type": "double precision",
+  "units_mentioned": [
+    "milliseconds"
+  ],
+  "view": "pg_stat_database"
+}

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

• pg_stat_database.active_time
• pg_stat_database.blk_read_time
• pg_stat_database.blk_write_time
• pg_stat_database.blks_hit
• pg_stat_database.blks_read
• pg_stat_database.checksum_failures
• pg_stat_database.checksum_last_failure
• pg_stat_database.conflicts
• pg_stat_database.datid
• pg_stat_database.datname
• pg_stat_database.deadlocks
• pg_stat_database.idle_in_transaction_time