diff options
| author | Peter Geoghegan <pg@bowt.ie> | 2021-08-27 13:08:41 -0700 |
|---|---|---|
| committer | Peter Geoghegan <pg@bowt.ie> | 2021-08-27 13:08:41 -0700 |
| commit | fdfbfa24fa6ae50d9e78dd70f835146f4b40e2fb (patch) | |
| tree | 0a803f1ead8880ab923cb9539d02804830d3ce72 /src/backend/commands/analyze.c | |
| parent | de5dcb0796e281fae0ee25ea33b915240de319f6 (diff) | |
| download | postgresql-fdfbfa24fa6ae50d9e78dd70f835146f4b40e2fb.tar.gz postgresql-fdfbfa24fa6ae50d9e78dd70f835146f4b40e2fb.zip | |
Reorder log_autovacuum_min_duration log output.
This order seems more natural. It starts with details that are
particular to heap and index data structures, and ends with system-level
costs incurred during the autovacuum worker's VACUUM/ANALYZE operation.
Author: Peter Geoghegan <pg@bowt.ie>
Discussion: https://postgr.es/m/CAH2-WzkzxK6ahA9xxsOftRtBX_R0swuHZsvo4QUbak1Bz7hb7Q@mail.gmail.com
Backpatch: 14-, which enhanced the log output in various ways.
Diffstat (limited to 'src/backend/commands/analyze.c')
| -rw-r--r-- | src/backend/commands/analyze.c | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/backend/commands/analyze.c b/src/backend/commands/analyze.c index 8d7b38d1707..a17349bcd6c 100644 --- a/src/backend/commands/analyze.c +++ b/src/backend/commands/analyze.c @@ -777,12 +777,6 @@ do_analyze_rel(Relation onerel, VacuumParams *params, get_database_name(MyDatabaseId), get_namespace_name(RelationGetNamespace(onerel)), RelationGetRelationName(onerel)); - appendStringInfo(&buf, _("buffer usage: %lld hits, %lld misses, %lld dirtied\n"), - (long long) AnalyzePageHit, - (long long) AnalyzePageMiss, - (long long) AnalyzePageDirty); - appendStringInfo(&buf, _("avg read rate: %.3f MB/s, avg write rate: %.3f MB/s\n"), - read_rate, write_rate); if (track_io_timing) { appendStringInfoString(&buf, _("I/O timings:")); @@ -796,6 +790,12 @@ do_analyze_rel(Relation onerel, VacuumParams *params, (double) (pgStatBlockWriteTime - startwritetime) / 1000); appendStringInfoChar(&buf, '\n'); } + appendStringInfo(&buf, _("avg read rate: %.3f MB/s, avg write rate: %.3f MB/s\n"), + read_rate, write_rate); + appendStringInfo(&buf, _("buffer usage: %lld hits, %lld misses, %lld dirtied\n"), + (long long) AnalyzePageHit, + (long long) AnalyzePageMiss, + (long long) AnalyzePageDirty); appendStringInfo(&buf, _("system usage: %s"), pg_rusage_show(&ru0)); ereport(LOG, |