You are now connected to database "dujour" as user "wyatt".
dujour=# select version,count(*) from (select distinct on (ip,version) version from checkins where product='puppetdb' and char_length(version)=5 and timestamp >= '2015-07-09') foo group by version order by version;
 version | count
---------+-------
 1.0.0   |     1
 1.0.1   |     2
 1.0.2   |     4
 1.0.4   |     1
 1.0.5   |    13
 1.1.0   |     6
 1.1.1   |    27
 1.2.0   |    26
 1.3.0   |     9
 1.3.1   |     9
 1.3.2   |    45
 1.4.0   |    20
 1.5.0   |    33
 1.5.2   |   121
 1.6.0   |    19
 1.6.2   |   639
 1.6.3   |   228
 2.0.0   |   190
 2.1.0   |   113
 2.2.0   |   166
 2.2.1   |    20
 2.2.2   |  1155
 2.3.0   |    82
 2.3.1   |    12
 2.3.2   |    48
 2.3.3   |  3075
 2.3.4   |   476
 2.3.5   |  1736
 2.3.6   |  2588
 2.3.7   |  1630
 3.0.0   |    69
 3.0.1   |   183
 3.0.2   |   286
 3.1.0   |   112
(34 rows)