Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit72e0ff2

Browse files
committed
doc: Re-order Table 28.2 "Collected Statistics Views"
Make the order more sensible and repeatable. Comments have been addedto guide future additions.Author: Peter Smith <peter.b.smith@fujitsu.com>Reviewed-by: David G. Johnston <david.g.johnston@gmail.com>Discussion:https://www.postgresql.org/message-id/flat/CAHut+Pv8Oa7v06hJb3+HzCtM2u-3oHWMdvXVHhvi7ofB83pNbg@mail.gmail.com
1 parent2ceea5a commit72e0ff2

File tree

1 file changed

+57
-50
lines changed

1 file changed

+57
-50
lines changed

‎doc/src/sgml/monitoring.sgml

Lines changed: 57 additions & 50 deletions
Original file line numberDiff line numberDiff line change
@@ -430,6 +430,9 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser
430430
</thead>
431431

432432
<tbody>
433+
434+
<!-- everything related to global objects, alphabetically -->
435+
433436
<row>
434437
<entry><structname>pg_stat_archiver</structname><indexterm><primary>pg_stat_archiver</primary></indexterm></entry>
435438
<entry>One row only, showing statistics about the
@@ -448,14 +451,6 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser
448451
</entry>
449452
</row>
450453

451-
<row>
452-
<entry><structname>pg_stat_wal</structname><indexterm><primary>pg_stat_wal</primary></indexterm></entry>
453-
<entry>One row only, showing statistics about WAL activity. See
454-
<link linkend="monitoring-pg-stat-wal-view">
455-
<structname>pg_stat_wal</structname></link> for details.
456-
</entry>
457-
</row>
458-
459454
<row>
460455
<entry><structname>pg_stat_database</structname><indexterm><primary>pg_stat_database</primary></indexterm></entry>
461456
<entry>One row per database, showing database-wide statistics. See
@@ -474,6 +469,41 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser
474469
</entry>
475470
</row>
476471

472+
<row>
473+
<entry><structname>pg_stat_replication_slots</structname><indexterm><primary>pg_stat_replication_slots</primary></indexterm></entry>
474+
<entry>One row per replication slot, showing statistics about the
475+
replication slot's usage. See
476+
<link linkend="monitoring-pg-stat-replication-slots-view">
477+
<structname>pg_stat_replication_slots</structname></link> for details.
478+
</entry>
479+
</row>
480+
481+
<row>
482+
<entry><structname>pg_stat_slru</structname><indexterm><primary>pg_stat_slru</primary></indexterm></entry>
483+
<entry>One row per SLRU, showing statistics of operations. See
484+
<link linkend="monitoring-pg-stat-slru-view">
485+
<structname>pg_stat_slru</structname></link> for details.
486+
</entry>
487+
</row>
488+
489+
<row>
490+
<entry><structname>pg_stat_subscription_stats</structname><indexterm><primary>pg_stat_subscription_stats</primary></indexterm></entry>
491+
<entry>One row per subscription, showing statistics about errors.
492+
See <link linkend="monitoring-pg-stat-subscription-stats">
493+
<structname>pg_stat_subscription_stats</structname></link> for details.
494+
</entry>
495+
</row>
496+
497+
<row>
498+
<entry><structname>pg_stat_wal</structname><indexterm><primary>pg_stat_wal</primary></indexterm></entry>
499+
<entry>One row only, showing statistics about WAL activity. See
500+
<link linkend="monitoring-pg-stat-wal-view">
501+
<structname>pg_stat_wal</structname></link> for details.
502+
</entry>
503+
</row>
504+
505+
<!-- all "stat" for schema objects, by "importance" -->
506+
477507
<row>
478508
<entry><structname>pg_stat_all_tables</structname><indexterm><primary>pg_stat_all_tables</primary></indexterm></entry>
479509
<entry>
@@ -539,6 +569,25 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser
539569
indexes on user tables are shown.</entry>
540570
</row>
541571

572+
<row>
573+
<entry><structname>pg_stat_user_functions</structname><indexterm><primary>pg_stat_user_functions</primary></indexterm></entry>
574+
<entry>
575+
One row for each tracked function, showing statistics
576+
about executions of that function. See
577+
<link linkend="monitoring-pg-stat-user-functions-view">
578+
<structname>pg_stat_user_functions</structname></link> for details.
579+
</entry>
580+
</row>
581+
582+
<row>
583+
<entry><structname>pg_stat_xact_user_functions</structname><indexterm><primary>pg_stat_xact_user_functions</primary></indexterm></entry>
584+
<entry>Similar to <structname>pg_stat_user_functions</structname>, but counts only
585+
calls during the current transaction (which are <emphasis>not</emphasis>
586+
yet included in <structname>pg_stat_user_functions</structname>).</entry>
587+
</row>
588+
589+
<!-- all "statio" for schema objects, by "importance" -->
590+
542591
<row>
543592
<entry><structname>pg_statio_all_tables</structname><indexterm><primary>pg_statio_all_tables</primary></indexterm></entry>
544593
<entry>
@@ -606,48 +655,6 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser
606655
user sequences are shown.</entry>
607656
</row>
608657

609-
<row>
610-
<entry><structname>pg_stat_user_functions</structname><indexterm><primary>pg_stat_user_functions</primary></indexterm></entry>
611-
<entry>
612-
One row for each tracked function, showing statistics
613-
about executions of that function. See
614-
<link linkend="monitoring-pg-stat-user-functions-view">
615-
<structname>pg_stat_user_functions</structname></link> for details.
616-
</entry>
617-
</row>
618-
619-
<row>
620-
<entry><structname>pg_stat_xact_user_functions</structname><indexterm><primary>pg_stat_xact_user_functions</primary></indexterm></entry>
621-
<entry>Similar to <structname>pg_stat_user_functions</structname>, but counts only
622-
calls during the current transaction (which are <emphasis>not</emphasis>
623-
yet included in <structname>pg_stat_user_functions</structname>).</entry>
624-
</row>
625-
626-
<row>
627-
<entry><structname>pg_stat_slru</structname><indexterm><primary>pg_stat_slru</primary></indexterm></entry>
628-
<entry>One row per SLRU, showing statistics of operations. See
629-
<link linkend="monitoring-pg-stat-slru-view">
630-
<structname>pg_stat_slru</structname></link> for details.
631-
</entry>
632-
</row>
633-
634-
<row>
635-
<entry><structname>pg_stat_replication_slots</structname><indexterm><primary>pg_stat_replication_slots</primary></indexterm></entry>
636-
<entry>One row per replication slot, showing statistics about the
637-
replication slot's usage. See
638-
<link linkend="monitoring-pg-stat-replication-slots-view">
639-
<structname>pg_stat_replication_slots</structname></link> for details.
640-
</entry>
641-
</row>
642-
643-
<row>
644-
<entry><structname>pg_stat_subscription_stats</structname><indexterm><primary>pg_stat_subscription_stats</primary></indexterm></entry>
645-
<entry>One row per subscription, showing statistics about errors.
646-
See <link linkend="monitoring-pg-stat-subscription-stats">
647-
<structname>pg_stat_subscription_stats</structname></link> for details.
648-
</entry>
649-
</row>
650-
651658
</tbody>
652659
</tgroup>
653660
</table>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp