|
From: Koichi S. <ko...@in...> - 2012-11-06 07:26:41
|
I tested with the current head (sorry) and found pg_statio_user_tables is available. Because this is not distributed tables (not distributed or replicated), query will return only local information of these tables. Please use execute direct to query each node's statistics. Regards; --- Koichi Suzuki On Tue, 06 Nov 2012 15:02:37 +0900 (JST) Tatsuo Ishii <is...@po...> wrote: > Hi, > > It seems I cannot read pg_statio_user_tables from either coordinator or > data node. Is this a known limitation? I just would like to see how I > can confirm UPDATEs distributed among data nodes. > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > English: http://www.sraoss.co.jp/index_en.php > Japanese: http://www.sraoss.co.jp > > ------------------------------------------------------------------------------ > LogMeIn Central: Instant, anywhere, Remote PC access and management. > Stay in control, update software, and manage PCs from one command center > Diagnose problems and improve visibility into emerging IT issues > Automate, monitor and manage. Do more in less time with Central > http://p.sf.net/sfu/logmein12331_d2d > _______________________________________________ > Postgres-xc-general mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > |