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
Appearance settings

Commit 5ba40b6

Browse filesBrowse files
michaelpqmichaelpq
committed
Doc: Fix and tweak documentation for ANALYZE reporting
The docs had some typos and grammar mistakes, and its indentation was inconsistent. Author: Amit Langote, Justin Pryzby Discussion: https://postgr.es/m/20200116151930.GM26045@telsasoft.com
1 parent f942dfb commit 5ba40b6
Copy full SHA for 5ba40b6

File tree

Expand file treeCollapse file tree

1 file changed

+54
-52
lines changed
Filter options
Expand file treeCollapse file tree

1 file changed

+54
-52
lines changed

‎doc/src/sgml/monitoring.sgml

Copy file name to clipboardExpand all lines: doc/src/sgml/monitoring.sgml
+54-52Lines 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 of computed extended 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 the samples 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 the samples 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+
progress information 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 the sample rows obtained
3665+
during the 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 the sample 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 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.