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