diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-08-26 15:38:42 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-08-26 15:38:42 +0000 |
| commit | cd0f42e87c6e90805437caabc71e2e36657ff0d8 (patch) | |
| tree | 6334999423d9d8f5c9782a51e6e47f285a9d3fef | |
| parent | f63cbccac7ad4017fabc645548fc9d4aeccde95d (diff) | |
| download | postgresql-cd0f42e87c6e90805437caabc71e2e36657ff0d8.tar.gz postgresql-cd0f42e87c6e90805437caabc71e2e36657ff0d8.zip | |
Attached is a (very small) patch to make analyze display some
interesting info in verbose mode about the analyzed relation (pages,
rows per block and rows).
Mark Kirkwood
| -rw-r--r-- | src/backend/commands/analyze.c | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/src/backend/commands/analyze.c b/src/backend/commands/analyze.c index aea5e45b231..844dce19b59 100644 --- a/src/backend/commands/analyze.c +++ b/src/backend/commands/analyze.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/analyze.c,v 1.59 2003/08/17 19:58:04 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/analyze.c,v 1.60 2003/08/26 15:38:42 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -687,6 +687,12 @@ pageloop:; */ *totalrows = floor((double) onerel->rd_nblocks * tuplesperpage + 0.5); + /* + * Emit some interesting relation info + */ + elog(elevel, " pages = %d rows/page = %d rows = %.0f", + onerel->rd_nblocks, (int)tuplesperpage, *totalrows); + return numrows; } |