How to view a detailed info on data distribution for a specific table in PDA database?

Answer

Below query will print n info how data is distributed:

select database as db_name,
objname as table_name,
dsid, hwid as spu_id,
(allocated_bytes/1048576) as allocated_mbytes,
(used_bytes/1048576) as used_mbytes
from _v_sys_relation_xdb sys, _v_sys_object_dslice_info ds
where ds.tblid = sys.objid
and db_name = 'YOUR_DB'
and table_name = 'SYOUR_TABLE'
order by db_name, table_name, dsid;

A sample output for above query:

DB_NAME | TABLE_NAME | DSID | SPU_ID | ALLOCATED_MBYTES | USED_MBYTES
---------+-------------+------+--------+------------------+-------------
YOUR DB | YOUR TABLE | 1 | 1007 | 2244 | 2242
YOUR DB | YOUR TABLE | 2 | 1007 | 2256 | 2255
YOUR DB | YOUR TABLE | 3 | 1007 | 2244 | 2243
YOUR DB | YOUR TABLE | 4 | 1007 | 2367 | 2366
YOUR DB | YOUR TABLE | 5 | 1145 | 2310 | 2308
YOUR DB | YOUR TABLE | 6 | 1145 | 2412 | 2411
YOUR DB | YOUR TABLE | 7 | 1007 | 2301 | 2300
YOUR DB | YOUR TABLE | 8 | 1007 | 2325 | 2322
YOUR DB | YOUR TABLE | 9 | 1145 | 2178 | 2175
YOUR DB | YOUR TABLE | 10 | 1145 | 2163 | 2160
YOUR DB | YOUR TABLE | 11 | 1145 | 2274 | 2272
YOUR DB | YOUR TABLE | 12 | 1145 | 2235 | 2232
YOUR DB | YOUR TABLE | 13 | 1007 | 2031 | 2028
YOUR DB | YOUR TABLE | 14 | 1007 | 2142 | 2140
YOUR DB | YOUR TABLE | 15 | 1145 | 2133 | 2130
YOUR DB | YOUR TABLE | 16 | 1145 | 2208 | 2206
YOUR DB | YOUR TABLE | 17 | 1145 | 2178 | 2177
YOUR DB | YOUR TABLE | 18 | 1145 | 2145 | 2142
YOUR DB | YOUR TABLE | 19 | 1145 | 1815 | 1812
YOUR DB | YOUR TABLE | 20 | 1145 | 2022 | 2019
YOUR DB | YOUR TABLE | 21 | 1007 | 2106 | 2103
YOUR DB | YOUR TABLE | 22 | 1007 | 1992 | 1990
YOUR DB | YOUR TABLE | 23 | 1007 | 1983 | 1982
YOUR DB | YOUR TABLE | 24 | 1007 | 2157 | 2156
YOUR DB | YOUR TABLE | 25 | 1145 | 1941 | 1939
YOUR DB | YOUR TABLE | 26 | 1145 | 1752 | 1750
YOUR DB | YOUR TABLE | 27 | 1145 | 1986 | 1983
YOUR DB | YOUR TABLE | 28 | 1145 | 2226 | 2223
YOUR DB | YOUR TABLE | 29 | 1007 | 2220 | 2217
YOUR DB | YOUR TABLE | 30 | 1007 | 2256 | 2253
YOUR DB | YOUR TABLE | 31 | 1007 | 2202 | 2201
YOUR DB | YOUR TABLE | 32 | 1007 | 2139 | 2137
YOUR DB | YOUR TABLE | 33 | 1007 | 2043 | 2041
YOUR DB | YOUR TABLE | 34 | 1007 | 2073 | 2072
YOUR DB | YOUR TABLE | 35 | 1145 | 2148 | 2146
YOUR DB | YOUR TABLE | 36 | 1145 | 2067 | 2064
YOUR DB | YOUR TABLE | 37 | 1145 | 2133 | 2130
YOUR DB | YOUR TABLE | 38 | 1145 | 2355 | 2354
YOUR DB | YOUR TABLE | 39 | 1007 | 2019 | 2018
YOUR DB | YOUR TABLE | 40 | 1007 | 2100 | 2098
(40 rows)