gistfile1.md

	new	old
Total	123810609	99868914
Valid	53776315	62461371
Invalid	70034294	37407543
Duplicate	58541564	24821424
No deployment/recovery	9889894	8786916
No deployment		1497812
No recovery		7289104
Unknown Receiver	1602836	3799203

sudo -u postgres time ./stats.sh

• psql aatams3 -c select count(*) from aatams.detection_with_rxr count

---

123810609 (1 row)

• psql aatams3 -c select count(*) from ( select id, ROW_NUMBER() OVER(PARTITION BY timestamp, transmitter_id, asc) AS row_num FROM aatams.detection ) dups where dups.row_num > 1; count

---

58541564 (1 row)

• psql aatams3 -c select count(*) from aatams.detection_with_rxr where invalid_reason is not null count

---

 0

(1 row)

0.08user 0.02system 47:45.52elapsed 0%CPU (0avgtext+0avgdata 21920maxresident)k 16280inputs+0outputs (124major+13241minor)pagefaults 0swaps

select count(*) from aatams.detection_with_reason where derived_reason is not null;

count

11492730 (1 row)