I was running the command as user postgres (default). The "vacuum anlyze" and the "analyze" I run as the same user. client_min_messages is still set to default in the server config.
Uwe Bartels <uwe.bartels@gmail.com> writes: > today i found an anomalie running > analyze verbose <table>
> the output was simply "ANALYZE", which tells me that analyze was running > successfully. but there was no verbose output. and in the statistics table > was no updated last_analyze column.
Perhaps you didn't have permission to analyze the table, and had client_min_messages set too high to see the resulting WARNING? It would have done something like this:
regression=> analyze verbose tenk1; WARNING: skipping "tenk1" --- only table or database owner can analyze it ANALYZE
but if the WARNING got suppressed it would match what you stated.
