We can get the number of returned rows in db_select() by ->rowCount().

// Get the number of nodes created by administrator
$query = db_select('node', 'n');
$result = $query->fields('n', array('nid'))->condition('uid', 1, '=')->execute();
return $result->rowCount();

Done =)

Reference: Drupal forum – get count with db_select