FAQ
Hi,

I've got a database on a hosted server that I'm interested in looking
at statistics for, initially the pg_stat_user_tables view. When I
query it, it's empty. Looking at the output the of SHOW ALL:

stats_block_level: off
stats_command_string: on
stats_reset_on_server_start: off
stats_row_level: off
stats_start_collector: on

So I'm assuming I need to ask the sys admin to turn on row level
stats? My question is which views/fields depend on row_level stats and
which depend on block_level stats?

tia,

Neil.

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedMay 11, '09 at 2:58p
activeMay 11, '09 at 2:58p
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Neil Saunders: 1 post

People

Translate

site design / logo © 2023 Grokbase