num_rows() function does not work

Does this?

Code:

$query = $this->db
  ->distinct()
  ->get('products')
  ->result_array();


echo $query->num_rows();

(get the result array first)