From e8a47b3cb92de64e80ae444e90f5a9cbb4294d48 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 13 Oct 2010 21:29:10 +0300 Subject: [PATCH] Add index entries for pg_stat* views --- doc/src/sgml/monitoring.sgml | 46 ++++++++++++++++++------------------ 1 file changed, 23 insertions(+), 23 deletions(-) diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 8c73f39fb8..dbf966b631 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -242,7 +242,7 @@ postgres: user database host - pg_stat_activity + pg_stat_activitypg_stat_activity One row per server process, showing database OID, database name, process ID, user OID, user name, application name, client's address and port number, times at which the server process, @@ -257,7 +257,7 @@ postgres: user database host - pg_stat_bgwriter + pg_stat_bgwriterpg_stat_bgwriter One row only, showing cluster-wide statistics from the background writer: number of scheduled checkpoints, requested checkpoints, buffers written by checkpoints and cleaning scans, @@ -270,7 +270,7 @@ postgres: user database host - pg_stat_database + pg_stat_databasepg_stat_database One row per database, showing database OID, database name, number of active server processes connected to that database, number of transactions committed and rolled back in that database, @@ -281,7 +281,7 @@ postgres: user database host - pg_stat_all_tables + pg_stat_all_tablespg_stat_all_tables For each table in the current database (including TOAST tables), the table OID, schema and table name, number of sequential scans initiated, number of live rows fetched by sequential @@ -302,19 +302,19 @@ postgres: user database host - pg_stat_sys_tables + pg_stat_sys_tablespg_stat_sys_tables Same as pg_stat_all_tables, except that only system tables are shown. - pg_stat_user_tables + pg_stat_user_tablespg_stat_user_tables Same as pg_stat_all_tables, except that only user tables are shown. - pg_stat_xact_all_tables + pg_stat_xact_all_tablespg_stat_xact_all_tables Similar to pg_stat_all_tables, but counts actions taken so far within the current transaction (which are not yet included in pg_stat_all_tables and related views). @@ -323,19 +323,19 @@ postgres: user database host - pg_stat_xact_sys_tables + pg_stat_xact_sys_tablespg_stat_xact_sys_tables Same as pg_stat_xact_all_tables, except that only system tables are shown. - pg_stat_xact_user_tables + pg_stat_xact_user_tablespg_stat_xact_user_tables Same as pg_stat_xact_all_tables, except that only user tables are shown. - pg_stat_all_indexes + pg_stat_all_indexespg_stat_all_indexes For each index in the current database, the table and index OID, schema, table and index name, number of index scans initiated on that index, number of @@ -345,19 +345,19 @@ postgres: user database host - pg_stat_sys_indexes + pg_stat_sys_indexespg_stat_sys_indexes Same as pg_stat_all_indexes, except that only indexes on system tables are shown. - pg_stat_user_indexes + pg_stat_user_indexespg_stat_user_indexes Same as pg_stat_all_indexes, except that only indexes on user tables are shown. - pg_statio_all_tables + pg_statio_all_tablespg_statio_all_tables For each table in the current database (including TOAST tables), the table OID, schema and table name, number of disk blocks read from that table, number of buffer hits, numbers of @@ -369,19 +369,19 @@ postgres: user database host - pg_statio_sys_tables + pg_statio_sys_tablespg_statio_sys_tables Same as pg_statio_all_tables, except that only system tables are shown. - pg_statio_user_tables + pg_statio_user_tablespg_statio_user_tables Same as pg_statio_all_tables, except that only user tables are shown. - pg_statio_all_indexes + pg_statio_all_indexespg_statio_all_indexes For each index in the current database, the table and index OID, schema, table and index name, numbers of disk blocks read and buffer hits in that index. @@ -389,19 +389,19 @@ postgres: user database host - pg_statio_sys_indexes + pg_statio_sys_indexespg_statio_sys_indexes Same as pg_statio_all_indexes, except that only indexes on system tables are shown. - pg_statio_user_indexes + pg_statio_user_indexespg_statio_user_indexes Same as pg_statio_all_indexes, except that only indexes on user tables are shown. - pg_statio_all_sequences + pg_statio_all_sequencespg_statio_all_sequences For each sequence object in the current database, the sequence OID, schema and sequence name, numbers of disk blocks read and buffer hits in that sequence. @@ -409,20 +409,20 @@ postgres: user database host - pg_statio_sys_sequences + pg_statio_sys_sequencespg_statio_sys_sequences Same as pg_statio_all_sequences, except that only system sequences are shown. (Presently, no system sequences are defined, so this view is always empty.) - pg_statio_user_sequences + pg_statio_user_sequencespg_statio_user_sequences Same as pg_statio_all_sequences, except that only user sequences are shown. - pg_stat_user_functions + pg_stat_user_functionspg_stat_user_functions For all tracked functions, function OID, schema, name, number of calls, total time, and self time. Self time is the amount of time spent in the function itself, total time includes the @@ -431,7 +431,7 @@ postgres: user database host - pg_stat_xact_user_functions + pg_stat_xact_user_functionspg_stat_xact_user_functions Similar to pg_stat_user_functions, but counts only calls during the current transaction (which are not yet included in pg_stat_user_functions). -- 2.40.0