return $table
->poll('10s')
->defaultSort('total_requests', 'desc')
->query(
MonitorResource::getEloquentQuery()->select(
'destination_pattern',
DB::raw('COUNT(*) as total_requests'),
DB::raw('SUM(CASE WHEN duration < 2 THEN 1 ELSE 0 END) as count_duration_lt_2s'),
DB::raw('SUM(CASE WHEN duration < 5 THEN 1 ELSE 0 END) as count_duration_lt_5s'),
DB::raw('SUM(CASE WHEN duration < 10 THEN 1 ELSE 0 END) as count_duration_lt_10s'),
DB::raw('SUM(CASE WHEN duration > 10 THEN 1 ELSE 0 END) as count_duration_gt_10s'),
DB::raw('SUM(CASE WHEN status = 0 THEN 1 ELSE 0 END) as error_count'),
)
->groupBy('destination_pattern')
)
return $table
->poll('10s')
->defaultSort('total_requests', 'desc')
->query(
MonitorResource::getEloquentQuery()->select(
'destination_pattern',
DB::raw('COUNT(*) as total_requests'),
DB::raw('SUM(CASE WHEN duration < 2 THEN 1 ELSE 0 END) as count_duration_lt_2s'),
DB::raw('SUM(CASE WHEN duration < 5 THEN 1 ELSE 0 END) as count_duration_lt_5s'),
DB::raw('SUM(CASE WHEN duration < 10 THEN 1 ELSE 0 END) as count_duration_lt_10s'),
DB::raw('SUM(CASE WHEN duration > 10 THEN 1 ELSE 0 END) as count_duration_gt_10s'),
DB::raw('SUM(CASE WHEN status = 0 THEN 1 ELSE 0 END) as error_count'),
)
->groupBy('destination_pattern')
)