coder
diff --git a/‎coderd/database/dump.sql
Lines changed: 1 addition & 1 deletion b/‎coderd/database/dump.sql
Lines changed: 1 addition & 1 deletion
diff --git a/‎coderd/database/migrations/000223_notifications_metrics.up.sql
Lines changed: 1 addition & 1 deletion b/‎coderd/database/migrations/000223_notifications_metrics.up.sql
Lines changed: 1 addition & 1 deletion
diff --git a/‎coderd/database/models.go
Lines changed: 1 addition & 1 deletion b/‎coderd/database/models.go
Lines changed: 1 addition & 1 deletion
diff --git a/‎coderd/notifications/metrics.go
Lines changed: 1 addition & 1 deletion b/‎coderd/notifications/metrics.go
Lines changed: 1 addition & 1 deletion
diff --git a/‎coderd/notifications/metrics_test.go
Lines changed: 2 additions & 0 deletions b/‎coderd/notifications/metrics_test.go
Lines changed: 2 additions & 0 deletions
@@ -1,2 +1,2 @@
 ALTER TABLE notification_messages
-ADD COLUMN queued_seconds FLOAT NULL;
+ADD COLUMN queued_seconds INTEGER NULL;
@@ -48,7 +48,7 @@ func NewMetrics(reg prometheus.Registerer) *Metrics {
 		// Aggregating on LabelTemplateID as well would cause a cardinality explosion.
 		QueuedSeconds: promauto.With(reg).NewHistogramVec(prometheus.HistogramOpts{
 			Name: "queued_seconds", Namespace: ns, Subsystem: subsystem,
-			Buckets: []float64{0.1, 1, 5, 15, 30, 60, 120, 300, 600, 3600, 86400},
+			Buckets: []float64{1, 5, 15, 30, 60, 120, 300, 600, 3600, 86400},
 			Help: "The time elapsed between a notification being enqueued in the store and retrieved for processing " +
 				"(measures the latency of the notifications system). This should generally be within CODER_NOTIFICATIONS_FETCH_INTERVAL " +
 				"seconds; higher values for a sustained period indicates delayed processing and CODER_NOTIFICATIONS_LEASE_COUNT " +
 
@@ -28,6 +28,8 @@ func TestMetrics(t *testing.T) {
 	t.Parallel()
 
 	// setup
+
+	// Requires postgres because retry business logic is required, and this is only implemented in the database.
 	if !dbtestutil.WillUsePostgres() {
 		t.Skip("This test requires postgres")
 	}
Original file line number	Diff line number	Diff line change
`@@ -1,2 +1,2 @@`
`1`	`1`	`ALTER TABLE notification_messages`
`2`		`-ADD COLUMN queued_seconds FLOAT NULL;`
	`2`	`+ADD COLUMN queued_seconds INTEGER NULL;`
Original file line number	Diff line number	Diff line change
`@@ -28,6 +28,8 @@ func TestMetrics(t *testing.T) {`
`28`	`28`	`t.Parallel()`
`29`	`29`
`30`	`30`	`// setup`
	`31`	`+`
	`32`	`+ // Requires postgres because retry business logic is required, and this is only implemented in the database.`
`31`	`33`	`if !dbtestutil.WillUsePostgres() {`
`32`	`34`	`t.Skip("This test requires postgres")`
`33`	`35`	`}`