1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
slashdeploy=> select count(*) from statuses;
 count  
--------
 288475
(1 row)

slashdeploy=> select count(*) from statuses where state != 'success';
 count  
--------
 190494
(1 row)


# this is an example of a SHA which never "finished"
select * from statuses where sha = '921be84db0cdf28385833e1f643959cba3b15f43';


# this is an example of a SHA which "finished"
select * from statuses where sha = 'ad00dbc510924e549a9baa3443f6a2a709f2f97f';



select * from statuses where sha = '921be84db0cdf28385833e1f643959cba3b15f43' and state = 'success';
(7 rows)

select * from statuses where sha = 'ad00dbc510924e549a9baa3443f6a2a709f2f97f' and state = 'success';
(8 rows)