aboutsummaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2020-03-17 16:35:32 -0700
committerBryan Newbold <bnewbold@archive.org>2020-03-17 16:36:45 -0700
commiteb0ccc24b63d55b437c4a67bc01fb282b2b2c698 (patch)
tree23ae8128d2dea2f42199f3df301148e1bf1826c1 /sql
parentb23469d5b978b3b42a0aa55e7a191280fe1beccd (diff)
downloadsandcrawler-eb0ccc24b63d55b437c4a67bc01fb282b2b2c698.tar.gz
sandcrawler-eb0ccc24b63d55b437c4a67bc01fb282b2b2c698.zip
make monitoring commands ingest_request local, not ingest_file_result
Diffstat (limited to 'sql')
-rw-r--r--sql/monitoring_queries.md4
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