This request came in on May 27. It has 2624 rows most of which are bycoord requests. These are the slowest to parse.

The request started parsing at 13:38 HST May 27. We can see this because that is the time stamp on the request file. At 15:55 it is about half done. 4994 jobs have been queued so far and all but 200 are requests for cleaned up data. So the parsing will probably complete around 18:00

The program pstampdump can be used to list the contents of a fits table

(ippdb02:work/20100527/5977) bills% pstampdump -simple web_1695.fits > dumpreq.txt

(ippdb02:work/20100527/5977) bills% wc dumpreq.txt
  2624  49856 256353 dumpreq.txt

# Each row has a ROWNUM which must be unique in the file.


(ippdb02:work/20100527/5977) bills% grep Collected psparse.5977.log | tail -n 1
Collected 1 rows beginning with row 100595. bycoord chip null null 

# it's working on the 1486th row now

(ippdb02:work/20100527/5977) bills% grep -n 100595 dumpreq.txt 
1486:100595 205.550874 28.351276 100 100 2 stamp 1 gpc1 bycoord chip null null null null y 0 0 search 

# We're up to 5123 jobs now.
mysql> select count(*) from pstampJob where req_id >= 5977 and fault = 0 ;
+----------+
| count(*) |
+----------+
|     5123 | 
+----------+
1 row in set (0.02 sec)

mysql> select count(*) from pstampJob where req_id >= 5977 and fault = 0 and dep_id = 0;
+----------+
| count(*) |
+----------+
|      200 | 
+----------+
1 row in set (0.02 sec)