Re: cannot get stable function to use index - Mailing list pgsql-general
| From | Andy Colson |
|---|---|
| Subject | Re: cannot get stable function to use index |
| Date | |
| Msg-id | 56842EA3.3020607@squeakycode.net Whole thread Raw |
| In response to | Re: cannot get stable function to use index (Tom Lane <tgl@sss.pgh.pa.us>) |
| Responses |
Re: cannot get stable function to use index
(Andy Colson <andy@squeakycode.net>)
Re: cannot get stable function to use index (Tom Lane <tgl@sss.pgh.pa.us>) |
| List | pgsql-general |
On 12/30/2015 1:07 PM, Tom Lane wrote: > I wrote: >> This says there's only about a 25% runtime penalty for the partial match, >> at least on your example, compared to the planner's estimate of 2700x >> penalty :-(. Definitely need to fix that. > > I tried to reproduce this behavior with simple generated data, and could > not: the estimates seem to track the actual cost reasonably well. So > it seems like you've got some weird data statistics that are causing a > misestimate. Could we see the pg_stats row for that tsvector column? > Or maybe even the actual data? > > regards, tom lane > The table exists in a schema named jasperia, I've been removing the name for simplicity. The dump of the table is here: http://camavision.com/dn/search.sql.bz2 Here is the pg_stats, I hope word wrap doesn't mess this up too bad: schemaname | tablename | attname | inherited | null_frac | avg_width | n_distinct | most_common_vals | most_common_freqs | histogram_bounds | correlation | most_common_elems | most_common_elem_freqs | elem_count_histogram ------------+-----------+------------+-----------+-----------+-----------+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------- jasperia | search | gid | f | 0 | 4 | -0.364807 | {152772,155637,155982,156520,157031,160805,165284,165865,172081,172100,172238,172373,172399,172412,172623,172727,176093,176096,176127,176146,176159,176162,176171,176185,176213,176236,176286,176390,176421,176635,176642,176668,176670,176859,177049,177071,177261,177306,177334,177359,178054,178097,178208,178382,178483,149328,149364,149384,149387,149392,149410,149425,149437,149438,149444,149472,149474,149476,149489,149493,149500,149540,149543,149549,149555,149571,149582,149585,149592,149617,149620,149658,149666,149675,149715,149719,149745,149783,149801,149818,149820,149842,149860,149894,149912,149920,149927,149941,149955,149957,150044,150067,150068,150079,150109,150126,150145,150156,150187,150216} | {0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001} | {149330,149636,149928,150207,150470,150722,150980,151230,151517,151759,152008,152246,152495,152763,153013,153280,153550,153806,154074,154334,154595,154866,155125,155394,155658,155919,156213,156513,156783,157054,157325,157579,157837,158127,158392,158654,158929,159211,159554,159876,160225,160554,160880,161218,161563,161917,162270,162646,162989,163307,163678,164067,164404,164719,165042,165355,165695,166049,166382,166726,167054,167377,167720,168045,168367,168728,169017,169314,169668,169990,170304,170622,170948,171276,171600,171944,172231,172481,172748,173089,173434,173780,174112,174437,174768,175107,175439,175813,176089,176312,176528,176747,176956,177182,177445,177716,178008,178263,178569,178870,179207} | 0.300417 | | | jasperia | search | type | f | 0 | 4 | 5 | {deed,pin,add,dba,cont} | {0.380367,0.371067,0.212667,0.0239667,0.0119333} | | 0.904334 | | | jasperia | search | descr | f | 0 | 20 | -0.647676 | {"CITY OF NEWTON","IOWA INTERSTATE RAILROAD LTD","U S FISH & WILDLIFE SERVICE","TALSMA LAND HOLDINGS LLLP","JASPER COUNTY","FARRELL PROPERTIES INC",CONVERSION,"STATE OF IOWA","WINCHESTER CARRIAGE INC","WILSON AGRI INC","IOWA NATURAL HERITAGE FOUNDATION","ROCK CREEK STATE PARK","CITY OF PRAIRIE CITY","JASPER COUNTY CONSERVATION BOARD","VACANT LOT","VERMEER FARMS INC,% VERMEER MFG","WEHRLE FARMS LLC","BIRKENHOLTZ, LARRY D & JONE M TRUSTS-TRUSTEES","CENTRALLY ASSESSED","HEALY FARM TRUST %VANZEE FARM MGMT CO","JANSEN, JERRY G & LINDA D REV TRUST/TRUSTEES","ROORDA FAMILY FARMS LLC","BARTELMA FARMS INC","BIRKENHOLTZ, LARRY D TRUST ETAL","BRUMMEL, BRUCE L & LINDA L","CITY OF COLFAX","CLEVENGER PROPERTIES LLC","PCW FARMLAND LLC","STATE OF IOWA IOWA DEPT OF NATURAL RESOURCES","SNOOK, W T INC","BROWN, MERL G REV TRUST/TRUSTEE 1/2 & GERDENA M REV TRUST/TRUSTEE 1/2","CHICHAQUA BIKE TRAIL","ELLIOTT, GUY","LAPLANT, JAMES R & CAROL A","LOUDEN FARMS INC","MORRIS, JERRY REV TRUST/TRUSTEE","PRENDERGAST, DAVID J REV TRST TRSTEE 1/2 & LILLIAN REV TRST TRSTEE 1/2","VANSLAND LTD","CENTRAL IOWA WATER ASSOCIATION","CITY OF KELLOGG","CITY OF MONROE","GANNON FARM INC","MARTIN MARIETTA MATERIALS INC","MERCY PROFESSIONAL PRACTICE ASSOCIATES INC","RO-DEN-CRIS INC","RUNNER, BEATRICE D LE & HUTCHESON, JANET K ETAL RMDR","SCHNELL FARMS INC,% SCHNELL, DAVID","BIRKENHOLTZ, LARRY D TRUST & JONE TRUST","BRUMMEL, BRUCE & LINDA (JT)","DEGREEF, FREDA L LE 1/2 & DEGREEF, FREDA L 1/2","DITTMER, JEREMY J & JACQUELYN J (JT)","HANSON, NOLA & VANGINKEL, MARGARET E REV TRUST","LUST, JANET S LIVING TRUST/TRUSTEE & LUST CARD D TRUSTEE","MAGGARD, MAX E & GLORIA JOYCE REV TRUST","O'ROAKE, CHARLES J & THERESA M","PIERCE, IRENE I REV TRUST","POAGE, WAYNE C & IRMA C REVOCABLE TRUST/TRUSTEES","RUMBAUGH, CARROLL & JUDY","SHARP FARMS INC","WORMLEY, JACK M & CHLORESSA DEW TRUSTS","2201 RUSTY WALLACE DR","BAXTER ECONOMIC DEVELOPMENT CORPORATION","BUCK CREEK FARMS PRTSHP LLP","FATLAND, JOHN L TRUST/TRUSTEE & DONITA V TRUST/TRUSTEE","GANNON, WILLIAM J & KATHLEEN KENNEDY","GUTHRIE, ILLA G REV TRUST","JANSCO FARMS INC","KADING PROPERTIES LLC","LIVINGSTON, JEAN ANN","STATE OF IOWA IOWA DEPT OF NATURAL RESOURCES(REAP)","STEENHOEK, HARLEY H & PHILLIS B REV TRUST/TRUSTEES","VERSENDAAL, DEXTER B & TERESA K (JT)","WILSON, SHERYL V REV TRUST","ASHBY, ROBERT W-MARY MARGARET REVOCABLE TRUST-TRUSTEES","BACKUS, KAREN S","BLOM, ALLEN LEROY 1/2 & BLOM, GREGORY ALLEN & ETALS 1/2","CITY OF BAXTER","CITY OF NEWTON IOWA","CRH PROPERTIES LLC","FLOSS FARMS INC","HANSON, SHIRLEY LADD REV TRUST/TRUSTEE","HEARTLAND COOP","KJ FARMS LLC","MCKLVEEN, J H & COMPANY","NEARMYER, RICHARD L",PARSONAGE,"ROUSH, ELAINE M & ROUSH, ELAINE M LE & ROUSH, HAROLD JAY 1/2 OF LE & ETAL","TAYLOR FARMS LLC","TRI-LEONARD FARMS LLC",VACANT,"VANHEMERT, KEITH","VANROEKEL & SONS INC","VANSICE, CHARLES R & LINDA S","VOS, MELDON L & ELOISE J","WEBB, PHILIP F","ARCHER PROPERTIES INC","BEALS, LARRY J FAMILY TRUST 1/2 BEALS, DONNA R 1/2","BEATTY, ALICE T","BEYER, DENNIS L","BRANDHOF, JOHN EDWARD & LEONA W REV TRUST/TRUSTEES"} | {0.00213333,0.00206667,0.0017,0.00166667,0.00143333,0.0009,0.000766667,0.000766667,0.000766667,0.0007,0.000666667,0.000666667,0.0006,0.0006,0.0006,0.0006,0.0006,0.000566667,0.000533333,0.000533333,0.000533333,0.000533333,0.000466667,0.000466667,0.000466667,0.000466667,0.000466667,0.000466667,0.000466667,0.000433333,0.0004,0.0004,0.0004,0.0004,0.0004,0.0004,0.0004,0.0004,0.000366667,0.000366667,0.000366667,0.000366667,0.000366667,0.000366667,0.000366667,0.000366667,0.000366667,0.000333333,0.000333333,0.000333333,0.000333333,0.000333333,0.000333333,0.000333333,0.000333333,0.000333333,0.000333333,0.000333333,0.000333333,0.000333333,0.0003,0.0003,0.0003,0.0003,0.0003,0.0003,0.0003,0.0003,0.0003,0.0003,0.0003,0.0003,0.0003,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000 233333,0.000233333,0.000233333,0.000233333,0.000233333} | {"",01.33.400.002,02.14.380.010,02.34.300.002,03.33.300.009,05.03.300.004,06.03.301.028,06.22.100.005,07.18.300.004,08.15.100.009,08.26.331.013,08.27.327.007,08.28.401.033,08.33.176.006,08.33.429.011,08.34.180.013,08.34.304.036,08.35.201.001,08.35.406.007,09.22.200.007,"10 VALLEY VIEW DR",10.22.301.002,"101 1 AVE W","10532 W 76 ST N",11.01.379.001,11.12.151.009,11.35.300.901,"11321 HWY S-62 N",12.07.400.008,"1208 W 9 ST S",13.03.301.005,13.13.100.006,"1308 S 8 AVE E",14.16.300.008,"1412 W 28 ST N",15.18.400.001,16.01.103.004,16.04.400.001,"1609 MONROE DR",17.25.454.003,17.36.404.003,18.19.100.007,"1807 S 4 AVE E",19.29.300.001,20.08.137.002,20.14.300.002,"2020 1 AVE E","2136A E 60 ST S","2609 HWY S-74 S","307 E STATION ST","323 BROAD ST","404 KAYLA LANE","4254 JEWEL ST","504 E 20 ST S","5309 E 5 ST S","605 W SHERMAN","6401 W 140 ST S","710 E 13 ST N","7793 HWY 6 E","826 S 5 AVE W","913 S 8 AVE W","AIKIN, KENDALL D","BABCOCK, MARK O,& DIANE R","BELL, ROBERT F,& VIRGINIA","BOOT, BRIAN & ETALS","BUCK CREEK FARMS PARTNERSHIP LLP","CDC OF JASPER COUNTY INC","COCHRANE, JUSTIN & BRIDGET (JT)","CW GRIFFITH PROPERTIES LLC","DEROUCHEY, DAVID,& ANNETTE","DURR, JAMES WILLIAM","ESTANCIA VIDA BUENA LLC","FORTUNE, DONALD JR,& GWENDOLYN","GOOCH, DAVID R,& JOAN K","HANEL FARMS LLC","HERREMA, DENNIS J & PAM S","HUGEN, WILBUR B REV TRUST, HUGEN, WILLIAM WAYNE TRUSTEE","JANSEN, DONALD,& KAREN","KALDENBERG, ALICIA M","KRAMER, STEVE ALLEN & KATIE JEANNE (JT)","LEWIS, MARTY L,& JOYCE A","MAHL, TIMOTHY SCOTT,& AMY","MCILRATH, ALICE L","MILLIGAN, MARK D & CHRISTIE D","NEARMYER FARM CO","OKLAND ACRES GOLF CLUB","PESKA, KEVIN,& TONI","RABEDEAUX, CYNTHIA D LIVING TRUST/TRUSTEE & STEVEN G TRUSTEE","ROGAHN, MATTHEW G","SANDQUIST, WILLIAM & COLEEN","SHARPNACK, THOMAS","SOLID ROCK CHURCH","STROVERS, MARILYN R REV TRUST","THOMAS, CINDY L","UNITED METHODIST CHURCH","VANGENDEREN, RONALD L,& LOIS VIRGINIA","VANWYK, DIRK & JOURDAN","VERSTEEGT, AMY H 1/2 INT LE 1/2 INT RMDR ETAL","WATTS, BENJAMIN DANIEL","WILSON, HAROLD T,& PAULA","ZYZANSKI, STEPHEN J TRUST-TRUSTEE"} | -0.382801 | | | jasperia | search | search_vec | f | 0 | 45 | -1 | | | | | {1,2,3,4,5,6,7,8,9,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,r,s,t,u,v,w,z,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,32,35,36,39,44,48,51,52,59,60,62,64,65,67,68,75,76,80,83,84,88,92,95,99,av,co,ct,dr,ii,jo,jr,jt,lc,le,ln,lp,of,op,pl,pr,rd,ro,sr,st,vw,-12,-17,-33,-36,-38,-48,-52,-62,-70,-74,1/2,1/3,1/4,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,120,121,124,125,128,132,140,142,148,156,1st,2/3,200,201,202,203,204,205,206,207,208,209,210,211,213,214,222,224,2nd,3/4,300,301,302,303,304,305,306,307,308,309,310,312,313,314,315,317,321,3rd,400,401,402,403,404,405,406,407,408,409,410,411,415,421,4th,500,501,502,503,504,505,506,507,508,510,513,516,5th,600,601,602,603,604,605,606,607,608,609,610,611,615,620,700,701,702,703,704,705,706,707,708,709,710,711,712,715,720,800,801,802,807,8th,901,acr,ami,and,ann,cir,cox,ctr,dan,dee,den,don,dop,est,fay,guy,hay,hwi,iii,inc,int,jay,jen,joe,jon,joy,kay,lee,leo,llc,llp,loi,lot,lou,ltd,mae,mat,max,mfg,oak,pcw,rae,ray,res, rev,rex,roy,son,sta,sue,the,tom,trl,vos,way,1000,1101,2201,adam,agri,alan,alic,anna,area,ball,bank,barr,beal,bell,beth,bike,blom,bort,buck,buns,burn,carl,chad,citi,clay,club,coop,corp,cris,dale,dana,davi,dawn,dean,depp,dept,dian,dodg,dori,doug,doyl,duan,each,earl,engl,eric,etal,farm,fish,fred,gail,gari,gene,glen,golf,hall,hast,high,hill,hold,holm,home,hous,hugh,illa,iowa,iren,irma,jack,jame,jami,jana,jane,jani,jayn,jean,jeff,jill,joan,jodi,joel,john,jone,joyc,judi,juli,june,kane,kent,keun,kirk,kurt,kyle,ladd,lanc,land,lenz,leon,lewi,life,lisa,live,lllp,long,lori,loui,lust,lynn,main,mapl,mari,mark,merl,mgmt,moor,oliv,owen,park,paul,reed,rene,rick,rmdr,roak,rock,rose,ross,rusk,ruth,ryan,sage,sara,teri,tina,todd,toni,troy,trst,unit,wade,wayn,webb,wood,york,12790,aaron,allan,allen,alvin,amber,apart,arvin,ashbi,baker,barri,beard,betti,bever,beyer,billi,board,bonni,booth,brand,brent,brian,brown,bruce,bryan,bryce,carol,carri,casey,cathi,cecil,charl,chris,cindi,clair,clark,co-op,conni,craig, creek,cross,cuppl,curti,dairi,danni,daryl,david,debra,delor,denis,denni,devri,diana,divis,donna,edith,edwin,ehler,elain,ellen,elois,emili,eugen,field,first,floss,floyd,franc,frank,freda,front,georg,glenn,grain,harri,hazel,heali,helen,henri,holli,jacob,janet,janic,jason,jeann,jerri,jewel,jimmi,joann,julia,junip,karen,kathi,keith,kelli,kevin,l-est,laird,larri,laura,leagu,leona,leroy,lesli,linda,lloyd,louis,lowel,lynda,maher,maria,merci,meyer,mildr,mingo,monro,morri,nanci,natur,nicol,nolin,norma,nuzum,patti,paula,peggi,penni,peter,pierc,plumb,ralph,randi,revoc,robin,roger,roush,rusti,salli,sarah,savag,scott,sharp,shawn,smith,snook,spark,staci,state,steve,stock,store,sulli,susan,swank,swift,tammi,terri,thoma,tower,traci,travi,trust,union,vanze,vicki,wanda,water,wehrl,wendi,weyer,white,wilma,woodi,young,amanda,andrea,andrew,angela,arthur,ashley,assess,associ,atwood,backus,barton,baxter,brenda,butler,calvin,carrol,carson,cheryl,church,coleen,colett,colfax,colleg,conrad,cooper,corpor,counti ,daniel,darlen,darrel,darwin,deanna,decook,degoey,dejong,delmar,deraad,donald,donita,dougla,dwight,econom,edward,ernest,esther,evelyn,famili,farmer,farrel,fisher,forest,foster,franci,gannon,gerald,gloria,gordon,graham,guthri,hammer,hansen,hanson,harlan,harold,hesson,hewitt,howard,hunter,huyser,invest,jansen,jasper,jennif,jeremi,joseph,joshua,judith,justin,keenan,kelley,kendal,kimber,kramer,kristi,kunkel,legaci,legion,lester,locust,louden,machin,manatt,marcia,marion,market,marlen,marlin,martha,martin,marvin,materi,maxwel,maytag,meadow,melvin,michel,miller,morgan,nathan,nation,nelson,newton,nikkel,norman,osborn,oswalt,pamela,parker,paulin,philip,phylli,rachel,randal,rankin,reform,regina,renaud,rental,rhonda,rippey,robert,rodger,rodney,ronald,roorda,runner,russel,sandra,school,season,second,servic,sharon,sherri,sheryl,simbro,spring,steven,storag,sylvia,talsma,taylor,teresa,thelma,trstee,truste,vacant,valeri,valley,vansic,vanwyk,vaughn,verlan,vernon,walker,wallac,walnut,walter,warner,war ren,weaver,wesley,wilbur,wilson,wright,altemei,anthoni,barbara,beatric,benskin,beukema,bradley,brandon,brother,brummel,bucklin,campbel,carolyn,carriag,central,charlen,clayton,clement,cleveng,colleen,commerc,compani,conserv,convers,crystal,cynthia,deborah,degreef,develop,dezwart,diamond,dittmer,donovan,dorothi,elliott,exchang,faidley,foundat,gerdena,gifford,gilbert,gregori,hackert,heather,herbold,heritag,interst,jackson,jeffrey,jessica,johnson,kaisand,kathryn,kellogg,kenneth,kristin,laplant,lawrenc,leonard,lillian,lincoln,lynnett,maasdam,madison,maggard,marilyn,marjori,marshal,matthew,meisner,melinda,melissa,michael,michell,mitchel,moffitt,nichola,patrick,phillip,practic,raymond,rebecca,resourc,richard,rozenda,schmidt,schnell,schwarz,shannon,sherman,shirley,societi,stanley,stephen,stewart,straver,terlouw,theresa,timothi,vangorp,vanzant,vermeer,wildlif,william,wormley,zylstra,american,anderson,bartelma,benjamin,brandhof,broadway,buchanan,catherin,cemeteri,chadwick,charlott,christin,cli fford,communic,constanc,disclaim,district,farmland,ferguson,franklin,goodrich,hagedorn,harrison,humphrey,jonathan,kathleen,landgreb,langmaid,lynnvill,margaret,marietta,mcgregor,mckibbin,mcklveen,mcmurray,milligan,nearmyer,parsonag,patricia,peterson,pleasant,properti,railroad,robinson,rumbaugh,schuster,stephani,terpstra,thompson,vandalen,vansland,verploeg,virginia,winchest,woodland,bruxvoort,chichaqua,christian,christina,christoph,cleverley,communiti,davenport,elizabeth,enterpris,heartland,hutcheson,jacquelyn,jefferson,kimberley,methodist,northcutt,patterson,steenhoek,vanginkel,vanhemert,vankooten,vanmaanen,vanroekel,vanryswyk,vansoelen,willemsen,birkenholz,dunsbergen,kaldenberg,livingston,manufactur,montgomeri,profession,richardson,ro-den-cri,vanderhart,vanderkamp,vanderwilt,washington,birkenholtz,breckenridg,partnership,prendergast,trst/trstee,vanderleest,vangenderen,trust-truste,vanderweerdt,vanwyngarden,trust/trustee,trusts-truste,vandusseldorp,trust/trustees} | {0.00596667,0.00653333,0.006,0.00926667,0.0063,0.00603333,0.00396667,0.00756667,0.0046,0.0342333,0.0067,0.0133333,0.0252,0.109733,0.0114667,0.0091,0.0061,0.00353333,0.0371333,0.0176,0.0532333,0.0275667,0.0681667,0.00223333,0.00636667,0.0213333,0.0981,0.0081,0.00216667,0.00313333,0.0881667,0.0004,0.0038,0.00343333,0.00576667,0.00413333,0.0047,0.00403333,0.0025,0.0018,0.00196667,0.0031,0.00223333,0.0011,0.000666667,0.0013,0.00103333,0.0008,0.000433333,0.0007,0.0024,0.000666667,0.0005,0.00153333,0.0008,0.000966667,0.000366667,0.0006,0.0015,0.0004,0.00163333,0.0006,0.000766667,0.0004,0.000433333,0.00103333,0.000533333,0.00143333,0.000466667,0.0004,0.000933333,0.000666667,0.0008,0.000566667,0.000633333,0.0693667,0.00223333,0.0015,0.00476667,0.000933333,0.00223333,0.00376667,0.0584333,0.0007,0.00376667,0.0015,0.000966667,0.0107667,0.000433333,0.00283333,0.00173333,0.000866667,0.0004,0.000466667,0.108533,0.000766667,0.0006,0.00113333,0.0004,0.001,0.00136667,0.0014,0.0004,0.00136667,0.00043 3333,0.000666667,0.0151667,0.00116667,0.00116667,0.00126667,0.000866667,0.0007,0.000933333,0.0017,0.000633333,0.000766667,0.0017,0.00123333,0.000833333,0.0009,0.000866667,0.00133333,0.0004,0.000466667,0.000933333,0.00123333,0.00126667,0.000966667,0.0005,0.00133333,0.0004,0.000533333,0.000533333,0.000866667,0.0004,0.000766667,0.000466667,0.000533333,0.000766667,0.000833333,0.0007,0.000933333,0.0008,0.0011,0.000766667,0.0008,0.00113333,0.000433333,0.0006,0.0008,0.000533333,0.0005,0.000566667,0.0004,0.0007,0.0004,0.000633333,0.000466667,0.000866667,0.001,0.000866667,0.0006,0.00123333,0.000866667,0.0009,0.0009,0.000966667,0.0008,0.000733333,0.000633333,0.0008,0.0007,0.000366667,0.000366667,0.000466667,0.0007,0.001,0.000666667,0.000933333,0.000766667,0.000733333,0.000933333,0.000866667,0.0005,0.0006,0.000833333,0.000433333,0.000366667,0.0004,0.000433333,0.0007,0.0014,0.000766667,0.000766667,0.000733333,0.000733333,0.000566667,0.000633333,0.0004,0.0005,0.000466667,0.000433333,0.0007,0.0006 66667,0.000966667,0.000966667,0.00123333,0.0006,0.0006,0.000633333,0.0006,0.000733333,0.000566667,0.0005,0.0005,0.0004,0.0004,0.000733333,0.0006,0.0008,0.000566667,0.000366667,0.000466667,0.000466667,0.0005,0.000533333,0.000433333,0.000533333,0.000366667,0.000566667,0.000433333,0.000366667,0.000433333,0.000466667,0.0005,0.0004,0.000633333,0.000433333,0.000533333,0.0019,0.000433333,0.00706667,0.000366667,0.000433333,0.00136667,0.000433333,0.000633333,0.0004,0.000766667,0.000633333,0.00453333,0.0008,0.001,0.000966667,0.0153,0.0007,0.0174333,0.00226667,0.00103333,0.000366667,0.000533333,0.000766667,0.000366667,0.0027,0.00463333,0.000433333,0.0163333,0.000733333,0.00113333,0.000866667,0.000666667,0.00356667,0.00123333,0.0005,0.00146667,0.000633333,0.0014,0.000466667,0.000966667,0.0015,0.000433333,0.0207667,0.000433333,0.0006,0.000733333,0.00146667,0.003,0.000833333,0.000433333,0.000733333,0.00226667,0.0004,0.000366667,0.000366667,0.000466667,0.000966667,0.0009,0.0014,0.00156667,0.0007333 33,0.0005,0.0005,0.00123333,0.000366667,0.000366667,0.00153333,0.0009,0.0004,0.000566667,0.000366667,0.000633333,0.0006,0.000466667,0.00146667,0.0012,0.00666667,0.000433333,0.0005,0.000833333,0.00166667,0.0004,0.00313333,0.000433333,0.0006,0.000966667,0.00343333,0.0006,0.00116667,0.00226667,0.0004,0.0007,0.000366667,0.000433333,0.00143333,0.000933333,0.00123333,0.0007,0.00163333,0.0117,0.0166667,0.00173333,0.000533333,0.000366667,0.00403333,0.00136667,0.00106667,0.000766667,0.000433333,0.0004,0.00143333,0.000766667,0.00186667,0.000633333,0.0009,0.0006,0.000366667,0.000433333,0.0083,0.00123333,0.000366667,0.0012,0.01,0.000366667,0.000433333,0.00276667,0.000833333,0.0008,0.0038,0.0006,0.000533333,0.00173333,0.0011,0.00133333,0.0091,0.00216667,0.00303333,0.0019,0.0016,0.0006,0.000433333,0.000766667,0.000633333,0.000533333,0.000366667,0.0005,0.0004,0.000466667,0.0025,0.0005,0.000433333,0.000633333,0.0006,0.00136667,0.00353333,0.00193333,0.000633333,0.00193333,0.000433333,0.00123333,0.003 13333,0.0039,0.000533333,0.00963333,0.00446667,0.0005,0.000766667,0.000733333,0.000466667,0.000366667,0.00356667,0.00376667,0.000366667,0.000433333,0.000933333,0.005,0.000466667,0.00216667,0.000633333,0.0006,0.000433333,0.0026,0.0014,0.000533333,0.000533333,0.0004,0.0005,0.0025,0.0009,0.0009,0.0023,0.00163333,0.0004,0.00286667,0.000766667,0.000766667,0.000666667,0.000366667,0.000533333,0.0004,0.0019,0.0004,0.000433333,0.000733333,0.0008,0.000566667,0.0006,0.000733333,0.0004,0.00336667,0.00163333,0.00136667,0.000633333,0.000866667,0.00106667,0.0004,0.0008,0.000666667,0.0024,0.00183333,0.00213333,0.0005,0.000566667,0.00276667,0.0004,0.000533333,0.000366667,0.000433333,0.00483333,0.000766667,0.00166667,0.000433333,0.000766667,0.000433333,0.00136667,0.0029,0.00286667,0.0006,0.000633333,0.0023,0.000466667,0.0009,0.000466667,0.0109,0.00193333,0.0004,0.00103333,0.00476667,0.00153333,0.000933333,0.001,0.00326667,0.000433333,0.000666667,0.00103333,0.00103333,0.00153333,0.0004,0.0006,0.0015666 7,0.000533333,0.00173333,0.0005,0.000366667,0.000566667,0.0016,0.000466667,0.000733333,0.00116667,0.0006,0.0004,0.000733333,0.0004,0.000566667,0.0017,0.001,0.0004,0.000566667,0.00376667,0.00176667,0.00156667,0.000566667,0.0029,0.000366667,0.000466667,0.000833333,0.000666667,0.000566667,0.00343333,0.00113333,0.0019,0.00163333,0.00243333,0.00336667,0.0004,0.0068,0.00173333,0.000566667,0.0005,0.000666667,0.000633333,0.0075,0.000566667,0.0005,0.000433333,0.000366667,0.0006,0.000366667,0.0004,0.0009,0.000833333,0.0005,0.00223333,0.0008,0.00243333,0.00176667,0.000433333,0.0008,0.00106667,0.000366667,0.000633333,0.000533333,0.000366667,0.000366667,0.000833333,0.00113333,0.000666667,0.001,0.0015,0.00313333,0.0007,0.00236667,0.0008,0.000533333,0.000466667,0.000666667,0.000533333,0.0036,0.0005,0.000633333,0.0034,0.0007,0.000366667,0.0005,0.0044,0.001,0.000366667,0.0004,0.00123333,0.00266667,0.000566667,0.000366667,0.000466667,0.00176667,0.00366667,0.0006,0.000733333,0.000533333,0.0268333,0.000 366667,0.0018,0.0014,0.000366667,0.00133333,0.0008,0.0005,0.0004,0.0007,0.0006,0.000533333,0.0006,0.000766667,0.0005,0.00146667,0.000866667,0.0011,0.0005,0.000533333,0.00183333,0.0004,0.000466667,0.0004,0.00126667,0.00196667,0.000533333,0.000366667,0.00233333,0.0004,0.0011,0.00343333,0.000366667,0.000466667,0.00206667,0.000466667,0.000366667,0.000833333,0.00173333,0.0032,0.00296667,0.0009,0.00123333,0.000366667,0.0006,0.000466667,0.000366667,0.000566667,0.000466667,0.000366667,0.00496667,0.0004,0.0029,0.00133333,0.0004,0.00246667,0.000766667,0.0004,0.000666667,0.00636667,0.000366667,0.00103333,0.0005,0.0004,0.0004,0.0006,0.00173333,0.000866667,0.000933333,0.000966667,0.0004,0.000566667,0.000433333,0.000633333,0.000833333,0.000366667,0.00153333,0.0005,0.000666667,0.000633333,0.000533333,0.0011,0.00113333,0.0025,0.00453333,0.0019,0.000866667,0.00166667,0.0006,0.00166667,0.000533333,0.000466667,0.000366667,0.0004,0.0015,0.000433333,0.0004,0.000466667,0.000433333,0.000466667,0.0005,0.000 566667,0.0005,0.0005,0.0004,0.00123333,0.0009,0.0004,0.0004,0.000433333,0.000866667,0.0013,0.00176667,0.000366667,0.000833333,0.0004,0.0004,0.00143333,0.000666667,0.0015,0.0005,0.000633333,0.000433333,0.0006,0.0052,0.0007,0.00146667,0.000433333,0.0004,0.00193333,0.0006,0.000366667,0.0007,0.000866667,0.000533333,0.0016,0.000433333,0.000433333,0.000433333,0.0004,0.000533333,0.000966667,0.000566667,0.00723333,0.0005,0.0009,0.0044,0.001,0.000733333,0.00156667,0.0027,0.000666667,0.000366667,0.000466667,0.0028,0.0016,0.000533333,0.0012,0.0004,0.000766667,0.00346667,0.0006,0.0004,0.0021,0.0011,0.00156667,0.000433333,0.00146667,0.00876667,0.00106667,0.000433333,0.000433333,0.000566667,0.00506667,0.000433333,0.0009,0.0012,0.000666667,0.000733333,0.0016,0.0007,0.000666667,0.0011,0.000366667,0.000566667,0.000433333,0.0025,0.0011,0.000666667,0.000733333,0.0035,0.000366667,0.000366667,0.000533333,0.00106667,0.0007,0.000433333,0.0011,0.000733333,0.000433333,0.00136667,0.000766667,0.0013,0.0006,0.0 00533333,0.000366667,0.0005,0.000633333,0.00106667,0.00276667,0.000833333,0.000766667,0.000466667,0.00133333,0.00143333,0.000566667,0.00156667,0.000566667,0.000466667,0.0004,0.0004,0.00206667,0.0013,0.0006,0.000666667,0.00103333,0.0004,0.0004,0.000533333,0.00156667,0.000433333,0.000666667,0.0005,0.000833333,0.0021,0.0008,0.0032,0.0005,0.00226667,0.000633333,0.0012,0.000666667,0.00376667,0.0007,0.0005,0.00126667,0.00116667,0.0006,0.00106667,0.000466667,0.000466667,0.0004,0.0004,0.00443333,0.00103333,0.000566667,0.0017,0.000466667,0.000366667,0.000833333,0.0081,0.00123333,0.0004,0.000833333,0.000533333,0.0014,0.0004,0.000366667,0.00126667,0.00123333,0.0009,0.0062,0.0012,0.000633333,0.0018,0.000566667,0.0004,0.0007,0.003,0.000366667,0.00126667,0.000833333,0.0005,0.0004,0.00126667,0.000933333,0.00243333,0.001,0.0008,0.000833333,0.0021,0.00713333,0.000733333,0.000533333,0.000566667,0.00203333,0.000466667,0.000366667,0.000466667,0.000766667,0.000366667,0.0005,0.00173333,0.000533333,0.00056 6667,0.00116667,0.0006,0.0004,0.0004,0.000366667,0.0004,0.000466667,0.000366667,0.000466667,0.00103333,0.0004,0.000433333,0.000366667,0.0004,0.00223333,0.000433333,0.000733333,0.0006,0.00273333,0.0004,0.000566667,0.0004,0.0005,0.000466667,0.000433333,0.000833333,0.000433333,0.00293333,0.000733333,0.0009,0.0052,0.00296667,0.0006,0.000466667,0.000466667,0.000666667,0.000633333,0.0008,0.000433333,0.0004,0.000933333,0.0016,0.000766667,0.0004,0.0005,0.0004,0.0007,0.000466667,0.00163333,0.000466667,0.000866667,0.000433333,0.0012,0.000833333,0.000566667,0.000366667,0.0004,0.000866667,0.000633333,0.0006,0.000566667,0.000533333,0.00166667,0.000433333,0.0005,0.00113333,0.0013,0.0008,0.000933333,0.000466667,0.000466667,0.000666667,0.000933333,0.0005,0.000366667,0.0004,0.000366667,0.000366667,0.000366667,0.0004,0.000433333,0.000466667,0.000533333,0.00183333,0.003,0.0004,0.00113333,0.000866667,0.000366667,0.0004,0.000833333,0.0012,0.0006,0.000366667,0.00873333,0.000866667,0.000533333,0.00653333,0 .000366667,0.109733} | (4 rows)
pgsql-general by date: