select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Monitoring

pg_sessions

Tracks per-session SQL execution metrics and optional Linux process resource statistics in shared memory.

pgext.cloud · Source code · Documentation · License text · Control file · PGXN

Overview

Packagepg_sessions
Version1.3
RepositoryUnspecified
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableYes
Shared librariespg_sessions
Stars1
Latest commit2016-06-02
Latest release2016-06-02
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

pg_grab_statementRecord detailed SQL statements from successfully committed transactions.
pg_dbwaAnalyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots.
pg_stat_statementstrack planning and execution statistics of all SQL statements executed
pgtelemetryProvides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics.
pgmonitorCollector-friendly metric views and background refresh worker
gbdchecksDatabase health-check functions and views for bloat, locks, query statistics, and privileges.
pg_stat_statements2Track SQL execution statistics using a PostgreSQL 9.4 pg_stat_statements derivative integrated with sql_firewall
pg_monPostgreSQL extension for query monitoring with execution-time histograms and plan information in a shared view
pg_query_statsLightweight shared-memory collector for per-query execution statistics.
pgsamplerExperimental PostgreSQL background worker that collects time-series status and performance metrics.