Untitled
unknown
plain_text
7 months ago
1.2 kB
1
Indexable
Never
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;