Changes between Initial Version and Version 1 of ThreePiPV2OBinPSPS

Timestamp:

Feb 18, 2015, 1:39:02 PM (11 years ago)

Author:

heather

Comment:

--

ThreePiPV2OBinPSPS

@@ +1 @@
+= This is ipp's wiki of 3pi pv2 ob in psps =
+
+First step is to do some sanity check queries to determine what is good / bad, second is to flag things to fix for PV3.
+
+== Detection Counts ==
+
+Total counts:
+
+* select count_big(*) from ObjectThin
+
+ * 4,460,992,385
+
+I then did counts to find out how many have x detections or x stackdetections (up to 20 in both). For easy comparisons, I show both tables side by side (they are not related):
+|| stacks || stacks || || single exp || single exp || ||
+||nstackdetections || count || || ndetections || count ||comment ||
+||0 ||3,271,281,682 || || 0 || 462,983,177 || || 3.2 billion things have no stack detections ||
+||1 || 420,775,092  || || 1 || 3,158,911,897 ||  || 3.1 billion things have only 1 detection, and .42 billion have only 1 stack ||
+||2 ||156,692,049  || ||2||254,952,659||  n detections decreases (not surprising)||
+||3 ||110,625,647  || || 3||52,419,438 ||  ||
+||4 ||139,184,223  || || 4||30,750,181||  ||
+||5 ||254,028,340  || || 5||21,236,521||  not surprising, a peak at 5 nstack detections (1 per filter) , and a peak at 10, and a peak at 15, and t 20...||
+||6 ||19,227,731  || || 6||17,913,219||  ||
+||7||3,859,474  || || 7||15,038,140||  ||
+||8||23,245,260  || || 8||13,648,608||  ||
+||9||3,314,548  || || 9||12,232,408||  ||
+||10||52,135,360  || || 10||11,502,291||  ||
+||11||343,750  || || 11||10,612,853||  ||
+||12||1,179,799  || || 12||10,129,705||  ||
+||13||165,876  || || 13||9,571,724||  ||
+||14||158,566  || || 14||9,257,316||  ||
+||15||1,310,614  || || 15||8,869,369||  ||
+||16||886,362  || || 16||8,656,862||  ||
+||17||85,019  || || 17||8,368,348||  ||
+||18||82,064  || || 18||8,235,649||  ||
+||19||102,699  || || 19||8,019,806||  ||
+||20||2,259,605  || || 20||7,964,360||  ||
+