cns=# SELECT pg_statistic.* FROM pg_statistic JOIN pg_attribute ON starelid=attrelid WHERE attname='idx_siteid'; starelid | staattnum | stanullfrac | stawidth | stadistinct | stakind1 | stakind2 | stakind3 | stakind4 | staop1 | staop2 | staop3 | staop4 | stanumbers1 | stanumbers2 | stanumbers3 | stanumbers4 | stavalues1 | stavalues2 | stavalues3 | stavalues4 -----------+-----------+-------------+----------+-------------+----------+----------+----------+----------+--------+--------+--------+--------+---------------------------------------------------------------------------------------------------------------------------+-------------+--------------+-------------+------------------------------------------------------------------------+--------------------------------------------------------------------------------+------------+------------ 217001056 | 1 | 0 | 4 | 87 | 1 | 2 | 3 | 0 | 96 | 97 | 97 | 0 | {0.0523333,0.0503333,0.0493333,0.0483333,0.0476667,0.0466667,0.045,0.0423333,0.0396667,0.039} | | {0.0499145} | | {2,365,256,16,347,369,44,1,125,361} | {3,70,93,131,158,167,184,234,273,321,372} | | 217001056 | 2 | 0 | 4 | 146519 | 1 | 2 | 3 | 0 | 96 | 97 | 97 | 0 | {0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667} | | {0.995807} | | {98842,220919,226722,227467,233547,240623,247158,250571,263140,272389} | {7830,107530,219983,235469,254627,275344,300722,329081,368187,400749,444740} | | 217001056 | 3 | 0 | 4 | 43 | 1 | 2 | 3 | 0 | 96 | 97 | 97 | 0 | {0.417333,0.254333,0.099,0.0686667} | | {0.297603} | | {26,24,94,1} | {-1,11,21,29,29,43,47,52,85,104,137} | | 217001056 | 4 | 0 | 4 | 2 | 1 | 3 | 0 | 0 | 96 | 97 | 0 | 0 | {0.610667,0.389333} | {0.500653} | | | {1,0} | | | 217001056 | 5 | 0 | 4 | 6 | 1 | 3 | 0 | 0 | 96 | 97 | 0 | 0 | {0.975,0.0173333,0.00366667,0.00166667,0.00133333,0.001} | {0.945512} | | | {0,6,5,4,2,3} | | | 217001056 | 6 | 0 | 4 | 7 | 1 | 2 | 3 | 0 | 96 | 97 | 97 | 0 | {0.991} | | {0.980425} | | {0} | {1,1,1,5,6,10} | | 217001056 | 7 | 0 | 4 | 1 | 1 | 3 | 0 | 0 | 96 | 97 | 0 | 0 | {1} | {1} | | | {0} | | | 217001056 | 8 | 0 | 4 | 2 | 1 | 3 | 0 | 0 | 96 | 97 | 0 | 0 | {0.95,0.05} | {0.886302} | | | {0,1} | | | 217001056 | 9 | 0 | 2 | 10 | 1 | 2 | 3 | 0 | 94 | 95 | 95 | 0 | {0.55,0.376} | | {0.406768} | | {5,0} | {10,15,15,100,105,105,105,125} | | 217001056 | 10 | 0.753333 | 4 | 670 | 1 | 2 | 3 | 0 | 96 | 97 | 97 | 0 | {0.002,0.002} | | {-0.097821} | | {113202,119271} | {100012,100936,101907,105599,110735,113304,119709,125821,132749,137070,140865} | | 217001056 | 12 | 0.717333 | 4 | 144 | 1 | 2 | 3 | 0 | 96 | 97 | 97 | 0 | {0.0106667,0.00933333,0.009} | | {-0.0338939} | | {900020,900013,900016} | {900001,900017,900042,900047,900270,900451,900550,900575,900617,901048,901546} | | (11 rows) cns=# select count(1),idx_siteid from re_site_listings_index group by idx_siteid; count | idx_siteid -------+------------ 88040 | 1 88050 | 2 18261 | 3 13495 | 6 17010 | 7 2 | 10 3 | 13 88036 | 16 1 | 21 2 | 24 2 | 26 12 | 27 2849 | 28 1 | 29 2 | 35 587 | 40 88034 | 44 4 | 47 3091 | 52 574 | 53 7491 | 55 2 | 56 1 | 61 13495 | 63 8 | 66 1 | 69 20327 | 70 3 | 73 52829 | 74 3468 | 78 1848 | 81 88 | 83 4188 | 84 17023 | 87 9329 | 90 35209 | 93 5583 | 98 10534 | 100 4 | 101 7238 | 102 1435 | 105 1 | 110 7932 | 111 2 | 117 1 | 118 18261 | 119 88038 | 125 19677 | 126 639 | 127 5 | 130 14131 | 131 19677 | 133 1847 | 135 1846 | 136 24225 | 143 6 | 144 5 | 149 17010 | 151 19677 | 154 19681 | 158 20250 | 162 35205 | 163 19677 | 165 1 | 166 35205 | 167 710 | 171 52829 | 173 2874 | 175 373 | 178 1 | 182 66 | 183 52829 | 184 9742 | 190 5 | 192 443 | 194 188 | 196 307 | 198 2 | 199 574 | 200 574 | 201 574 | 202 574 | 203 574 | 204 89 | 205 279 | 208 4 | 209 1846 | 210 17010 | 212 18261 | 215 5 | 228 17010 | 231 18261 | 234 354 | 237 3 | 238 5853 | 247 1 | 250 1 | 251 1 | 252 1 | 253 1 | 254 88034 | 256 12 | 260 2 | 262 1 | 263 20536 | 264 615 | 268 615 | 269 615 | 270 615 | 271 16886 | 272 52829 | 273 1 | 274 1 | 275 1 | 276 1 | 278 3 | 280 92 | 294 10531 | 307 52829 | 319 35604 | 321 251 | 322 1 | 327 5582 | 345 88034 | 347 615 | 350 9747 | 352 2851 | 353 2 | 354 1 | 355 20806 | 356 301 | 358 6177 | 359 3700 | 360 88034 | 361 73 | 363 26676 | 364 88034 | 365 6306 | 366 5627 | 367 18261 | 368 88034 | 369 1384 | 370 1846 | 372 911 | 374 (144 rows)