Files

18 lines
816 B
Go

package postgres
import (
"context"
"time"
"gitea.privcloud.tech/vlad_marlo/mtusi2026lab6/internal/observation"
)
// Snapshot observes current-version backlog and local pool occupancy under a short deadline.
func (s *Store) Snapshot(ctx context.Context) (observation.Snapshot, error) {
ctx, cancel := context.WithTimeout(ctx, 250*time.Millisecond)
defer cancel()
result := observation.Snapshot{PoolUsed: int64(s.pool.Stat().AcquiredConns())}
err := s.pool.QueryRow(ctx, `SELECT count(*),COALESCE(EXTRACT(EPOCH FROM clock_timestamp()-min(j.created_at)),0)::double precision FROM attachment_jobs j JOIN attachments a ON a.id=j.attachment_id AND a.pipeline_version=j.pipeline_version WHERE j.status IN ('queued','processing')`).Scan(&result.QueueDepth, &result.OldestSeconds)
return result, normalize(err)
}