my @found = $aggr_table->search(
         undef,
         {
             select => [
                 'span', 'max(ts)'
             ],
             as       => [qw/ span ts /],
             group_by => 'span',
         }