Postgres · jobtread

Record metrics by month

Every row the JobTread Pave sync has landed, counted by the month the record was created in JobTread — not the month it was synced. Six record types across three contractor organizations.

Warehouse totals

Row counts per table, with the share of rows attributable to a single organization.

Records created per month

Stacked by record type. Toggle a type to remove it from the stack, or filter to one organization. Hover a column for the month's breakdown.

Record type
Organization

Each record type on its own scale

The stack above is dominated by whichever type is most numerous; these share a month axis but each sets its own ceiling, so the shape of every type is legible.

Rows by organization

Every table now carries organization_id, so ownership is a single-column filter rather than a multi-hop join.

Composition

How the records break down within each type.

Integrity checks

What the counts imply about sync completeness. Each figure is a query against the warehouse, not an estimate.