-
Notifications
You must be signed in to change notification settings - Fork 29
Runbooks:Fastpath
Federico Ceratto edited this page Mar 3, 2020
·
7 revisions
ssh fastpath.ooni.nu
sudo apt-get update
apt-cache show fastpath | grep Ver | head -n5
sudo apt-get install fastpath
SELECT report_id, input, test_start_time, probe_cc, probe_asn
FROM measurement
LEFT OUTER JOIN input ON input.input_no = measurement.input_no
JOIN report ON report.report_no = measurement.report_no
WHERE
NOT EXISTS (
SELECT
FROM
fastpath fp
WHERE
measurement_start_time > NOW() - interval '48 hours'
AND measurement_start_time <= NOW()
AND fp.report_id = report.report_id
AND fp.test_name = report.test_name
AND fp.input = input.input)
AND measurement_start_time > NOW() - interval '48 hours'
AND measurement_start_time <= NOW()
LIMIT 100;