From eb0ccc24b63d55b437c4a67bc01fb282b2b2c698 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Tue, 17 Mar 2020 16:35:32 -0700 Subject: make monitoring commands ingest_request local, not ingest_file_result --- sql/monitoring_queries.md | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/monitoring_queries.md b/sql/monitoring_queries.md index b46e6ec..35eef8f 100644 --- a/sql/monitoring_queries.md +++ b/sql/monitoring_queries.md @@ -8,7 +8,7 @@ Overall ingest status, past 3 days: LEFT JOIN ingest_request ON ingest_file_result.ingest_type = ingest_request.ingest_type AND ingest_file_result.base_url = ingest_request.base_url - WHERE ingest_file_result.updated >= NOW() - '3 day'::INTERVAL + WHERE ingest_request.created >= NOW() - '3 day'::INTERVAL AND ingest_request.ingest_type = 'pdf' AND ingest_request.ingest_request_source = 'fatcat-changelog' GROUP BY ingest_file_result.ingest_type, ingest_file_result.status @@ -40,7 +40,7 @@ Broken domains, past 3 days: Throughput per day, and success, for past month: SELECT ingest_request.ingest_type, - date(ingest_file_result.updated), + date(ingest_request.created), COUNT(*) as total, COUNT(CASE ingest_file_result.status WHEN 'success' THEN 1 ELSE null END) as success FROM ingest_file_result -- cgit v1.2.3