Results

First experiment with 1000 explained queries

Limited to DR5

Distinct queries in BestDR5: 158548

Top 10 queries:
4994 SELECT  top 1 '<a target=INFO href=http://skyserver5.fnal.gov/dr5/en/tools/explore/obj.asp?id=' + cast(p.objId as varchar(20)) + '>' + cast(p.objId as varchar(20)) + '</a>' as objID, p.run, p.rerun, p.camcol, p.field, p.obj, p.type, p.ra, p.dec, p.u,p.g,p.r,p.i,p.z, p.Err_u, p.Err_g, p.Err_r,p.Err_i,p.Err_z FROM fGetNearbyObjEq(195,2.5,0.5) n, PhotoPrimary p WHERE n.objID=p.objID
4994 SELECT  top 1 '<a target=INFO href=http://skyserver6.fnal.gov/dr5/en/tools/explore/obj.asp?id=' + cast(p.objId as varchar(20)) + '>' + cast(p.objId as varchar(20)) + '</a>' as objID, p.run, p.rerun, p.camcol, p.field, p.obj, p.type, p.ra, p.dec, p.u,p.g,p.r,p.i,p.z, p.Err_u, p.Err_g, p.Err_r,p.Err_i,p.Err_z FROM fGetNearbyObjEq(195,2.5,0.5) n, PhotoPrimary p WHERE n.objID=p.objID
4988 SELECT  top 1 '<a target=INFO href=http://cas.sdss.org/dr5/en/tools/explore/obj.asp?id=' + cast(p.objId as varchar(20)) + '>' + cast(p.objId as varchar(20)) + '</a>' as objID, p.run, p.rerun, p.camcol, p.field, p.obj, p.type, p.ra, p.dec, p.u,p.g,p.r,p.i,p.z, p.Err_u, p.Err_g, p.Err_r,p.Err_i,p.Err_z FROM fGetNearbyObjEq(195,2.5,0.5) n, PhotoPrimary p WHERE n.objID=p.objID
3464 select description from DBObjects where name='spregionor'
3464 select text from DBObjects where name='spregionor'
2112 SELECT  top 1 '<a target=INFO href=http://cas.sdss.org/dr5/en/tools/explore/obj.asp?id=' + cast(p.objId as varchar(20)) + '>' + cast(p.objId as varchar(20)) + '</a>' as objID, p.run, p.rerun, p.camcol, p.field, p.obj, p.type, p.ra, p.dec, p.u,p.g,p.r,p.i,p.z, p.Err_u, p.Err_g, p.Err_r,p.Err_i,p.Err_z FROM fGetNearbyObjEq(195,2.5,3) n, PhotoPrimary p WHERE n.objID=p.objID
691 select name, type from DBObjects where name like '%Constants%' or name like '%Defs%' order by name
643 select name, type from DBObjects where type='V' and name NOT IN ('LoadEvents', 'QueryResults') order by name
581 select name, type from DBObjects where type='P' and access='U' and name NOT IN ('LoadEvents', 'QueryResults') order by name
576 select name, type from DBObjects where type='U' and access='U' and name NOT IN ('LoadEvents', 'QueryResults') order by name

Error messages:
33075 ERROR: Maximum 60 queries allowed per minute. Rejected query:
357 error: must be a select statement:
  6 error: limit is  top 100000
  5 error: limit is  top 500000

Distinct queries with query plan: 1353
Overall cost assuming 1 (aka number of queries): 1353
Overall actual cost: 8998.152068
Overall estimated cost: 28.39570932

Cost of 1, aggregate on query: 1191.0
Actual cost, aggregate on query: 8979.85441512
Estimated cost, aggregate on query: 27.19554738
Cost of 1, aggregate on plan: 364.0
Actual cost, aggregate on plan: 2007.08075182
Estimated cost, aggregate on plan: 11.88978073
(Average cost assumed per query)

Find recurring subtrees in distinct queries:
Saved cost [25.316974951000415] 89.1577479742%
Remaining cost 3.078734369
Cached rows: 431.3995

Tables used:
  PhotoObjAll: 3880
  fGetNearbyObjEq: 291
  SpecPhotoAll: 135
  DBObjects: 41
  fDocColumns: 26
  DBViewCols: 16
  fGetObjFromRect: 9
  ELRedShift: 8
  PhotoTag: 7
  Frame: 6
  SpecLineIndex: 6
  XCRedshift: 6
  SpecLineAll: 4
  fDocFunctionParams: 4
  SpecObjAll: 3
  Photoz: 3
  Field: 2
  IndexMap: 1