Skip site navigation (1) Skip section navigation (2)

pg_stat_all_tables shows all 0's

From: Michael Guerin <guerin(at)rentec(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: pg_stat_all_tables shows all 0's
Date: 2003-12-16 18:15:01
Message-ID: 3FDF4BA5.2080109@rentec.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

  When I query the pg_stat_all_tables view all I get back is 0's.  How 
can I tell if the statistics collector is running?  I have the  param's 
set in my config file.
 
#
#    Access statistics collection
#
stats_start_collector = true
stats_reset_on_server_start = true
stats_command_string = false
stats_row_level = false
stats_block_level = false

thanks
michael



pgsql-novice by date

Next:From: Joe ConwayDate: 2003-12-16 18:23:41
Subject: Re: Returning arbitrary row sets from a function
Previous:From: Joe ConwayDate: 2003-12-16 18:12:21
Subject: Re: Returning arbitrary row sets from a function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group