Daily Ingestion
IATF Database Ingestion Log
Each time TJ Systems drops a daily snapshot into the S3 bucket, the iatf-ingest Lambda reloads every table from it in one transaction. Every run is logged below (most recent first, last 50).
2026-11-17 06:18 PM EST
11,871,897
Ingestion runs
rows shown as +inserted ~updated -deleted2026-11-17 06:18 PM EST · 152.2 MB · 369.8s
11,871,897 rows · 34 tables
2026-11-16 06:18 PM EST · 152.1 MB · 367.9s
11,866,771 rows · 34 tables
2026-11-15 06:19 PM EST · 152.1 MB · 364.2s
11,860,101 rows · 34 tables
2026-11-14 06:19 PM EST · 152.1 MB · 369.9s
11,859,501 rows · 34 tables
2026-11-13 06:19 PM EST · 152.0 MB · 368.9s
11,858,875 rows · 34 tables
2026-11-12 06:18 PM EST · 152.0 MB · 372.6s
11,854,328 rows · 34 tables
2026-11-11 06:18 PM EST · 151.9 MB · 368.2s
11,849,256 rows · 34 tables
2026-11-10 06:18 PM EST · 151.9 MB · 367.6s
11,844,185 rows · 34 tables
2026-11-09 06:19 PM EST · 151.8 MB · 371.0s
11,840,090 rows · 34 tables
2026-11-08 06:18 PM EST · 151.8 MB · 364.3s
11,833,876 rows · 34 tables
2026-11-07 06:18 PM EST · 151.8 MB · 366.3s
11,833,347 rows · 34 tables
2026-11-06 06:18 PM EST · 151.8 MB · 367.7s
11,833,007 rows · 34 tables
2026-11-05 06:19 PM EST · 151.7 MB · 371.3s
11,827,926 rows · 34 tables
2026-11-04 06:19 PM EST · 151.6 MB · 376.5s
11,823,262 rows · 34 tables
2026-11-03 06:21 PM EST · 151.6 MB · 357.5s
11,817,766 rows · 34 tables
2026-11-02 06:18 PM EST · 151.5 MB · 372.7s
11,812,412 rows · 34 tables
2026-11-01 06:18 PM EST · 151.5 MB · 362.4s
11,806,127 rows · 34 tables
2026-10-31 07:18 PM EDT · 151.4 MB · 365.6s
11,805,541 rows · 34 tables
2026-10-30 07:18 PM EDT · 151.4 MB · 374.3s
11,805,003 rows · 34 tables
2026-10-29 07:19 PM EDT · 151.4 MB · 370.3s
11,799,746 rows · 34 tables
2026-10-28 07:18 PM EDT · 151.3 MB · 359.4s
11,794,506 rows · 34 tables
2026-10-28 08:20 AM EDT · 151.3 MB · 379.5s
11,788,154 rows · 34 tables
2026-10-27 07:18 PM EDT · 151.3 MB · 0.2s
1 foreign key(s) from outside the iatf spec point into it, so the TRUNCATE would fail: coaching_oem_approvals_oem_id_fkey (apps.coaching_oem_approvals -> iatf.oems). Drop them -- an app table must not FK into a schema that is wiped and reloaded nightly (the load runs session_replication_role=replica, so the constraint is skipped during the reload anyway). Never answer this with CASCADE: that would silently empty the referencing tables every night.
0 rows · 0 tables
2026-10-26 07:18 PM EDT · 151.2 MB · 358.8s
11,783,394 rows · 34 tables
2026-10-25 07:18 PM EDT · 151.2 MB · 361.4s
11,777,801 rows · 34 tables
2026-10-24 06:19 PM EDT · 151.2 MB · 366.7s
11,777,547 rows · 34 tables
2026-10-23 06:18 PM EDT · 151.1 MB · 368.1s
11,777,166 rows · 34 tables
2026-10-22 06:19 PM EDT · 151.1 MB · 373.1s
11,772,539 rows · 34 tables
2026-10-21 06:18 PM EDT · 151.0 MB · 373.8s
11,767,563 rows · 34 tables
2026-10-20 06:18 PM EDT · 151.0 MB · 371.1s
11,762,924 rows · 34 tables
2026-10-19 06:19 PM EDT · 150.9 MB · 367.4s
11,758,761 rows · 34 tables
2026-10-18 06:18 PM EDT · 150.9 MB · 353.4s
11,753,414 rows · 34 tables
2026-10-17 06:18 PM EDT · 150.9 MB · 351.3s
11,753,119 rows · 34 tables
2026-10-16 06:19 PM EDT · 150.9 MB · 367.9s
11,752,797 rows · 34 tables
2026-10-15 06:18 PM EDT · 150.8 MB · 368.4s
11,748,196 rows · 34 tables
2026-10-14 06:20 PM EDT · 150.8 MB · 362.5s
11,744,312 rows · 34 tables
2026-10-13 06:19 PM EDT · 150.7 MB · 367.5s
11,739,716 rows · 34 tables
2026-10-12 06:18 PM EDT · 150.7 MB · 370.6s
11,735,119 rows · 34 tables
2026-10-11 06:18 PM EDT · 150.6 MB · 358.8s
11,729,477 rows · 34 tables
2026-10-10 06:18 PM EDT · 150.6 MB · 361.1s
11,729,149 rows · 34 tables
2026-10-09 06:18 PM EDT · 150.6 MB · 365.8s
11,726,883 rows · 34 tables
2026-10-08 06:18 PM EDT · 150.5 MB · 364.6s
11,721,844 rows · 34 tables
2026-10-07 06:18 PM EDT · 150.5 MB · 369.8s
11,716,065 rows · 34 tables
2026-10-06 06:18 PM EDT · 150.4 MB · 404.9s
11,713,075 rows · 34 tables
2026-10-05 06:18 PM EDT · 150.4 MB · 373.6s
11,709,590 rows · 34 tables
2026-10-04 06:18 PM EDT · 150.4 MB · 400.4s
11,706,066 rows · 34 tables
2026-10-03 06:18 PM EDT · 150.4 MB · 396.6s
11,705,247 rows · 34 tables
2026-10-02 06:18 PM EDT · 150.4 MB · 399.1s
11,704,404 rows · 34 tables
2026-10-01 06:19 PM EDT · 150.3 MB · 400.3s
11,702,061 rows · 34 tables
2026-09-30 06:18 PM EDT · 150.3 MB · 368.2s
11,699,317 rows · 34 tables