Commitcd0f42e

committed

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

1 parentf63cbcc commitcd0f42eCopy full SHA for cd0f42e

File tree

-1

lines changed

-1

lines changed

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $Header: /cvsroot/pgsql/src/backend/commands/analyze.c,v 1.59 2003/08/17 19:58:04 tgl Exp $`
	`11`	`+ * $Header: /cvsroot/pgsql/src/backend/commands/analyze.c,v 1.60 2003/08/26 15:38:42 momjian Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -687,6 +687,12 @@ pageloop:;`
`687`	`687`	`*/`
`688`	`688`	`totalrows=floor((double)onerel->rd_nblockstuplesperpage+0.5);`
`689`	`689`
	`690`	`+/*`
	`691`	`+ * Emit some interesting relation info`
	`692`	`+ */`
	`693`	`+elog(elevel," pages = %d rows/page = %d rows = %.0f",`
	`694`	`+onerel->rd_nblocks, (int)tuplesperpage,*totalrows);`
	`695`	`+`
`690`	`696`	`returnnumrows;`
`691`	`697`	`}`
`692`	`698`

Comments

(0)