pg_stats
text/plain
Filename: pg_stats
Type: text/plain
Part: 0
tablename | attname | null_frac | avg_width | n_distinct | most_common_vals | most_common_freqs | histogram_bounds | correlation
-----------+---------+-----------+-----------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------
foo | id | 0 | 4 | -1 | | | {10000028,10044844,10084132,10127060,10168908,10208677,10251756,10298604,10337189,10383913,10423409} | -0.563276
foo | name | 0 | 21 | 32304 | {"Andreas Müller","Dirk Bäcker","Frank Müller","Horst Graf","Marc Müller","Martin Schneider","SCS GmbH","Stefan Schmidt","Thorsten Fischer"} | {0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667} | {"1 & 1 Internet Service GmbH","Berufsfachschule für Krankenpf' lege am KKH Dinkelsbühl","Dina Schreckeis","Gerhard Lahr","Institute for Enzymology","Lambrakis Research Foundation' leanthis Kremmidas","Michael Brodersen","PlanConsult Kraneis&Partner Gm' bH","Solutions 4 Ideas","Torsten Binias","Özcan Ferhat"} | 0.0231532
foo | street | 0 | 19 | 31973 | {" ","Berliner Str. 19","Otto-Hahn-Ring 6","Bahnhofstr. 54","Breslauer Str. 15","Dorfstr. 18","Dorfstr. 24","Gabelsberger Str. 12","Lindenstr. 20","Mühlenweg 2"} | {0.007,0.001,0.001,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667} | {"'Boskenna', Green Lane","Am Staubecken 1e","Brandenburger Weg 1","Fasanenstr. 7","Hauptstr. 52","Karl-Schmolz-Str 4","Margaretenstr. 8","Pfarrwiese 12a","Schneewittchenstr. 24","Univ.of Nottingham, Univ.Park","Über der Elz 4"} | 0.0199549
foo | zip | 0 | 8 | 19968 | {" ",99999,999,1210,61440,70771,80538,81739,10785,1090} | {0.018,0.00366667,0.00266667,0.00166667,0.00166667,0.00166667,0.00166667,0.00166667,0.00133333,0.00133333} | {*,13127,25337,"3437 AE",44230,52078,63303,71397,81369,90403,"W6 8LJ"} | 0.0547398
foo | city | 0 | 12 | 14577 | {Berlin,München,Hamburg,Frankfurt,Nürnberg,Wien,Stuttgart,Düsseldorf,Köln,Bonn} | {0.037,0.0266667,0.0216667,0.0116667,0.0103333,0.0103333,0.00833333,0.008,0.00766667,0.00733333} | {*,Bochum,Dortmund,Gelnhausen,Herten,"Krumbach OT Niederraunau",Mettingen,Paderborn,Schellerten,Valladolid,Ütze} | 0.0473121
foo | tel | 0 | 12 | 22744 | {" "} | {0.3} | {" 49 (0)441 798-2913",0039-0522971069,0170-9810773,0228-6420301,030-6931606,04084002600,05409-6465,06421-21327,07231/75220,089-31692761,972-3-6203038} | 0.219408
foo | fax | 0 | 5 | 12 | {" "} | {0.999667} | | 0.999994
(7 rows)