There is data in pg_stat_activity and pg_stat_database view. There is also data in the pg_stat views related to system but not in pg_stat views related to user .
-----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 15, 2008 10:04 AM To: Bhella Paramjeet-PFCW67 Cc: Scott Marlowe; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Pg_statio_user_tables view does not get populated "Bhella Paramjeet-PFCW67" <[EMAIL PROTECTED]> writes: > Yes I did restart the database after making these changes but still > there is no data in pg_statio_user_tables view. Is data appearing in *any* of the pg_stat views? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
