This is an easy calculation, but we might be missing some information. We want to take the most recent few messages that were processed by the queue consumer and find the average of <time_recorded_in_civi> - source_enqueued_time. We might have to make that time available somewhere.
Description
Description
Details
Details
Customize query in gerrit
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | Ejegg | T120002 Dash widget to measure donations queue lag | |||
Invalid | awight | T120003 Record timestamp when contribution is stored in Civi |
Event Timeline
Comment Actions
What about if it was something like this? https://docs.google.com/a/wikimedia.org/drawings/d/1y3pHqSg-_KHRXWM_F4FbGAS9vB0X8Ah5t0zVlNhnApM/edit?usp=sharing
Comment Actions
Ooh, we already have the information we need: it's just now() - source_enqueued_time of the top few donations in Civi.
Comment Actions
Change 256362 had a related patch set uploaded (by Ejegg):
Add donation age widget to Big English board
Comment Actions
Change 256613 had a related patch set uploaded (by Ejegg):
Fix more problems with donation age / BE SQL
Comment Actions
Change 256744 had a related patch set uploaded (by Ejegg):
Add ganglia link to donation age widget