diff options
| -rw-r--r-- | sql/monitoring_queries.md | 4 |
1 files changed, 2 insertions, 2 deletions
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 |