SELECT date_trunc('hour', CAST(recon_start_date AS TIMESTAMP)) AS recon_start_date,
total_no_of_events AS total_no_of_events__,
no_of_passed_events AS no_of_passed_events,
no_of_failed_events AS no_of_failed_events,
no_of_passed_events_via_recon AS no_of_passed_events_via_recon,
no_of_failed_events_pubished_to_kafka AS no_of_failed_events_pubished_to_kafka,
sum(total_no_of_events) AS "total events",
sum(no_of_passed_events) AS "success events",
sum(no_of_failed_events) AS "failed events",
sum(no_of_passed_events_via_recon) AS "passed events via recon",
sum(no_of_failed_events_pubished_to_kafka) AS "failed events published to kafka"
FROM hobs_ods_staging.hos_event_recon_summary
GROUP BY date_trunc('hour', CAST(recon_start_date AS TIMESTAMP)),
total_no_of_events,
no_of_passed_events,
no_of_failed_events,
no_of_passed_events_via_recon,
no_of_failed_events_pubished_to_kafka
ORDER BY "total events" DESC
LIMIT 50000;