From ddfc2d9a3705d246c7f262d1f3745d2cf64da1bd Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Sat, 25 Feb 2012 15:21:04 +0100 Subject: [PATCH] Merge the list of statistics functions into the view documentation Most people won't read them individually anyway, it's an easy way to find them, and it's a lot of duplicated information if they are kept in two different places. --- doc/src/sgml/monitoring.sgml | 940 ++++++++--------------------------- 1 file changed, 217 insertions(+), 723 deletions(-) diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index ffad77f04f..3cc5d4df00 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -225,8 +225,9 @@ postgres: user database host pg_stat_xact_sys_tables, pg_stat_xact_user_tables, and pg_stat_xact_user_functions, or via these views' underlying - functions. These numbers do not act as stated above; instead they update - continuously throughout the transaction. + functions (named the same as the standard statistics functions but with the + prefix pg_stat_get_xact_). These numbers do not act + as stated above; instead they update continuously throughout the transaction. @@ -489,6 +490,22 @@ postgres: user database host + + Other ways of looking at the statistics can be set up by writing + queries that use the same underlying statistics access functions as + these standard views do. These functions are listed in . The per-database access + functions take a database OID as argument 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 + in the current database can be seen with these functions.) The + per-server-process access functions take a server process + number, which ranges from one to the number of currently active + server processes. + + +
pg_stat_activity view @@ -505,7 +522,9 @@ postgres: user database host datid oid - The oid of the database the backend is connected to. + The oid of the database the backend is connected to. + This value can also be returned by directly calling + the pg_stat_get_backend_dbid. datname @@ -515,12 +534,16 @@ postgres: user database host pid integer - The process ID of the backend. + The process ID of the backend. + This value can also be returned by directly calling + the pg_stat_get_backend_pid. usesysid oid - The id of the user logged into the backend. + The id of the user logged into the backend. + This value can also be returned by directly calling + the pg_stat_get_backend_userid. usename @@ -540,6 +563,8 @@ postgres: user database host pg_stat_get_backend_client_addr. @@ -557,6 +582,8 @@ postgres: user database host The remote TCP port that the client is using for communication to the backend, or NULL if a unix socket is used. + This value can also be returned by directly calling + the pg_stat_get_backend_client_port. @@ -565,6 +592,8 @@ postgres: user database host The time when this process was started, i.e. when the client connected to the server. + This value can also be returned by directly calling + the pg_stat_get_backend_start. @@ -574,6 +603,8 @@ postgres: user database host pg_stat_get_backend_xact_start. @@ -583,6 +614,8 @@ postgres: user database host state is idle, when the last query was started. + This value can also be returned by directly calling + the pg_stat_get_backend_activity_start. @@ -595,6 +628,8 @@ postgres: user database host boolean Boolean indicating if a backend is currently waiting on a lock. + This value can also be returned by directly calling + the pg_stat_get_backend_waiting. @@ -687,6 +722,18 @@ postgres: user database host + + All functions used in the view are indexed by backend id number. The + function pg_stat_get_backend_idset provides a + convenient way to generate one row for each active server process. For + example, to show the PIDs and current queries of all server processes: + + +SELECT pg_stat_get_backend_pid(s.backendid) AS pid, + pg_stat_get_backend_activity(s.backendid) AS query + FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s; + +
pg_stat_bgwriter view @@ -704,33 +751,45 @@ postgres: user database host checkpoints_timed bigint - Number of scheduled checkpoints + Number of scheduled checkpoints. + This value can also be returned by directly calling + the pg_stat_get_bgwriter_timed_checkpoints function. checkpoints_requested bigint - Number of requested checkpoints + Number of requested checkpoints. + This value can also be returned by directly calling + the pg_stat_get_bgwriter_requested_checkpoints function. buffers_checkpoint bigint - Number of buffers written during checkpoints + Number of buffers written during checkpoints. + This value can also be returned by directly calling + the pg_stat_get_bgwriter_buf_written_checkpoints function. buffers_clean bigint - Number of buffers written by the background writer + Number of buffers written by the background writer. + This value can also be returned by directly calling + the pg_stat_get_bgwriter_buf_written_clean function. maxwritten_clean bigint Number of times the background writer stopped a cleaning - scan because it had written too many buffers + scan because it had written too many buffers. + This value can also be returned by directly calling + the pg_stat_get_bgwriter_maxwritten_clean function. buffers_backend bigint - Number of buffers written directly by a backend + Number of buffers written directly by a backend. + This value can also be returned by directly calling + the pg_stat_get_buf_written_backend function. buffers_backend_fsync @@ -742,12 +801,16 @@ postgres: user database host buffers_alloc bigint - Number of buffers allocated + Number of buffers allocated. + This value can also be returned by directly calling + the pg_stat_get_buf_alloc function. stats_reset bigint - The last time these statistics were reset + The last time these statistics were reset. + This value can also be returned by directly calling + the pg_stat_get_bgwriter_stat_reset_time function. @@ -786,54 +849,75 @@ postgres: user database host The number of backends currently connected to this database. This is the only column in this view that returns a value for the current state, all other columns return the accumulated values since - the last reset. + the last reset. This value can also be returned by directly calling + the pg_stat_get_db_numbackends function. xact_commit bigint - The number of transactions in this database that has committed + The number of transactions in this database that has committed. + This value can also be returned by directly calling + the pg_stat_get_db_xact_commit function. xact_rollback bigint - The number of transactions in this database that has rolled back + The number of transactions in this database that has rolled back. + This value can also be returned by directly calling + the pg_stat_get_db_xact_rollback function. blks_read bigint - The number of disk blocks read in this database + The number of disk blocks read in this database. + This value can also be returned by directly calling + the pg_stat_get_db_blocks_fetched and + pg_stat_get_db_blocks_hit functions and + subtracting the results. blks_hits bigint The number of disk blocks read from the buffer cache (this only includes hits in the PostgreSQL buffer cache, and not - the operating system filesystem cache) + the operating system filesystem cache). + This value can also be returned by directly calling + the pg_stat_get_db_blocks_hit function. tup_returned bigint - The number of rows returned by queries in this database + The number of rows returned by queries in this database. + This value can also be returned by directly calling + the pg_stat_get_db_tuples_returned function. tup_fetched bigint - The number of rows fetched by queries in this database + The number of rows fetched by queries in this database. + This value can also be returned by directly calling + the pg_stat_get_db_tuples_fetched function. tup_inserted bigint - The number of rows inserted by queries in this database + The number of rows inserted by queries in this database. + This value can also be returned by directly calling + the pg_stat_get_db_tuples_inserted function. tup_updated bigint - The number of rows updated by queries in this database + The number of rows updated by queries in this database. + This value can also be returned by directly calling + the pg_stat_get_db_tuples_updated function. tup_deleted bigint - The number of rows deleted by queries in this database + The number of rows deleted by queries in this database. + This value can also be returned by directly calling + the pg_stat_get_db_tuples_deleted function. conflicts @@ -841,7 +925,9 @@ postgres: user database host The number of queries canceled due to conflict with recovery (on standby servers) in this database. (See - for more details) + for more details). + This value can also be returned by directly calling + the pg_stat_get_db_conflict_all function. @@ -852,6 +938,8 @@ postgres: user database host setting. + This value can also be returned by directly calling + the pg_stat_get_db_temp_files function. @@ -862,17 +950,23 @@ postgres: user database host setting. + This value can also be returned by directly calling + the pg_stat_get_db_temp_bytes function. deadlocks bigint - Number of deadlocks detected in the database + Number of deadlocks detected in the database. + This value can also be returned by directly calling + the pg_stat_get_db_deadlocks function. stats_reset timestamptz - The last time the statistics were reset + The last time the statistics were reset. + This value can also be returned by directly calling + the pg_stat_get_reset_time function. @@ -909,31 +1003,37 @@ postgres: user database host confl_tablespace bigint The number of queries that have been canceled due to - dropped tablespaces + dropped tablespaces. This value can also be returned by directly calling + the pg_stat_get_db_conflict_tablespace function. confl_lock bigint The number of queries that have been canceled due to - lock timeouts + lock timeouts. This value can also be returned by directly calling + the pg_stat_get_db_conflict_lock function. confl_snapshot bigint The number of queries that have been canceled due to - old snapshots + old snapshots. This value can also be returned by directly calling + the pg_stat_get_db_conflict_snapshot function. confl_bufferpin bigint The number of queries that have been canceled due to - pinned buffers + pinned buffers. This value can also be returned by directly calling + the pg_stat_get_db_conflict_bufferpin function. confl_deadlock bigint The number of queries that have been canceled due to - deadlocks + deadlocks. This value can also be returned by directly calling + the pg_stat_get_db_conflict_startup_deadlock + function. @@ -1094,12 +1194,16 @@ postgres: user database host seq_scan bigint - The number of sequential scans initiated on this table + The number of sequential scans initiated on this table. + This value can also be returned by directly calling + the pg_stat_get_numscans function. seq_tup_read bigint - The number of live rows fetch by sequential scans + The number of live rows fetch by sequential scans. + This value can also be returned by directly calling + the pg_stat_get_tuples_returned function. idx_scan @@ -1109,77 +1213,105 @@ postgres: user database host idx_tup_fetch bigint - The number of live rows fetch by index scans + The number of live rows fetch by index scans. n_tup_ins bigint - The number of rows inserted + The number of rows inserted. + This value can also be returned by directly calling + the pg_stat_get_tuples_inserted function. n_tup_upd bigint - The number of rows updated + The number of rows updated. + This value can also be returned by directly calling + the pg_stat_get_tuples_updated function. n_tup_del bigint - The number of rows deleted + The number of rows deleted. + This value can also be returned by directly calling + the pg_stat_get_tuples_deleted function. n_tup_hot_upd bigint - The number of rows HOT (i.e., no separate index update) updated + The number of rows HOT (i.e., no separate index update) updated. + This value can also be returned by directly calling + the pg_stat_get_tuples_hot_updated function. n_live_tup bigint - The number of live rows + The number of live rows. + This value can also be returned by directly calling + the pg_stat_get_live_tuples function. n_dead_tup bigint - The number of dead rows + The number of dead rows. + This value can also be returned by directly calling + the pg_stat_get_dead_tuples function. last_vacuum timestamp with time zone - The last time the table was manually non- + The last time the table was manually non- last_autovacuum timestamp with time zone - The last time the table was vacuumed by the autovacuum daemon + The last time the table was vacuumed by the autovacuum daemon. + This value can also be returned by directly calling + the pg_stat_get_last_autovacuum_time function. last_analyze timestamp with time zone - The last time the table was manually analyzed + The last time the table was manually analyzed. + This value can also be returned by directly calling + the pg_stat_get_last_analyze_time function. last_autoanalyze timestamp with time zone - The last time the table was analyzed by the autovacuum daemon + The last time the table was analyzed by the autovacuum daemon. + This value can also be returned by directly calling + the pg_stat_get_last_autoanalyze_time function. vacuum_count bigint - The number of times this table has been manually non- + The number of times this table has been manually non- autovacuum_count bigint - The number of times this table has been vacuumed by the autovacuum daemon + The number of times this table has been vacuumed by the autovacuum daemon. + This value can also be returned by directly calling + the pg_stat_get_autovacuum_count function. analyze_count bigint - The number of times this table has been manually analyzed + The number of times this table has been manually analyzed. + This value can also be returned by directly calling + the pg_stat_get_analyze_count function. autoanalyze_count bigint - The number of times this table has been analyzed by the autovacuum daemon + The number of times this table has been analyzed by the autovacuum daemon. + This value can also be returned by directly calling + the pg_stat_get_autoanalyze_count function. @@ -1234,17 +1366,23 @@ postgres: user database host idx_scan bigint - Number of index scans initiated on this index + Number of index scans initiated on this index. + This value can also be returned by directly calling + the pg_stat_get_numscans function. idx_tup_read bigint - Number of index entries returned by scans on this index + Number of index entries returned by scans on this index. + This value can also be returned by directly calling + the pg_stat_get_tuples_returned function. idx_tup_fetch bigint - Number of live table rows fetched by simple index scans using this index + Number of live table rows fetched by simple index scans using this index. + This value can also be returned by directly calling + the pg_stat_get_tuples_fetched function. @@ -1289,12 +1427,18 @@ postgres: user database host heap_blks_read name - Number of disk blocks read from this table + Number of disk blocks read from this table. + This value can also be returned by directly calling + the pg_stat_get_blocks_fetched and + pg_stat_get_blocks_hit functions and + subtracting the results. heap_blks_hit name - Number of buffer hits in this table + Number of buffer hits in this table. + This value can also be returned by directly calling + the pg_stat_get_blocks_hit function. idx_blks_read @@ -1304,7 +1448,7 @@ postgres: user database host idx_blks_hit name - Number of buffer hits in all indexes of this table + Number of buffer hits in all indexes of this table. toast_blks_read @@ -1379,12 +1523,18 @@ postgres: user database host idx_blks_read name - Number of disk blocks read from the index + Number of disk blocks read from the index. + This value can also be returned by directly calling + the pg_stat_get_blocks_fetched and + pg_stat_get_blocks_hit functions and + subtracting the results. idx_blks_hit name - Number of buffer hits in the index + Number of buffer hits in the index. + This value can also be returned by directly calling + the pg_stat_get_blocks_hit function. @@ -1476,19 +1626,25 @@ postgres: user database host calls bigint - Number of times the function has been called + Number of times the function has been called. + This value can also be returned by directly calling + the pg_stat_get_function_calls function. total_time bigint Total time spent in this functions and all other functions - called by it, in milliseconds. + called by it, in milliseconds. + This value can also be returned by directly calling + the pg_stat_get_function_time function. self_time bigint Total time spent in this functions itself but not including - other functions called by it, in milliseconds. + other functions called by it, in milliseconds. + This value can also be returned by directly calling + the pg_stat_get_function_self_time function. @@ -1501,25 +1657,11 @@ postgres: user database host - Statistics Access Functions + Other Statistics Functions - - Other ways of looking at the statistics can be set up by writing - queries that use the same underlying statistics access functions as - these standard views do. These functions are listed in . The per-database access - functions take a database OID as argument 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 - in the current database can be seen with these functions.) The - per-server-process access functions take a server process - number, which ranges from one to the number of currently active - server processes. -
- Statistics Access Functions + Other Statistics Functions @@ -1531,401 +1673,6 @@ postgres: user database host - - pg_stat_get_db_numbackends(oid) - integer - - Number of active server processes for database - - - - - pg_stat_get_db_xact_commit(oid) - bigint - - Number of transactions committed in database - - - - - pg_stat_get_db_xact_rollback(oid) - bigint - - Number of transactions rolled back in database - - - - - pg_stat_get_db_blocks_fetched(oid) - bigint - - Number of disk block fetch requests for database - - - - - pg_stat_get_db_blocks_hit(oid) - bigint - - Number of disk block fetch requests found in cache for database - - - - - pg_stat_get_db_tuples_returned(oid) - bigint - - Number of tuples returned for database - - - - - pg_stat_get_db_tuples_fetched(oid) - bigint - - Number of tuples fetched for database - - - - - pg_stat_get_db_tuples_inserted(oid) - bigint - - Number of tuples inserted in database - - - - - pg_stat_get_db_tuples_updated(oid) - bigint - - Number of tuples updated in database - - - - - pg_stat_get_db_tuples_deleted(oid) - bigint - - Number of tuples deleted in database - - - - - pg_stat_get_db_conflict_tablespace(oid) - bigint - - Number of queries canceled because of recovery conflict with dropped tablespaces in database - - - - - pg_stat_get_db_conflict_lock(oid) - bigint - - Number of queries canceled because of recovery conflict with locks in database - - - - - pg_stat_get_db_conflict_snapshot(oid) - bigint - - Number of queries canceled because of recovery conflict with old snapshots in database - - - - - pg_stat_get_db_conflict_bufferpin(oid) - bigint - - Number of queries canceled because of recovery conflict with pinned buffers in database - - - - - pg_stat_get_db_conflict_startup_deadlock(oid) - bigint - - Number of queries canceled because of recovery conflict with deadlocks in database - - - - - pg_stat_get_db_stat_reset_time(oid) - timestamptz - - Time of the last statistics reset for the database. Initialized to the - system time during the first connection to each database. The reset time - is updated when you call pg_stat_reset on the - database, as well as upon execution of - pg_stat_reset_single_table_counters against any - table or index in it. - - - - - pg_stat_get_db_temp_bytes(oid) - bigint - - Amount of data written to temporary files by queries in the database. - All temporary files are counted, regardless of why the temporary file - was created (sorting or hash), and regardless of the - setting. - - - - - pg_stat_get_db_temp_files(oid) - bigint - - Number of temporary files written by queries in the database. All temporary - files are counted, regardless of why the temporary file was created - (sorting or hash) or file size, and regardless of the - setting. - - - - - pg_stat_get_db_deadlocks(oid) - bigint - - Number of deadlocks detected in the database - - - - - pg_stat_get_numscans(oid) - bigint - - Number of sequential scans done when argument is a table, - or number of index scans done when argument is an index - - - - - pg_stat_get_tuples_returned(oid) - bigint - - Number of rows read by sequential scans when argument is a table, - or number of index entries returned when argument is an index - - - - - pg_stat_get_tuples_fetched(oid) - bigint - - Number of table rows fetched by bitmap scans when argument is a table, - or table rows fetched by simple index scans using the index - when argument is an index - - - - - pg_stat_get_tuples_inserted(oid) - bigint - - Number of rows inserted into table - - - - - pg_stat_get_tuples_updated(oid) - bigint - - Number of rows updated in table (includes HOT updates) - - - - - pg_stat_get_tuples_deleted(oid) - bigint - - Number of rows deleted from table - - - - - pg_stat_get_tuples_hot_updated(oid) - bigint - - Number of rows HOT-updated in table - - - - - pg_stat_get_live_tuples(oid) - bigint - - Number of live rows in table - - - - - pg_stat_get_dead_tuples(oid) - bigint - - Number of dead rows in table - - - - - pg_stat_get_blocks_fetched(oid) - bigint - - Number of disk block fetch requests for table or index - - - - - pg_stat_get_blocks_hit(oid) - bigint - - Number of disk block requests found in cache for table or index - - - - - pg_stat_get_last_vacuum_time(oid) - timestamptz - - Time of the last non- vacuum initiated by the user on this table - - - - - pg_stat_get_last_autovacuum_time(oid) - timestamptz - - Time of the last vacuum initiated by the autovacuum daemon on this table - - - - - pg_stat_get_last_analyze_time(oid) - timestamptz - - Time of the last analyze initiated by the user on this table - - - - - pg_stat_get_last_autoanalyze_time(oid) - timestamptz - - Time of the last analyze initiated by the autovacuum daemon on this - table - - - - - pg_stat_get_vacuum_count(oid) - bigint - - The number of times this table has been non- - - - - pg_stat_get_autovacuum_count(oid) - bigint - - The number of times this table has been vacuumed by the autovacuum daemon - - - - - pg_stat_get_analyze_count(oid) - bigint - - The number of times this table has been analyzed manually - - - - - pg_stat_get_autoanalyze_count(oid) - bigint - - The number of times this table has been analyzed by the autovacuum daemon - - - - - pg_stat_get_xact_numscans(oid) - bigint - - Number of sequential scans done when argument is a table, - or number of index scans done when argument is an index, in the current transaction - - - - - pg_stat_get_xact_tuples_returned(oid) - bigint - - Number of rows read by sequential scans when argument is a table, - or number of index entries returned when argument is an index, in the current transaction - - - - - pg_stat_get_xact_tuples_fetched(oid) - bigint - - Number of table rows fetched by bitmap scans when argument is a table, - or table rows fetched by simple index scans using the index - when argument is an index, in the current transaction - - - - - pg_stat_get_xact_tuples_inserted(oid) - bigint - - Number of rows inserted into table, in the current transaction - - - - - pg_stat_get_xact_tuples_updated(oid) - bigint - - Number of rows updated in table (includes HOT updates), in the current transaction - - - - - pg_stat_get_xact_tuples_deleted(oid) - bigint - - Number of rows deleted from table, in the current transaction - - - - - pg_stat_get_xact_tuples_hot_updated(oid) - bigint - - Number of rows HOT-updated in table, in the current transaction - - - - - pg_stat_get_xact_blocks_fetched(oid) - bigint - - Number of disk block fetch requests for table or index, in the current transaction - - - - - pg_stat_get_xact_blocks_hit(oid) - bigint - - Number of disk block requests found in cache for table or index, in the current transaction - - @@ -1947,59 +1694,6 @@ postgres: user database host - - pg_stat_get_function_calls(oid) - bigint - - Number of times the function has been called - - - - - pg_stat_get_function_time(oid) - bigint - - Total wall clock time spent in the function, in microseconds. Includes - the time spent in functions called by this one. - - - - - pg_stat_get_function_self_time(oid) - bigint - - Time spent in only this function. Time spent in called functions - is excluded. - - - - - pg_stat_get_xact_function_calls(oid) - bigint - - Number of times the function has been called, in the current transaction. - - - - - pg_stat_get_xact_function_time(oid) - bigint - - Total wall clock time spent in the function, in microseconds, in the - current transaction. Includes the time spent in functions called by - this one. - - - - - pg_stat_get_xact_function_self_time(oid) - bigint - - Time spent in only this function, in the current transaction. Time - spent in called functions is excluded. - - - pg_stat_get_backend_idset() setof integer @@ -2009,181 +1703,6 @@ postgres: user database host - - pg_stat_get_backend_pid(integer) - integer - - Process ID of the given server process - - - - - pg_stat_get_backend_dbid(integer) - oid - - Database ID of the given server process - - - - - pg_stat_get_backend_userid(integer) - oid - - User ID of the given server process - - - - - pg_stat_get_backend_activity(integer) - text - - Active command of the given server process, but only if the - current user is a superuser or the same user as that of - the session being queried (and - track_activities is on) - - - - - pg_stat_get_backend_waiting(integer) - boolean - - True if the given server process is waiting for a lock, - but only if the current user is a superuser or the same user as that of - the session being queried (and - track_activities is on) - - - - - pg_stat_get_backend_activity_start(integer) - timestamp with time zone - - The time at which the given server process' currently - executing query was started, but only if the - current user is a superuser or the same user as that of - the session being queried (and - track_activities is on) - - - - - pg_stat_get_backend_xact_start(integer) - timestamp with time zone - - The time at which the given server process' currently - executing transaction was started, but only if the - current user is a superuser or the same user as that of - the session being queried (and - track_activities is on) - - - - - pg_stat_get_backend_start(integer) - timestamp with time zone - - The time at which the given server process was started, or - null if the current user is not a superuser nor the same user - as that of the session being queried - - - - - pg_stat_get_backend_client_addr(integer) - inet - - The IP address of the client connected to the given - server process; null if the connection is over a Unix domain - socket, also null if the current user is not a superuser nor - the same user as that of the session being queried - - - - - pg_stat_get_backend_client_port(integer) - integer - - The TCP port number of the client connected to the given - server process; -1 if the connection is over a Unix domain - socket, null if the current user is not a superuser nor the - same user as that of the session being queried - - - - - pg_stat_get_bgwriter_timed_checkpoints() - bigint - - Number of times the background writer has started timed checkpoints - (because the checkpoint_timeout time has expired) - - - - - pg_stat_get_bgwriter_requested_checkpoints() - bigint - - Number of times the background writer has started checkpoints based - on requests from backends because the checkpoint_segments - has been exceeded or because the CHECKPOINT - command has been issued - - - - - pg_stat_get_bgwriter_buf_written_checkpoints() - bigint - - Number of buffers written by the background writer during checkpoints - - - - - pg_stat_get_bgwriter_buf_written_clean() - bigint - - Number of buffers written by the background writer for routine cleaning of - dirty pages - - - - - pg_stat_get_bgwriter_maxwritten_clean() - bigint - - Number of times the background writer has stopped its cleaning scan because - it has written more buffers than specified in the - bgwriter_lru_maxpages parameter - - - - - pg_stat_get_bgwriter_stat_reset_time() - timestamptz - - Time of the last statistics reset for the background writer, updated - when executing pg_stat_reset_shared('bgwriter') - on the database cluster. - - - - - pg_stat_get_buf_written_backend() - bigint - - Number of buffers written by backends because they needed - to allocate a new buffer - - - - - pg_stat_get_buf_alloc() - bigint - - Total number of buffer allocations - - pg_stat_get_wal_senders() @@ -2243,31 +1762,6 @@ postgres: user database host
- - - pg_stat_get_blocks_fetched minus - pg_stat_get_blocks_hit gives the number of kernel - read() calls issued for the table, index, or - database; the number of actual physical reads is usually - lower due to kernel-level buffering. The *_blks_read - statistics columns use this subtraction, i.e., fetched minus hit. - - - - - All functions to access information about backends are indexed by backend id - number, except pg_stat_get_activity which is indexed by PID. - The function pg_stat_get_backend_idset provides - a convenient way to generate one row for each active server process. For - example, to show the PIDs and current queries of all server processes: - - -SELECT pg_stat_get_backend_pid(s.backendid) AS pid, - pg_stat_get_backend_activity(s.backendid) AS query - FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s; - - - -- 2.40.0