Changes between Version 4 and Version 5 of ippToPspsIngestof3piPV2

Timestamp:

Jan 17, 2015, 8:17:30 PM (12 years ago)

Author:

heather

Comment:

--

ippToPspsIngestof3piPV2

@@ -77 +77 @@
 
 === Saturday, 8:00pm === 
+ * first query is how many are pending for each slice
+ * second is total number published
+ * third is how many total are remaining
+ 
 {{{
  select count(*), datastore_product from pending join box on box_id = id join skychunk on name = skychunk where name like 'PSPS%' group by datastore_product ;select count(*) from batch where dvo_db like 'LAP.PV2%' and loaded_to_datastore =1; select count(*), datastore_product from pending join box on box_id = id join skychunk on name = skychunk where name like 'PSPS%';