pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Pg_statio_user_tables view does not get populated
6+ messages / 3 participants
[nested] [flat]

* Pg_statio_user_tables view does not get populated
@ 2008-01-15 00:43  Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Bhella Paramjeet-PFCW67 @ 2008-01-15 00:43 UTC (permalink / raw)
  To: pgsql-admin

I have installed postgres 8.2.4 in my development environment. I have
the stats_command_string, stats_start_collector, stats_block_level,
stats_row_level options turned on in postgresql.conf file but still the
pg_statio_user_tables view does not get populated. Is there any other
option I need to enable? Please advice. 

Thanks
Paramjeet Bhella
 



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Pg_statio_user_tables view does not get populated
@ 2008-01-15 15:19  Scott Marlowe <scott.marlowe@gmail.com>
  parent: Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Scott Marlowe @ 2008-01-15 15:19 UTC (permalink / raw)
  To: Bhella Paramjeet-PFCW67 <PBhella@motorola.com>; +Cc: pgsql-admin

On Jan 14, 2008 6:43 PM, Bhella Paramjeet-PFCW67 <PBhella@motorola.com> wrote:
> I have installed postgres 8.2.4 in my development environment. I have
> the stats_command_string, stats_start_collector, stats_block_level,
> stats_row_level options turned on in postgresql.conf file but still the
> pg_statio_user_tables view does not get populated. Is there any other
> option I need to enable? Please advice.

Have you restarted postgresql since making those changes?



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Pg_statio_user_tables view does not get populated
@ 2008-01-15 17:34  Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
  parent: Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Bhella Paramjeet-PFCW67 @ 2008-01-15 17:34 UTC (permalink / raw)
  To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: pgsql-admin

Yes I did restart the database after making these changes but still
there is no data in  pg_statio_user_tables view.

-----Original Message-----
From: Scott Marlowe [mailto:scott.marlowe@gmail.com] 
Sent: Tuesday, January 15, 2008 7:20 AM
To: Bhella Paramjeet-PFCW67
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Pg_statio_user_tables view does not get populated

On Jan 14, 2008 6:43 PM, Bhella Paramjeet-PFCW67 <PBhella@motorola.com>
wrote:
> I have installed postgres 8.2.4 in my development environment. I have 
> the stats_command_string, stats_start_collector, stats_block_level, 
> stats_row_level options turned on in postgresql.conf file but still 
> the pg_statio_user_tables view does not get populated. Is there any 
> other option I need to enable? Please advice.

Have you restarted postgresql since making those changes?



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Pg_statio_user_tables view does not get populated
@ 2008-01-15 18:04  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Tom Lane @ 2008-01-15 18:04 UTC (permalink / raw)
  To: Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>; +Cc: Scott Marlowe <scott.marlowe@gmail.com>; pgsql-admin

"Bhella Paramjeet-PFCW67" <PBhella@Motorola.com> 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



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Pg_statio_user_tables view does not get populated
@ 2008-01-15 18:12  Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 6+ messages in thread

From: Bhella Paramjeet-PFCW67 @ 2008-01-15 18:12 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Scott Marlowe <scott.marlowe@gmail.com>; pgsql-admin

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:tgl@sss.pgh.pa.us] 
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" <PBhella@Motorola.com> 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



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Pg_statio_user_tables view does not get populated
@ 2008-01-15 20:46  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Tom Lane @ 2008-01-15 20:46 UTC (permalink / raw)
  To: Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>; +Cc: Scott Marlowe <scott.marlowe@gmail.com>; pgsql-admin

"Bhella Paramjeet-PFCW67" <PBhella@Motorola.com> writes:
> 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 . 

[ squint.. ]  That's pretty hard to believe --- those views use the same
underlying view, which doesn't even know the difference between system
and user tables.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2008-01-15 20:46 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-15 00:43 Pg_statio_user_tables view does not get populated Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
2008-01-15 15:19 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-01-15 17:34   ` Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
2008-01-15 18:04     ` Tom Lane <tgl@sss.pgh.pa.us>
2008-01-15 18:12       ` Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
2008-01-15 20:46         ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox