|
From: Tatsuo I. <is...@po...> - 2012-11-06 07:35:42
|
I sent a query to coordinator node and got following result. Doesn't
this means table "pgbench_accounts" distributed?
test=# select * from pgxc_class as x join pg_class as c on x.pcrelid = c.oid where c.relname = 'pgbench_accounts';
-[ RECORD 1 ]---+-----------------
pcrelid | 16413
pclocatortype | H
pcattnum | 1
pchashalgorithm | 1
pchashbuckets | 4096
nodeoids | 16384 16385
relname | pgbench_accounts
relnamespace | 2200
reltype | 16415
reloftype | 0
relowner | 10
relam | 0
relfilenode | 16419
reltablespace | 0
relpages | 0
reltuples | 0
reltoastrelid | 0
reltoastidxid | 0
relhasindex | t
relisshared | f
relpersistence | p
relkind | r
relnatts | 4
relchecks | 0
relhasoids | f
relhaspkey | t
relhasrules | f
relhastriggers | f
relhassubclass | f
relfrozenxid | 78651
relacl |
reloptions | {fillfactor=100}
> 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
>>
|