From b4b8efbd3826ac0af2d1c2e7c40fcf80a4bfba45 Mon Sep 17 00:00:00 2001
From: Daniel Baumann
+
PostgreSQL's cumulative statistics
system supports collection and reporting of information about
server activity. Presently, accesses to tables and indexes in both
@@ -516,7 +516,8 @@
replication to reach durable storage.
Returns the time when the backend's current transaction was started.
- 28.2. The Cumulative Statistics System
pg_stat_activity
pg_stat_replication
pg_stat_replication_slots
pg_stat_wal_receiver
pg_stat_recovery_prefetch
pg_stat_subscription
pg_stat_subscription_stats
pg_stat_ssl
pg_stat_gssapi
pg_stat_archiver
pg_stat_bgwriter
pg_stat_wal
pg_stat_database
pg_stat_database_conflicts
pg_stat_all_tables
pg_stat_all_indexes
pg_statio_all_tables
pg_statio_all_indexes
pg_statio_all_sequences
pg_stat_user_functions
pg_stat_slru
28.2. The Cumulative Statistics System
pg_stat_activity
pg_stat_replication
pg_stat_replication_slots
pg_stat_wal_receiver
pg_stat_recovery_prefetch
pg_stat_subscription
pg_stat_subscription_stats
pg_stat_ssl
pg_stat_gssapi
pg_stat_archiver
pg_stat_bgwriter
pg_stat_wal
pg_stat_database
pg_stat_database_conflicts
pg_stat_all_tables
pg_stat_all_indexes
pg_statio_all_tables
pg_statio_all_indexes
pg_statio_all_sequences
pg_stat_user_functions
pg_stat_slru
TimelineHistoryFileWrite
Waiting for a write of a timeline history file received via
streaming replication. TimelineHistoryRead
Waiting for a read of a timeline history file. TimelineHistorySync
Waiting for a newly created timeline history file to reach durable
storage. TimelineHistoryWrite
Waiting for a write of a newly created timeline history
- file. TwophaseFileRead
Waiting for a read of a two phase state file. TwophaseFileSync
Waiting for a two phase state file to reach durable storage. TwophaseFileWrite
Waiting for a write of a two phase state file. VersionFileWrite
Waiting for the version file to be written while creating a database. WALBootstrapSync
Waiting for WAL to reach durable storage during
+ file. TwophaseFileRead
Waiting for a read of a two phase state file. TwophaseFileSync
Waiting for a two phase state file to reach durable storage. TwophaseFileWrite
Waiting for a write of a two phase state file. VersionFileSync
Waiting for the version file to reach durable storage while
+ creating a database. VersionFileWrite
Waiting for the version file to be written while creating a database. WALBootstrapSync
Waiting for WAL to reach durable storage during
bootstrapping. WALBootstrapWrite
Waiting for a write of a WAL page during bootstrapping. WALCopyRead
Waiting for a read when creating a new WAL segment by copying an
existing one. WALCopySync
Waiting for a new WAL segment created by copying an existing one to
reach durable storage. WALCopyWrite
Waiting for a write when creating a new WAL segment by copying an
@@ -2467,4 +2468,4 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS pid,
\ No newline at end of file
+