Skip to content
Signalcrest
Back to feed
devtodata

Your Audit Log Agrees With Itself. That's the Problem.

Postgres audit logs can become self-contradictory, risking data integrity checks.

Steady
Signal score
34
Sources
3
agreeing on postgres
Trajectory
Accelerating
7-day est. ~66

Why this scored 34

every term, weighted
Velocity+0.0 / 40

Engagement gained per hour since the last capture, against the fastest item on its own source

Acceleration+11.3 / 25

Whether that velocity is itself speeding up, as a per-hour rate

Cross-source spread+16.7 / 25

How many independent communities are talking about the same entity

Recency+7.9 / 10

Decays to zero over 14 days

Saturation penalty1.5 / 30

Subtracted once something is big and old — we rank what's next, not what's peaked

Composite34.4

Weights are hand-tuned, not learned — we're calibrating them against realized trends as history accumulates. On a topic's first sighting there's no previous reading to compare against, so acceleration starts from a neutral prior rather than a measurement, and velocity falls back to engagement over its whole lifetime until a second reading exists. Full methodology

Outlook

low confidence · estimate, not a guarantee

7-day

~66

range 2477

14-day

~75

range 3089

30-day

~79

range 3098

Signal history

7-day window (free)
1866

projected trajectory (estimate, not a guarantee)

Entities

postgres
Embed a live signal badge
Signalcrest signal badge
[![Signalcrest signal](https://www.signalcrest.app/api/badge/dev%3A4613934)](https://www.signalcrest.app/topic/dev%3A4613934)

Drop this in a README or blog post — it updates automatically as the score moves.