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

Commit5ba40b6

Browse files
committed
Doc: Fix and tweak documentation for ANALYZE reporting
The docs had some typos and grammar mistakes, and its indentation wasinconsistent.Author: Amit Langote, Justin PryzbyDiscussion:https://postgr.es/m/20200116151930.GM26045@telsasoft.com
1 parentf942dfb commit5ba40b6

File tree

1 file changed

+54
-52
lines changed

1 file changed

+54
-52
lines changed

‎doc/src/sgml/monitoring.sgml

Lines changed: 54 additions & 52 deletions
Original file line numberDiff line numberDiff line change
@@ -3571,51 +3571,53 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS pid,
35713571
<entry><structfield>sample_blks_total</structfield></entry>
35723572
<entry><type>bigint</type></entry>
35733573
<entry>
3574-
Total number of heap blocks that will be sampled.
3574+
Total number of heap blocks that will be sampled.
35753575
</entry>
35763576
</row>
35773577
<row>
35783578
<entry><structfield>sample_blks_scanned</structfield></entry>
35793579
<entry><type>bigint</type></entry>
35803580
<entry>
3581-
Number of heap blocks scanned.
3581+
Number of heap blocks scanned.
35823582
</entry>
35833583
</row>
35843584
<row>
35853585
<entry><structfield>ext_stats_total</structfield></entry>
35863586
<entry><type>bigint</type></entry>
35873587
<entry>
3588-
Number of extended statistics.
3588+
Number of extended statistics.
35893589
</entry>
35903590
</row>
35913591
<row>
35923592
<entry><structfield>ext_stats_computed</structfield></entry>
35933593
<entry><type>bigint</type></entry>
35943594
<entry>
3595-
Number ofcomputedextended statistics computed.This counter only advances when
3596-
the phase is <literal>computing extended statistics</literal>.
3595+
Number of extended statistics computed. This counter only advances
3596+
when the phase is <literal>computing extended statistics</literal>.
35973597
</entry>
35983598
</row>
35993599
<row>
36003600
<entry><structfield>child_tables_total</structfield></entry>
36013601
<entry><type>bigint</type></entry>
36023602
<entry>
3603-
Number of child tables.
3603+
Number of child tables.
36043604
</entry>
36053605
</row>
36063606
<row>
36073607
<entry><structfield>child_tables_done</structfield></entry>
36083608
<entry><type>bigint</type></entry>
36093609
<entry>
3610-
Number of child tables scanned.This counter only advances when the phase
3611-
is <literal>acquiring inherited sample rows</literal>.
3610+
Number of child tables scanned. This counter only advances when the
3611+
phase is <literal>acquiring inherited sample rows</literal>.
36123612
</entry>
36133613
</row>
36143614
<row>
36153615
<entry><structfield>current_child_table_relid</structfield></entry>
36163616
<entry><type>oid</type></entry>
3617-
<entry>OID of the child table currently being scanned. This field is only valid when
3618-
the phase is <literal>computing extended statistics</literal>.
3617+
<entry>
3618+
OID of the child table currently being scanned. This field is
3619+
only valid when the phase is
3620+
<literal>acquiring inherited sample rows</literal>.
36193621
</entry>
36203622
</row>
36213623
</tbody>
@@ -3626,58 +3628,58 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS pid,
36263628
<title>ANALYZE phases</title>
36273629
<tgroup cols="2">
36283630
<thead>
3629-
<row>
3631+
<row>
36303632
<entry>Phase</entry>
36313633
<entry>Description</entry>
36323634
</row>
36333635
</thead>
3634-
<tbody>
3635-
<row>
3636-
<entry><literal>initializing</literal></entry>
3637-
<entry>
3636+
<tbody>
3637+
<row>
3638+
<entry><literal>initializing</literal></entry>
3639+
<entry>
36383640
The command is preparing to begin scanning the heap. This phase is
36393641
expected to be very brief.
3640-
</entry>
3641-
</row>
3642-
<row>
3643-
<entry><literal>acquiring sample rows</literal></entry>
3644-
<entry>
3642+
</entry>
3643+
</row>
3644+
<row>
3645+
<entry><literal>acquiring sample rows</literal></entry>
3646+
<entry>
36453647
The command is currently scanning the table given by
3646-
<structfield>current_relid</structfield> to obtain sample rows.
3647-
</entry>
3648-
</row>
3649-
<row>
3650-
<entry><literal>acquiring inherited sample rows</literal></entry>
3651-
<entry>
3652-
The command is currently scanning child tables to obtain sample rows. Columns
3653-
<structfield>child_tables_total</structfield>,
3648+
<structfield>relid</structfield> to obtain sample rows.
3649+
</entry>
3650+
</row>
3651+
<row>
3652+
<entry><literal>acquiring inherited sample rows</literal></entry>
3653+
<entry>
3654+
The command is currently scanning child tables to obtain sample rows.
3655+
Columns<structfield>child_tables_total</structfield>,
36543656
<structfield>child_tables_done</structfield>, and
3655-
<structfield>current_child_table_relid</structfield> contain the progress
3656-
information for this phase.
3657-
</entry>
3658-
</row>
3659-
<row>
3660-
<entry><literal>computing statistics</literal></entry>
3661-
<entry>
3662-
The command is computing statistics from thesamples rows obtained during
3663-
the table scan.
3664-
</entry>
3665-
</row>
3666-
<row>
3667-
<entry><literal>computing extended statistics</literal></entry>
3668-
<entry>
3669-
The command is computing extended statistics from thesamples rows obtained
3670-
durring the table scan.
3671-
</entry>
3672-
</row>
3673-
<row>
3674-
<entry><literal>finalizing analyze</literal></entry>
3675-
<entry>
3657+
<structfield>current_child_table_relid</structfield> contain the
3658+
progressinformation for this phase.
3659+
</entry>
3660+
</row>
3661+
<row>
3662+
<entry><literal>computing statistics</literal></entry>
3663+
<entry>
3664+
The command is computing statistics from thesample rows obtained
3665+
duringthe table scan.
3666+
</entry>
3667+
</row>
3668+
<row>
3669+
<entry><literal>computing extended statistics</literal></entry>
3670+
<entry>
3671+
The command is computing extended statistics from thesample rows
3672+
obtained during the table scan.
3673+
</entry>
3674+
</row>
3675+
<row>
3676+
<entry><literal>finalizing analyze</literal></entry>
3677+
<entry>
36763678
The command is updating pg_class. When this phase is completed,
36773679
<command>ANALYZE</command> will end.
3678-
</entry>
3679-
</row>
3680-
</tbody>
3680+
</entry>
3681+
</row>
3682+
</tbody>
36813683
</tgroup>
36823684
</table>
36833685

0 commit comments

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