Untitled

 avatar
unknown
plain_text
2 years ago
1.2 kB
2
Indexable
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;