Open grzn opened 2 months ago
https://github.com/prometheus-community/postgres_exporter/blob/98f75c7e7ea3a02b974cfeda736cf7dbc091b18e/collector/pg_long_running_transactions.go#L52C2-L52C30
Its missing a condition on the duration of the query, as seen in https://github.com/prometheus-community/postgres_exporter/pull/819/files, e.g.
AND (now() - xact_start) > '1 minutes'::interval
https://github.com/prometheus-community/postgres_exporter/blob/98f75c7e7ea3a02b974cfeda736cf7dbc091b18e/collector/pg_long_running_transactions.go#L52C2-L52C30
Its missing a condition on the duration of the query, as seen in https://github.com/prometheus-community/postgres_exporter/pull/819/files, e.g.