1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>19.9. Run-time Statistics</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets V1.79.1" /><link rel="prev" href="runtime-config-logging.html" title="19.8. Error Reporting and Logging" /><link rel="next" href="runtime-config-autovacuum.html" title="19.10. Automatic Vacuuming" /></head><body id="docContent" class="container-fluid col-10"><div xmlns="http://www.w3.org/TR/xhtml1/transitional" class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">19.9. Run-time Statistics</th></tr><tr><td width="10%" align="left"><a accesskey="p" href="runtime-config-logging.html" title="19.8. Error Reporting and Logging">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="runtime-config.html" title="Chapter 19. Server Configuration">Up</a></td><th width="60%" align="center">Chapter 19. Server Configuration</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 13.4 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="runtime-config-autovacuum.html" title="19.10. Automatic Vacuuming">Next</a></td></tr></table><hr></hr></div><div class="sect1" id="RUNTIME-CONFIG-STATISTICS"><div class="titlepage"><div><div><h2 class="title" style="clear: both">19.9. Run-time Statistics</h2></div></div></div><div class="toc"><dl class="toc"><dt><span class="sect2"><a href="runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-COLLECTOR">19.9.1. Query and Index Statistics Collector</a></span></dt><dt><span class="sect2"><a href="runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-MONITOR">19.9.2. Statistics Monitoring</a></span></dt></dl></div><div class="sect2" id="RUNTIME-CONFIG-STATISTICS-COLLECTOR"><div class="titlepage"><div><div><h3 class="title">19.9.1. Query and Index Statistics Collector</h3></div></div></div><p>
These parameters control server-wide statistics collection features.
When statistics collection is enabled, the data that is produced can be
accessed via the <code class="structname">pg_stat</code> and
<code class="structname">pg_statio</code> family of system views.
Refer to <a class="xref" href="monitoring.html" title="Chapter 27. Monitoring Database Activity">Chapter 27</a> for more information.
</p><div class="variablelist"><dl class="variablelist"><dt id="GUC-TRACK-ACTIVITIES"><span class="term"><code class="varname">track_activities</code> (<code class="type">boolean</code>)
<a id="id-1.6.6.12.2.3.1.1.3" class="indexterm"></a>
</span></dt><dd><p>
Enables the collection of information on the currently
executing command of each session, along with the time when
that command began execution. This parameter is on by
default. Note that even when enabled, this information is not
visible to all users, only to superusers and the user owning
the session being reported on, so it should not represent a
security risk.
Only superusers can change this setting.
</p></dd><dt id="GUC-TRACK-ACTIVITY-QUERY-SIZE"><span class="term"><code class="varname">track_activity_query_size</code> (<code class="type">integer</code>)
<a id="id-1.6.6.12.2.3.2.1.3" class="indexterm"></a>
</span></dt><dd><p>
Specifies the amount of memory reserved to store the text of the
currently executing command for each active session, for the
<code class="structname">pg_stat_activity</code>.<code class="structfield">query</code> field.
If this value is specified without units, it is taken as bytes.
The default value is 1024 bytes.
This parameter can only be set at server start.
</p></dd><dt id="GUC-TRACK-COUNTS"><span class="term"><code class="varname">track_counts</code> (<code class="type">boolean</code>)
<a id="id-1.6.6.12.2.3.3.1.3" class="indexterm"></a>
</span></dt><dd><p>
Enables collection of statistics on database activity.
This parameter is on by default, because the autovacuum
daemon needs the collected information.
Only superusers can change this setting.
</p></dd><dt id="GUC-TRACK-IO-TIMING"><span class="term"><code class="varname">track_io_timing</code> (<code class="type">boolean</code>)
<a id="id-1.6.6.12.2.3.4.1.3" class="indexterm"></a>
</span></dt><dd><p>
Enables timing of database I/O calls. This parameter is off by
default, because it will repeatedly query the operating system for
the current time, which may cause significant overhead on some
platforms. You can use the <a class="xref" href="pgtesttiming.html" title="pg_test_timing"><span class="refentrytitle"><span class="application">pg_test_timing</span></span></a> tool to
measure the overhead of timing on your system.
I/O timing information is
displayed in <a class="link" href="monitoring-stats.html#MONITORING-PG-STAT-DATABASE-VIEW" title="27.2.11. pg_stat_database">
<code class="structname">pg_stat_database</code></a>, in the output of
<a class="xref" href="sql-explain.html" title="EXPLAIN"><span class="refentrytitle">EXPLAIN</span></a> when the <code class="literal">BUFFERS</code> option is
used, and by <a class="xref" href="pgstatstatements.html" title="F.29. pg_stat_statements">pg_stat_statements</a>. Only superusers can
change this setting.
</p></dd><dt id="GUC-TRACK-FUNCTIONS"><span class="term"><code class="varname">track_functions</code> (<code class="type">enum</code>)
<a id="id-1.6.6.12.2.3.5.1.3" class="indexterm"></a>
</span></dt><dd><p>
Enables tracking of function call counts and time used. Specify
<code class="literal">pl</code> to track only procedural-language functions,
<code class="literal">all</code> to also track SQL and C language functions.
The default is <code class="literal">none</code>, which disables function
statistics tracking. Only superusers can change this setting.
</p><div class="note"><h3 class="title">Note</h3><p>
SQL-language functions that are simple enough to be <span class="quote">“<span class="quote">inlined</span>”</span>
into the calling query will not be tracked, regardless of this
setting.
</p></div></dd><dt id="GUC-STATS-TEMP-DIRECTORY"><span class="term"><code class="varname">stats_temp_directory</code> (<code class="type">string</code>)
<a id="id-1.6.6.12.2.3.6.1.3" class="indexterm"></a>
</span></dt><dd><p>
Sets the directory to store temporary statistics data in. This can be
a path relative to the data directory or an absolute path. The default
is <code class="filename">pg_stat_tmp</code>. Pointing this at a RAM-based
file system will decrease physical I/O requirements and can lead to
improved performance.
This parameter can only be set in the <code class="filename">postgresql.conf</code>
file or on the server command line.
</p></dd></dl></div></div><div class="sect2" id="RUNTIME-CONFIG-STATISTICS-MONITOR"><div class="titlepage"><div><div><h3 class="title">19.9.2. Statistics Monitoring</h3></div></div></div><div class="variablelist"><dl class="variablelist"><dt><span class="term"><code class="varname">log_statement_stats</code> (<code class="type">boolean</code>)
<a id="id-1.6.6.12.3.2.1.1.3" class="indexterm"></a>
<br /></span><span class="term"><code class="varname">log_parser_stats</code> (<code class="type">boolean</code>)
<a id="id-1.6.6.12.3.2.1.2.3" class="indexterm"></a>
<br /></span><span class="term"><code class="varname">log_planner_stats</code> (<code class="type">boolean</code>)
<a id="id-1.6.6.12.3.2.1.3.3" class="indexterm"></a>
<br /></span><span class="term"><code class="varname">log_executor_stats</code> (<code class="type">boolean</code>)
<a id="id-1.6.6.12.3.2.1.4.3" class="indexterm"></a>
</span></dt><dd><p>
For each query, output performance statistics of the respective
module to the server log. This is a crude profiling
instrument, similar to the Unix <code class="function">getrusage()</code> operating
system facility. <code class="varname">log_statement_stats</code> reports total
statement statistics, while the others report per-module statistics.
<code class="varname">log_statement_stats</code> cannot be enabled together with
any of the per-module options. All of these options are disabled by
default. Only superusers can change these settings.
</p></dd></dl></div></div></div><div xmlns="http://www.w3.org/TR/xhtml1/transitional" class="navfooter"><hr></hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="runtime-config-logging.html" title="19.8. Error Reporting and Logging">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="runtime-config.html" title="Chapter 19. Server Configuration">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="runtime-config-autovacuum.html" title="19.10. Automatic Vacuuming">Next</a></td></tr><tr><td width="40%" align="left" valign="top">19.8. Error Reporting and Logging </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 13.4 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 19.10. Automatic Vacuuming</td></tr></table></div></body></html>
|
