pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPg_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