make monitoring commands ingest_request local, not ingest_file_result

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